Ban công inox đẹp mẫu 1 - Lan can Ban công inox
$curenttime = gmdate("M-d-Y-H:i:s", time());
$ok_acc =0;
if(isset($_SESSION['acc']))
$ok_acc = Make_field_values('id',"tblaccess",$db," where id=".$_SESSION['acc']);
if(!isset($_SESSION['acc']) || $ok_acc<=0)
{ //Create session name
$sql_information_insert = "INSERT INTO `tblaccess` (`name`,`date`)
VALUES('" . insertData($curenttime)."',NOW())";
$db->sql_query($sql_information_insert) or die(mysql_error());
//Khoi tao thong tin login
$_SESSION['login'] = $curenttime;
$sql_account = "SELECT `id` FROM `tblaccess` ORDER BY id DESC LIMIT 0,1";
$sql_account = $db->sql_query($sql_account) or die(mysql_error());
while($sql_account_rows = $db->sql_fetchrow($sql_account))
{
$_SESSION['acc'] = $sql_account_rows['id'];
}
}
$clear_id = "";
//Kiem tra neu session['acc'] qua 5 ngay ma khong online thi se bi xoa tai khoan
$sql_check = "Select id,(NOW()-date) as KKK from `tblaccess`";
$sql_check = $db->sql_query($sql_check) or die(mysql_error());
while($sql_check_rows = $db->sql_fetchrow($sql_check))
{
$time_in_use = ($sql_check_rows['KKK']/3600);
$time_in_use = (int)$time_in_use;
if($time_in_use>=240 && $sql_check_rows['id']<>$_SESSION['acc'])
{
$clear_id .= $sql_check_rows['id'].",";
}
}
//Xoa tat ca cac truy cap khong mua hang
if($clear_id<>"")
{
$clear_id = "(".$clear_id."0)";
//Xoa cac san pham da them vao
$sql_delete = "delete from `tbladds` WHERE user in".$clear_id;
$db->sql_query($sql_delete) or die(mysql_error());
//Xoa cac quyen truy câp do
$sql_delete = "DELETE FROM `tblaccess` WHERE `id` in".$clear_id;
$db->sql_query($sql_delete) or die(mysql_error());
}
?>