聯(lián)系官方銷售客服
1835022288
028-61286886
投訴
已解決 開發(fā)怎么讀取一個(gè)表所有數(shù)據(jù)
2 0
開發(fā)怎么讀取一個(gè)表所有數(shù)據(jù)
$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'];
}
怎么不好使啊
是你語(yǔ)法錯(cuò)了
$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框架的語(yǔ)法，看ci框架手冊(cè)就行
http://www.poscms.net/dev-doc/database/results.html
這里的語(yǔ)法