[eluser]jzmwebdevelopement[/eluser]
Currently I have the current code within my routes.php.
I was wanting to know can someone provide an example on how I could do it as a hook so that I can expand it below using an if statement and correct CI methods.
What i'm wanting
Code:
if($website_page['post_url_link'] == 'value')
{
write the specific routes for this link
}else{
write standard
}
Code
Code:
if (!file_exists('./cache/'.DOMAIN_NAME.'-routes.php'))
{
// Setup database connection
include(APPPATH.'config/database'.EXT);
$conn = mysql_connect($db['default']['hostname'],$db['default']['username'],$db['default']['password']);
mysql_select_db($db['default']['database'],$conn);
$data[] = "<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');";
$website_page_sql = 'SELECT * FROM posts WHERE post_type = \'page\' AND is_external_url = 0 AND website_id = \''.WEBSITE_ID.'\' ORDER BY post_order ASC';
$website_page_query = mysql_query($website_page_sql);
while($website_page = mysql_fetch_array($website_page_query))
{
{
$data[] = "\$route['{$website_page['post_url_link']}/details/(:any)/(:any)'] = 'screenings/details/\$1/\$2'; ";
$data[] = "\$route['{$website_page['post_url_link']}/(:any)/(:any)'] = 'page/load/{$website_page['post_id']}/{$website_page['post_url_link']}/\$1/\$2';";
$data[] = "\$route['{$website_page['post_url_link']}/(:any)'] = 'page/load/{$website_page['post_id']}/{$website_page['post_url_link']}/\$1';";
$data[] = "\$route['{$website_page['post_url_link']}'] = 'page/load/{$website_page['post_id']}/{$website_page['post_url_link']}';";
}
}
$output = implode("\n", $data);
$fp = fopen('./cache/'.DOMAIN_NAME.'-routes.php', 'w+');
fwrite($fp, $output);
fclose($fp);
}
// Close mysql connection if it has been opened
if ( isset($conn) ) mysql_close($conn);
include_once './cache/'.DOMAIN_NAME.'-routes.php';