How to pass sql rows to array in codeigniter

Question

How do I make an array of the sql rows please help I am new to PHP?

$data = null;
if ($query->num_rows() > 0) {
  foreach ($query->result() as $row) {
    $SurveyTitle = $row->SurveyTitle;
    $SurveyId = $row->SurveyId;
    $data =array('lidata' => '<li id=' . $SurveyId . '><a href=' . $SurveyTitle . '>' . $SurveyTitle . '</a><li>',);
  }
  return $data;
}
else
{
  return $data;
}

EDIT: I need to pass the lidata to my view

<ul class="nav nav-sidebar">
  <li class="active"><a href="#">Home</a></li>
  <li><a href="#">Add new Survey</a></li>
  <?php echo $lidata;?>
</ul>

What issue you facing with above code ? Can you be more clear ? — Rikesh
– Rikesh, Commented Mar 25, 2014 at 7:12
have you any error? what you getting after return result try with remove comma after <li>'); — Rakesh Sharma
– Rakesh Sharma, Commented Mar 25, 2014 at 7:13
Why you not return if($query->num_rows > 0 ){ return $query->result_array();} and use foreach() for this result array in your controller/view — Rakesh Sharma
– Rakesh Sharma, Commented Mar 25, 2014 at 7:19

Mohan · Accepted Answer · 2014-03-25 07:27:27Z

3

instaead if $query->result() use $query->result_array()

your function will be something like this

$data = null;
    if ($query->num_rows() > 0) {
        $data = $query->result_array();
        return $data;
    }
    else
    {
        return $data;
    }

answered Mar 25, 2014 at 7:27

Mohan

4,8597 gold badges47 silver badges70 bronze badges

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

1 Comment

vini Over a year ago

I need to pass the li elements to front end

Littlebobbydroptables · Accepted Answer · 2014-03-25 07:19:10Z

0

If you want just to store mysql results into an array you need to do this:

$query = $this->db->query("YOUR QUERY");
$allResults = $query->result_array();

Thats all, just check it:

var_dump($allResults);

More information about Codeigniter database helper you can find here: http://ellislab.com/codeigniter/user-guide/database/results.html

answered Mar 25, 2014 at 7:19

Littlebobbydroptables

3,7419 gold badges53 silver badges82 bronze badges

Collectives™ on Stack Overflow

How to pass sql rows to array in codeigniter

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related