codeigniter get field names and row values into a single string

Question

i want to get the field names and the row values into a single string.

select * from table where id=1  
$this->db->where('id', 1);
$query = $this->db->get('table');
$row = $query->row();
$string = $row->id . $row->fname . $row->gender . $row->email;

Desire outcome:
id:1, fname:john, gender:male, email:[email protected]
or
id, fname, gender, email, 1, john, male, [email protected]

Any advise on how to construct the sql query dynamically, many thanks.

Loïc · Accepted Answer · 2014-04-22 02:26:48Z

3

$query = $this->db->query("select whatever from wherever.");
$string = "";
foreach ($query->result_array() as $row)
{
    foreach($row as $key=>$val){$string.="$key:$val,";}
}

answered Apr 22, 2014 at 2:26

Loïc

12k2 gold badges35 silver badges52 bronze badges

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

Comments

PrestonDocks · Accepted Answer · 2015-04-17 05:41:07Z

0

The only problem with selected answer is that if the query returns no records then you will not get any field names either.

You may prefer to get the field names discretely with the following command

$query = $this->db->query("select * from users");
$field_array = $query->list_fields();
$data = "";
foreach($field_array as $field){
     $data .= $field . ", "
}

edited Apr 17, 2015 at 5:41

answered Apr 16, 2015 at 22:25

PrestonDocks

5,5279 gold badges59 silver badges94 bronze badges

2 Comments

Angel Over a year ago

May I ask what is the purpose of $data?

PrestonDocks Over a year ago

The op asked how to get results into a string. $data is just a variable to hold that string.

Collectives™ on Stack Overflow

codeigniter get field names and row values into a single string

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related