Jump to content

Archived

This topic is now archived and is closed to further replies.

phporcaffeine

mysql

Recommended Posts

Lokking for help on building a MySQL UPDATE query

my script does a

foreach ($_POST as $key => $value) {

}

for the POST array. In the foreach of the $_POST the '$key' is the column name and the '$value' is the column data, respectively.

I need help figuring out how to build that? INSERT queries are a sinch cause all the tables are on one side of the query and values on the other, but UPDATE dictates a table=value, table=value ... etc.

Is there some kind of " array implode function " I am missing?

My solution was to put the following in the foreach;

$string .= "$key='$value', ";

and then just ltrim " , " off the end and build the end of the query.

Is there a better way?

Share this post


Link to post
Share on other sites
Nevermind, I figured it out

I did this:

foreach $_POST as $key => $value) {

$data_string[] = "$key='$value'";

}

then:

$partial = "UPDATE record SET ";

$partial .= implode(", ", $datastring);

$partial .= " WHERE id='$record_number'";

after it finished it built a fully qualified MySQL UPDATE query.

Thanks to those who took/take the time to look.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.