mysql 排序 源码,PHP+MySQL数据库ID重新排序源码

$localhost="localhost";$root="root";$password="123456";$datebest="db_ku";$conn=mysqli_connect($localhost,$root,$password,$datebest) or die("数据库服务器连接错误".mysqli_error($conn));mysqli_select_db($conn,$datebest) or die("数据库访问错误".mysqli_error($conn));mysqli_query($conn,"set character set utf8");mysqli_query($conn,"set names utf8");functionedit_id()

{Global $conn;$table_name=$_POST[‘name‘];$sql="ALTER TABLE `".$table_name."` DROP id";$sql1="ALTER TABLE `".$table_name."` ADD id MEDIUMINT(8) NOT NULL FIRST";$sql2="ALTER TABLE `".$table_name."` MODIFY COLUMN id MEDIUMINT(8) NOT NULL AUTO_INCREMENT,ADD PRIMARY KEY(id)";mysqli_query($conn,$sql);mysqli_query($conn,$sql1);mysqli_query($conn,$sql2);echo mysqli_error($conn);echo "";exit;

}if ($_SERVER[‘REQUEST_METHOD‘] === ‘POST‘) {

edit_id();

}?>

重置ID

margin:50px 30%;

width:400px;

}

div{

display:inline;

}

label{

border:1px solid;

background-color: #4CAF50;

}

input{

width:200px;

padding:7px 0px;

}

button {

background-color: #4CAF50;

}

表名:

提交

二、展示

PHP+MySQL数据库ID重新排序源码

标签：incr   cti   Enctype   line   label   null   成功   password   name

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：https://www.cnblogs.com/wlei5206/p/13222825.html