how to insert data to a mysql table using ajax (client side)

[nastaran zanjnai]

can you please let me know how to insert data to a mysql table from client side using ajax. the client generates the data. this data should be stored in the database.

[Bear Bibeault]

Send the data back to the server in a request same as any other request. The server doesn't even know what Ajax is, so you don't do anything different.

[nastaran zanjnai]

I am suing the following code in a JS file

         var queryString = "?hrefAdd=" + hrefAdd;
	axRequest.open("GET","ajax_request.php" ,queryString , true);

and the following code in the php file

<?php
mysql_connect("localhost", "admin", "1admin") or die(mysql_error());
mysql_select_db("lln") or die(mysql_error());
mysql_query("CREATE TABLE links(
	
	link_add varchar(50) NOT NULL,
	PRIMARY KEY  (link_add))")
 or die(mysql_error());  

$link = $_GET['hrefAdd'];
// Escape User Input to help prevent SQL Injection
$link = mysql_real_escape_string($link);


mysql_query("INSERT INTO links (link_add) VALUES ($link )") or die(mysql_error());
?>

but when I check the data base there is noting written in the table.

[Bear Bibeault]

Have you checked the request to make sure that it contains the data you expect? And, a GET isn't an appropriate method; should be a POST.

[nastaran zanjnai]

sorry, do you mean that I should change all GETs to POST. is this a correct one?

$link = $_POST['hrefAdd'];
$link = mysql_real_escape_string($link);
mysql_query("INSERT INTO links (link_add) VALUES ($link)") or die(mysql_error());

[Bear Bibeault]

At a high level, GETs are for getting data without changing anything. POSTs are for making changes.

[nastaran zanjnai]

solved.