Consider the following relational database: Project (P_Group_No, Project_Title) Student (Seat no, Name, Class, P_Group_No) Write a PHP script to accept project title and display list of students those who are working in a particular project.

Project.html

<html>
<body>
<form method=get action="Project.php">
Enter Project Tittle : <input type=text name="pname"><br><br>
<input type=submit value="Display">
</form>
</body>
</html>

Project.php

<?php
         $pname=$_GET['pname'];
mysql_connect("localhost","root","") or die(mysql_error());
mysql_select_db("userpass") or die(mysql_error());
         $result=mysql_query("SELECT * FROM student WHERE pgno IN (SELECT pgno FROM project WHERE ptittle = '".$pname."')");
while($row=mysql_fetch_array($result))
         {
echo"Seat No = ".$row['sno']."  Name  = ".$row['name'];
echo"  Class =  ".$row['class']." Proj. Group No. =  ".$row['pgno']."<br>";
        }
?>

Comments

Post a Comment

Popular posts from this blog

Create an XML file which gives details of books available in “ABC Bookstore” from following categories. 1)      Technical 2)      Cooking 3)      Yoga And elements in each category are in the following format.     …….     …….     ……. Save the file as “Book.xml” Create an application that reads “Book.xml” file into simple XML object. Display attributes and elements. (Hint:- Use simple_xml_load_file() function). 

Book.XML <?xml version="1.0" encoding="utf-8"?> <ABCBOOK>         <Technical>         <BOOK>         <Book_PubYear>ABC</Book_PubYear>         <Book_Title>pqr</Book_Title>         <Book_Author>400</Book_Author>         </BOOK>         </Technical>          <Cooking>         <BOOK>         <Book_PubYear>ABC</Book_PubYear>         <Book_Title>pqr</Book_Title>         <Book_Author>400</Book_Author>         </BOOK>...
Read more

Write a simple PHP program which implements Ajax for addition of two numbers

Add.php <html> <head>    <script language="javascript" src="ajax.js">    </script> </head> <body> <div id="txt" name="txt"></div>    <form action="javascript:add(document.getElementById('frm'));" name="frm" id="frm">   <table>    <tr>      <td>Enter first number : </td>      <td><input type="text" id="num1"></td>      </tr>      <tr>      <td>Enter second number : </td>      <td><input type="text" id="num2"></td>      </tr>      <tr>        <td colspan="2"><input type="submit" name="button" value="show"></td>      </tr> </table> </form> </body> ...
Read more