AJAX style form

[Mav3n]

In my form I have an input box that asks for a name...

As the user enters the name, I would like the javascript to access the MySQL db and look for names that match this entry. If it matches any of the entries it will display the name with a nice little message next to the input box..."Name Exists"

How would I go about doing this? Can someone point me to a tutorial or in the right direction?

[stymiee]

I moved this to the JavaScript forum as the core work here will be done by Ajax. If you already know how to query a MySQL database with PHP you already know how to do most of the server-side work for Ajax. You just need to know how to spit out the XML properly.

Like your title said you'll need Ajax to do this. Have you tried to write any code for this? If not, check out some Ajax tutorials to get started and then post whatever code you need help with.

Ajax sites: http://www.ajaxian.com/, http://www.ajaxmatters.com/r/welcome, http://sourcelabs.com/ajb/archives/2..._mistakes.html

[manya]

In my form I have an input box that asks for a name...

As the user enters the name, I would like the javascript to access the MySQL db and look for names that match this entry. If it matches any of the entries it will display the name with a nice little message next to the input box..."Name Exists"

How would I go about doing this? Can someone point me to a tutorial or in the right direction?

Hi Mav3n!

For this to work you will first have to know the basic concept of AJAX. After you know this, you can do it very easily.

Following are few codes that might help you:

1. You should have a form with input box and put a onSubmit function. The function should look like this:

2. The function should look some thing like this:

function abc()
{
var xhReq;
xhReq = createXMLHttpRequest();
xhReq.open('get', 'test_ajax.php?id='+ document.ajax_ex.ajax_select.selectedIndex);
xhReq.onreadystatechange = onSumResponse;
xhReq.send(null);
}

3. Now this function acts as an AJAX Engine and would communicate with test_ajax.php (in this example code) to process your request (access the MySQL db and look for names that match this entry). Now the file which would actually process your request would be test_ajax.php where you can put codes so that it queries your mysql database and echoes the result.

<self promotion is not allowed>


Regards,
Mani.

[Mav3n]

test_ajax.php would have a MySQL query in it correct?


Thank you for the tutorial sites... That's what I was looking for.

[Mav3n]

I would like to thank you guys for your help... I was able to find the tutorial I needed.. Not only was it exactly what I wanted but it also taught me very well... It was a good tutorial... To help other people I will post the tutorial link
http://ajax.phpmagazine.net/2005/09/..._with_php.html

Like I said, it was a very informative tutorial and it even taught me how to do it as well. I was able to add onto the .js to make more interesting things.

cheers

[manya]

<self promotion is not allowed>

Just to let you know that the blog link that I gave was not for self promotion. I have much better way of doing promotion. That was just to help some one in need.

Regards
MN