How to modify mysql data in php

php method to modify mysql data: first obtain the user number through GET to query user information; then create an update.php file to modify user information; finally return the number of rows in the previous record through "mysql_affected_rows".

The operating environment of this tutorial: Windows 7 system, PHP version 5.6. This method is suitable for all brands of computers.

Recommended: "PHP Video Tutorial"

PHP MYSQL Modify and Delete Data

Create userinfo_update.php for query User information, display the information first, then modify:

First obtain the user number through GET to query the user information:

 $sql = "select * from user_info where user_id='".$_GET['userId']."'";
 $result = mysql_query($sql,$con);
 if($row = mysql_fetch_array($result)){
}

Page effect:

Create the update.php file to modify user information:

The mysql_affected_rows() function is used to return the number of record rows affected by the previous MySQL operation.

//通过post获取页面提交数据信息
$userId = $_POST[userId];
$userName = $_POST[userName];
$userAge = $_POST[userAge];
 
$sql = "update user_info set user_name='".$userName."',user_age=".$userAge." where user_id='".$userId."'";
mysql_query($sql,$conn);//执行SQL
$mark  = mysql_affected_rows();//返回影响行数
$url = "userinf_select.php";

Running results

Create delete.php file , Complete the function of deleting user information:

$userId = $_GET['userId'];
 
include 'connection.php';
 
$sql = "delete from user_info where user_id='".$userId."'";
 
mysql_query($sql,$con);
 
$mark  = mysql_affected_rows();//返回影响行数
 
if($mark>0){
 echo "删除成功";
}else{
 echo  "删除失败";
}
 
mysql_close($con);

## Running results:

successfully deleted

The above is the detailed content of How to modify mysql data in php. For more information, please follow other related articles on the PHP Chinese website!