php update value from an array except one

Question

I want update my database from an array except one value from $_POST

$_POST['value'] = 'b';
$array = array('a','ab','b','bb','c','cc');
//insert 'a','ab','bb','c','cc' except $_POST['value'] 'b'
mysql_query("UPDATE core SET list='".$newarray."' WHERE id='".$_POST['id']."' ");

How do I do? use preg_replace remove the $_POST['value'] --> difficulty judge the comma ','

or advanced mysql query skill?

$_POST['value'] = 'b'; $array = array('a','ab','b','bb','c','cc'); I don't understand this part. — M. Suleiman
– M. Suleiman, Commented Sep 30, 2011 at 10:50

JJJ · Accepted Answer · 2011-09-30 10:50:55Z

2

If I understood the question correctly...

$newarray = implode( ',', array_diff( $array, array( $_POST[ 'value' ] ) ) );

// $newarray == "a,ab,bb,c,cc"

answered Sep 30, 2011 at 10:50

JJJ

33.2k20 gold badges95 silver badges103 bronze badges

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

1 Comment

johannes Over a year ago

Mind that this answer does no escaping (mysql_real_escape) of the array elements, so $array may only include database-safe values ...

Fabio · Accepted Answer · 2011-09-30 11:05:06Z

1

Try this if you need to filter by array value

$filtered = array_filter($array, function($value) {
  // you need to return a boolean value which tells
  // whether to include this element or not
  return $value != 'b';
});
$fields = implode(', ', $filtered);
mysql_query("UPDATE core SET list='".$fields."' WHERE id='".$_POST['id']."' ");

Or if you need to filter by array keys

$keys = array('...'); // list here allowed keys
$filtered = array_merge(array_combine($keys, $keys), $_POST);
$fields = implode(', ', $filtered);
mysql_query("UPDATE core SET list='".$fields."' WHERE id='".$_POST['id']."' ");

answered Sep 30, 2011 at 11:05

Fabio

19.3k9 gold badges85 silver badges114 bronze badges

Comments

Paul · Accepted Answer · 2011-09-30 11:05:36Z

0

$newarray = $array;
$key = array_search($_POST['value'], $newarray);

if ($key !== false)
{
   unset($newarray[$key]);
}

answered Sep 30, 2011 at 11:05

Paul

6,9093 gold badges42 silver badges52 bronze badges

1 Comment

Paul Over a year ago

Note: This only removes the first matched item.

Collectives™ on Stack Overflow

php update value from an array except one

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related