Jump to content

mysql


phporcaffeine

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?
Link to comment
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.
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.