Display database with javascript and php?

[ChrisPaul]

Hi, i think i posted this wrong in databases...more a php-question I think.

I wanna open a php-file from my javascript and then in the php-file search through my databse and display the results on the original site(the one that called the javascript) with innerHTML. Or if you have any option to that, the main thing is that its done without the page reloads.

You see my code down here, thats so far i have got, its getting messy when i try to either display the results from inside the php-file, or passing the results back to the javascript...I would be very happy to get help with this

displaydata.js

	  function displaydata(kurskod)
      {

	var url = "displaydata.php?kurskod=" + kurskod;
    var mozillaFlag = false;
    var XMLHttpRequestObject = false; 

       if (window.XMLHttpRequest) {
     var XMLHttpRequestObject = new XMLHttpRequest();

     if (XMLHttpRequest.overrideMimeType) {
           XMLHttpRequestObject.overrideMimeType('text/xml');
     }
  }

  else if (window.ActiveXObject) {

     try {
        var XMLHttpRequestObject = new ActiveXObject("Msxml2.XMLHTTP");
     }
     catch(e) {
        try {
           var XMLHttpRequestObject = new ActiveXObject("Microsoft.XMLHTTP");
        }
        catch(e) {}
     }
  } 

    if(XMLHttpRequestObject) {
      XMLHttpRequestObject.open("GET", url, true); 

      XMLHttpRequestObject.onreadystatechange = function() 
      { 
      } 

      XMLHttpRequestObject.send(null); 
    }
  }

displaydata.php

<?php

include "conn.php";

     $kurskod = $_GET['kurskod'];

     if (isset($kurskod))
     {
        $query  = "SELECT * FROM litteraturlista_temp WHERE kurskod = $kurskod";
        $result = mysql_query($query) or die("SQL: $query <br />\n".mysql_error());

         echo "<table>";
        while($row = mysql_fetch_assoc($result))
        {
             echo "<tr><td>{$row['titel']}</tr></td>";
        }

     }

     ?>
     <script language="javascript">
     var target = document.getElementById("reklam");
          target.innerHTML += '<p "' + iconurl + '">' ;
     </script>
     <td id="{$row['id']}"></td>

[bpat1434]

Read a few of the AJAX tutorials that google pops up for you.

Your main AJAX library should send the info to the <div> or whatever. So changing the innerHTML should be done with your first javascript stuff, and your PHP page should just be returning the valid xHTML string to fill that area.

[scrupul0us]

very easy:

ajax.js

function getObject(id) 
{ 
	if (ie4) 
	{ 
		return document.all[id]; 
	} 
	else 
	{ 
		return document.getElementById(id); 
	} 
}
function loadModule(id)
{
	var d = getObject(id);
	var xmlHttp;
	try
	{
	// Firefox, Opera 8.0+, Safari
	xmlHttp=new XMLHttpRequest();
	}
	catch (e)
	{
		// Internet Explorer
		try
		{
		xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
		}

	catch (e)
	{
		try
		{
		xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
		}
		catch (e)
		{
		alert("Your browser does not support AJAX!");
		return false;
		}
	}
}

xmlHttp.onreadystatechange=function()
{
	if(xmlHttp.readyState==4)
	{
	d.innerHTML = xmlHttp.responseText;
	}
}
xmlHttp.open("POST","databasefile.php",true);
xmlHttp.send('var=1');
xmlHttp.close;
}

call by using:

<script type="text/javascript" lanaguage="javascript">loadModule('myDIV');</script>

and it will load the contents into:

<div id="myDIV"></div>