php mysql update statment generation from form values

Question

I am creating a very small database abstract layer, i want to send an array of variables that i obtained from a form, and generate an update sql statement, and eventually execute it. What do I put on the second to last line below? for example.

$table name = "user";
$username = $_post['username'];
$password = $_post['password'];
$email    = $_post['email'];
$array = (username=>$username, password=>$password, email=>$email);
$query = "update $this->tableName".
$query = """" The value from the assc array in the form of database value='form value' 
$query = "WHERE condition";

zombat · Accepted Answer · 2010-02-03 03:19:49Z

3

You can use a foreach() loop to generate your query clause from your array. Note that you need to declare your array with the array() construct, and quote your associative keys.

//...
$array = array('username'=>$username, 'password'=>$password, 'email'=>$email);
$query = "update ".$this->tableName." SET ";
foreach($array as $field => $value) {
    $query .= "`".$field."`='".mysql_real_escape_string($value)."',";
}
//knock off trailing comma
$query = substr($query,0,-1);
$query .= " WHERE condition";

answered Feb 3, 2010 at 3:19

zombat

94.5k25 gold badges158 silver badges165 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

zf. Over a year ago

I am thinking of sending it as a multidimensional array for example $multi = array(); $multi[] = array($customer_id, $domain_name, $purchase_date, $expiry_date, $vendor); $multi[] = array("c_id", "domain_id", "purchase_date", "expiry_date", "vendor"); how can you implement the foreach on this kind of array?

pedro · Accepted Answer · 2010-02-03 03:21:18Z

0

You can use something like:

$a = array();
foreach($array as $key => $value)
{
    $a[] = $key . " = '" . mysql_real_escape_string($value) ."'";
}
$query = join(',', $a);

but you need to take care of special cases, for example when the value is null or a date

answered Feb 3, 2010 at 3:21

pedro

4113 silver badges9 bronze badges

Collectives™ on Stack Overflow

php mysql update statment generation from form values

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related