数据库名username
代码入下
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: ");
}
$sql = "SELECT uname FROM usertables";
$result = mysqli_query($conn,$sql);
if (mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
echo $row['uname'];
}
} else {
echo "0 results";
}
$conn->close();
输出是 0 results
不知问题在哪。
代码入下
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: ");
}
$sql = "SELECT uname FROM usertables";
$result = mysqli_query($conn,$sql);
if (mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
echo $row['uname'];
}
} else {
echo "0 results";
}
$conn->close();
输出是 0 results
不知问题在哪。
<?php
// 假定数据库用户名:root,密码:123456,数据库:RUNOOB
$con=mysqli_connect("localhost","root","123456","RUNOOB");
if (mysqli_connect_errno($con))
{
echo "连接 MySQL 失败: " . mysqli_connect_error();
} $sql = "SELECT name,url FROM websites ORDER BY alexa;";if ($result=mysqli_query($con,$sql))
{
// 返回记录数
$rowcount=mysqli_num_rows($result);
printf("总共返回 %d 行数据。",$rowcount);
// 释放结果集
mysqli_free_result($result);
}
mysqli_close($con);