无法使用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代码：

<?php

session_start();

if(!isset($_SESSION["loggedin"]) || $_SESSION["loggedin"] !== true){

    header("location: login.php");

    exit;

}

?>

<?php

require_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

<?php

define('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);