Home > Article > Backend Development > How to simply modify mysql data in php
php method to simply modify mysql data: first connect to the database; then execute the SQL statement "select * from users;"; then query through "mysqli_query($conn,$sql);"; finally use the update method Just modify the mysql data.
The operating environment of this article: windows7 system, PHP7.1 version, DELL G3 computer
How to simply modify mysql data with php?
PHP Simple implementation of modifying data
index.php
<?php
$mysql_server_name='127.0.0.1'; //改成自己的mysql数据库服务器
$mysql_username='root'; //改成自己的mysql数据库用户名
$mysql_password=''; //改成自己的mysql数据库密码
$mysql_database='chuan'; //改成自己的mysql数据库名
$conn=mysqli_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database) or die("error connecting") ; //连接数据库
$sql ="select * from users ;"; //SQL语句
$result = mysqli_query($conn,$sql); //查询
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>可编辑表格DEMO</title>
</head>
<body>
<div class="container">
<table class="data" >
<tr>
<td>id</td>
<td>name</td>
<td >操作</td>
</tr>
<?php
while($row = mysqli_fetch_array($result))
{
echo "<tr>" ;
echo "<td>".$row['id']."</td>";
echo "<td>".$row['username']."</td>";
$id=$row['id'];
echo "<td><a href=update.php?id=$id>修改</a></td>";
echo " </tr>";
}
?>
</table>
</div>
</body>
</html>update.php
<?php
/**
* Created by PhpStorm.
* User: Administrator
* Date: 2018/6/17
* Time: 17:54
*/
$id = $_GET['id'];
$mysql_server_name='127.0.0.1'; //改成自己的mysql数据库服务器
$mysql_username='root'; //改成自己的mysql数据库用户名
$mysql_password=''; //改成自己的mysql数据库密码
$mysql_database='chuan'; //改成自己的mysql数据库名
$conn=mysqli_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database) or die("error connecting") ; //连接数据库
$sql ="select * from users where id= $id ;"; //SQL语句
$result = mysqli_query($conn,$sql); //查询
while($row = mysqli_fetch_array($result))
{
$username=$row['username'];
}
?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>可编辑表格DEMO</title>
</head>
<body>
<form method="post" action="doUpdate.php?id=<?php echo $id ?>">
username:<input type="text" name='username' value=<?php echo $username?>><br/>
<input type="submit">
</form>
</body>
</html>doUpdate.php
<?php
$mysql_server_name='127.0.0.1'; //改成自己的mysql数据库服务器
$mysql_username='root'; //改成自己的mysql数据库用户名
$mysql_password=''; //改成自己的mysql数据库密码
$mysql_database='chuan'; //改成自己的mysql数据库名
$conn=mysqli_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database) or die("error connecting") ; //连接数据库
$id = $_GET['id'];
$username = $_POST['username'];
$sql="update users set username= '"."$username' where id = $id";
$result= mysqli_query($conn,$sql);
if($result){
exit("<script>
alert('修改成功');
location.href='index.php'
</script>");
}else{
exit("<script>
alert('修改失败');
location.href='index.php';
</script>");
}
?>Recommended study: " PHP video tutorial》
The above is the detailed content of How to simply modify mysql data in php. For more information, please follow other related articles on the PHP Chinese website!