php_pizaa_project/details.php at master · sidaaryan7/php_pizaa_project · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
<?php
include('config/db_connect.php');

if(isset($_POST['delete'])){
  $id_to_delete=mysqli_real_escape_string($conn,$_POST['id_to_delete']);
  $sql="DELETE FROM pizza WHERE id=$id_to_delete";

  if(mysqli_query($conn,$sql)){
    //success
header('Location: index.php');
  }{
     // failure
echo "query error:".mysqli_error($conn);

  }


}


//check get request id parameter

if(isset($_GET['id'])){
  $id=mysqli_real_escape_string($conn,$_GET['id']);

//make sql
$sql="SELECT * FROM pizza WHERE id=$id";

//get the query results
$result=mysqli_query($conn,$sql);

//fetch the result in an array format
$pizza=mysqli_fetch_assoc($result);


mysqli_free_result($result);
mysqli_close($conn);


}

?>


<!DOCTYPE html>
<html lang="en" dir="ltr">
  <?php  include('templates/header.php');    ?>
<div class="container center grey-text">
  <?php if($pizza): ?>
<h4> <?php echo htmlspecialchars($pizza['title']); ?> </h4>
<p> created by : <?php echo htmlspecialchars($pizza['email']); ?></p>
<p><?php echo date($pizza['created_at']); ?></p>

<h5>Ingrediant</h5>
<p><?php echo htmlspecialchars($pizza['ingredinat']); ?></p>


<!--delete form-->
<form class="" action="details.php" method="POST">
  <input type="hidden" name="id_to_delete" value="<?php echo $pizza['id']; ?>">
  <input type="submit" name="delete" value="Delete" class="btn brand z-depth-0">
</form>

  <?php else:  ?>

<h5>NO such pizza exists!</h5>
  <?php endif; ?>

</div>

  <?php include('templates/footer.php'); ?>
</html>