How to translate PHP array identifier into a string that can be used in MySQL Query?

Question

This question probably has a simple solution. Here's what I am doing:

I am dynamically creating checkbox inputs with a PHP loop.

<td><input type=\"checkbox\" class=\"current\" name=\"User[$row[0]]\" value=\"1\" ></td>

This snippet, name=\"User[$row[0]]\", is part of an array that is passed via post upon submission. Rather than using User[], I define the associative array by using $row[0]. $row[0] allows me to use a unique identifier that is really a UserId - it is guaranteed to be unique. The value of an instance of a submitted array is either 1 or 0 (true or false). This is a result of print_r(said array):

Array ( [1] => 1 
        [12] => 0
        [31] => 1 
        [4] => 1 )

What I need to do is use the User Id (which happens to be the identifier of a component of the array, i.e. 1, 12, 31...) in a SQL query. For example.

UPDATE...WHERE UserId = array identifier

At the same time, I need to use the value of that component (0 or 1) in that same query.

Any input is appreciated.

Surreal Dreams · Accepted Answer · 2013-06-20 04:57:37Z

2

When you process your array, use a foreach loop:

foreach($results as $key => $value)
{
    $sql .= "UPDATE...WHERE UserId = $key;";
}

This lets you not only use the value of each array element, but also its key. See the php manual for more on foreach.

answered Jun 20, 2013 at 4:57

Surreal Dreams

26.5k4 gold badges49 silver badges61 bronze badges

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

1 Comment

Mlagma Over a year ago

Thanks! I now know yet another use for this function.

Yogesh Suthar · Accepted Answer · 2013-06-20 04:59:00Z

1

Use foreach loop with key=>value pair

foreach($arr as $key=>$val) {
    $sql = "UPDATE table_name SET column = $val WHERE UserId = $key";
}

answered Jun 20, 2013 at 4:59

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

Collectives™ on Stack Overflow

How to translate PHP array identifier into a string that can be used in MySQL Query?

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