Javascript, AJAX and PHP Help

Question

I have the following table in a MYSQL database:

Messages
MessageId (PK) int(10) - auto_inc
Message varchar(100)

I have the following PHP that echos a particular message:

<?php

//..connect to database
$query = "SELECT Message FROM Messages WHERE MessageId = '1'";
$result = mysql_query($query);
$num = mysql_num_rows( $result );
if ($num == 1){
  $row = mysql_fetch_assoc($result);
  echo json_encode($row);
}else{
  echo('Invalid');
}

?>

Can anyone advise me on how best to integrate jQuery in order to allow the document browser window to write the response...

This is a pretty vague question. People don't generally write manual ajax code anymore, they use a library or framework like jQuery to help them. I'd start by researching jQuery. — Jonathan Rowny
– Jonathan Rowny, Commented Aug 8, 2011 at 15:38
Also, your PHP application should send appropriate headers (Content-Type: application/json) in order for these frameworks suggested by @Jonathan to work. — Linus Kleen
– Linus Kleen, Commented Aug 8, 2011 at 15:41

Kyle · Accepted Answer · 2011-08-08 15:48:24Z

4

If you use jQuery, you can easily use jQuery.getJSON()^[DOCS] as follows:

$.getJSON('mypage.php', function(data) { 
   //Do somewith with JSON data
});

For normal Javascript, use

var xmlhttp;
if(window.XMLHttpRequest)
   xmlhttp = new XMLHttpRequest();
else//IE5, IE6
   xmlhttp = ActiveXObject("Microsoft.XMLHTTP");

xmlhttp.onreadystatechange = function()
{
   if(xmlhttp.readyState == 4 && xmlhttp.Status == 200)
   {
      var response = JSON.parse(xmlhttp.responseText);
      //Do something with JSON Data
   }
};

edited Aug 8, 2011 at 15:48

answered Aug 8, 2011 at 15:43

Kyle

4,46124 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kyle Over a year ago

Thanks for adding that link, Matt. I was going to link to it, but couldn't find it.

Collectives™ on Stack Overflow

Javascript, AJAX and PHP Help

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related