Accessing each data of the Result set i.e. $this->db->get(), on the model in Codeigniter

Question

I have to get all the phone numbers of students from database and store in string variable with a comma in between them. I have tried the following but failed.

This is my code below :

        $toNumbersCsv="";
        $this->db->select("std_cellNo");
        $this->db->from("student");

        $queryforPhone = $this->db->get();
        //Attempt 1
        // while ($row = mysql_fetch_assoc($queryforPhone)) {
            // $toNumbersCsv .= $row['std_cellNo'].',';
        // }
        //Attempt 2
        foreach($queryforPhone as $qfp){
            $toNumbersCsv .= $qfp.',';
        }

score 0 · Answer 1 · answered Aug 12 '18 at 06:46

0

foreach($queryforPhone->result() as $qfp){
        $toNumbersCsv .= $qfp->std_cellNo.',';
}

answered Aug 12 '18 at 06:46

Anas Bin Numan

64
2

Thanks. this worked with a slight modification: $toNumbersCsv .= $qfp['std_cellNo'].','; – Abdul Munim Khan Aug 13 '18 at 07:36

score 0 · Accepted Answer · answered Aug 12 '18 at 07:17

Hope this will help you :

use result() to get the record from the query also

$toNumbersCsv = "";
$this->db->select("std_cellNo");
$this->db->from("student");
$results = $this->db->get()->result();
foreach ($results as  $row) 
{
   $toNumbersCsv .= $row->std_cellNo.',';
}
echo rtrim($toNumbersCsv, ',');

for more : https://www.codeigniter.com/user_guide/database/results.html

Accessing each data of the Result set i.e. $this->db->get(), on the model in Codeigniter

2 Answers2