public function checkpwd($name)
{
if (validate('phone', $name)) {
$sql = 'SELECT uid,name, email, phone, pwd FROM user WHERE phone = \'' . $name . '\'';
} elseif (validate('email', $name)) {
$sql = 'SELECT uid,name, email, pwd , phone FROM user WHERE email = \'' . $name . '\'';
} elseif (validate('username', $name)) {
$sql = 'SELECT uid,name, email, phone, pwd FROM user WHERE name = \'' . $name . '\'';
} else {
app::usrerror(0, '用户名或密码错误', ['loginname' => $name]);
}
$sql_result = app::mysqli('user#user')->query('single', $sql);
return $sql_result;
}
private function sqltest()
{
$sql = 'SELECT SQL_NO_CACHE uid,name, email, pwd FROM user WHERE name =?';
$name = 'def';
$sql_result = app::mysqli('user#user')->pquery('single', $sql, 's', [$name]);
var_dump($sql_result);
$sql = 'insert into user (email,name,pwd,phone) values (\'a@qq.com\',\'zhangsan\',\'abcefadfafa\',\'12323232323\')';
$name = '*****@*****.**';
$sql_result = app::mysqli()->query('insert', $sql);
var_dump($sql_result);
/*
$sql = 'SELECT uid,name, email, pwd FROM user WHERE name =:name';
$driver_options[\PDO::ATTR_ERRMODE] = \PDO::ERRMODE_SILENT;
$driver_options[\PDO::MYSQL_ATTR_USE_BUFFERED_QUERY] = false;
$driver_options[\PDO::ATTR_EMULATE_PREPARES] = false;
$dbh = new \PDO('mysql:dbname=qi_user;host=127.0.0.1','root','adolf',$driver_options);
$sth = $dbh->prepare($sql);
$sth->bindParam(':name', $name, \PDO::PARAM_STR);
$name ='yb';
$sth->execute();
$red = $sth->fetchAll();
var_dump($red);
$name ='yb2';
$sth->execute();
sleep(10);
$yellow = $sth->fetchAll();
var_dump($yellow);
*/
}
public function adduserbyphone($phone, $pwd)
{
$pwd = password_hash($pwd, PASSWORD_BCRYPT, ['cost' => 10]);
$sql = 'insert into user (`phone`,`pwd`) values(? ,?)';
return app::mysqli('user#user')->query('insert', $sql, 'ss', [$phone, $pwd]);
}
