前端输入
<?php foreach($pic as $p) {?>
<tr align="center">
<td><?php echo $p['id'];?></td>
<td><?php echo $p['picturename'];?></td>
<td><?php echo $p['picturetime'];?></td>
<td>
<a href="pic_edit.php?id=<?php echo $p['id'];?>" class="ui mini teal basic button">编辑</a>
<a href="pic_del.php?id=<?php echo $p['id'];?>" onclick="return confirm('确定要删除该照片吗?三思啊! 删了可就没了!')"
class="ui mini red basic button">删除</a>
</td>
</tr>
<?php }?>
PHP删除数据,并使id自动重新排序
<?php
$id = $_GET['id'];
//echo $id;
header('Content-type:text/html;charset=utf-8');
//连接认证
$link = mysqli_connect('localhost:3306','root','123456') or die('连接失败');
//设定字符集
mysqli_query($link,'set names utf8');
//选择数据库
mysqli_query($link,'use myblog');
//判断是否为数字
if (!is_numeric($id)){
echo 'id不合格';
exit();
}
/*
//检测栏目是否存在
$sql = "select count(*) from pictures where id = $id";
$rs = mysqli_query($link,$sql);
if (mysqli_fetch_row($rs)[0]!=0){
echo '栏目下有文章不能删';
exit();
}
*/
//检测完毕,删除栏目
$sql = "delete from pictures where id = $id";
if (!mysqli_query($link,$sql)){
echo '删除失败';
}else{
echo '删除成功';
}
//使id重新排序,删除id字段,从新插入id字段,设置主键自动排序
$sql = "alter table myblog.pictures drop id";
mysqli_query($link,$sql);
$sql = "alter table myblog.pictures add id int not null primary key auto_increment first";
mysqli_query($link,$sql);