Program 1 :

Consider the following entities and their relationships Doctor (doc_no, doc_name, address, city, area) Hospital (hosp_no, hosp_name, hosp_city) Doctor and Hospital are related with many-many relationship. Create a RDB in 3 NF for the above and solve following Using above database, write a PHP script which accepts hospital name and print information about doctors visiting / working in that hospital in tabular format.

Answer :

File : Index.php

<html> <head> <link rel="stylesheet" href="style/style.css"> </head> <body> <div class="container"> <div class="row py-3 " > <div class="col-md-5 form-group py-2" style="border:2px solid gold"> <h4 class="text-center">Information About Doctors Visiting / Working in Hospital</h4><br> <form action="#" method="post"> <input type="text" name="str" class="form-control" Placeholder="Enter Hospital Name"> <br> <input type="submit" value="Submit" class="btn btn-info"> <input type="reset" value="Clear" class="btn btn-danger"> </form> </div> <div class="col-md-7"> <?php if(isset($_POST['str'])){ $conn = mysqli_connect("localhost","root","","slip26_db"); $sql = "SELECT * FROM Doctor d,Hospital h,doc_hos dh WHERE d.doc_no=dh.doc_no1 AND h.hosp_no=dh.hosp_no1"; $res = mysqli_query($conn,$sql); if(mysqli_num_rows($res)>0){ echo " <table class='table'> <tr> <thead class='thead-dark'> <th>Doctor ID</th> <th>Doctor Name</th> <th>Doctor Address</th> <th>Doctor City</th> <th>Hospital Name</th> <th>Hospital City</th> <th>Print</th> </thead> </tr>"; while($row = mysqli_fetch_assoc($res)){ if($row['hosp_name']==$_POST['str']){ echo "<tr> <td>". $row['doc_no'] ."</td><td>". $row['doc_name'] ."</td> <td>". $row['city'] ."</td><td>". $row['address'] ."</td><td>". $row['hosp_name']."</td> <td>". $row['hosp_city']."</td><td><button onclick=print()>Print</button></td></tr>"; } } echo "</table></div></body></html>"; } } ?> </div> </div> </div> </body> </html>

Team Analytics

Assignment NO : 5 MySQL

No comments:

Search This Blog

Pages

Popular Posts

Labels