show information in textbox from mysql

[Noorain]

Let's say there is an A/C no. in my database and it is is 01234553434.
I want to type a/c no. into a textbox. When i type then numbers "012", the rest of digits should show up in textbox from database automatically.

I am using MySQL for a database.

[chathura86]

well it is all about AJAX and CSS

what you need to do is place the textbox and use key press event

http://www.smartwebby.com/DHTML/textbox_characters_counter.asp

http://www.geekpedia.com/tutorial138_Get-key-press-event-using-JavaScript.html

on the key press event send an ajax request to server with the entered value

http://www.w3schools.com/php/php_ajax_database.asp

on the server you have a php page where you get the value and search it
on the database and get the relevant values and sends back to the
browser

use js to show these data on the page the way you want.

here is a good example done with jquery

http://www.nodstrum.com/2007/09/19/autocompleter/

try it out and post your code here if you have any problems

i will try to help you


Regards

[Markus]

Moving this to JavaScript as it has more to do with that than PHP.

[Frinavale]

We'll see where this ends up being placed but PHP does play a part here.

When ever the user types a character into the text box you have to make an Ajax request to the server (a PHP script) which will return any matching options based on what the user typed. When the Ajax request is finished, and the browser has received the matches, you will use JavaScript to display the options to the user.

The articles that chathura86 posted should get you pointed in the right direction.