Search for database rows having a column value found in an PHP array using CodeIgniter [duplicate]

Question

I'm using CodeIgniter and trying to use an array in the WHERE clause to return only rows whose id is found in the array.

Submitted by form:

$arrTID = $this->input->post('Present'); print_r($arrTID);

output:

Array(
 [0]=>FMM003
 [1]=>30089
 [2]=>30097
)

query:

$query = $this->db->query("
    select TraineeID
    from tbl_attendance_processed
    where TraineeID IN $ID
    and attnDate='$atnDate'
");
$res = $query->result_array();

I need the query to return the TraineeIDs for the qualifying rows. How do get this?

Maxim Colesnic · Accepted Answer · 2016-02-09 22:14:32Z

7

$arrTID = $this->input->post('Present');
$atnDate = $this->input->post('atnDate');

$this->db->select('TraineeID');
$this->db->where_in('TraineeID', $arrTID);
$this->db->where('attnDate', $atnDate);
$query = $this->db->get('tbl_attendance_processed');

// and fetch result
$res = $query->result(); // as object
$res = $query->result_array(); // as array

and learn this http://www.codeigniter.com/userguide2/database/active_record.html

answered Feb 9, 2016 at 22:14

Maxim Colesnic

4861 gold badge5 silver badges17 bronze badges

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

Comments

Jaimil Patel · Accepted Answer · 2020-05-19 00:50:33Z

0

$array_check = array(10,11,12,13);
$name = "Raj Shekhar";

$this->db->select('*');

$this->db->where_in('id', $array_check);

$this->db->where('name', $name);

$query = $this->db->get('table_name');

// return result as array
return $query->result_array();

edited May 19, 2020 at 0:50

Jaimil Patel

1,3639 silver badges13 bronze badges

answered May 18, 2020 at 12:39

Raj Shekhar

71 bronze badge

Collectives™ on Stack Overflow

Search for database rows having a column value found in an PHP array using CodeIgniter [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related