显示结果选择* - Show result Select *

Show result Select *

本文关键字：选择结果显示 | 更新日期: 2023-09-27

我在我的model.php中完成了这样的SQL请求：

public function getUserForAdmin() { 
    $arrayUser = $this->bdd->getArray('SELECT prenom AS prenomUFA, nom AS nomUFA, email AS emailUFA, cp AS cpUFA FROM user');
    return $arrayUser['prenomUFA'];
}

在我的index.php中，我这样称呼它

$userForAdmin = $user->getUserForAdmin();
echo $userForAdmin['prenomUFA'];

有了这个，我才有了婚前协议的第一封信。。。

我的阵列输出：

Array ( 
    [0] => Array ( [prenom] => Coline [nom] => [email] => hj [userForAdmin] => 69570 ) 
    [1] => Array ( [prenom] => Coline [nom] => [email] => officiel@coucou.fr [userForAdmin] => 69570 ) 
    [2] => Array ( [prenom] => Coline [nom] => [email] => officiel@coucou.fr [userForAdmin] => 69570 ) 
    [3] => Array ( [prenom] => Coline [nom] => [email] => hjkjk [userForAdmin] => 69570 )
    [4] => Array ( [prenom] => Coline [nom] => [email] => officiel@coucou.fr [userForAdmin] => ) 
    [5] => Array ( [prenom] => Coline [nom] => [email] => hjkhjk [userForAdmin] => 69570 )   
    [6] => Array ( [prenom] => Coline [nom] => jkljl [email] => jkljl@fgfg.fr [userForAdmin] => ) 
    [7] => Array ( [prenom] => Coline [nom] => fgdfg [email] => dfgfdg@dsdfg.hfg [userForAdmin] => ) 
    [8] => Array ( [prenom] => Coline [nom] => ghjg [email] => ghj@fddfg.fr [userForAdmin] => ghj ) 
    [9] => Array ( [prenom] => ghj [nom] => ghjghj [email] => ghgh@dfgdfg.fra [userForAdmin] => ) 
    [10] => Array ( [prenom] => hjkhk [nom] => hjkhjk [email] => hjk@sdfdf.fr [userForAdmin] => ) 
    [11] => Array ( [prenom] => cvbcb [nom] => cvbcvb [email] => cvbcv@dfgdfg.fr [userForAdmin] => ) 
    [12] => Array ( [prenom] => jhk [nom] => hjkhjk [email] => hjhjk@dfgdfg.fr [userForAdmin] => ) 
    [13] => Array ( [prenom] => Coline [nom] => [email] => cghjghj [userForAdmin] => 45645 )   
    [14] => Array ( [prenom] => Coline [nom] => [email] => ghj [userForAdmin] => 44545 ) 
)

为了从函数do this-返回整个数组

public function getUserForAdmin() { 
    $arrayUser = $this->bdd->getArray('SELECT prenom, nom, email, cp AS userForAdmin FROM user');
    return $arrayUser;
}

这么说吧-

$userForAdmin = $user->getUserForAdmin();
print_r($userForAdmin); // testing to see what is in the array

似乎getArray()返回了一个数组数组，并且正确返回了您的AS别名"。要访问单个项目，您必须这样做：

echo $userForAdmin[0]['userForAdmin']; // note the specification used in multidimensional arrays
echo $userForAdmin[0]['prenom']; // has no 'AS' alias
echo $userForAdmin[0]['nom'];
echo $userForAdmin[0]['email'];

您可能希望查看getArray()，以便它返回更方便使用的内容。

public function getUserForAdmin() { 
    $arrayUser = $this->bdd->getArray('SELECT prenom AS prenomUFA, nom AS nomUFA, email AS emailUFA, cp AS cpUFA FROM user');
    return $arrayUser;
}

在index.php中，这样称呼它-

$userForAdmin = $user->getUserForAdmin();
foreach($userForAdmin as $rows)
{  
    echo '<p>'.$rows['prenomUFA'].'</p><br>';
    echo '<p>'.$rows['nomUFA'].'</p><br>';
    echo '<p>'.$rows['emailUFA'].'</p><br>';
    echo '<p>'.$rows['cpUFA'].'</p><br>';
}

以上代码输出所有值。