$employe = new \Home\Model\EmployeModel ();
$where['employe_id'] = session ( 'employe_id' );
$employeRes = $employe->where ( $where )->find ();
var_dump($employeRes);
结果:
array(8) {
["employe_id"]=>
string(1) "1"
["employe_name"]=>
string(6) "测试"
["mail"]=>
string(18) "ceshi@hyvision.com"
["department"]=>
string(1) "1"
["accounts"]=>
string(5) "ceshi"
["password"]=>
string(6) "222222"
["permission"]=>
string(1) "1"
["favorite"]=>
string(27) "去玩儿去玩儿完全二"
}
更新的:
$data['favorite'] = "qqq";
$data['password'] = "222222";
$data['Permission'] = 1;
var_dump ( $data );
echo $employe->getLastSql();
print "<br>";
$employe->where('employe_id=1')->save($data);
echo $employe->getLastSql();
两次getLastSql:
SELECT * FROM `hqft_employe` WHERE `employe_id` = 1 LIMIT 1
UPDATE `hqft_employe` SET `password`='222222',`Permission`='1' WHERE ( employe_id=1 )
最佳答案