Easy way to pass Form Submit to DB?

nightdesigns

I have a HTML form with about 30 fields in it. Is there a quick way to pass that info to update the record in the DB? or Do i have to define each one? Currently I have to set each field like SET title=$title, etc, etc, 30x. The names of the fields in the HTML form are the same as the names of the fields in the database.

I hope that makes sense

m_tt

Heh, you would have to define them but I sometimes get creative when building larger queries or queries that can be manipulated (like stats).

In your situation, one thing you could do is match the form fields to your database fields. Then do something like

$query[] = array();
foreach($_POST as $key => $value)	{
	$query[] = "`{$key}` = '{$value}'";
}

$myQuery = "UPDATE `table` SET " . join(",", $query) . " WHERE `id` = '{$id}'";

It's proably best to just type out the fields in this case 😉

nightdesigns

Thanks for the reply. You said I should just type out the fields instead, why? That looks like it would work ....

m_tt

Just safety reasons really... someone could manipulate your query. It is unlikely but a possibility and you should never make a habit of building _POST data like this. Just my 2 cents 😉

Sometimes you just have to be creative, that's why I love PHP

nightdesigns

I'm giving this a try, but it's returning an error.

Could not successfully run query (UPDATE accounts SET Array,action = 'update',ID = '1',identifie...

The issue I believe is the "Array" result which is contained in the $query[0] value. Is this correct?

m_tt

It means that $value is an array. Are you posting an array of checkboxes or something?

You could bypass certain variables from the insert query by doing a simple If

ie:

if ($key != "action" && $key != "array_key")

nightdesigns

Actually, after more testing I think the issues is with column names with a dash ( - ) in them.

from DB: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-ifier = 'name here',Name...

I tried moving the dash and the "near" changes. Is that it?

nightdesigns

I think I figured it out, i accidenly eliminated the ``'s.

nightdesigns

How about doing the oppostie?

I'd like to dump all the fields and results out ... how would I go about doing that too?

Thanks.