我想从数据库中选择数据,并将其显示在我的网站上给登录的用户,但只显示他的数据,而不是其他人。当我放入代码时,它很少发出错误通知。我不知道如何解决它们,请帮我。谢谢
错误通知按摩:
Notice: Undefined index: username in C:'xampp'htdocs'mysql_login'user_details2.php on line 20
Notice: Undefined index: name in C:'xampp'htdocs'mysql_login'user_details2.php on line 21
Notice: Undefined index: username in C:'xampp'htdocs'mysql_login'user_details2.php on line 20
Notice: Undefined index: name in C:'xampp'htdocs'mysql_login'user_details2.php on line 21
Notice: Undefined index: username in C:'xampp'htdocs'mysql_login'user_details2.php on line 20
Notice: Undefined index: name in C:'xampp'htdocs'mysql_login'user_details2.php on line 21
Notice: Undefined index: username in C:'xampp'htdocs'mysql_login'user_details2.php on line 20
Notice: Undefined index: name in C:'xampp'htdocs'mysql_login'user_details2.php on line 21
Notice: Undefined index: username in C:'xampp'htdocs'mysql_login'user_details2.php on line 20
Notice: Undefined index: name in C:'xampp'htdocs'mysql_login'user_details2.php on line 21
Notice: Undefined index: username in C:'xampp'htdocs'mysql_login'user_details2.php on line 20
Notice: Undefined index: name in C:'xampp'htdocs'mysql_login'user_details2.php on line 21
Notice: Undefined index: username in C:'xampp'htdocs'mysql_login'user_details2.php on line 20
Notice: Undefined index: name in C:'xampp'htdocs'mysql_login'user_details2.php on line 21
Notice: Undefined index: username in C:'xampp'htdocs'mysql_login'user_details2.php on line 20
Notice: Undefined index: name in C:'xampp'htdocs'mysql_login'user_details2.php on line 21
Notice: Undefined index: username in C:'xampp'htdocs'mysql_login'user_details2.php on line 20
Notice: Undefined index: name in C:'xampp'htdocs'mysql_login'user_details2.php on line 21
Notice: Undefined index: username in C:'xampp'htdocs'mysql_login'user_details2.php on line 20
Notice: Undefined index: name in C:'xampp'htdocs'mysql_login'user_details2.php on line 21
Notice: Undefined index: username in C:'xampp'htdocs'mysql_login'user_details2.php on line 20
Notice: Undefined index: name in C:'xampp'htdocs'mysql_login'user_details2.php on line 21
Notice: Undefined index: username in C:'xampp'htdocs'mysql_login'user_details2.php on line 20
Notice: Undefined index: name in C:'xampp'htdocs'mysql_login'user_details2.php on line 21
Notice: Undefined index: username in C:'xampp'htdocs'mysql_login'user_details2.php on line 20
Notice: Undefined index: name in C:'xampp'htdocs'mysql_login'user_details2.php on line 21
Notice: Undefined index: username in C:'xampp'htdocs'mysql_login'user_details2.php on line 20
Notice: Undefined index: name in C:'xampp'htdocs'mysql_login'user_details2.php on line 21
Notice: Undefined index: username in C:'xampp'htdocs'mysql_login'user_details2.php on line 20
Notice: Undefined index: name in C:'xampp'htdocs'mysql_login'user_details2.php on line 21
Notice: Undefined index: username in C:'xampp'htdocs'mysql_login'user_details2.php on line 20
Notice: Undefined index: name in C:'xampp'htdocs'mysql_login'user_details2.php on line 21
Username Name
这是我的php代码:
<?php
$con=mysqli_connect("localhost","root","123","login");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con,"SELECT * FROM users");
echo "<table border='1'>
<tr>
<th>Username</th>
<th>Name</th>
</tr>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['username'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysqli_close($con);
?>
尝试mysqli_fetch_assoc($result)或mysqli_fetch _array($result,MYSQL_assoc),而不是mysqli_featch_array