Assignment: Practice Set Q.2 Solution

Consider the following entities and their relationships Customer (c_no, c_name, c_city, c_ph_no ) Ticket (t_no, booking_date, fare, traveling_date) The relationship between Customer and Ticket is one-to-many. Create a RDB in 3 NF for the above. Using the above database, write a PHP script to accept date and display, 1) The total fare collected from customers on a given date. 2) Ticket details booked by the customer.


          <html>
  <body>
    <form action="backend.php" method="post">
        Select Travel Date:
      <input type="date" name="td">
      <br><br>
      <input type="submit">
    </form>
  </body>
</html>


                  <?php
$td = $_POST['td'];

$conn = mysql_connect("localhost", "root", "");
if (!$conn) {
  echo "Not connected to db";
}

$cd = mysql_select_db("ticketmanagement");
if (!$cd) {
  echo "Not selected db";
}

/*Count can display total fare*/
$q1 = mysql_query("  SELECT SUM( t.fare )
  FROM ticket t, customer c
  WHERE c.cno = t.cno
  AND t.tdate = '$td';
                    ");

$result = mysql_fetch_array($q1);

echo " Total Fare collected on Travel Date $td is : $result[0] Rs<br><br>";

/* Display custumer details*/
$q2 = mysql_query("  SELECT c.cno, c.cname, c.cphone,t.tno, t.bdate, t.fare
                /*            0       1         2       3    4         5*/      
  FROM ticket t, customer c
  WHERE c.cno = t.cno
  AND t.tdate = '$td';
                    ");

while($result=mysql_fetch_array($q2))
{
  echo"Customer number :       $result[0]<br>";
  echo"Customer name :         $result[1]<br>";
  echo"Customer phone number : $result[2]<br>";
  echo"Ticket number :         $result[3]<br>";
  echo"Ticket Booking Date :   $result[4]<br>";
  echo"Ticket Fare :           $result[5]<br><br>";
}
?>

Coding Gear

Assignment: Practice Set Q.2 Solution

Post a Comment

0 Comments

Menu Footer Widget

Contact form