how to do an sql query using values from a dynamic array?

Question

here is my array

Array
(
    [0] => 31
    [1] => 36
    [2] => 41
)

the 31,36, and 41 are id's of a record. the elements in this array can be from anywhere of 1 element to 10+ elements. the table structure looks something like this (shortened-version)

tbl_cart
---------
id (auto-incremented)
product_name
price

what i'm trying to figure out is how can i do a query that will grab the id's listen in a dynamically created array then accumulate the price for each respected id and display the output?

thanks, let me know if this doesnt make sense.

Pascal MARTIN · Accepted Answer · 2011-03-11 05:58:38Z

2

You can get the ids as a comma-separated string using the implode() function, like this :

$str_ids = implode(', ', $array);

Then, you can inject that into an SQL query, using in() :

select sum(price) as total_price
from tbl_cart
where id in ($str_ids)

answered Mar 11, 2011 at 5:58

Pascal MARTIN

402k82 gold badges665 silver badges666 bronze badges

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

Comments

jon_darkstar · Accepted Answer · 2011-03-11 06:05:57Z

1

you want to sum the prices for the ids in your list right?

$idStr = implode(',', $arr);
$sql = "SELECT sum(price) FROM tbl_cart WHERE id in ($idStr)";

answered Mar 11, 2011 at 6:05

jon_darkstar

16.9k7 gold badges35 silver badges38 bronze badges

Comments

S L · Accepted Answer · 2011-03-11 06:03:53Z

0

$vars = array(1, 2, 3, 4);

$newvars = array();

foreach($vars as $var){

    if(!empty($var))
        $newvars[] = " ID = ".$var;

}

$where = join(" OR ", $newvars);

$sql = "SELECT * FROM table ".(($where)?"WHERE ".$where: null);

echo $sql;

answered Mar 11, 2011 at 6:03

S L

14.3k18 gold badges81 silver badges119 bronze badges

Comments

Chris · Accepted Answer · 2011-03-11 06:17:34Z

0

$ids = implode(',', $array);
$query = "SELECT id, price FROM tbl_cart WHERE id in ($ids)";

$result = mysql_query($query);

while ($row = mysql_fetch_array($result)) {
    echo "ID: {$row['id']}  Price: {$row['price']}");  
}

Outputs

//    ID: 31  Price: (the price)
//    ID: 36  Price: (the price)
//    ID: 41  Price: (the price)

answered Mar 11, 2011 at 6:17

Chris

58.9k34 gold badges158 silver badges198 bronze badges

Collectives™ on Stack Overflow

how to do an sql query using values from a dynamic array?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related