????3.findBy<????>????
??????Phalcon????????findBy<????>?????????????????У???????????????findFirstByUsername??????????????????????
????$customer = Customer::findFirstByUsername('kirineko');
????4.????????????
??????????????????????????????SQL?????????????????????ò??????????????????????????????в???username=(@?????????)????password=(@?????????)???????????????ò??????????
??????????????????????????????????????????????????????н??в??????????????????????????????????????????
public function loginAction()
{
$username = $this->request->getPost('username');
$password = $this->request->getPost('password');
$conditons = 'username = :username: and password = :password:';
$parameters = [
'username' => $username??
'password' => $password??
];
$ret = Customer::findFirst(
[
$conditons??
'bind' => $parameters??
]);
if($ret){
print_r('login success');
} else {
print_r('login failed');
}
}
????4.3 ????????
???????????????????????????????????鵽???????????и???????save???ɡ????????????????kirineko???????????????????????????:
public function updateAction()
{
$password = $this->request->getPost('password');
$newpassword = $this->request->getPost('newpassword');
$conditons = 'username = :username: and password = :password:';
$parameters = [
'username' => 'kirineko'??
'password' => $password??
];
$customer = Customer::findFirst([
$conditons??
'bind' => $parameters??
]);
if($customer){
$customer->password = $newpassword;
$customer->save();
print_r('???3??');
} else {
print_r('???????????????????');
}
}
????4.4 ???????
????Phalcon??????delete?????????????????????????liyi???????????????:
public function deleteAction()
{
$customer = Customer::findFirstByUsername('liyi');
if($customer){
$res = $customer->delete();
if($res) {
print_r('??????');
} else {
print_r('??????');
}
} else {
print_r('?????????');
}
}