Assignment: Q.1 Solution

Consider the following entities and their relationships. Employee (eno, ename, sal) Project (pno, pname,duration) Employee and Project are related with a many-many relationship. Create a RDB in 3 NF for the above. Using the above database write a PHP script to accept the project name. Display the name ofthe employees and the duration of the project.

Index.html


          <html>
  <body align="center">
    <form action="backend.php" method="post">
      <input type="text" name="pname" placeholder="Project Name">
      <br><br>
      <input type="submit">
    </form>
  </body>
</html>

Backend.php


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

  $conn=mysql_connect("localhost","root","");

  $sd=mysql_select_db("projectmanager");

  $query=mysql_query("SELECT e.eno,p.pno,pm.eduration,e.ename
  FROM pro_emp pm, employee e, project p
  WHERE p.pno = pm.pno
  AND e.eno = pm.eno
  AND p.pname ='$pname';");
  
  if(!$query)
  {
    echo"Not a valid project name";
  }
  
  while ($result=mysql_fetch_array($query))
   {
      echo"Eno: $result[0] <br>";
      echo"Pno : $result[1]<br>";
      echo"Employee Duration : $result[2]<br>";
      echo"Employee Name : $result[3]<br><br>";
  }

?>

Coding Gear

Assignment: Q.1 Solution

Index.html

Backend.php

Post a Comment

0 Comments

Menu Footer Widget

Contact form