<!DOCTYPE html>
<html>
<body><h1>我的第一张 PHP 页面</h1>
<?php
$servername = "localhost";
$username = "root";
$password = "root";// 创建连接
$conn = new mysqli($servername, $username, $password,"ghtl_e");// 检测连接
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
echo "连接成功";$sql = "select id from t_user";
$result = $conn->query($sql);
if($result === false){//执行失败
echo $conn->error;
echo $conn->errno;
}
while($row = $result->fetch_assoc()){
echo $salt = $row["us_id"];
echo $id = $row["id"];
}
?></body>
</html>这是我的代码
数据库能连接成功 但是 页面上 只能显示 id 显示不出来 us_id 报错 Notice: Undefined index: us_id in D:\nginx\html\lx.php on line 27
求救 实在是不知道怎么办了
<html>
<body><h1>我的第一张 PHP 页面</h1>
<?php
$servername = "localhost";
$username = "root";
$password = "root";// 创建连接
$conn = new mysqli($servername, $username, $password,"ghtl_e");// 检测连接
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
echo "连接成功";$sql = "select id from t_user";
$result = $conn->query($sql);
if($result === false){//执行失败
echo $conn->error;
echo $conn->errno;
}
while($row = $result->fetch_assoc()){
echo $salt = $row["us_id"];
echo $id = $row["id"];
}
?></body>
</html>这是我的代码
数据库能连接成功 但是 页面上 只能显示 id 显示不出来 us_id 报错 Notice: Undefined index: us_id in D:\nginx\html\lx.php on line 27
求救 实在是不知道怎么办了
$result = $conn->query($sql);
if($result === false){//执行失败
echo $conn->error;
echo $conn->errno;
}
while($row = $result->fetch_assoc()){
echo $salt = $row["us_id"];
echo $id = $row["id"];
}
$sql = "select * from t_user";
改为
$sql = "select * from t_user";
这个sql语句运行后只会查询出这张表所有id的字段的内容所以只会出一个ID
正确的sql
$sql="select id,us_id from t_user ";
这样就ok了
建议你先把sql的增删改查学好再去看php的其他内容