if (isset($_POST['login_submit'])){
$user_login = mysql_query("SELECT * FROM users WHERE username='".$_POST['username']."' AND password='".$_POST['password']."'");
if (mysql_num_rows($user_login)==1){
$user_info = mysql_fetch_array($user_login);
$today_info = date("Y-m-d H:i:s");
$ip = $_SERVER['REMOTE_ADDR'];
mysql_query("UPDATE users SET last_login='".$today_info."' WHERE username='".$_POST['username']."'");
mysql_query("UPDATE users SET active_status='Online' WHERE username='".$_POST['username']."'");
mysql_query("UPDATE users SET ip='".$ip."' WHERE username='".$_POST['username']."'");
setcookie('music','Active',time()+365*86400);
setcookie('music_username',$user_info['username'],time()+365*86400);
setcookie('music_id',$user_info['id'],time()+365*86400);
echo "<script>document.location.href='index.php'</script>";
}
Всичко е точно но неиска да сетне кукиеса ......
$user_login = mysql_query("SELECT * FROM users WHERE username='".$_POST['username']."' AND password='".$_POST['password']."'");
if (mysql_num_rows($user_login)==1){
$user_info = mysql_fetch_array($user_login);
$today_info = date("Y-m-d H:i:s");
$ip = $_SERVER['REMOTE_ADDR'];
mysql_query("UPDATE users SET last_login='".$today_info."' WHERE username='".$_POST['username']."'");
mysql_query("UPDATE users SET active_status='Online' WHERE username='".$_POST['username']."'");
mysql_query("UPDATE users SET ip='".$ip."' WHERE username='".$_POST['username']."'");
setcookie('music','Active',time()+365*86400);
setcookie('music_username',$user_info['username'],time()+365*86400);
setcookie('music_id',$user_info['id'],time()+365*86400);
echo "<script>document.location.href='index.php'</script>";
}
Всичко е точно но неиска да сетне кукиеса ......