Read out of tables with JSON and AJAX

**DiNettio** · 01-07-2009, 10:19 AM

Hello,

This is want I want, I want a table with data, where I can load the parts I want with a drop box.

I've got my code in PHP, but it isn't working, but that's not the problem, but I would do the same with JSON and AJAX, can someone help me to the right way?

Greetings

index.htm

<html>

<head>

<script 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>

<p>

<div id="txtHint"><b>User info will be listed here.</b></div>

</p>

</body>

</html>

selectuser.js

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 || xmlHttp.readyState=="complete")

 { 

 document.getElementById("txtHint").innerHTML=xmlHttp.responseText 

 } 

}

function GetXmlHttpObject()

{

var xmlHttp=null;

try

 {

 // Firefox, Opera 8.0+, Safari

 xmlHttp=new XMLHttpRequest();

 }

catch (e)

 {

 //Internet Explorer

 try

  {

  xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");

  }

 catch (e)

  {

  xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");

  }

 }

return xmlHttp;

}

getuser.php

<?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);

?>

**DiNettio** · 01-07-2009, 10:30 AM

and this should be the file in place of getuser.php, but I can't let it work... if I test it... It doesn't work but that's normal I have nowhere defined a table with data, but I can't imagine how I should start with this...

getcostumer.asp

<%

response.expires=-1

sql="SELECT * FROM CUSTOMERS WHERE CUSTOMERID="

sql=sql & "'" & request.querystring("q") & "'"



set conn=Server.CreateObject("ADODB.Connection")

conn.Provider="Microsoft.Jet.OLEDB.4.0"

conn.Open(Server.Mappath("/db/northwind.mdb"))

set rs = Server.CreateObject("ADODB.recordset")

rs.Open sql, conn



response.write("<table>")

do until rs.EOF

  for each x in rs.Fields

    response.write("<tr><td><b>" & x.name & "</b></td>")

    response.write("<td>" & x.value & "</td></tr>")

  next

  rs.MoveNext

loop



response.write("</table>")

%>

Thread: Read out of tables with JSON and AJAX

Thread Tools

Search Thread

Read out of tables with JSON and AJAX

Bookmarks

Bookmarks

Posting Permissions