Ramdas Biradar: TY_BCS_PHP_slip 25

Slip no. 25. Write AJAX program to print movie by selecting an actor’s name. create table Movie and Actor with 1:M cardinality as follows:

Movie ( mno, mname, release_year)

Actor( ano, aname)

[USE PostgreSQL]

HTML file :

<html>

function display()

{

ob = new XMLHttpRequest();

var a = document.getElementById("a").value;

ob.open("GET","slip25_2.php?a="+a);

ob.send();

ob.onreadystatechange = function()

{

if(ob.readyState == 4 && ob.status == 200)

document.getElementById("i").innerHTML = ob.responseText;

}

</script>

<body>

Enter Actor Name :<input type=text name=a id=a><br>

</body>

</html>

PHP file :

<?php

$con_string = "host=localhost dbname=bcs_slips port=5432 user=postgres password=nrc";

$con = pg_connect($con_string);

$a = $_GET['a'];

echo $a;

echo "</br>";

$q = "select movie.mno,mname,r_yr from movie,actor where aname='$a' and movie.mno = actor.mno;";

$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();

Ramdas Biradar