in that case you could just get ur hands dirty and do the function urself. if you ensure that your form elements match the table name, you can have a function to the quick one ave written below, it returns the last insert id function update($_POST, $tableName) { $tableCols = "("; $colValues = "("; foreach($_POST as $key=>$value) { $tableCols. = $key.","; $colValues = "'".mysql_real_escape_string($value)."',"; } $tableCols .=")"; $colValues .=")"; $sql = "insert into $tableName $tableCols values $colValues"; $res = mysql_query($sql) or ("handle ur errors"); $num = mysql_insert_id(); return $num; } On Tue, Nov 9, 2010 at 9:49 AM, Peter Karunyu <pkarunyu@gmail.com> wrote:
Already looked into code igniter, it has something similar, I think. Zend framework has the exact same thing I need, but using a framework for the need I have at hand is like chartering the VMS Eve for a trip to shaggs :-)
On Tue, Nov 9, 2010 at 9:36 AM, Chris Mwirigi <mwirigic@gmail.com> wrote:
isn't it time you looked at a framework perhaps?
codeIgniter cake Yii zend
./chris
On Tue, Nov 9, 2010 at 9:20 AM, Peter Karunyu <pkarunyu@gmail.com> wrote:
Good people, I seek to write a generic, reusable set of functions that, given a GET/POST array, a table name and a few other instructions, can retrieve data from a form and save it in one or more tables. Anyone know of anything similar which I can build upon?
If there is one thing I find totally boring, its processing form data. Oh yeah, ideas on how to do this are also welcome, below are my initial ideas:
---- i Parameters to be received by function:
1. Associative array with name of form element and corresponding name of table column 2. Name of table, to be used to construct the INSERT statement 3. A flag to instruct the function to return the last_insert_id() for those cases where you need it for the next save
To be returned by the function
1. The last_insert_id() if specified 2. A boolean value indicating if the saving was successful or not
Anything else I am missing?
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke