Home > php教程 > php手册 > php+mysqli实现将数据库中一张表信息打印到表格里的方法,mysqli表格

php+mysqli实现将数据库中一张表信息打印到表格里的方法,mysqli表格

WBOY
Release: 2016-06-13 09:16:11
Original
1636 people have browsed it

php+mysqli实现将数据库中一张表信息打印到表格里的方法,mysqli表格

本文实例讲述了php+mysqli实现将数据库中一张表信息(包括表头)打印到表格里的方法。分享给大家供大家参考。具体如下:

这段代码将就看吧。需要学习基础知识。代码如下:

复制代码 代码如下:

$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);
 //获取返回总行数和列数
 echo "共有:".$res->num_rows."行;共有:".$res->field_count."列。";
 //获取表头---从$res取出
 echo "

";
 while($field=$res->fetch_field()){
   echo "";
 }
 echo "";
 //循环取出数据
 while($row=$res->fetch_row()){
  echo "";
  foreach($row as $value){
   echo "";
  }
  echo "";
 }
 echo "
{$field->name}
$value
";
 $res->free();
}
showTable($mysqli,"news");
?>

希望本文所述对大家的php程序设计有所帮助。

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Recommendations
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template