I have this code below, it fetches data on a mysql database. I was hoping you could give me a code hint on where could, my goal is to display this data on a browser which i did already and be able to edit it via a form.
edit? -> table1=value -> table2=value
I dont know where to start. please help me, i hope i can display all the data and have a button for editing and catch which one to edit.
Well, my first suggestion is to use a database abstraction class such as PEAR's DB. It offers much more powerful features than the regular mysql extension in PHP, has better error handling, and allows you to have the same interface for all of the databases it supports.
My second suggestion is to use DB_DataObject and DB_DataObject_FormBuilder to create the forms for a table and handle editing the data. It really simplifies things.
My third suggestion would be to use a new package that I'm writing. It not only automates editing of table data, but it also shows you all of the records and lets you view multiple tables. Unfortunately, it's not out yet, but I could give you a copy if you wanted. To see the precursor to what I'm working on, check out RDBEdit (http://rdbedit.sf.net).
PEAR::DB http://pear.php.net/package/DB
PEAR::DB_DataObject http://pear.php.net/package/DB_DataObject
PEAR::DB_DataObject_FormBuilder http://pear.php.net/package/DB_DataObject_FormBuilder
-- paperCrane <Justin Patrin> -- Question Everything, Reject Nothing
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
