サマリー://查詢語句 $res = select($db,"select * from `acctor`",null,"`name` = '馮剛'"); //查詢 條件為 name字段為 馮剛的 $res&
//查詢語句 $res = select($db,"select * from `acctor`",null,"`name` = '馮剛'"); //查詢 條件為 name字段為 馮剛的 $res = select($db,"select * from `acctor`",'id'); // select * from `acctor` order by `id` desc; //查詢id并且為降序 $res = select($db,"select * from `acctor`",null,"`name` = '馮剛'",2); //查詢字段名為 馮剛 且 只返回兩條數(shù)據(jù) while($row = mysqli_fetch_assoc($res)){ echo "<pre>"; print_r($row); } /** * 查詢語句 * @param 數(shù)據(jù)庫 * @param $sql 語句 * @param $order 語句 排序的字段 * @param $where 查詢條件 * @param $limit 返回的數(shù)據(jù) */ function select($db,$sql,$order = '',$where = '',$limit = ''){ if($order){ $sql .= " order by ".$order." desc "; } if($where){ $sql .= " where ".$where; } if($limit){ $sql .= " limit ".$limit; } $res = mysqli_query($db,$sql.";"); return $res; }
添削の先生:韋小寶添削時間:2019-03-02 17:32:47
先生のまとめ:查詢函數(shù)都可以封裝是不是也可以封裝個連接數(shù)據(jù)庫的函數(shù)呢 沒事的時候記得多寫些哦