我想第一次使用mySQLi.我已经在循环的情况下完成了它.循环结果显示但我在尝试显示单个记录时卡住了.这是循环代码正在工作.
// Connect To DB
$hostname="localhost";
$database="mydbname";
$username="root";
$password="";
@$conn = mysqli_connect($hostname, $username, $password)
or die("Could not connect to server " . mysql_error());
mysqli_select_db($conn, $database)
or die("Error: Could not connect to the database: " . mysql_error());
/*Check for Connection*/
if(mysqli_connect_errno()){
// Display Error message if fails
echo 'Error, could not connect to the database please try again again.';
exit();
}
?>
$query = "SELECT ssfullname, ssemail FROM userss ORDER BY ssid";
$result = mysqli_query($conn, $query);
@$num_results = mysqli_num_rows($result);
?>
/*Loop through each row and display records */
for($i=0; $i
$row = mysqli_fetch_assoc($result);
?>
Name: <?php print $row['ssfullname']; ?>
Email: <?php print $row['ssemail']; ?>
// end loop
}
?>
在循环的情况下,上面的代码很好.
现在我如何从第一行或其他任何地方显示单个记录,任何记录,名称或电子邮件,只是单个记录,我该怎么做?
在单个记录的情况下,考虑删除所有上面的循环部分,并让我们显示任何单循环没有循环.