首先我会更改要使用的 url 链接网址标题()(网址助手)。如果您使用来自我认为是数据库调用的 ID 的文本值创建查询,这将为您提供类似的信息
(例如,如果 id 1 的记录是 name="America");
echo 'http://www.mysite.in/package/tour-packages/'.url_title($name);
会给予;
http://www.mysite.in/package/tour-packages/American
如果您随后添加此扩展路由器类,它将自动为您将破折号重新格式化为下划线。
<?php if (! defined('BASEPATH')) exit('No direct script access allowed');
class MY_Router extends CI_Router {
function set_class($class) {
$this->class = str_replace('-', '_', $class);
}
function set_method($method) {
$this->method = str_replace('-', '_', $method);
}
function _validate_request($segments) {
// Does the requested controller exist in the root folder?
if (file_exists(APPPATH.'controllers/'.str_replace('-', '_', $segments[0]).EXT)) {
return $segments;
}
// Is the controller in a sub-folder?
if (is_dir(APPPATH.'controllers/'.$segments[0])) {
// Set the directory and remove it from the segment array
$this->set_directory($segments[0]);
$segments = array_slice($segments, 1);
if (count($segments) > 0) {
// Does the requested controller exist in the sub-folder?
if ( ! file_exists(APPPATH.'controllers/'.$this->fetch_directory().str_replace('-', '_', $segments[0]).EXT)) {
show_404($this->fetch_directory().$segments[0]);
}
} else {
$this->set_class($this->default_controller);
$this->set_method('index');
// Does the default controller exist in the sub-folder?
if ( ! file_exists(APPPATH.'controllers/'.$this->fetch_directory().$this->default_controller.EXT)) {
$this->directory = '';
return array();
}
}
return $segments;
}
// Can't find the requested controller...
show_404($segments[0]);
}
}
然后你可以在路由文件中添加一个条目(在配置中);就像是;
$route['package/tour_package/(:any)'] = "package/lookup_by_name/$1";
然后,您需要在包控制器中创建一个名为的方法按名称查找($名称)。
此方法需要对数据库执行 sql 查询,从名称值中获取 id。然后您可以继续加载视图或执行任何您想要的操作。
E.g
public function lookup_by_id($name) {
// sql to get id from database record
// load the view?
$this->view($id);
}
public function view($id) {
// sql to load full record from id
$this->load->view('foo', $data);
}