deleteFormSQL.php


<!DOCTYPE HTML>
<html dir=RTL>
	<head>
		<meta charset="UTF-8">
			<title>מערכת לניהול אירועים</title>
			<link rel="stylesheet" type="text/css" href="include/cssstyle.css">
			<script language="JavaScript" src="include/javascript.js"></script>
	</head>

	<body onLoad=mark()>
		<script>document.write(header)</script>

		<div id="wrapper">
			<main>
				<h2> מחיקה של מנה</h2>
				<section>
								
				<?php
								$servername = "localhost";
								$username = "root";
								$password = "";
								$dbname = "reservvationmanager";
								// Create connection
								$conn = mysqli_connect($servername, $username, $password, $dbname);
								// Check connection
								if (!$conn) {
									die("Connection failed: " . mysqli_connect_error());
								}

								$sql="DELETE FROM  dish
								WHERE 
								Id_dish=('".$_POST['Id_dish']."')";
								if (mysqli_query($conn, $sql)) {
									echo " Record was delete successfully return to table";
								} else {
									echo "Error: " . $sql . "<br>" . mysqli_error($conn);
								}

								mysqli_close($conn);
								?>

				</section>	
			</main>
			
			<script>document.write(sideNav)</script>
			<script>document.write(footer)</script>
	</div>
	
</body>
</html>