[i=s] 本帖最后由 chnzbq 于 2019-5-3 11:45 编辑
基于我司数字工厂咖啡云2.0--PHP MVC 框架改进，由于此系统为半成品，所以必须进行以下改造。
1. session表 不能为空，可把原数据导进来。
2.postgrelSQL大小写敏感，要加双引号
public function read($sessID){
$sql = 'SELECT session_data AS d FROM "'.$this->table.'" WHERE session_id=\''.$sessID .'\' AND session_time > ' . $this->now . ' LIMIT 1';
$res = $this->con->fetch($sql);
if($res){
$data = json_decode($res['d'], true);
return serialize($data);
}
return '';
Author:
chnzbq Time: 2019-5-3 11:44 Title: 智慧农场MVC框架项目搭建
智慧农场MVC框架项目搭建Author:
教授222 Time: 2019-5-3 11:49
数据库开发内容
Image attachment:
mmexport1556855258975.jpg (2019-5-3 11:49, 53.32 K) / Number of times this attachment has been downloaded 6 http://iot.caffz123.uk:12345/mud/AbyssalSwamp/index/attachment.php?aid=25647
Author:
chnzbq Time: 2019-5-3 11:50
$sql = <<prefix}admin.id,{$this->prefix}admin.name,passwd,role_id,info,{$this->prefix}role.name AS role,auth
FROM "{$this->prefix}admin"
LEFT JOIN {$this->prefix}role ON {$this->prefix}admin.id={$this->prefix}role.id
WHERE {$this->prefix}admin.{$type}='{$input}' LIMIT 1;
SQL;Author:
chnzbq Time: 2019-5-3 11:57
表名，全部要加双引号：
$sql = <<prefix}admin".id,"{$this->prefix}admin".name,passwd,role_id,info,"{$this->prefix}role".name AS role,auth
FROM "{$this->prefix}admin"
LEFT JOIN "{$this->prefix}role" ON "{$this->prefix}admin".id="{$this->prefix}role".id
WHERE "{$this->prefix}admin".{$type}='{$input}' LIMIT 1;
SQL;
Author:
chnzbq Time: 2019-5-3 12:02
[i=s] 本帖最后由 chnzbq 于 2019-5-3 12:03 编辑
遇到表名，要加双引号：
"{$this->prefix}device" WHERE user_id={$uid} ORDER BY id ASC;
SQL;
return $this->db->query($sql);
}
/*
获取一个设备信息（单个设备）
*/
public function getOneDevice($id){
$sql = <<"{$this->prefix}device" WHERE id={$id} LIMIT 1;
SQL;
return $this->db->fetch($sql);
}
/*
获取设备状态信息
*/
public function getStatusByUID($uid){
$sql = <<"{$this->prefix}device" WHERE user_id={$uid};
SQL;
return $data = $this->db->query($sql);
}
/*
手动模式设置设备开关（单个设备）（mode=>1）
*/
public function setDeviceStatus($id,$uid,$status){
$sql = <<"{$this->prefix}device" SET status={$status} WHERE id={$id} AND user_id={$uid} AND mode=1;
SQL;
return $this->db->exec($sql);
}
/*
设置设备模式（自动1、手动2模式）（单个设备）
*/
public function setDeviceMode($id,$uid,$mode){
$sql = <<prefix}device" SET mode={$mode} WHERE id={$id} AND user_id={$uid};
SQL;
return $this->db->exec($sql);
}
}
Author:
chnzbq Time: 2019-5-3 14:29
Image attachment:
mmexport1556855258975.jpg (2019-5-3 11:49, 53.32 K) / Number of times this attachment has been downloaded 6