<?php
$mysqli = new MySQLi("localhost","root","123456","liuyan");
if(!$mysqli){
?die($mysqli->error);
}
function showTable($mysqli,$table_name){
?$sql = "select * from $table_name";
?$res = $mysqli->query($sql);
?//獲取返回總行數(shù)和列數(shù)
?echo "共有：".$res->num_rows."行；共有：".$res->field_count."列.";
?//獲取表頭---從$res取出
?echo "<table border=1><tr>";
?while($field=$res->fetch_field()){
?? echo "<th>{$field->name}</th>";
?}
?echo "</tr>";
?//循環(huán)取出數(shù)據(jù)
?while($row=$res->fetch_row()){
? echo "<tr>";
? foreach($row as $value){
?? echo "<td>$value</td>";
? }
? echo "</tr>";
?}
?echo "</table>";
?$res->free();
}
showTable($mysqli,"news");
?>