You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
25 lines
692 B
PHP
25 lines
692 B
PHP
<?php
|
|
|
|
class test_model extends CI_Model {
|
|
|
|
function __construct() {
|
|
parent::__construct();
|
|
$this->HT = $this->load->database('HT', TRUE);
|
|
}
|
|
|
|
//获取对应模板的页面
|
|
public function get_url($template){
|
|
$sql = "SELECT ic_url FROM infoContents WHERE ic_sitecode = 'ah' and ic_status = 1 and ic_template = '{$template}'";
|
|
$query = $this->HT->query($sql);
|
|
return $query->result();
|
|
}
|
|
|
|
//获取字符串查询所属的页面
|
|
public function get_contents($string){
|
|
$sql = "SELECT ic_url FROM infoContents WHERE ic_sitecode = 'ah' and ic_status = 1 and ic_content like '%{$string}%'";
|
|
$query = $this->HT->query($sql);
|
|
return $query->result();
|
|
}
|
|
|
|
}
|