Where did this delete go wrong?
|
Paper Title |
Comments |
Upload Date |
Delete |
$con = @mysql_connect ("localhost", "root", "") or Die ("Failed to connect the database"); mysql_select_db ("ICCP", $con); mysql_query ("Set names ' GBK '"); $sql = "SELECT * from T_paper where contributor_id=118"; $query = mysql_query ($sql), while ($ Row=mysql_fetch_array ($query)) {?>
|
|
|
|
|
}
if (!empty ($_post[' name ')) {
$str = Explode (",", $_post[' name ');
mysql_query ("Delete from T_paper where Paper_title in ($STR)");}
?>
Here's a test of why you can't get the value of $_post[' name ']
------Solution--------------------
The form form is not
------Solution--------------------
In addition, it should be used isset () to determine whether the form should be submitted.
PHP Code
if (isset ($_post[' name ')) { $str = explode (",", $_post[' name ']); mysql_query ("Delete from T_paper where Paper_title in ($STR)"); Obviously there is a problem here, the explode () function returns an array, the SQL statement syntax is wrong}