Foreach loop mysql query

Question

I have array like this

Array
(
[0] => 149
[1] => 150
)

how to make foreach loop and query ? i like each of this $values to match result and return

$damasks = $cart['damask_id']; //array data
            foreach ($damasks as $key => $value) {

            }

Complete Example:

foreach ($damasks as $key => $value) 
{ 
    $damask_query = $this->db->query("
        SELECT oc_damask_name.name 
        FROM " . DB_PREFIX . "cart 
        LEFT JOIN oc_damask_frontend ON ( $value = oc_damask_frontend.damask_id) 
        LEFT JOIN oc_damask_name ON ( oc_damask_frontend.damask_id = oc_damask_name.id ) WHERE api_id = '" . (isset($this->session->data['api_id']) ? (int)$this->session->data['api_id'] : 0) . "' 
        AND customer_id = '" . (int)$this->customer->getId() . "' 
        AND session_id = '" . $this->db->escape($this->session->getId()) . "'"); 
}

echo $value; will return 149 and 150, what kind of match result u have? — devpro
– devpro, Commented Jan 23, 2019 at 14:19
yes if i echo inside foreach will return both and if i do inside foreach query is returning only one value — Ivan
– Ivan, Commented Jan 23, 2019 at 14:33
foreach ($damasks as $key => $value) { $damask_query = $this->db->query("SELECT oc_damask_name.name FROM " . DB_PREFIX . "cart LEFT JOIN oc_damask_frontend ON ( $value = oc_damask_frontend.damask_id) LEFT JOIN oc_damask_name ON ( oc_damask_frontend.damask_id = oc_damask_name.id ) WHERE api_id = '" . (isset($this->session->data['api_id']) ? (int)$this->session->data['api_id'] : 0) . "' AND customer_id = '" . (int)$this->customer->getId() . "' AND session_id = '" . $this->db->escape($this->session->getId()) . "'"); } — Ivan
– Ivan, Commented Jan 23, 2019 at 14:35
( $value = oc_damask_frontend.damask_id) equal to column name? — devpro
– devpro, Commented Jan 23, 2019 at 14:42

devpro · Accepted Answer · 2019-01-23 15:01:00Z

1

According to your example and comment, you are not storing data into an array and printing outside the loop, which will only print last index.

you need to store result into an array like: $damask_query[]

Example:

$damask_query = array(); // initialize
foreach ($damasks as $key => $value) 
{ 
    $damask_query[] = $this->db->query(" // change in this line
        SELECT oc_damask_name.name 
        FROM " . DB_PREFIX . "cart 
        LEFT JOIN oc_damask_frontend ON ( $value = oc_damask_frontend.damask_id) 
        LEFT JOIN oc_damask_name ON ( oc_damask_frontend.damask_id = oc_damask_name.id ) WHERE api_id = '" . (isset($this->session->data['api_id']) ? (int)$this->session->data['api_id'] : 0) . "' 
        AND customer_id = '" . (int)$this->customer->getId() . "' 
        AND session_id = '" . $this->db->escape($this->session->getId()) . "'"); 
}

print_r($damask_query); // will print multiple records store in array.

answered Jan 23, 2019 at 15:01

devpro

16.1k3 gold badges29 silver badges39 bronze badges

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

4 Comments

Ivan Over a year ago

now i get to another problem ... how to access them ? Array ( [0] => stdClass Object ( [num_rows] => 2 [row] => Array ( [name] => test 6 ) [1] => stdClass Object ( [num_rows] => 2 [row] => Array ( [name] => test 7 ) )

devpro Over a year ago

solution is that, foreach($damask_query as $newVal){ echo $newVal->name;} @bobibobi

Ivan Over a year ago

i face another problem if are only 1 item in cart this work fine but if is more than one all other items have the previews product damask look like its stack in that array any ideas how to fix it ?

devpro Over a year ago

@bobibobi: please create a new question with this problem.

Collectives™ on Stack Overflow

Foreach loop mysql query

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related