示例
';
$sql = 'SELECt * FROM emp4 order by name';
$retval=mysqli_query($conn, $sql);
if(mysqli_num_rows($retval) > 0){
while($row = mysqli_fetch_assoc($retval)){
echo "EMP ID :{$row['id']}
".
"EMP NAME : {$row['name']}
".
"EMP SALARY : {$row['salary']}
".
"--------------------------------
";
} //end of while
}else{
echo "0 results";
}
mysqli_close($conn);
?>
执行上面代码输出结果如下 -
Connected successfully
EMP ID :3
EMP NAME : jai zhang
EMP SALARY : 90000
--------------------------------
EMP ID :2
EMP NAME : minsu
EMP SALARY : 40000
--------------------------------
EMP ID :1
EMP NAME : maxsu
EMP SALARY : 9000
--------------------------------
