【php开源代码栏目提醒】:网学会员在php开源代码频道为大家收集整理了aa_do_user.php提供大家参考,希望对大家有所帮助!
<?php
//瀵煎叆鍏叡鍑芥暟闆嗗悎
require_once "common.php";
class aa_do_user {
/*******************************************************
鍑芥暟鍚嶏細 selectUserByUserID
鍔熻兘锛?鏍规嵁鐢ㄦ埛ID/妫绱㈢敤鎴?
鍙傛暟锛?鏁版嵁搴撹繛鎺?鐢ㄦ埛ID
杩斿洖鍊硷細 sql鎵ц缁撴灉
********************************************************/
public function selectUserByUserID($par_conn,$par_user_id) {
try{
//鍖归厤鐢ㄦ埛ID
$sql = "select * ";
$sql = $sql . "from t_user ";
$sql = $sql . "where user_id = '" . $par_user_id . "' ";
//鎵цsql璇彞
$result = $par_conn->query($sql);
//杩斿洖
return $result;
}catch(Exception $e){
return G_NULL;
}
}
/*******************************************************
鍑芥暟鍚嶏細 selectUserByPKey
鍔熻兘锛?鏍规嵁鐢ㄦ埛ID/瀵嗙爜妫绱㈢敤鎴?
鍙傛暟锛?鏁版嵁搴撹繛鎺?鐢ㄦ埛ID 瀵嗙爜
杩斿洖鍊硷細 sql鎵ц缁撴灉
********************************************************/
public function selectUserByPKey($par_conn,$par_user_id,$par_password) {
try{
//鍖归厤鐢ㄦ埛ID銆佸瘑鐮?
$sql = "select * ";
$sql = $sql . "from t_user ";
$sql = $sql . "where user_id = '" . $par_user_id . "' ";
$sql = $sql . "and password = '" . $par_pass
word . "' ";
error_log($sql);
//鎵цsql璇彞
$result = $par_conn->query($sql);
//杩斿洖
return $result;
}catch(Exception $e){
return G_NULL;
}
}
/*******************************************************
鍑芥暟鍚嶏細 selectUserByLastLoginTime
鍔熻兘锛?鏍规嵁鐢ㄦ埛ID/鏈鍚庣櫥褰曟椂闂存绱㈢敤鎴?
鍙傛暟锛?鏁版嵁搴撹繛鎺?鐢ㄦ埛ID 鏈鍚庣櫥褰曟椂闂?
杩斿洖鍊硷細 sql鎵ц缁撴灉
********************************************************/
public function selectUserByLastLoginTime($par_conn,$par_user_id,$par_login_time) {
try{
//鍖归厤鐢ㄦ埛ID銆佸瘑鐮?
$sql = "select * ";
$sql = $sql . "from t_user ";
$sql = $
sql . "where user_id = '" . $par_user_id . "' ";
$sql = $sql . "and last_login_time = '" . $par_login_time . "' ";
//鎵цsql璇彞
$result = $par_conn->query($sql);
//杩斿洖
return $result;
}catch(Exception $e){
return G_NULL;
}
}
/*******************************************************
鍑芥暟鍚嶏細 updateUserByUserID
鍔熻兘锛?鏍规嵁鐢ㄦ埛ID鏇存柊鏈鍚庣櫥褰曟椂闂?
鍙傛暟锛?鏁版嵁搴撹繛鎺?鐢ㄦ埛ID 鏈鍚庣櫥褰曟椂闂?
杩斿洖鍊硷細 sql鎵ц缁撴灉
********************************************************/
public function updateLastLoginTimeByUserID($par_conn,$par_user_id,$par_login_time) {
try{
//鏇存柊user琛ㄤ腑鐨勭櫥褰曟椂闂?
$sql = "update t_user ";
$sql = $sql . "set last_login_time = '" . $par_login_time ."' ";
$sql = $sql . "where user_id = '" . $par_user_id ."'";
//鎵цsql璇彞锛屽鏋滆鏇存柊鐨勭邯褰曟槸涓浠讹紝璇存槑鏇存柊鎴愬姛
$result = $par_conn->query($sql);
//杩斿洖
return $result;
}catch(Exception $e){
return G_NULL;
}
}
/*******************************************************
鍑芥暟鍚嶏細 insertUser
鍔熻兘锛?鏍规嵁鐢ㄦ埛ID鏇存柊鏈鍚庣櫥褰曟椂闂?
鍙傛暟锛?鏁版嵁搴撹繛鎺?鐢ㄦ埛鏁版嵁缁撴瀯浣?
杩斿洖鍊硷細 sql鎵ц缁撴灉
********************************************************/
public function insertUser($par_conn,$par_object) {
try{
//杞崲鏁版嵁缁撴瀯浣?
$aa_eo_user = (object)$par_object;
//鎻掑叆涓鏉¤褰曡嚦user琛ㄤ腑
$sql = "insert into t_user ";
$sql = $sql . "(user_id,password,last_login_time) values('";
$sql = $sql . $aa_eo_user->user_id ."','";
$sql = $sql . $aa_eo_user->password ."','";
$sql = $sql . $aa_eo_user->last_login_time ."')";
//鎵цsql璇彞锛屽鏋滆鏇存柊鐨勭邯褰曟槸涓浠讹紝璇存槑鏇存柊鎴愬姛
$result = $par_conn->query($sql);
//杩斿洖
return $result;
}catch(Exception $e){
return G_NULL;
}
}
}
?>