Modify<?php $code= $_get["C"]; //Connecting Objects$db =NewMysqli ("localhost","Root","123","MyDB"); //Write SQL statements$sinfo ="SELECT * from info where code= ' {$code} '"; $rinfo= $dbquery ($sinfo); $ainfo= $rinfoFetch_row ();? ><form action="xiugaichuli.php"Method="Post"> <div><input type="Hidden"Name="Code"Value="<?php echo $ainfo [0];?>"/></div> <div> Name: <input type="text"Name="name"Value="<?php echo $ainfo [1];?>"/></div> <div>Gender:<input type="Radio"Name="Sex"Value="1"<?php Echo $ainfo [2]?"checked= ' checked '":""?>/>male <input type="Radio"Name="Sex"Value="0"<?php Echo $ainfo [2]?"":"checked= ' checked '"?>/>female</div> <div>Ethnicity:<SelectName="Nation"> <?php $sql="SELECT * FROM Nation"; $result= $dbquery ($sql); $attr= $resultFetch_all (); foreach($attr as$v) { if($v [0]== $ainfo [3]) {echo"<option selected= ' selected ' value= ' {$v [0]} ' >{$v [1]}</option>"; } Else{echo"<option value= ' {$v [0]} ' >{$v [1]}</option>"; } } ?> </Select> </div> <div> Birthdays: <input type="text"Name="Birthday"Value="<?php Echo $ainfo [4];?>"/></div> <div><input type="Submit"Value="Modify"/></div></form>Modify Processing
<?Php$code= $_post["Code"]; $name= $_post["name"]; $sex= $_post["Sex"]; $nation= $_post["Nation"]; $birthday= $_post["Birthday"];//Connecting Objects$db =NewMysqli ("localhost","Root","123","MyDB"); $sql="Update Info Set name= ' {$name} ', sex={$sex},nation= ' {$nation} ', birthday= ' {$birthday} ' where code= ' {$code} '"; $db-query ($sql); Header ("location:main.php");
php-> mSQL Modification