迅睿開源框架是一款PHP8高性能·簡單易用的PHP開源開發(fā)框架, 基于MIT開源許可協(xié)議發(fā)布,不限制商業(yè)使用,以多端互聯(lián)為設(shè)計理念, 支持的微信公眾號、小程序、APP客戶端、移動端網(wǎng)站、PC網(wǎng)站等多終端式管理系統(tǒng)。
業(yè)務(wù)經(jīng)理
微信掃描以上二維碼
028-61286886
技術(shù)咨詢
開發(fā)怎么讀取一個表所有數(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'];
}
怎么不好使啊
是你語法錯了
$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框架手冊就行
http://www.poscms.net/dev-doc/database/results.html
這里的語法
是你語法錯了
$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框架手冊就行
http://www.poscms.net/dev-doc/database/results.html
這里的語法