无法使用php提取和显示数据

Question

我正在尝试显示用户名，电子邮件ID，但每次输出都显示为“ 1”。在我尝试获取并显示值的任何地方，它仅将1显示为输出。数据库：CREATE TABLE `admin` (  `id` int(11) NOT NULL,  `username` varchar(50) NOT NULL,  `password` varchar(255) NOT NULL,  `created_at` datetime DEFAULT current_timestamp(),  `email` varchar(255) DEFAULT NULL,  `name` varchar(255) DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;PHP代码：<?phpsession_start();if(!isset($_SESSION["loggedin"]) || $_SESSION["loggedin"] !== true){    header("location: login.php");    exit;}?><?phprequire_once('config/config.php');//Counting Member$members = "SELECT count( * ) as  id FROM admin";$member_result = $mysqli->query($members);$total_member = mysqli_num_rows($member_result);//Showing Admin Name$admin_name = "SELECT `name` FROM `admin` WHERE id='1'";$name_result = $mysqli->query($admin_name);$name_sh = mysqli_num_rows($name_result);//Showing Email$admin_email = "SELECT `email` FROM `admin` WHERE id='1'";$email_result = $mysqli->query($admin_email);$email_sh = mysqli_num_rows($email_result);?>config.php<?phpdefine('DB_SERVER', 'localhost');define('DB_USERNAME', 'root');define('DB_PASSWORD', '');define('DB_NAME', 'test1');$mysqli = new mysqli(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_NAME);if($mysqli === false){    die("ERROR: Could not connect. " . $mysqli->connect_error);}?>它只显示1而不是值。提前致谢

Answer 1

这是因为您显示的是的结果mysqli_num_rows，该结果返回结果中的行数（因此始终等于1）。

取而代之的mysqli_stmt_fetch是获取查询结果。

Answer 2

$admin_name = "SELECT `name` FROM `admin` WHERE id='1'";

$name_result = $mysqli->query($admin_name);

$result=mysqli->fetch_array($name_result,MYSQLI_ASSOC);