I Have got Error in the Foreach loop
in below Code,Can any one Help me to Fix the
Error...
action=" $_SERVER['PHP_SELF'];?>">
$dbc=mysqli_connect("localhost","root","","elvis_store")
or die("Error Connecting to Mysql
Database");
if(isset($_POST['submit'])){
foreach($_POST['todelete']
as delete_id){
$query="DELETE FROM email_list WHERE
id=$delete_id";
mysqli_query($dbc,$query) or die("Error Querying
Database");
}
echo "Customer(s)
Removed";
}
$query="SELECT
* FROM email_list";
$result=mysqli_query($dbc,$query)or die("Query Syntaxt is
Incorrect");
while($row=mysqli_fetch_array($result)){
echo
' name="todelete[]"/>';
echo $row['first_name']." ".$row['last_name']."
".$row['email'];
echo
"
";
}
mysqli_close($dbc);
?>
type="submit" name"submit"
value="Remove"/>
No comments:
Post a Comment