Bonfire - Query builder #database #cibonfire #PHP

check whether the record is exist

$query = $this->MODELNAME_model->as_array()->find_by('id', $seller_id);
$insert_data = array();
if ( $query !== FALSE ){//exist
    $error=$this->MODELNAME_model->update_where('id', $seller_id, $insert_data);
    if (!$error) {
      Template::set_message('Query error', 'danger');
      Template::message();
    } else {
    	Template::set_message('Success', 'success');
      Template::message();
    }

}
else {//not exist
      $error=$this->MODELNAME_model->insert($insert_data);
      if (!$error) {
        Template::set_message('Query error', 'danger');
        Template::message();
      } else {
          Template::set_message('Success', 'success');
        Template::message();
      }
}

Count records

$tmp = $this->inventory_model->select('id')->as_array()->order_by($id, 'asc')->find_all();
$max = count($tmp);
echo $max;

//$tmp = $this->inventory_model->select('id')->as_array()->order_by($id, 'asc')->find_all();
//$max = end($tmp);

Delete a record

$wheres = array('id' => $id);
$error = $this->MODEL_NAME_model->delete_where('id' => $id);
if (!$error) {
	$flash_message .= 'Query error: '.$data_table.'<br>';
} else {
	$flash_message .= 'Deleted all features ('.$lazada_id.'). Data Tabe: '.$data_table.'<br>';
}

get-random-record

$products = array();
$total_rows = $this->db->count_all_results($table_name);

$products = array();
$i = 0;
$succeed_records = 1;
do {
$return = $this->db->get_where($table_name, array('id' => rand(1,$total_rows), 
'availability_instock' => 1
), 
1); //limit 1
if($return->num_rows() == 1){
$result = $return->row_array();
array_push($products, $result);
$succeed_records++;
$i++;
}

} while ($i < $number_of_items && $succeed_records <= $number_of_items);

run-a-query.php

$rows = $this->MODELNAME_model->select('*')
            ->where('gender', 'male')
            ->limit(15,0) //limit, offset
            ->as_array()
            ->find_all();

select random record

$row = $this->select('*')
            ->where(array('size' => $size,
                            'status' => 'published',
            ))
            ->limit(1, 0) //limit, offset
            ->order_by('id', 'RANDOM')
            ->as_array()
            ->find_all();

       

select-by-id.php

$row = $this->MODELNAME_model->find($id);

update record

$update_data = array(
	'sync_status' => 'success',
);
$error = $this->MODELNAME_model->update_where('id', $id, $update_data);
if ($error === false) {
  //Failed
  
} else {
	//success

}