简单的一个,我很难用php在网页上显示我的sql数据。我有一个单独的页面,根据连接到数据库。然而,使用简单的连接php脚本并不能显示结果。。。
<?php
include("header.php");
include("connect.php");
?>
<?php
$sql = mysqli_query("SELECT * FROM members ORDER BY id ASC");
$id = 'id';
$username = 'username';
$useremail = 'useremail';
$rows = mysqli_fetch_assoc($sql);
echo 'Name: ' . $rows[$id] . '<br />' . 'Username: ' . $rows[$useremail];
?>
我甚至试过这个,但还是什么都没有。。。
<?php
include 'includes/connect.php';
$query = "SELECT * FROM members";
$result = mysqli_query ($query);
while($person = mysqli_fetch_array($result)) {
echo "<h1>" . $person['useremail'] . "</h1>";
}
?>
请检查您是否已在connect.php
中正确写入所有连接变量。您使用的是$rows[$id]
,这不是问题,因为您已经定义了变量$id='id'
。但问题是你们并没有使用循环。如果您要打印
$rows = mysqli_fetch_assoc($sql);
echo $rows[$id];
它只会给出一个记录;请尝试以下
<?php
$host='localhost';
$user='root';
$pass='';
$db='mydata';//change above four variable as per your setting or write down in connect.php
$con=mysqli_connect($host,$user,$pass) or die(mysqli_error());
mysqli_select_db($con,$db);
$id = 'id';
$username = 'username';
$useremail = 'useremail';
$q="SELECT * FROM members ORDER BY id ASC";
$r=mysqli_query($con,$q);
while($rows=mysqli_fetch_assoc($r)){
echo "Name :".$rows[$username]."<br />"."useremail :".$useremail."<br />";
}
?>