如何从PHP中删除MySQL数据库中的条目 [英] How to delete an entry in a MySQL Database from PHP

问题描述

<?php
		include '../forms/includes/connection.php';
		
		$sql = "SELECT FROM (booking_request) WHERE `booking_request_id`";
		$query = mysqli_query ($link,$sql);
		
		if (isset ($_POST['booking_request_id']))
	
	{	

		$id = $_POST['booking_request_id'];
		$sql = "DELETE from booking_requests where `booking_request_id` ='$id'";
		$query = mysqli_query ($link,$sql);
		
		
		if ($query)
	{
		header('location:whatsBooked.php');	
	}
	else
	{
		echo "Error: Record was not deleted" .mysql_error();
	}
	
	}
	
	else 
		
	echo " Function Error " .mysql_error();
?>

点击删除按钮时功能错误，任何人都可以帮助我吗？

When the delete button is clicked Function Error, can anyone help me ?

推荐答案

sql = SELECT FROM（booking_request）WHERE`review_request_id`;

sql = "SELECT FROM (booking_request) WHERE `booking_request_id`";

query = mysqli_query（

query = mysqli_query (

link，

这篇关于如何从PHP中删除MySQL数据库中的条目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！