- 先在Navicat建好數據庫,然后在項目文件夾model下建PHP.web文件,然后引入include_once (ROOT . '/library_Easy/mysqlhelper.php');
?
程序框架、<?php // include_once (ROOT . '/library_Easy/mysqlhelper.php');//固定寫法 apqc流程框架 最新版?class MessageList extends MySqlHelper { public function __construct() { parent::__construct("message_list");//和數據庫一致 } } ?> |
?
2.在項目新建文件夾text,在文件夾下建文件PHP.web
include_once '../library_Easy/config_Self.php'; include_once '../model/message.php'; //StaffList::IsLogin(); //判斷是否登錄不用打開 |
?
3.增append
$username=new MessageList();//實例化一個對象 $username ['my_id'];//數據庫id設置自增 $username ['username']=bonly8; $username ['passage']=123456; $username->append()->submit(); |
?
刪除delete
$username=new MessageList();//實例化一個對象 $username->delete()->where('my_id=6')->submit(); |
?
修改update
$username=new MessageList();//實例化一個對象 $username['password']=334456;//將id=6的數據修改password這一列的值為334456 $username->update()->where('my_id=6')->submit(); |
?
查詢
$username=new MessageList();//實例化一個對象 $username->select ()->where('my_id=6')->get_first_rows (); echo $username['username'];//輸出 |
?
按照升序輸出
$username=new MessageList();//實例化一個對象 $username->select()->get_page_asc('my_id');//按照升序輸出 <?php while($username->for_in_rows()){ echo $username['my_id']; echo $username['username']; echo $username['password']; ?> |