標籤:user 開啟 寫法 sel order roo mode word web
- 先在Navicat建好資料庫,然後在專案檔夾model下建PHP.web檔案,然後引入include_once (ROOT . ‘/library_Easy/mysqlhelper.php‘);
|
<?php //
include_once (ROOT . ‘/library_Easy/mysqlhelper.php‘);//固定寫法
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‘];
?> |
使用Rss架構PHP開發流程