دو نمونه کد برای شما آماده کرده ایم ، اول طریقه حذف بر اساس table
<?php mysql_connect("mysql153.iranpage.net","java2s","password"); mysql_select_db("java2s"); $rowID = "001"; $query = "DELETE FROM Employee WHERE ID='$rowID'"; $result = mysql_query($query); if ((mysql_affected_rows() == 0) || mysql_affected_rows() == -1) { echo "<p>There was a problem deleting some of the selected items.</p>"; exit; } ?>
و کد زیر حذف بر اساس ID می باشد .
<html> <body> <?php $cnx = mysql_connect('mysql153.secureserver.net','java2s','password'); mysql_select_db('java2s'); $id = '1'; $ok1 = @mysql_query("DELETE FROM Employee WHERE ID='$id'"); if ($ok1) { echo('<p>Author deleted successfully!</p>'); } else { echo('<p>Error deleting author from database!<br />'. 'Error: ' . mysql_error() . '</p>'); } ?> </body> </html>
دیدگاه بگذارید
Be the First to Comment!