|
|
|
เมื่อ Login เข้ามาแล้วอยากเก็บ ID ผู้ที่ Login เข้ามา ไปเก็บอีกตารางต้องทำไงครับ |
|
|
|
|
|
|
|
Code (PHP)
function insert($field,$value,$table){
$sql = "insert into $table ($field) values ($value)";
$result= mysql_query($sql);
return $result;
}
function select($table,$condition){
$sql = "select * from $table $condition";
$dbquery = mysql_query($sql);
$result= mysql_fetch_array($dbquery);
return $result;
}
function num_rows($table,$condition){
$sql = "select * from $table $condition";
$dbquery = mysql_query($sql);
$num_rows = mysql_num_rows($dbquery);
return $num_rows;
}
$num_rows=num_rows("user","where user_name='$user' and user_pass='$pass' and user_status=1");
$login=select("user","where user_name='$user' and user_pass='$pass' and user_status=1 ");
if($num_rows==1 && $login['userg_id']==1) {
$_SESSION["regist"]=1;
$_SESSION["sess_name"]=$login['user_name']; //maker
$_SESSION["sess_id"]=$login['person_id'];
$_SESSION["sess_code"]=$login['person_code'];
$person_id=$login['person_id'];
$login_date=Date("Y-m-d H:i:s");
$ip=@$REMOTE_ADDR;
$bh="เข้าสู่ระบบ";
insert("login_id,person_id,login_datetime,ipaddress,login_behavior", "'','$person_id','$login_date','$ip','$bh'","login");
header("location:admin/?page=home"); //ไปไปตามหน้าที่คุณต้องการ
}
|
|
|
|
|
Date :
2012-06-26 21:51:04 |
By :
Manussawin |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 05
|