Skip to main content

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.

 HTML CODE:

<html>
<body>
<form method="GET" action="B2.php">
Enter Competition Name : <input type="text" name="cpn"> <br>
<input type="submit" value="Submit">

</form>
</body>
</html>


PHP CODE:

<?php
$cname=$_GET['cpn'];
$con=pg_connect("host=192.168.1.254 dbname=ty64 user=ty64 password=ty64");
if(!$con)
{
    echo "Error : Unable to open database\n";
}
else
{
    echo "Opened database succesfully\n";
}
$sql=<<<EOF
select * from sc,competition,student where student.stud_id=sc.stud_id and competition.c_no=sc.c_no and rank=1 and c_name='$cname';
EOF;
$ret=pg_query($con,$sql);
while($row=pg_fetch_row($ret))
{
    echo "<br>Stud_id : ".$row[0]."\n";
    echo "<br>C_no : ".$row[1]."\n";
    echo "<br>Rank : ".$row[2]."\n";
    echo "<br>Year : ".$row[3]."\n";
}
echo "<br>NO Record has rank 1";
pg_close($con);
?>


Comments

Post a Comment

Popular posts from this blog

Write a program to read book information (bookid, bookname, bookprice, bookqty) in file “book.dat”. Write a menu driven program to perform the following operations using Random access file: i. Search for a specific book by name. ii. Display all book and total cost

  import java . io .*; import java . util .*; class Book {       String name , id ;       int qty ;       double price , total ;       Book ( String i , String n , String p , String q )      {               name = n ;               id = i ;               qty = Integer . parseInt ( q );               price = Double . parseDouble ( p );               total = qty * price ;      }       public String toString ()      {               System . out . println ( "name\t id\t qty\t price\t total" );               String s = name + "\t" + id + "\t" + qty + "\t" + price + "\t" + total ;           ...
Post a Comment
Read more

Define a class MyDate (day, month, year) with methods to accept and display a MyDate object. Accept date as dd, mm, yyyy. Throw user defined exception “InvalidDateException” if the date is invalid. Examples of invalid dates : 03 15 2019, 31 6 2000, 29 2 2021

  import java . io .*; import java . util .*; class InvalidDateException extends Exception {       InvalidDateException ()       {               System . out . println ( "Invalid Date" );       } } class MyDate {       int day , mon , yr ;       void accept ( int d , int m , int y )       {             day = d ;             mon = m ;             yr = y ;       }       void display ()       {             System . out . println ( "Date is valid : " + day + "/" + mon + "/" + yr );       } } class Date {       public static void main ( String args []) throws Exception       {             Scanner sc = new Sca...
Post a Comment
Read more

Write a Java program to design a screen using Awt that will take a user name and password. If the user name and password are not same, raise an Exception with appropriate message. User can have 3 login chances only. Use clear button to clear the TextFields.

  import java . awt .*; import java . awt . event .*; import javax . swing .*; class InvalidPasswordException extends Exception {       InvalidPasswordException ()       {             System . out . println ( "Username and password is not same" );       } } public class Password extends Frame implements ActionListener {       Label uname , upass ;       TextField nametext ;       TextField passtext , msg ;       Button login , Clear ;       Panel p ;       int attempt = 0 ;       char c = '*' ;             public void login ()       {             p = new Panel ();             uname = new Label ( "Username : " , Label . CENTER );             upass = n...
Post a Comment
Read more