How to UPDATE multiple fields in MySQL table using array?

Question

I want to update a MySQL database entry. For this, I am using a PHP form. I get entered data in form of an array (fieldname as key and data as value), and also the id of entry to be edited. But how do I update the entry by using the array?

I am using similar array for inserting new entry by using following code -

array_walk($register_data, 'array_sanitize');
$register_data['password'] = md5($register_data['password']);

$fields = '`' . implode('`, `', array_keys($register_data)) . '`';
$data = '\'' . implode('\', \'', $register_data) . '\'';

mysql_query("INSERT INTO `users` ($fields) VALUES ($data)");

But how do I update an existing row?

See the red warning on top for mysql_* functions. If you are going to learn php, learn it the right way. Use PDO/mysqli functions. — Mysteryos
– Mysteryos, Commented Jan 26, 2015 at 6:23
This is just a quick fix. I will be doing everything in proper way, later. Thanks for the suggestions. — user1543784
– user1543784, Commented Jan 26, 2015 at 6:29

Khushboo · Accepted Answer · 2015-01-26 06:39:57Z

1

Try below :-

$arr = array('name' => 'kh', 'phone' => 23456);

$s = "UPDATE table_name SET ";

foreach($arr as $k => $v){
   $s .= $k."='". $v."', ";
}

$s = rtrim($s, ", ");

$s .= " where id = 1";

echo $s;

Output will be :-

UPDATE table_name SET name='kh', phone='23456' where id = 1

answered Jan 26, 2015 at 6:39

Khushboo

1,8191 gold badge11 silver badges17 bronze badges

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

Comments

Ali Shaan · Accepted Answer · 2015-01-26 06:19:08Z

0

Use an UPDATE query,

UPDATE (Table Name) set (Field name)= (New Value) where (your condition).

or

UPDATE table_name SET column1=value1,column2=value2,... WHERE some_column=some_value;

answered Jan 26, 2015 at 6:19

Ali Shaan

3451 gold badge2 silver badges10 bronze badges

1 Comment

user1543784 Over a year ago

I am aware of UPDATE query. I just can't figure out how to make it work with an array as input (see my INSERT example). I want to do it dynamically. So that any changes in the array will be reflected automatically in the query.

Steve Chamaillard · Accepted Answer · 2015-01-26 06:36:06Z

0

$userData = array();
foreach ($userList as $user) {
    $userData[] = '("' . $user['first_name'] . '", "' . $user['last_name'] . '")';
 }
$query = 'INSERT INTO users (first_name,last_name) VALUES' . implode(',', $userData);
mysql_query($query);

You can also do this for $fields.

answered Jan 26, 2015 at 6:36

Steve Chamaillard

2,33920 silver badges33 bronze badges

Collectives™ on Stack Overflow

How to UPDATE multiple fields in MySQL table using array?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related