Home > Article > Backend Development > How to modify data in php form
How to modify data in php form: first create the "xiugai.php" page; then execute the statement "select * from info where code='{$code}'"; finally create the "update.php" page and Execute the update command to update the data.
Recommended: "PHP Video Tutorial"
php form modification data
First one Page xiugai.php
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>无标题文档</title> </head> <body> <h1>修改数据</h1> <?php $code = $_GET["code"]; $db = new MySQLi("localhost","root","root","dbname"); $sql = "select * from info where code='{$code}'"; $result = $db->query($sql); $arr = $result->fetch_row(); ?> <form action="update.php" method="post"> <div> <input type="hidden" name="code" value="<?php echo $arr[0]; ?>" /> </div> <div>姓名: <input type="text" name="name" value="<?php echo $arr[1]; ?>" /> </div> <div>性别: <input type="radio" name="sex" value="1" <?php echo $arr[2]?"checked='checked'":""; ?> />男 <input type="radio" name="sex" value="0" <?php echo $arr[2]?"":"checked='checked'"; ?> />女 </div> <div>民族: <select name="nation"> <?php $snation = "select * from nation"; $rnation = $db->query($snation); while($attr = $rnation->fetch_row()) { //判断将要输出的民族是否和该人员的相同 if($arr[3]==$attr[0]) { echo "<option value='{$attr[0]}' selected='selected'>{$attr[1]}</option>"; } else { echo "<option value='{$attr[0]}'>{$attr[1]}</option>"; } } ?> </select> </div> <div>生日: <input type="text" name="birthday" value="<?php echo $arr[4] ?>" /> </div> <div><input type="submit" value="修改" /></div> </form> </body> </html>
1. The code item is the primary key in the database and cannot be changed, so it must be set to type="hidden". You can also use type="text" style="display:none". The readonly attribute can also be used, but the disable attribute cannot be used. (Disable means to make it unavailable. Although it cannot be modified, it does not pass information to the back.)
2. It is easier to write gender with the ternary operator.
3. Modify the selection of page default value.
4. $db = new MySQLi("localhost","root","root","dbname"); You only need to write it once in this page, and you do not need to write it again in the php code inserted later. .
The second page update.php
<?php $code = $_POST["code"]; $name = $_POST["name"]; $sex = $_POST["sex"]; $nation = $_POST["nation"]; $birthday = $_POST["birthday"]; $db = new MySQLi("localhost","root","root","dbname"); $sql = "update info set name='{$name}',sex={$sex},nation='{$nation}',birthday='{$birthday}' where code='{$code}'"; if($db->query($sql)) { header("location:main.php"); } else { echo "修改失败!"; }
The above is the detailed content of How to modify data in php form. For more information, please follow other related articles on the PHP Chinese website!