how to get values of array out

Question

I have this array

$pv->orderRecordsArray = array();


foreach($order->records as $i=>$orderRecord){

$pv->orderRecordsArray[] = $orderRecord->orderRecordID;  
        }

// print_r($pv->orderRecordsArray) for example
// shows Array ( [0] => 46839 [1] => 46840 [2] => 46841 )

I need to use the array values from above in my sql statement below.

$sql = "
    SELECT 
    *               
         FROM 
    table1               
    WHERE 
    orderRecordID IN (46741, 46742) 
         ";

so infront of IN I want $pv->orderRecordsArray results.

thanks

Gumbo · Accepted Answer · 2010-10-07 18:35:05Z

3

You can use implode to generate such a list:

$sql = "SELECT *
        FROM table1
        WHERE orderRecordID IN (" . implode(', ', $pv->orderRecordsArray) . ")";

But you should also consider a subquery or Join of your tables.

answered Oct 7, 2010 at 18:35

Gumbo

657k112 gold badges792 silver badges852 bronze badges

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

2 Comments

strager Over a year ago

Don't forget about sanitation! (Probably with array_map.)

Gumbo Over a year ago

@strager: I think the values are also coming from a database query.

MatTheCat · Accepted Answer · 2010-10-07 18:35:19Z

1

$sql = 'SELECT *
        FROM table1               
        WHERE orderRecordID IN ('.implode(',',$pv->orderRecordsArray).')';

answered Oct 7, 2010 at 18:35

MatTheCat

18.8k6 gold badges59 silver badges70 bronze badges

2 Comments

strager Over a year ago

Don't forget about sanitation! (Probably with array_map.)

MatTheCat Over a year ago

It depends to how he launches this query ^^

Collectives™ on Stack Overflow

how to get values of array out

2 Answers 2

2 Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Related