[SOLVED] How to pass external array to the query?

Issue

I am new to the mysql queries, i have one query which will search all the items inside the array status in ('php','laravel','apiato') if i use like this it’s working, now i have to add more values to the array instead of passing strings i made one constant file from that file i want to send an array,it’s throwing an exception Array To string Conversion

public function getALlData(){
$array = BooksConstants::Status_constants;
DB::select("SELECT count(1) as total_transactions from books  where books.account_id in ('$this->account_ids') and DATE(created_at) between ? and ? and status in $array ", [$fromDate, $toDate]);
}

Solution

Try this,

public function getALlData(){
$array = BooksConstants::Status_constants;
DB::select("SELECT count(1) as total_transactions from books  where books.account_id in ('$this->account_ids') and DATE(created_at) between ? and ? and status in ('" . implode("','", array_map('trim', $array)) ."') ", [$fromDate, $toDate]);
}

Answered By – Keerthi S

Answer Checked By – Candace Johnson (BugsFixing Volunteer)