HTML/php form to retrieve and update mysql DB

Hi all,

I have a customer database with about 6 fields. Now I want to create an html page with a search button. And I have aready created a text boxes to match the fields on the database table.

The idea is that when I enter a customer phone number or postcode and hit the search button, the text boxes will be populated and I can update the records. Finally is it possible to have all these implemented on one html page? Completely new to php not were to start.

Thank you for your time and help.

So you want a script that only you can use, so that you can manage your databases? It’s the editing from your PHP script where it gets tricky. The search I could probably help with, as I’ve done similar things myself. But then editing it from PHP? I suppose it’s possbile to display the results IN new forms, and then resubmit them and have it process, but that’s getting super complicated. Are you sure you couldn’t just be satisfied with running the SQL query from EasyPHP and just editing it in there? I would teach you how to do that, but writing a page like you suggested is beyond me at this point.

Sponsor our Newsletter | Privacy Policy | Terms of Service