php_DBHelper

包含【CURD】 demo

<?php class DBHelper{ private $host="localhost"; private $userName="root"; private $pwd="root"; private $DBName="mytest"; /*** 獲取數據*/ function GetQuery($sql){$conn=new mysqli($this->host,$this->userName,$this->pwd,$this->DBName);if(!$conn){echo "conn mysql error";mysqli_close($conn);return;}mysqli_query($conn,"set names utf8");$return=mysqli_query($conn,$sql);mysqli_close($conn);return $return; } /*** 增刪修函數*/ function NOQuery($sql){$conn=new mysqli($this->host,$this->userName,$this->pwd,$this->DBName);if(!$conn){echo "conn mysql error";mysqli_close($conn);return;}mysqli_query($conn,"set names utf8");mysqli_query($conn,$sql);//獲取操作行數$rows=mysqli_affected_rows($conn);mysqli_close($conn);return $rows;//別忘記$符號 }} #開始執行測試 $db=new DBHelper(); #添加數據 // $db->NOQuery("insert into users values(0,'damo','11','易筋經')"); #修改數據 // $db->NOQuery("update users set userName='達摩' where userName='damo'"); #刪除數據 // $db->NOQuery("delete from users where userName='達摩'"); $result=$db->GetQuery("select * from users"); ?> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"> <table class="table table-hover table-bordered"><tr class="info"><th>編號</th><th>用戶名</th><th>密碼</th><th>愛好</th></tr><?php foreach ($result as $rows) {?><tr><td><?php echo $rows["id"]?></td><td><?php echo $rows["userName"]?></td><td><?php echo $rows["passWord"]?></td><td><?php echo $rows["likes"]?></td></tr><?php }?> </table>

總結

以上是生活随笔為你收集整理的php_DBHelper的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。