Follow along with the video below to see how to install our site as a web app on your home screen.
Бележка: This feature may not be available in some browsers.
mysql_query("UPDATE таблицата SET vlizaniq=vlizaniq+1 WHERE username='$username'")or die(mysql_error());
ALTER TABLE таблицата ADD `vlizaniq` INT(10) NOT NULL DEFAULT '0';
<?php
echo '<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />';
if($_POST['username'] AND $_POST['password'])
{
$username = $_POST['username'];
$password = $_POST['password'];
}
else if (isset($_COOKIE['login']))
{
$var = explode("|", $_COOKIE['login']);
$username = $var[0];
$password = $var[1];
}
else
{
$username = null;
$password = null;
}
if(preg_match('/^([a-z0-9_-]{4,16})/i',$username) AND preg_match('/^([a-z0-9_-]{4,16})/i',$password) )
{
$sql = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password' LIMIT 0,1");
if($row = mysql_fetch_array($sql))
{
$_SESSION['username'] = $row['username'];
$_SESSION['password'] = $row['password'];
$_SESSION['site'] = $row['site'];
$_SESSION['skype'] = $row['skype'];
$_SESSION['userid'] = $row['id'];
if($_POST['check'])
{
setcookie("login",$username."|".$password,time()+24*60*60*200);
}
}
else
{
if($_POST)
{
$error = "Грешno потребителско име";
}
else
{
setcookie('login', '', time() - 24*60*60*200);
}
}
}
if($_SESSION)
{
$users = $_SESSION['username'];
$sql="SELECT * FROM messages WHERE `to`='$users' AND `mode2`='3'";
$query=mysql_query($sql);
$a1=mysql_num_rows($query);
$sql="SELECT * FROM messages WHERE `to`='$users' AND `mode2`='2'";
$query=mysql_query($sql);
$u=mysql_num_rows($query);
$a=$a1+$u;
if ($u > 0){
echo "<table border='0' cellspacing='0' cellpadding='10' bgcolor='red'>
<tr>
Вие имате <b>$u</b></font> ново
<a href='../messages/?messages&mode=inbox'> съобщение!</a>
</td>
</tr>
</table>";}
echo ' <a href="../'.$_SESSION['username'].' "style="text-decoration: none;" ">
<font color="grey"> <span style="cursor:default">'.$_SESSION['username'].' </span></a>
<font color="000000"> [<a href="../messages/" "style="text-decoration: none;" >Лични съобщения</a>]</font>
<font color="000000"> [<a href="../edit/" "style="text-decoration: none;" >Профил</a>]</font>
<font color="000000">[<a href="?logout=v" "style="text-decoration: none;" ><font color="cc0000">Изход</font></a>]</font>';
}
else
{
echo '<form action="" method="POST">
<input type="text" name="username"><br />
<input type="password" name="password"><br/>
<input type="checkbox" name="check"> <font size="2"> Запомни ме </font>
<input type="submit" value="Вход">
</form>';
echo '<div><a href="../register/" "style="text-decoration: none;">Регистрация</a></div>';
echo '<div><a href="../forget/" "style="text-decoration: none;">Забравена парола</a></div>';
}
if ( $_GET['logout'] == "v" AND ( (int) $_SESSION['userid']) > 0)
{
session_unregister("username");
session_unregister("password");
session_unregister("site");
session_unregister("userid");
session_destroy();
if ( isset($_COOKIE['login']) )
{
setcookie('login','',time()-24*60*60*200);
}
header("Location: ".$_SERVER['PHP_SELF']);
}
?>
J01nt каза:ето го кода ако можеш да го направиш както трябва да е ;X
<?php
echo '<meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />';
if($_POST['username'] AND $_POST['password'])
{
$username = $_POST['username'];
$password = $_POST['password'];
}
else if (isset($_COOKIE['login']))
{
$var = explode("|", $_COOKIE['login']);
$username = $var[0];
$password = $var[1];
}
else
{
$username = null;
$password = null;
}
if(preg_match('/^([a-z0-9_-]{4,16})/i',$username) AND preg_match('/^([a-z0-9_-]{4,16})/i',$password) )
{
$sql = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$password' LIMIT 0,1");
if($row = mysql_fetch_array($sql))
{
$_SESSION['username'] = $row['username'];
$_SESSION['password'] = $row['password'];
$_SESSION['site'] = $row['site'];
$_SESSION['skype'] = $row['skype'];
$_SESSION['userid'] = $row['id'];
mysql_query("UPDATE таблицата SET vlqzyl=vlqzyl+1 WHERE username='$username'")or die(mysql_error());
if($_POST['check'])
{
setcookie("login",$username."|".$password,time()+24*60*60*200);
}
}
else
{
if($_POST)
{
$error = "Грешno потребителско име";
}
else
{
setcookie('login', '', time() - 24*60*60*200);
}
}
}
if($_SESSION)
{
$users = $_SESSION['username'];
$sql="SELECT * FROM messages WHERE `to`='$users' AND `mode2`='3'";
$query=mysql_query($sql);
$a1=mysql_num_rows($query);
$sql="SELECT * FROM messages WHERE `to`='$users' AND `mode2`='2'";
$query=mysql_query($sql);
$u=mysql_num_rows($query);
$a=$a1+$u;
if ($u > 0){
echo "<table border='0' cellspacing='0' cellpadding='10' bgcolor='red'>
<tr>
Вие имате <b>$u</b></font> ново
<a href='../messages/?messages&mode=inbox'> съобщение!</a>
</td>
</tr>
</table>";}
echo ' <a href="../'.$_SESSION['username'].' "style="text-decoration: none;" ">
<font color="grey"> <span style="cursor:default">'.$_SESSION['username'].' </span></a>
<font color="000000"> [<a href="../messages/" "style="text-decoration: none;" >Лични съобщения</a>]</font>
<font color="000000"> [<a href="../edit/" "style="text-decoration: none;" >Профил</a>]</font>
<font color="000000">[<a href="?logout=v" "style="text-decoration: none;" ><font color="cc0000">Изход</font></a>]</font>';
}
else
{
echo '<form action="" method="POST">
<input type="text" name="username"><br />
<input type="password" name="password"><br/>
<input type="checkbox" name="check"> <font size="2"> Запомни ме </font>
<input type="submit" value="Вход">
</form>';
echo '<div><a href="../register/" "style="text-decoration: none;">Регистрация</a></div>';
echo '<div><a href="../forget/" "style="text-decoration: none;">Забравена парола</a></div>';
}
if ( $_GET['logout'] == "v" AND ( (int) $_SESSION['userid']) > 0)
{
session_unregister("username");
session_unregister("password");
session_unregister("site");
session_unregister("userid");
session_destroy();
if ( isset($_COOKIE['login']) )
{
setcookie('login','',time()-24*60*60*200);
}
header("Location: ".$_SERVER['PHP_SELF']);
}
?>
Replace, ти даде абсолютно цялото решение.От теб се иска само да paste-неш кода, и да добавиш един ред в база-данниJ01nt каза:еми даде пак същото .. брой и да решлешна хиляда пъти аз искамда брой логванията логвам се записва 1 излизам и ако се логна отново тогава да запише още 1 в бд ..