|
<?php
namespace app\model;
class User extends MySqlite
{
protected $tablename = 'sys_user';
protected $pk = 'id';
protected $schema = [
"id" => "INTEGER",
"username" => "TEXT",
"password" => "TEXT",
"create_time" => "INTEGER",
];
public function __construct()
{
parent::__construct();
}
public function getInfoByUsername($username)
{
$sql = "select * from " . $this->tablename . " where username='" . $username . "' limit 1";
$data = $this->getOne($sql);
return $data;
}
public function getInfoById($userid)
{
$sql = "select * from " . $this->tablename . " where id='" . $userid . "' limit 1";
$data = $this->getOne($sql);
return $data;
}
}
|