function searchCb($word, $accid, $begin = 0, $limit = 20) { global $db; $acc = new Account(); $reply = new InboxReply(); $q = "\n \n (SELECT {$this->searchColoms} FROM {$this->table_name} INNER JOIN {$acc->table_name}\n ON ({$this->table_name}.inbox_from = {$acc->table_name}.admin_id)\n WHERE\n (inbox_from = '{$accid}' OR inbox_to = '{$accid}') AND inbox_type = 'cb' AND \n (inbox_judul LIKE '%{$word}%' OR inbox_msg LIKE '%{$word}%' OR admin_nama_depan LIKE '%{$word}%') \n )\n UNION\n (SELECT {$this->searchColoms} FROM {$this->table_name} INNER JOIN {$acc->table_name}\n ON ({$this->table_name}.inbox_to = {$acc->table_name}.admin_id)\n WHERE\n (inbox_from = '{$accid}' OR inbox_to = '{$accid}') AND inbox_type = 'cb' AND \n (inbox_judul LIKE '%{$word}%' OR inbox_msg LIKE '%{$word}%' OR admin_nama_depan LIKE '%{$word}%') \n ) \n ORDER BY inbox_changedate DESC LIMIT {$begin},{$limit}\n \n "; $arr = $db->query($q, 2); // pr($arr); // echo $q; $newMurid = array(); foreach ($arr as $databasemurid) { $m = new Inbox(); $m->fill(toRow($databasemurid)); $newMurid[] = $m; } //return jumlah totalnya $q = " \n (SELECT {$this->searchColoms} FROM {$this->table_name} INNER JOIN {$acc->table_name}\n ON ({$this->table_name}.inbox_from = {$acc->table_name}.admin_id)\n WHERE\n (inbox_from = '{$accid}' OR inbox_to = '{$accid}') AND inbox_type = 'cb' AND \n (inbox_judul LIKE '%{$word}%' OR inbox_msg LIKE '%{$word}%' OR admin_nama_depan LIKE '%{$word}%') \n )\n UNION\n (SELECT {$this->searchColoms} FROM {$this->table_name} INNER JOIN {$acc->table_name}\n ON ({$this->table_name}.inbox_to = {$acc->table_name}.admin_id)\n WHERE\n (inbox_from = '{$accid}' OR inbox_to = '{$accid}') AND inbox_type = 'cb' AND \n (inbox_judul LIKE '%{$word}%' OR inbox_msg LIKE '%{$word}%' OR admin_nama_depan LIKE '%{$word}%') \n ) \n "; $arr2 = $db->query($q, 2); return array("arrMsg" => $newMurid, "total" => count($arr2)); //die(); }