获取数据库所有数据
$sql = mysql_query("select * from user");
$datarow = mysql_num_rows($sql); //长度
//循环遍历出数据表中的数据
for($i=0;$i<$datarow;$i++){
$sql_arr = mysql_fetch_assoc($sql);
echo $id = $sql_arr['id']." ";
echo $name = $sql_arr['username']." ";
echo $pwd = $sql_arr['password']." ";
echo $number = $sql_arr['number']." ";
echo $regtime = $sql_arr['regtime']." ";
echo $ip = $sql_arr['ip']." ";
echo $frozen = $sql_arr['frozen'];
echo "<br>";
}
获取数据库一行数据的所有数据
$sql = "select * from user where '$username'";
$result = mysql_query($sql);
//$row = mysql_fetch_array($result);
while($row = mysql_fetch_array($result))//这里不能直接使用$row
{
echo $row['username'] . " " . $row['password'] . " " . $row['number'];
echo " " . $row['regtime']. " " . $row['ip'];
echo "<br />";
}
