connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "use project"; if ($conn->query($sql) === TRUE) {} else { echo "Error creating database: " . $conn->error; } $sql = "SELECT uname,email FROM login"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { $uname=$row["uname"]; $umail=$row["email"]; } } else { echo "0 results"; } if($uname==="NULL") { header('location: check.php'); } $conn->close(); ?> Book

booked movies



connect_error) { die("Connection failed: " . $conn->connect_error); } // Create database $sql = "use project"; if ($conn->query($sql) === TRUE) {} else { echo "Error creating database: " . $conn->error; } $sq= "SELECT Mid,QTY,vanue,time, price,Mname FROM movies,book where Mid=Eid and umail='$umail' "; $result = $conn->query($sq); if ($result->num_rows> 0) { // output data of each row while($row = $result->fetch_assoc()) { $z=$row["Mname"]; $y=$row["QTY"]; $a=$row["Mid"]; $b=$row["vanue"]; $c=$row["time"]; $e=$row["price"]; echo NL2BR("Movie name: $z \n event_id: $a     vanue: $b     time: $c   ");echo nl2br("\t cost: $e     for: $y people\n") ; } } else { echo "0 results"; } $conn->close(); ?>