Slip no. 17. Write a AJAX
program to print Teacher information from postgreSQL table Teacher.
Teacher (Tno, Name, Subject,
Research area).
[Note: Examiner can change
PostgreSQL table ]
HTML file :
<html>
<script
type="text/javascript">
function display()
{
ob
= new XMLHttpRequest();
ob.open("GET","slip17_2.php");
ob.send();
ob.onreadystatechange
= function()
{
if(ob.readyState
== 4 && ob.status == 200)
document.getElementById("i").innerHTML
= ob.responseText;
}
}
</script>
<body>
<h2>DISPLAY INFORMATION OF
TEACHER</h2>
<input type=submit
value="DISPLAY INFORMATION" onclick=display()>
<span id=i></span>
</body>
</html>
PHP
file :
<?php
$con_string
= "host=localhost dbname=bcs_slips port=5432 user=postgres password=nrc";
$con = pg_connect($con_string);
echo
"</br>";
$q = "select
* from teacher;";
$rs = pg_query($con,$q)
or die("Cannot Execute query");
while($row
= pg_fetch_row($rs))
echo
"$row[0] $row[1] $row[2]\n</br>";
pg_close();
?>
No comments:
Post a Comment
Note: only a member of this blog may post a comment.