Assignment: Q.3 Solution

Consider the following entities and their relationships. Crop (c_no, c_name, c_season, pesticides) Farmer (f_no, f_name, f_location) The relationship between Crop and Farmer is many-to-many with descriptive attribute year. Create a RDB in 3 NF for the above. Using the above database write a PHP script to accept crop name and year value. Display total number of farmers harvesting given crop in a given year.

Index.html


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

Backend.php

    
                  <?php
  $conn=mysql_connect("localhost","root","");
  $sd=mysql_select_db("farm");
  $year=$_POST['year'];
  $query=mysql_query("
                        Select c.cname,f.fname,c.season
                        from crop c,farmer f,cr_fa cf
                        where c.cno=cf.cno and f.fno=cf.fno and cf.year='$year';
  ");
  echo"cultivation in year $year<br><br>";
  while ($result=mysql_fetch_array($query)) 
  {
    echo"Crop name :$result[0]<br>";
    echo"Cultivated by farmer :$result[1]<br>";
    echo"in season :$result[2]<br><br>";
  }
?>

Coding Gear

Assignment: Q.3 Solution

Index.html

Backend.php

Post a Comment

0 Comments

Menu Footer Widget

Contact form