Add AJAX to my PHP MySQL page?

birdbrain24 · 01-14-2008, 08:30 PM

I was wondering how to make my PHP MySQL page queries refresh when they change without the page refreshing! I think that AJAX is the only way i could do that so could someone could me do it because i don't know any AJAX and i don't want to try and learn another language!

Here's the script

PHP Code:


		
			
<html>

<head>

<title>Site</title>

</head>

<body>

<?php

session_start();

include("functions.php"); 

connect();

sessioncheck();

$username=$_SESSION['username'];



$fetch=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$username'"));

$info=mysql_fetch_object(mysql_query("SELECT * FROM user_info WHERE username='$username'"));



$carselected=$info->carselected;

$carname=mysql_query("SELECT * FROM cars WHERE id='$carselected' AND username='$username' LIMIT 1");

$cars=mysql_fetch_object($carname);



?>

<div align="center">

<table width="295" height="93" border="0" cellpadding="0" cellspacing="0">

<tr>

<td align="right" width="72"><strong>Username :</strong></td>

<td align="left" width="223"><?php echo "$fetch->username"; ?></td>

</tr>

<tr>

<td align="right"><strong>Rank :</strong></td>

<td align="left"><?php echo "$fetch->rank"; ?></td>

</tr>

<tr>

<td align="right"><strong>Cash :</strong></td>

<td align="left"><?php echo "$".makecomma($fetch->cash).""; ?></td>

</tr>

<tr>

<td align="right"><strong>Vehicle :</strong></td>

<td align="left">  <?php if($carselected == 0){ echo "None"; } else { if($carselected != 0){ echo $cars->name; }}?></td>

</tr>

<tr>

<td align="right"><strong>Location :</strong></td>

<td align="left"><?php echo "$fetch->location" ?></td>

</tr>

<tr>

<td align="right"><strong>Reputation :</strong></td>

<td align="left"><?php echo "".makecomma($fetch->reputation).""; ?></td>

</tr>

<tr>

<td align="right"><strong>Level :</strong></td>

<td align="left"><?php echo "$fetch->location" ?></td>

</tr>

</table>

</div>

</body>

</html>

So i hope someone can help me!
Thanks in Advance!

greenfinger · 01-17-2008, 05:38 AM

Have a look at JQuery. It's very easy to use.

You will need to put some effort in, and be prepared to learn.

What it does is, for example, you set up the fields on a form to trigger the Jquery in the background (onclick/onfocus etc), it HTTP POSTS (or GETS, depends on how you configure it) the data to the server and then the reply is sent back to Jquery where it is then placed onto the page inside an element which you specify.

I use this to tell users whether a username is already in use immediately after they have typed it in.

http://jquery.com/