<?php
namespace app;class mydb{ public $host="127.0.0.1"; public $name="root"; public $dbname='taobao'; public $table='myuser'; public $link; public function __construct() { // 連接數(shù)據(jù)庫 $this->link=MySQLi_connect('127.0.0.1','root','root',"taobao"); $sql="set names utf8";; mysqli_query($this->link,$sql); } // / 執(zhí)行 sql查詢 語句 public function query($sql) { return mysqli_query($this->link,$sql); } // 返回一行數(shù)據(jù)查詢的結(jié)果 public function getOne($field="*",$where="") { $sql="select ".$field." from ".$this->table." ".$where; $res=mysqli_query($this->link,$sql); $row=mysqli_fetch_assoc($res); return $row; } // 執(zhí)行一條sql public function getRow($sql) { $sql='select * from '.$this->table; return mysql_fetch_assoc($this->query($sql)); } // 返回?cái)?shù)據(jù)庫查詢結(jié)果 public function getAll($where="") { $sql="select * from myuser"." ".$where; // return $sql; $res=mysqli_query($this->link,$sql); while($row=mysqli_fetch_assoc($res)){ $data[]=$row; } return $data; }}
第二部，如果用框架里引入類這樣寫
public function actionIndex() { $db=new mydb(); $request=Yii::$app->request; $page=$request->get('page'); // 煤業(yè)條數(shù) $per_page=4; // 總條數(shù) $num=$db->getOne('count(id) as num'); //便宜量 // 總頁碼 $num=$num['num']; // var_dump($num);die; $last_page=ceil($num/$per_page); // var_dump($last_page);die; $offset=empty($page)?0:($page-1)*$per_page; // 查詢數(shù)據(jù) // var_dump($num);die; $where=' limit '.$offset.','.$per_page; $data=$db->getAll($where); // var_dump($data);die; return $this->render('show',['data'=>$data,'page'=>$page,'last_page'=>$last_page]); }
新聞熱點(diǎn)
疑難解答
圖片精選
網(wǎng)友關(guān)注
