My goal is to write a PHP database application with a GUI that will display and update information on a remote database on a server. I need a basic template in the PHP code so I can just fill in the correct server and user, etc.
The GUI will have two text boxes to display for example customer name, and address. See picture for desired basic gui layout.
It will also have 3 buttons: previous, next, and update. Previous and Next will go to the previous or next row in the table of the database to display the next or previous record. The data will be read in from a remote database using SELECT statements, an example in the code would be helpful.
I should be able to update information in the text boxes and clicking the update button will use an SQL UPDATE statement to update the row in the table. An example update statement in the code would be helpful.
I will be connecting to a PSQL databse.