Assignment: Q.2 Solution

Consider the following entities and their relationships. Train(t_no, t_name) Passenger (p_no, p_name, addr, age) The relationship between Train and Passenger is many-to-many with descriptive attribute date, seat_no and amt. Create a RDB in 3 NF for the above. Using the above database write a PHP script to accept a date. Display train details having maximum passenger for a given date.

Index.html


          <html>
  <body>
    <form action="backend.php" method="post">
      <input type="date" name="tdate">
      <br><br>
      <input type="submit">
    </form>
  </body>
</html>

Backend.php

    
                  <?php
  $conn=mysql_connect("localhost","root","");
  $sd=mysql_select_db("trainmanager");

  $query=mysql_query("SELECT t.tno, t.tname, COUNT( tp.pno ) AS passenger_count
  FROM Train t, train_pass tp
  WHERE tp.date = '2023-11-05'
  AND t.tno = tp.tno
  GROUP BY t.tno, t.tname
  ORDER BY passenger_count DESC
  LIMIT 1 ;");

  while ($result=mysql_fetch_array($query)) 
  {
    echo"Train number: $result[0]<br>";
    echo"Train name: $result[1]<br>";
    echo"Total passenger: $result[2]";
  }
?>

Coding Gear

Assignment: Q.2 Solution

Index.html

Backend.php

Post a Comment

0 Comments

Menu Footer Widget

Contact form