9 files changed, 270 insertions, 0 deletions
diff --git a/ajax/database/New Text Document.txt b/ajax/database/New Text Document.txt
new file mode 100644
index 0000000..e69de29
--- /dev/null
+++ b/ajax/database/New Text Document.txt
diff --git a/ajax/database/getuser.php b/ajax/database/getuser.php
new file mode 100644
index 0000000..bf6e677
--- /dev/null
+++ b/ajax/database/getuser.php
@@ -0,0 +1,38 @@
+<?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
new file mode 100644
index 0000000..98b0009
--- /dev/null
+++ b/ajax/database/index.htm
@@ -0,0 +1,20 @@
+<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
new file mode 100644
index 0000000..a91721e
--- /dev/null
+++ b/ajax/database/selectuser.js
@@ -0,0 +1,40 @@
+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
diff --git a/ajax/form_suggestions/clienthint.js b/ajax/form_suggestions/clienthint.js
new file mode 100644
index 0000000..408c220
--- /dev/null
+++ b/ajax/form_suggestions/clienthint.js
@@ -0,0 +1,45 @@
+var xmlhttp
+
+function showHint(str)
+{
+if (str.length==0)
+  {
+  document.getElementById("txtHint").innerHTML="";
+  return;
+  }
+xmlhttp=GetXmlHttpObject();
+if (xmlhttp==null)
+  {
+  alert ("Your browser does not support XMLHTTP!");
+  return;
+  }
+var url="gethint.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
diff --git a/ajax/form_suggestions/gethint.php b/ajax/form_suggestions/gethint.php
new file mode 100644
index 0000000..8cb7379
--- /dev/null
+++ b/ajax/form_suggestions/gethint.php
@@ -0,0 +1,71 @@
+<?php
+// Fill up array with names
+$a[]="Anna";
+$a[]="Brittany";
+$a[]="Cinderella";
+$a[]="Diana";
+$a[]="Eva";
+$a[]="Evan";
+$a[]="Fiona";
+$a[]="Gunda";
+$a[]="Hege";
+$a[]="Inga";
+$a[]="Johanna";
+$a[]="Kitty";
+$a[]="Linda";
+$a[]="Nina";
+$a[]="Ophelia";
+$a[]="Petunia";
+$a[]="Amanda";
+$a[]="Raquel";
+$a[]="Cindy";
+$a[]="Doris";
+$a[]="Eve";
+$a[]="Evita";
+$a[]="Sunniva";
+$a[]="Tove";
+$a[]="Unni";
+$a[]="Violet";
+$a[]="Liza";
+$a[]="Elizabeth";
+$a[]="Ellen";
+$a[]="Wenche";
+$a[]="Vicky";
+
+//get the q parameter from URL
+$q=$_GET["q"];
+
+//lookup all hints from array if length of q>0
+if (strlen($q) > 0)
+  {
+  $hint="";
+  for($i=0; $i<count($a); $i++)
+    {
+    if (strtolower($q)==strtolower(substr($a[$i],0,strlen($q))))
+      {
+      if ($hint=="")
+        {
+        $hint=$a[$i];
+        }
+      else
+        {
+        $hint=$hint." , ".$a[$i];
+        }
+      }
+    }
+  }
+
+// Set output to "no suggestion" if no hint were found
+// or to the correct values
+if ($hint == "")
+  {
+  $response="no suggestion";
+  }
+else
+  {
+  $response=$hint;
+  }
+
+//output the response
+echo $response;
+?>
+\ No newline at end of file
diff --git a/ajax/form_suggestions/index.htm b/ajax/form_suggestions/index.htm
new file mode 100644
index 0000000..c2fc742
--- /dev/null
+++ b/ajax/form_suggestions/index.htm
@@ -0,0 +1,14 @@
+<html>
+<head>
+<script src="clienthint.js"></script>
+</head>
+<body>
+
+<form>
+First Name: <input type="text" id="txt1" onkeyup="showHint(this.value)" />
+</form>
+
+<p>Suggestions: <span id="txtHint"></span></p>
+
+</body>
+</html>
+\ No newline at end of file
diff --git a/ajax/simple_form/index.htm b/ajax/simple_form/index.htm
new file mode 100644
index 0000000..2c01922
--- /dev/null
+++ b/ajax/simple_form/index.htm
@@ -0,0 +1,36 @@
+<html>
+<body>
+
+<script type="text/javascript">
+function ajaxFunction()
+{
+var xmlhttp;
+if (window.XMLHttpRequest)
+  {
+  // code for IE7+, Firefox, Chrome, Opera, Safari
+  xmlhttp=new XMLHttpRequest();
+  }
+else
+  {
+  // code for IE6, IE5
+  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
+  }
+xmlhttp.onreadystatechange=function()
+{
+if(xmlhttp.readyState==4)
+  {
+  document.myForm.time.value=xmlhttp.responseText;
+  }
+}
+xmlhttp.open("GET","time.php",true);
+xmlhttp.send(null);
+}
+</script>
+
+<form name="myForm">
+Name: <input type="text" name="username" onkeyup="ajaxFunction();" />
+Time: <input type="text" name="time" />
+</form>
+
+</body>
+</html>
+\ No newline at end of file
diff --git a/ajax/simple_form/time.php b/ajax/simple_form/time.php
new file mode 100644
index 0000000..3d938ae
--- /dev/null
+++ b/ajax/simple_form/time.php
@@ -0,0 +1,6 @@
+<?php
+// Date in the past
+header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
+header("Cache-Control: no-cache");
+echo(date("G:i:s",time()));
+?>
+\ No newline at end of file