Fetch MySQL Data and display it in text fields using PHP

Here we create a PHP page which consists of dropdown list and text fields. We fill dropdown list with primary key and on selecting particular id, we display the record in the text field, using simple AJAX query and JSON data.

The link for updating the records:

[jeromeordonez]

helo good day what if search by employee name not to ID

[opefaleye]

Thanks for this Raj, but what if the records are so much up to 2000 records, I can't search one after the other...I hope you get me.

[delata]

How are you using echo when nothing is getting diisplayed on your brwoser?? it worked for me but the json file is getting displayed in the browser. Can you help me man?

[freddiegrandyanc]

Greetings to you your highness, am an amateur in php and am trying to build a site where one can select an option from a dropdown-list, I have managed to load from MYSQL data-table onto the selection list, every option on the list has additional information in the data-table so when the user choose an option the other info should display in the text filled and label before submission.

My problem is, the details are not displaying on text input nor the label. I used Ajax to send to html, I have tried every possible way that I could. The confusing part is, when i was loading from the database onto the select dropdown-list sometimes the language is difficult to understand when some codes work at some pages and same code won't work at some. I have watch tutorials that did the same thing but when I try mine give error, " Notice: Undefined variable: rows in"----"Notice: Trying to access array offset on value of type null in".

[tonyiken]

Please would like to know how you were able to use Mysql instead of xampp in step by step

[cimflgf]

hi sir, i followed same steps but i didnot get result, data is coming in the text field as undefined, please help me very urgent

[cristianoarlindodasilva]

Olá tem o código e o banco de dados para baixar

[ssenthilkumar]

Sir source code if you add in the description it will be much more effective

[mannbajpai]

The code is not working for me, can someone please help

[chopbar]

hi good can you do it on a drop down menu