Considerer the following entities and their relationships.

Student (Stud_id,name,class)

Competition (c_no,c_name,type)

Relationship between student and competition is many-many with attribute rank and year. Create a RDB in 3NF for the above and solve the following. Using above database write a script in PHP to accept a competition name from user and display information of student who has secured 1st rank in that competition.

Answer :

<html> <head> </head> <body> <form action="#" method="post"> Competition name: <input type="text" name="cname"><br><br> <input type="submit" value="Submit"> <input type="reset" value="Clear"> </form> </body> </html> <?php if(isset($_POST['cname'])){ $cname= $_POST['cname']; $conn = mysqli_connect('localhost','root','','slip30_db') or die ('Connection Unsuccessful.'); $sql = "SELECT * FROM student s, competition c, stdcom sc WHERE s.stud_id=sc.stud_id1 AND c.c_no=sc.c_no1 AND rank=1 AND c_name='$cname'"; $result = mysqli_query($conn,$sql) or die("Query Unsuccessful."); if(mysqli_num_rows($result)>0){ while($row= mysqli_fetch_assoc($result)){ echo "<tbody> <tr> <td>".$row['name']."</td> <td>".$row['c_name']."</td> <td>".$row['rank']."</td> <td>".$row['year']."</td> <td>".$row['class']."</td> </tr>"; } echo " </tbody> </table> </div> </div>"; } } ?>

Team Analytics

PHP Solved Slip

Considerer the following entities and their relationships.

Student (Stud_id,name,class)

Competition (c_no,c_name,type)

No comments:

Search This Blog

Pages

Popular Posts

Labels