php+mysqli建表读多条单条增改查完整实例

表格和字段都符号 `处理，支持中文字段

<style>
table{display:block;border:1px #ccc solid;border-top:3px #ccc blue;}
</style>
<?php
error_reporting(0);
header("content-Type: text/html; charset=utf-8");//输出编码不要修改

//测试请先修改以下五个参数
$dbhost = "localhost"; //数据库地址 本地localhost
$dbuser = "chalide"; //数据库用户名
$dbpass = "888888"; //数据库密码
$dbname = "chalide"; //数据库名称
$biaoge = "chafenba_com"; //创建的数据表名称

//连接数据库
$conn = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
if (!$conn) { die("连接失败: " . mysqli_connect_error()); }
//mysqli_query($conn,"set names utf8");

//建表：有则建立 mysql<5.6 CURRENT_TIMESTAMP改为''
$domas = "InnoDB";
$sqldo="CREATE TABLE `{$biaoge}` (
 `chalide_id` int(10) unsigned NOT NULL PRIMARY KEY AUTO_INCREMENT,
 `chalide_ps` varchar(32) DEFAULT '-',
 `chalide_mobi` varchar(32) NOT NULL,
 `chalide_name` varchar(32) DEFAULT '名称',
 `chalide_qian` varchar(32) DEFAULT '0.88',
 `check` int(4) NOT NULL DEFAULT '0',
 `chalide_addtime` datetime DEFAULT CURRENT_TIMESTAMP,
 `chalide_paytime` datetime DEFAULT CURRENT_TIMESTAMP,
  KEY `chalide_mobi` (`chalide_mobi`)
 ) ENGINE={$domas} DEFAULT CHARSET=utf8";
$resu = mysqli_query($conn, $sqldo);
if (!$resu){
echo "<br><b>建库出错：</b>".mysqli_error($conn);
}else{
echo "<br><b>建库成功：</b>";
}

//新插入数据
$pici="DD".Date("Ymd").uniqid();
$mobi="15058593138";
$name="admin@ewuyi.net";
$qian="1.88";
$pt="`chalide_ps`,`chalide_mobi`,`chalide_name`,`chalide_qian`";
$pz="'$pici','$mobi','$name','$qian'";
$sqlu = "INSERT INTO `{$biaoge}` ($pt) VALUES ($pz)";
$resu = mysqli_query($conn, $sqlu);
if (!$resu){
echo "<br><b>插入出错：</b>".mysqli_error($conn);
}else{
echo "<br><b>插入成功：</b>";
}

//列出所有数据 自己可以加条件 where
$sqlu = "select * from `{$biaoge}` Limit 0,5";
$resu = mysqli_query($conn, $sqlu); 
if (mysqli_num_rows($resu) > 0) {
  echo "<table style=\"tb\">\r\n<caption>读取前5条内容</caption>";
 while($row = mysqli_fetch_assoc($resu)) {
  echo "<tr>";
  foreach($row as $rew) echo "<td>$rew</td>";
  echo "</tr>";
 }
  echo "</table>";
}else{
  echo "<table><tr><td>提示</td><td>无结果</td></tr></table>";
} 

//读取单条数据(id=2)
$id = "2";
$sqlu = "select * from `{$biaoge}` WHERE `chalide_id`={$id}";
$resu = mysqli_query($conn, $sqlu);
if (!$resu){
echo "<br><b>读取数据出错：</b>".mysqli_error($conn);
}else{
  echo "<table style=\"tb\">\r\n<caption>读取ID=2内容</caption>";
while($row = mysqli_fetch_assoc($resu)){
  echo "<tr>";
  foreach($row as &$rew) echo "<td>$rew</td>";
  echo "</tr>";
}
  echo "</table>";
}

//修改第二条(id=2)数据
$id = "2"; $zduan = "chalide_mobi"; $nval = date("YmdHis");
$sqlu = "UPDATE `{$biaoge}` SET `{$zduan}`='{$nval}' WHERE `chalide_id`={$id}";
$resu = mysqli_query($conn, $sqlu);
if (!$resu){
echo "<br><b>更新出错：</b>".mysqli_error($conn);
}else{
echo "<br><b>更新成功：</b>";
}

//重新读取单条数据(id=2)
$id = "2";
$sqlu = "select * from `{$biaoge}` WHERE `chalide_id`={$id}";
$resu = mysqli_query($conn, $sqlu);
if (!$resu){
echo "<br><b>读取数据出错：</b>".mysqli_error($conn);
}else{
  echo "<table style=\"tb\">\r\n<caption>重新读取ID=2内容</caption>";
while($row = mysqli_fetch_assoc($resu)){
  echo "<tr>";
  foreach($row as &$rew) echo "<td>$rew</td>";
  echo "</tr>";
}
  echo "</table>";
}

//删除 ID=3 得数据
$id = "3";
if($id=="" || !is_numeric($id)) eixt("ID传递失败无效");
$sqlc = "DELETE FROM `{$biaoge}` WHERE `chalide_id`={$id}";
$resu = mysqli_query($conn, $sqlc);
if (!$resu){
echo "<br><b>删除出错：</b>".mysqli_error($conn);
}else{
echo "<br><b>删除成功：</b>";
}

mysqli_close($conn);//关闭数据库
?>