diff options
Diffstat (limited to 'ajax/database')
-rw-r--r-- | ajax/database/New Text Document.txt | 0 | ||||
-rw-r--r-- | ajax/database/getuser.php | 38 | ||||
-rw-r--r-- | ajax/database/index.htm | 20 | ||||
-rw-r--r-- | ajax/database/selectuser.js | 40 |
4 files changed, 0 insertions, 98 deletions
diff --git a/ajax/database/New Text Document.txt b/ajax/database/New Text Document.txt deleted file mode 100644 index e69de29..0000000 --- a/ajax/database/New Text Document.txt +++ /dev/null diff --git a/ajax/database/getuser.php b/ajax/database/getuser.php deleted file mode 100644 index bf6e677..0000000 --- a/ajax/database/getuser.php +++ /dev/null @@ -1,38 +0,0 @@ -<?php -$q=$_GET["q"]; - -$con = mysql_connect('localhost', 'peter', 'abc123'); -if (!$con) - { - die('Could not connect: ' . mysql_error()); - } - -mysql_select_db("ajax_demo", $con); - -$sql="SELECT * FROM user WHERE id = '".$q."'"; - -$result = mysql_query($sql); - -echo "<table border='1'> -<tr> -<th>Firstname</th> -<th>Lastname</th> -<th>Age</th> -<th>Hometown</th> -<th>Job</th> -</tr>"; - -while($row = mysql_fetch_array($result)) - { - echo "<tr>"; - echo "<td>" . $row['FirstName'] . "</td>"; - echo "<td>" . $row['LastName'] . "</td>"; - echo "<td>" . $row['Age'] . "</td>"; - echo "<td>" . $row['Hometown'] . "</td>"; - echo "<td>" . $row['Job'] . "</td>"; - echo "</tr>"; - } -echo "</table>"; - -mysql_close($con); -?>
\ No newline at end of file diff --git a/ajax/database/index.htm b/ajax/database/index.htm deleted file mode 100644 index 98b0009..0000000 --- a/ajax/database/index.htm +++ /dev/null @@ -1,20 +0,0 @@ -<html> -<head> -<script type="text/javascript" src="selectuser.js"></script> -</head> -<body> - -<form> -Select a User: -<select name="users" onchange="showUser(this.value)"> -<option value="1">Peter Griffin</option> -<option value="2">Lois Griffin</option> -<option value="3">Glenn Quagmire</option> -<option value="4">Joseph Swanson</option> -</select> -</form> -<br /> -<div id="txtHint"><b>Person info will be listed here.</b></div> - -</body> -</html>
\ No newline at end of file diff --git a/ajax/database/selectuser.js b/ajax/database/selectuser.js deleted file mode 100644 index a91721e..0000000 --- a/ajax/database/selectuser.js +++ /dev/null @@ -1,40 +0,0 @@ -var xmlhttp; - -function showUser(str) -{ -xmlhttp=GetXmlHttpObject(); -if (xmlhttp==null) - { - alert ("Browser does not support HTTP Request"); - return; - } -var url="getuser.php"; -url=url+"?q="+str; -url=url+"&sid="+Math.random(); -xmlhttp.onreadystatechange=stateChanged; -xmlhttp.open("GET",url,true); -xmlhttp.send(null); -} - -function stateChanged() -{ -if (xmlhttp.readyState==4) -{ -document.getElementById("txtHint").innerHTML=xmlhttp.responseText; -} -} - -function GetXmlHttpObject() -{ -if (window.XMLHttpRequest) - { - // code for IE7+, Firefox, Chrome, Opera, Safari - return new XMLHttpRequest(); - } -if (window.ActiveXObject) - { - // code for IE6, IE5 - return new ActiveXObject("Microsoft.XMLHTTP"); - } -return null; -}
\ No newline at end of file |