I have enclosed my code below.
Tanx.
This is the form that accepts data
Expand|Select|Wrap|Line Numbers
- <?php session_start();?>
- <html>
- <head>
- <link rel="stylesheet" type="text/css" href="main2.css">
- <script type="text/javascript">
- var request = false;
- try {
- request = new XMLHttpRequest();
- } catch (e) {
- try {
- request = new ActiveXObject("Msxml2.XMLHTTP");
- } catch (e2) {
- try {
- request = new ActiveXObject("Microsoft.XMLHTTP");
- } catch (e3) {
- request = false;
- }
- }
- }
- if (!request)
- alert("Sorry Your Browser Settings Do Not Permit You To Use This Application!");
- var request2 = false;
- try {
- request2 = new XMLHttpRequest();
- } catch (e) {
- try {
- request2 = new ActiveXObject("Msxml2.XMLHTTP");
- } catch (e2) {
- try {
- request2 = new ActiveXObject("Microsoft.XMLHTTP");
- } catch (e3) {
- request = false;
- }
- }
- }
- if (!request2)
- alert("Sorry Your Browser Settings Do Not Permit You To Use This Application!");
- function get_number(){
- var i=document.getElementById("number").value;
- var class=document.getElementById("get_class").value;
- var form=document.getElementById("form").value;
- if (i=="")
- {alert("Please Supply A Valid Number");
- return;}
- if(form==0){
- alert("Please Select A Valid Form!!! ");
- return;}
- else{ var url = "/demonstration/get_number.php?number=" + escape(i) + "&class=" +escape(class)+"&form=" +escape(form);
- request2.open("GET", url, true);
- request2.onreadystatechange = updatePage;
- request2.send(null);}
- }
- function updatePage(){
- if(request2.readyState==4){
- if(request2.status==200)
- {var response2=request2.responseText;
- if (request2.responseText=='')
- {alert("Sorry,An Error Ocurred.Please Try Again Later.!!");}
- else{
- document.getElementById("feedback").innerHTML=response2;
- }
- }
- else{
- alert("Status is " + request.status);}}}
- function getclass(){
- var i=document.getElementById("number").value;
- var form=document.getElementById("form").value;
- if(form==0){
- alert("Please Select A Valid Form!!! ");}
- else{
- var url = "/demonstration/get_class.php?form=" + escape(form);
- request.open("GET", url, true);
- request.onreadystatechange = updateForm;
- request.send(null);}}
- function updateForm(){
- if(request.readyState==4){
- if(request.status==200)
- {var response=request.responseText.split("|");
- if (request.responseText=='')
- {alert("Sorry,An Error Ocurred.Please Try Again Later.!!");}
- else{
- document.getElementById("get_class").innerHTML=response[0];
- }
- }
- else{
- alert("Status is " + request.status);}}}
- </script>
- </head>
- <body>
- <div class="container" align="center">
- <h2 align="center">Please Enter The Form,Class And Number Of Fresh Students You Want To Register Below</h2>
- <hr/>
- <?php
- $user_id=$_SESSION['user_id'];
- include 'demo_connect.php';
- $sql="select * from forms";
- $result=mysqli_query($link,$sql);
- echo '
- <table><tr><td class=form align=right>Form:</td><td><select name="form" id=form onChange=getclass();>
- <option value=0>Select Form Here</option>';
- while ($r=mysqli_fetch_assoc($result))
- {$form=$r['form_name'];
- echo "<option value="; echo $r['form_id'];echo ">$form\n";
- }
- echo'</select></td></tr>
- <tr><td class=form align=right>Class:</td><td id="class_feedback"><select id=get_class><option value=0>Get Class here</select></td></tr>
- <tr><td class="form" align=right>Enter Desired Number Here:<td><input type="text" id="number"></td><td></td><td><input type="button" value="Submit Number" onClick="get_number();"></td></tr></table>
- <div id=feedback></div>
- <div id=submit_form></div>';
- ?>
- </div>
- </body>
- </html>
Expand|Select|Wrap|Line Numbers
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
- <title>Untitled Document</title>
- </head>
- <body>
- <?php
- include 'demo_connect.php';
- $form_id=mysqli_real_escape_string($link,$_GET['form']);
- $sql="select * from classes where form_id='$form_id' order by class_name";
- $result=mysqli_query($link,$sql);
- $a='
- <select name="class" id="class" onChange=trial();>
- ';
- while ($r=mysqli_fetch_assoc($result))
- {$class=$r['class_name'];
- echo "<option value=";echo $r['class_id'];echo">$class\n</option>";
- }
- echo'</select></td></tr>';
- echo $a;
- ?>
- </body>
- </html>