Multi-Function HTML form.

[ardevain1]

I can't find it.

 

I am trying to find source code examples for web forms that will allow

 

1- Input of a new row into my mySql database table.

 

2- Query the mySQL databse table for a row (or multiple rows)

  - if a single row is returned, display the data it contains in the fields of the web form.

  - if multiple rows are returned, display the data of the first in the web form AND

    allow me to [NEXT] and [PREV] through the array of results, showing each row in the single web form.

 

3- For any row result currently displayed in the web form, allow me to modify data fields and update that row in the

    data table.

 

4- For any row currently displayed in the web form, allow me to delete that row from the data table. (It would be nice if, after

    deleting one of the rows returned in a query, that the query could be re-executed so that [NEXT] and [PREV] instructions

    would not become hung up on a row that is no longer there -- but this is not required.)

 

I believe to the point of certainty that this has long since been accomplished, but none of the "Learn PHP" books I have access to

go anywhere near this kind of thing.  I can't find anything useful in my online searches for free code -- probably because I can't

search for the right terms. Can anyone point me to a code sample that I can use?

 

P.S.: I do have a very nice web form that allows INPUT only.  I would like very much to expand its functionality to allow QUERY, UPDATE, and DELETE.

Edited July 5, 2013 by ardevain1

[Barand]

Jessica's CRUD tutorial should be of help

 

http://thewebmason.com/php-mysql-crud-tutorial-using-pdo-create-read-update-delete-part-4-delete/

[ardevain1]

"Thanking you, I am!"

                                   -- Yoda, 1977