Updating config/routes.php using mysql

[eluser]robert.fulcher[/eluser]
mattnewark,

From looking at the code, you are looping, and the blow code

Code:

$data = '$route["' . $r['link'] . '"] = "' . $r['route'] . '";';

will reassign $data to the most recent information that is in the string to the right of the equals. Resulting in just the last line only being written to the file.

So what you need to do is build your full $data string and then write it once to the file. I think the reason you got the undefined variable is because you did not define $data outside the for each.

Give this a try

Code:

function update_routes()
    {
            $this->db->select("*");
            $query = $this->db->get("articles");
            $data = '';
            foreach ($query->result() as $r)
                {
                    $data = $data.'$route["' . $r['link'] . '"] = "' . $r['route'] . '";';
                }
            write_file(APPPATH . 'cache/routes.php', $data);                
    }

Basically you initialize the $data outside the foreach and it should be ok.

Thanks