How to simply modify mysql data in php-PHP Problem-php.cn

How to simply modify mysql data in php

藏色散人

Release： 2023-03-11 06:56:02

Original

3267 people have browsed it

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.

How to simply modify mysql data in php

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=&#39;127.0.0.1&#39;; //改成自己的mysql数据库服务器
$mysql_username=&#39;root&#39;; //改成自己的mysql数据库用户名
$mysql_password=&#39;&#39;; //改成自己的mysql数据库密码
$mysql_database=&#39;chuan&#39;; //改成自己的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[&#39;id&#39;]."</td>";
                    echo "<td>".$row[&#39;username&#39;]."</td>";
                    $id=$row[&#39;id&#39;];
                    echo "<td><a href=update.php?id=$id>修改</a></td>";
                    echo " </tr>";
                }
            ?>
    </table>
</div>
</body>
</html>

Copy after login

update.php

<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2018/6/17
 * Time: 17:54
 */
$id = $_GET[&#39;id&#39;];
$mysql_server_name=&#39;127.0.0.1&#39;; //改成自己的mysql数据库服务器
$mysql_username=&#39;root&#39;; //改成自己的mysql数据库用户名
$mysql_password=&#39;&#39;; //改成自己的mysql数据库密码
$mysql_database=&#39;chuan&#39;; //改成自己的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[&#39;username&#39;];
}
?>
<!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=&#39;username&#39; value=<?php echo  $username?>><br/>
<input type="submit">
</form>
</body>
</html>

Copy after login

doUpdate.php

<?php
$mysql_server_name=&#39;127.0.0.1&#39;; //改成自己的mysql数据库服务器
$mysql_username=&#39;root&#39;; //改成自己的mysql数据库用户名
$mysql_password=&#39;&#39;; //改成自己的mysql数据库密码
$mysql_database=&#39;chuan&#39;; //改成自己的mysql数据库名
$conn=mysqli_connect($mysql_server_name,$mysql_username,$mysql_password,$mysql_database) or die("error connecting") ; //连接数据库
    $id = $_GET[&#39;id&#39;];
    $username = $_POST[&#39;username&#39;];
    $sql="update users set username= &#39;"."$username&#39; where id = $id";
    $result= mysqli_query($conn,$sql);
    if($result){
        exit("<script>
            alert(&#39;修改成功&#39;);
            location.href=&#39;index.php&#39;
        </script>");
    }else{
        exit("<script>
            alert(&#39;修改失败&#39;);
            location.href=&#39;index.php&#39;;
        </script>");
    }
?>

Copy after login

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!