restrobooking/custdetails.php at master · vjbytes101/restrobooking · 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
74
75
76
77
78
79
80
81
82
83
84
85

<!DOCTYPE html>
<html>
<head>
<body>
<a href ="index1.php">Back to main page</a>

<?php
include "mydbcon.php";


session_start();

if(isset($_POST['cust_name'])) {
    $_SESSION['cust_name'] = $_POST['cust_name'];
}
if(isset($_POST['qnt'])) {
    $_SESSION['qnt'] = $_POST['qnt'];
}
if(isset($_POST['rid'])) {
    $_SESSION['rid'] = $_POST['rid'];
}

$custname = $_SESSION['cust_name'];
$qnt = $_SESSION['qnt'];
$rid = $_SESSION['rid'];
$insertstatus = $_SESSION['err'];
$sql = "SELECT cid from customer where cname = {$custname}";
$result = mysql_query( $sql, $con);
$value = mysql_fetch_object($result);
$result1 = $value->cid;
if($insertstatus == "0"){
	$dispNone001 = "display:none";
	$dispNone111 = "display:block";
}else{
	$dispNone001 = "display:block";
	$dispNone111 = "display:none";
}
if(empty($value)){
	$dispNone01 = "display:none";
	$dispNone11 = "display:block";
}else{
	$dispNone01 = "display:block";
	$dispNone11 = "display:none";
}
?>
<div align="center" style="<?=$dispNone11?>">Customer id is invalid....</div>
<div style="<?=$dispNone01?>">
<div align="center" style="<?=$dispNone001?>">
<h4> Previous booking of <?php echo $custname; ?></h4><br><br>
<table border ="2">
<th> Restaurant Name </th>
<th> Number of Seats </th>
<th> Booking Time </th>
<?php
if($result1){
$sql1 = "SELECT r.rname,b.quantity,b.btime FROM booking as b, restaurant as r where b.cid = {$result1} and b.rid = r.rid ORDER BY b.bid ASC";
$result2 = mysql_query( $sql1, $con);
if ($result2) {
    // output data of each row
    while($data = mysql_fetch_array($result2,MYSQL_NUM)){
       ?>
		 <tr>
		 <td><?php echo $data[0]; ?></td>
		 <td><?php echo $data[1]; ?></td>
		 <td><?php echo $data[2]; ?></td>
		 </tr>
  <?php
    }
} else {
    echo "0 results";
}
}
else{
	echo "Customer id not found";
}
mysql_close($con);

?>
</table>
</div>
<div align="center" style="<?=$dispNone111?>">Booking is failed due to invalid quantity please try again....</div>
</div>
</body>
</html>