PPTwww 1 ppt commoban PPTwww 1 ppt comhangye
PPT模板下载:www. 1 ppt. com/moban/ 行业PPT模板:www. 1 ppt. com/hangye/ 节日PPT模板:www. 1 ppt. com/jieri/ PPT 素材下载:www. 1 ppt. com/sucai/ PPT背景图片:www. 1 ppt. com/beijing/ PPT 图表下载:www. 1 ppt. com/tubiao/ 优秀PPT下载:www. 1 ppt. com/xiazai/ PPT 教程: www. 1 ppt. com/powerpoint/ Word教程: www. 1 ppt. com/word/ Excel 教程:www. 1 ppt. com/excel/ 资料下载:www. 1 ppt. com/ziliao/ PPT 课件下载:www. 1 ppt. com/kejian/ 范文下载:www. 1 ppt. com/fanwen/ 试卷下载:www. 1 ppt. com/shiti/ 教案下载:www. 1 ppt. com/jiaoan/ 後端教學-MYSQL 講師:邱小楓(邱珈蓉)
常見的SQL指令 Ø Ø Select Insert Update Delete - 查詢 插入 更新 刪除
連接資料庫 <? php $link =mysqli_connect('localhost', 'root', 'password'); mysqli_query($link, "SET NAMES utf 8"); if (!$link) { die(' 連線失敗,輸出錯誤訊息 : '. mysql_error()); } echo ' 連線成功 '; ? >
妥善使用include
查詢資料 $sql=“select * from xxx”; $result = mysqli_query($link, $sql); while($row=mysqli_fetch_array($result)) { echo $row[0] ; echo $row[1] ; echo $row[2] ; }
新增資料 $sql=“select * from xxx”; $result = mysqli_query($link, $sql); $sql = "INSERT INTO `classtest`. `menu` (`id`, `name`, `price`, `description`, `type`, `ca`) VALUES (NULL, '". $fname. "', '". $fp. "', '". $des. "', '". $pic. "', '". $ca. "'); "; echo $sql. " "; $result = mysqli_query($conn, $sql);
修改資料 $sql=“select * from xxx”; $result = mysqli_query($link, $sql); $sql ="UPDATE `menu` SET `name` = '". $name. "', `price` = '". $price. "', `ca` = '". $ca. "', `description` = '". $descrip. "', `type` = '". $pic. "' WHERE `menu`. `id` = ". $fid. "; "; echo $sql. " "; $result = mysqli_query($conn, $sql); //回傳true 跟flase
刪除資料 $sql=“select * from xxx”; $result = mysqli_query($link, $sql); $sql = " DELETE FROM `menu` WHERE `id` = ". $fid. ""; $result = mysqli_query($conn, $sql);
- Slides: 8