开发怎么读取一个表所有数据
开源系统 更新 2018-05-09 13:27:04
找寻知音
找寻知音
开发怎么读取一个表所有数据
$sql = "SELECT `id`,`content` FROM `dr_1_news_data_0`";
$data = $this -> db -> query($sql);
while ($r = mysql_fetch_array($data)) {
echo $r['id'];
echo $r['content'];
}
怎么不好使啊
$sql = "SELECT `id`,`content` FROM `dr_1_news_data_0`"; $data = $this->db->query($sql)->result_array(); foreach ($data as $r) { echo $r['id']; echo $r['content']; }我推荐你用这种$data = $this->db->get('1_news_data_0')->result_array(); foreach ($data as $r) { echo $r['id']; echo $r['content']; }都是ci框架的语法，看ci框架手册就行