<h1>修改記錄</h1>?
<?php?
??? if(isset($_POST['btnModify'])){?
??????? //驗證表單省略?
??????? $sql = "UPDATE animal SET WHERE ID = '$_POST[id]'";?
??????? $result = mysqli_query($sql);?? //執行更新?
??????? if($result){?
??????????? echo "修改已經成功!";?
??????? }?
??????? else?
??????? {?
??????????? echo "修改失敗!";?
??????? }?
??? }?
??? //查詢當前的記錄?
??? $query = "SELECT * FROM symbols";?
??? //執行該查詢?
??? if($result = $mysqli->query($query)){?
??????? //顯示返回的記錄集行數?
??????? if($result->num_rows>0){?
??????????? //如果有記錄?
??????????? //顯示記錄集中列的內容?
??????????? echo "<table cellpadding=10 border=1>";?
??????????? while($row=$result->fetch_array()){?
??????????????? echo "<tr>";?
??????????????? echo "<td><input name='id' type='text' id='id' value='$row[0]'/></td>";?
??????????????? echo "<td><input name='country' type='text' id='country' value='$row[1]'/></td>";?
??????????????? echo "<td><input name='animal' type='text' id='animal' value='$row[2]' /></td>";?
??????????????? echo "<td><input name='btnModify' type='submit' id='btnModify' value='修改' /></td>";?
??????????????? echo "</tr>";?
??????????? }?
??????? }?
??????? //釋放對象所占用的內存?
??????? $result->close();?
??? }?
?>