<H1> modify record </p> <br/> <? Php <br/> If (isset ($ _ post ['btnmodify']) {<br/> // verification form omitted <br/> $ SQL = "Update animal set where id = '$ _ post [ID]'"; <br/> $ result = mysqli_query ($ SQL); // execute update <br/> if ($ result) {<br/> echo "modification successful! "; <Br/>}< br/> else <br/>{< br/> echo" modification failed! "; <Br/>}< br/> // query the current record <br/> $ query =" select * from symbols "; </P> <p> // execute the query <br/> if ($ result = $ mysqli-> query ($ query )) {<br/> // display the number of returned records <br/> if ($ result-> num_rows> 0) {<br/> // If a record exists <br/> // display the content of the columns in the record set <br/> echo "<Table cellpadding = 10 border = 1> "; <br/> while ($ ROW = $ result-> fetch_array () {<br/> echo "<tr> "; <br/> echo "<TD> <input name = 'id' type = 'text' id = 'id' value = '$ row [0]'/> </TD> "; <br/> echo "<t D> <input name = 'country' type = 'text' id = 'country' value = '$ row [1]'/> </TD> "; <br/> echo "<TD> <input name = 'original' type = 'text' id = 'original' value = '$ row [2]'/> </TD> "; <br/> echo "<TD> <input name = 'btnmodify 'type = 'submit' Id = 'btnmodify 'value = 'modify'/> </TD> "; <br/> echo "</tr> "; <br/>}< br/> // release the memory occupied by the object <br/> $ result-> close (); <br/>}< br/>?>