Assignment: Q.1 Solution

Consider the following entities and their relationships. Client (c_no, c_name, c_addr, birth_date) Policy_info (p_no, p_name, maturity_amt, prem_amt, policy_term) The relationship between Client and Policy_info is many-to-many with descriptive attribute date_of_purchase. Create a RDB in 3NF for the above. Using the above database write a PHP script to display policy details of a given client for a given year in the following format.

Index.html


          <html>
  <body>
    <form action="backend.php" method="post">
      <input type="text" name="cname" placeholder="Cname">
      <br><br>
      <input type="number" name="year" placeholder="Year">
      <br></br>
      <input type="submit">
    </form>
  </body>
</html>

Backend.php


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

  $cn=$_POST['cname'];
  $year=$_POST['year'];

  $query=mysql_query("Select p.pname,p.pmat_amt
  from client c,policy_info p,cl_po cp
  where c.cno=cp.cno and p.pno=cp.pno and cp.pyear='$year' and c.cname='$cn';");

echo"Client name: $cn<br>";
echo"Year: $year<br>";

while ($result=mysql_fetch_array($query))
 {
  echo"Policy name: $result[0]";
  echo"Premium Account: $result[1]";
}
echo "</table>";

?>

Coding Gear

Assignment: Q.1 Solution

Index.html

Backend.php

Post a Comment

0 Comments

Menu Footer Widget

Contact form