Welcome Guest, Not a member yet? Register   Sign In
Having trouble passing database information to the view
#1

[eluser]deadzebra[/eluser]
Hey guys! firstly i would like to say awesome framework...no doubt about it this is the one to use!

secondly and i know this expected...im having trouble trying to pass information from my database to my view
Code:
/* this snippet is from the controller */
        //get file list from database
        $this->db->select('fid,name');
        $this->db->order_by('id','desc');
        $this->db->limit('10');
        $query = $this->db->get('upload');
            foreach($query->result() as $row)
            {
                $data['downloads']['fid']["$row->fid"] = $row->fid;
                $data['downloads']['name']["$row->name"] = $row->name;
            }
/* end snippet */

Code:
/* this snippet is from the view */
        foreach($downloads as $download_info)
        {
            echo anchor("/downloads/id/$download_info['fid']", "$download_info['name']", "title=\"$download_info['name']\"") . "<br />";
        }
/* end snippet */

its probably something obvious for you pros but i have no idea whats going on

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in F:\xampp\htdocs\ci\application\views\m\downloads.php on line 17
#2

[eluser]Mirge[/eluser]
Try changing $download_info['fid'] to $download_info[fid]... repeat for others.
#3

[eluser]Bart v B[/eluser]
You have some trouble with quoting. Smile

Code:
foreach($query->result() as $row)
{
   $data['downloads']['fid'][$row->fid] = $row->fid;
   $data['downloads']['name'][$row->name] = $row->name;
}

The view:

Code:
foreach($downloads as $download_info)
{
  echo anchor('/downloads/id/'.$download_info['fid'], $download_info['name'], "title=".$download_info['name'].'"/"). '<br />';
}
#4

[eluser]deadzebra[/eluser]
Thanks guys really appreciate it i got it working Smile




Theme © iAndrew 2016 - Forum software by © MyBB