Бисквитки

kikity_94

Registered
Може ли да ми помогнете да си направя запомни ме в сайта ми :D
Ако може и да вградите кода за бисквитки тук ще съм ви много благодарен тъй като с бисквитки не мога да работя

Код:
<div id="login_panel">
	<?php
		if($_POST['login']) {
			$username = trim(htmlspecialchars(addslashes($_POST['username'])));
			$password = md5(trim(htmlspecialchars(addslashes($_POST['password']))));
				$sql = "SELECT * FROM users WHERE username='$username'";
				$result = mysql_query($sql) or die (mysql_error());
				$broi = mysql_num_rows($result);
				$row = mysql_fetch_assoc($result);
					if($broi == 0) {
						echo "<div class='Err_Not_Logged' style='margin: 0 auto; width: 260px;'>Грешно потребителско име или парола!</div>";
					} 
					else {
						if ($password == $row['password']) {
							$_SESSION['username'] = $row[username];	
							echo "<meta http-equiv=\"refresh\" content=\"0\">";	
						}	
					}
			}	
			if($_SESSION['username']) {
				$our = mysql_query("SELECT * FROM users WHERE username = '$username'");				
				while ($row = mysql_fetch_assoc($our)) {
				$sql = "SELECT * FROM pmessages WHERE unread='unread' AND touser='$username'";
				$query = mysql_query($sql);
				$broi = mysql_num_rows($query); 
					echo "<table width='300' border='0'>
							<tr>
								<td width='70'><img src='images/avatars/$row[avatar]' width='70' height='70'/></td>

								<td width='230'>
									<table align='center' width='215'>
										<tr><td colspan='4' align='center'>Здравей <a href='profile.php?user_id=$row[user_id]'><font color='red'><b>".$_SESSION['username']."</b></font></a></span></td></tr>
										<tr>
											<td width='17'><img src='images/icon01.jpg' /></td><td><a href='profile.php?user_id=$row[user_id]'>Профил</a></td>
											<td width='17'><img src='images/icon_editprofil.png' /></td><td><a href='editprofile.php'>Настройки</a></td>
										</tr>
										<tr>
											<td width='17'><img src='images/icon_addtut.png' /></td><td><a href='addtutorial.php'>Качи урок</a></td>
											<td width='17'><img src='images/icon_pm.png' /></td><td><a href='messages.php'>Съобщения (<font color='red'>".$broi."</font>)</a></td>
										</tr>		
										<tr>
											<td width='17'><img src='images/icon_logout.png' /></td><td><a href='logout.php'>Изход</a></td>";
											$Levels = mysql_query("SELECT username, user_level FROM users WHERE username = '$username'") or die (mysql_error());
											while ($level = mysql_fetch_assoc($Levels)) {
												if ($level['user_level'] == 3 || $level['user_level'] == 2) {
													echo "<td width='17'><img src='images/icon_admin.png'/></td><td><a href='admin/'>Админ панел</a></td>";
												}
											}
											echo "
										</tr>
									</table>
								</td>
							</tr>
						</table>";
				}		
			}
			else
			{				
	?>		
		<table border="0" width="300">
			<form method="post" action="<?php $_SERVER['PHP_SELF'] ?>">
				<tr>
					<td><input type="text" name="username" size="17" class="user" /></td>
					<td><input type="password" name="password" size="17" class="pass"/></td>
				</tr>
				<tr>
					<td></td>
					<td align="center"><input type="submit" name="login" value="Вход" class="lgb"/></td>
				</tr>
				<tr>
					<td align="center"><a href="register.php">Регистрация</a></td>
					<td align="center"><a href="">Забравена парола</a></td>
				</tr>
			</form>
		</table>
	<?php
			}	
	?>			
</div>
 
Пробвай така:

Код:
<div id="login_panel">
   <?php
      if($_POST['login']) {
         $username = trim(htmlspecialchars(addslashes($_POST['username'])));
         $password = md5(trim(htmlspecialchars(addslashes($_POST['password']))));
            $sql = "SELECT * FROM users WHERE username='$username'";
            $result = mysql_query($sql) or die (mysql_error());
            $broi = mysql_num_rows($result);
            $row = mysql_fetch_assoc($result);
               if($broi == 0) {
                  echo "<div class='Err_Not_Logged' style='margin: 0 auto; width: 260px;'>Грешно потребителско име или парола!</div>";
               }
               else {
                  if ($password == $row['password']) {
                     $_SESSION['username'] = $row[username]; 
					 setcookie('logged', '', time()+3600*720);
                     echo "<meta http-equiv=\"refresh\" content=\"0\">";   
                  }   
               }
         }   
         if(isset($_SESSION['username']) or isset($_COOKIE['logged'])) {
            $our = mysql_query("SELECT * FROM users WHERE username = '$username'");            
            while ($row = mysql_fetch_assoc($our)) {
            $sql = "SELECT * FROM pmessages WHERE unread='unread' AND touser='$username'";
            $query = mysql_query($sql);
            $broi = mysql_num_rows($query);
               echo "<table width='300' border='0'>
                     <tr>
                        <td width='70'><img src='images/avatars/$row[avatar]' width='70' height='70'/></td>

                        <td width='230'>
                           <table align='center' width='215'>
                              <tr><td colspan='4' align='center'>Здравей <a href='profile.php?user_id=$row[user_id]'><font color='red'><b>".$_SESSION['username']."</b></font></a></span></td></tr>
                              <tr>
                                 <td width='17'><img src='images/icon01.jpg' /></td><td><a href='profile.php?user_id=$row[user_id]'>Профил</a></td>
                                 <td width='17'><img src='images/icon_editprofil.png' /></td><td><a href='editprofile.php'>Настройки</a></td>
                              </tr>
                              <tr>
                                 <td width='17'><img src='images/icon_addtut.png' /></td><td><a href='addtutorial.php'>Качи урок</a></td>
                                 <td width='17'><img src='images/icon_pm.png' /></td><td><a href='messages.php'>Съобщения (<font color='red'>".$broi."</font>)</a></td>
                              </tr>      
                              <tr>
                                 <td width='17'><img src='images/icon_logout.png' /></td><td><a href='logout.php'>Изход</a></td>";
                                 $Levels = mysql_query("SELECT username, user_level FROM users WHERE username = '$username'") or die (mysql_error());
                                 while ($level = mysql_fetch_assoc($Levels)) {
                                    if ($level['user_level'] == 3 || $level['user_level'] == 2) {
                                       echo "<td width='17'><img src='images/icon_admin.png'/></td><td><a href='admin/'>Админ панел</a></td>";
                                    }
                                 }
                                 echo "
                              </tr>
                           </table>
                        </td>
                     </tr>
                  </table>";
            }      
         }
         else
         {            
   ?>      
      <table border="0" width="300">
         <form method="post" action="<?php $_SERVER['PHP_SELF'] ?>">
            <tr>
               <td><input type="text" name="username" size="17" class="user" /></td>
               <td><input type="password" name="password" size="17" class="pass"/></td>
            </tr>
            <tr>
               <td></td>
               <td align="center"><input type="submit" name="login" value="Вход" class="lgb"/></td>
            </tr>
            <tr>
               <td align="center"><a href="register.php">Регистрация</a></td>
               <td align="center"><a href="">Забравена парола</a></td>
            </tr>
         </form>
      </table>
   <?php
         }   
   ?>         
</div>
 
нещо не се получава или азне правя нещо както трябва.
Самия чекбокс как трябва да изглежда аз го правя така

Код:
<input type="checkbox" name="logged" />
 
Така ?

Код:
<div id="login_panel">
   <?php
      if($_POST['login']) {
         $username = trim(htmlspecialchars(addslashes($_POST['username'])));
         $password = md5(trim(htmlspecialchars(addslashes($_POST['password']))));
            $sql = "SELECT * FROM users WHERE username='$username'";
            $result = mysql_query($sql) or die (mysql_error());
            $broi = mysql_num_rows($result);
            $row = mysql_fetch_assoc($result);
               if($broi == 0) {
                  echo "<div class='Err_Not_Logged' style='margin: 0 auto; width: 260px;'>Грешно потребителско име или парола!</div>";
               }
               else {
                  if ($password == $row['password']) {
                     $_SESSION['username'] = $row[username]; 
					 if ($_POST['logged'] == 1)
					 {
						setcookie('logged', '', time()+3600*720);
					 }
					 else
					 {
					 }
					 
                     echo "<meta http-equiv=\"refresh\" content=\"0\">";   
                  }   
               }
         }   
         if($_SESSION['username']) {
            $our = mysql_query("SELECT * FROM users WHERE username = '$username'");            
            while ($row = mysql_fetch_assoc($our)) {
            $sql = "SELECT * FROM pmessages WHERE unread='unread' AND touser='$username'";
            $query = mysql_query($sql);
            $broi = mysql_num_rows($query);
               echo "<table width='300' border='0'>
                     <tr>
                        <td width='70'><img src='images/avatars/$row[avatar]' width='70' height='70'/></td>

                        <td width='230'>
                           <table align='center' width='215'>
                              <tr><td colspan='4' align='center'>Здравей <a href='profile.php?user_id=$row[user_id]'><font color='red'><b>".$_SESSION['username']."</b></font></a></span></td></tr>
                              <tr>
                                 <td width='17'><img src='images/icon01.jpg' /></td><td><a href='profile.php?user_id=$row[user_id]'>Профил</a></td>
                                 <td width='17'><img src='images/icon_editprofil.png' /></td><td><a href='editprofile.php'>Настройки</a></td>
                              </tr>
                              <tr>
                                 <td width='17'><img src='images/icon_addtut.png' /></td><td><a href='addtutorial.php'>Качи урок</a></td>
                                 <td width='17'><img src='images/icon_pm.png' /></td><td><a href='messages.php'>Съобщения (<font color='red'>".$broi."</font>)</a></td>
                              </tr>      
                              <tr>
                                 <td width='17'><img src='images/icon_logout.png' /></td><td><a href='logout.php'>Изход</a></td>";
                                 $Levels = mysql_query("SELECT username, user_level FROM users WHERE username = '$username'") or die (mysql_error());
                                 while ($level = mysql_fetch_assoc($Levels)) {
                                    if ($level['user_level'] == 3 || $level['user_level'] == 2) {
                                       echo "<td width='17'><img src='images/icon_admin.png'/></td><td><a href='admin/'>Админ панел</a></td>";
                                    }
                                 }
                                 echo "
                              </tr>
                           </table>
                        </td>
                     </tr>
                  </table>";
            }      
         }
         else
         {            
   ?>      
      <table border="0" width="300">
         <form method="post" action="<?php $_SERVER['PHP_SELF'] ?>">
            <tr>
               <td><input type="text" name="username" size="17" class="user" /></td>
               <td><input type="password" name="password" size="17" class="pass"/></td>
			   <td>Запомни ме: <input type="checkbox" name="logged" value="1"/></td>
            </tr>
            <tr>
               <td></td>
               <td align="center"><input type="submit" name="login" value="Вход" class="lgb"/></td>
            </tr>
            <tr>
               <td align="center"><a href="register.php">Регистрация</a></td>
               <td align="center"><a href="">Забравена парола</a></td>
            </tr>
         </form>
      </table>
   <?php
         }   
   ?>         
</div>
 
слагам кода както си го написал влизам си в акаунта излизам от браузъра и пак влизам и пак ми дава да се логна :(
 
Код:
<div id="login_panel">
   <?php
      if($_POST['login']) {
         $username = trim(htmlspecialchars(addslashes($_POST['username'])));
         $password = md5(trim(htmlspecialchars(addslashes($_POST['password']))));
            $sql = "SELECT * FROM users WHERE username='$username'";
            $result = mysql_query($sql) or die (mysql_error());
            $broi = mysql_num_rows($result);
            $row = mysql_fetch_assoc($result);
               if($broi == 0) {
                  echo "<div class='Err_Not_Logged' style='margin: 0 auto; width: 260px;'>Грешно потребителско име или парола!</div>";
               }
               else {
                  if ($password == $row['password']) {
                    if ($_POST['logged'] == 1)
                    {
                      setcookie('logged', $row[username], time()+3600*720);
                    }
                    else
                    {
                      $_SESSION['username'] = $row[username];
                    }

                     echo "<meta http-equiv=\"refresh\" content=\"0\">";
                  }
               }
         }
         if($_SESSION['username'] || $_COOKIE['logged']) {
            if ($_SESSION['username']) $uname=$_SESSION['username']; else $uname=$_COOKIE['logged'];
            $our = mysql_query("SELECT * FROM users WHERE username = '$uname'");
            while ($row = mysql_fetch_assoc($our)) {
            $sql = "SELECT * FROM pmessages WHERE unread='unread' AND touser='$uname'";
            $query = mysql_query($sql);
            $broi = mysql_num_rows($query);
               echo "<table width='300' border='0'>
                     <tr>
                        <td width='70'><img src='images/avatars/$row[avatar]' width='70' height='70'/></td>

                        <td width='230'>
                           <table align='center' width='215'>
                              <tr><td colspan='4' align='center'>Здравей <a href='profile.php?user_id=$row[user_id]'><font color='red'><b>".$_SESSION['username']."</b></font></a></span></td></tr>
                              <tr>
                                 <td width='17'><img src='images/icon01.jpg' /></td><td><a href='profile.php?user_id=$row[user_id]'>Профил</a></td>
                                 <td width='17'><img src='images/icon_editprofil.png' /></td><td><a href='editprofile.php'>Настройки</a></td>
                              </tr>
                              <tr>
                                 <td width='17'><img src='images/icon_addtut.png' /></td><td><a href='addtutorial.php'>Качи урок</a></td>
                                 <td width='17'><img src='images/icon_pm.png' /></td><td><a href='messages.php'>Съобщения (<font color='red'>".$broi."</font>)</a></td>
                              </tr>
                              <tr>
                                 <td width='17'><img src='images/icon_logout.png' /></td><td><a href='logout.php'>Изход</a></td>";
                                 $Levels = mysql_query("SELECT username, user_level FROM users WHERE username = '$username'") or die (mysql_error());
                                 while ($level = mysql_fetch_assoc($Levels)) {
                                    if ($level['user_level'] == 3 || $level['user_level'] == 2) {
                                       echo "<td width='17'><img src='images/icon_admin.png'/></td><td><a href='admin/'>Админ панел</a></td>";
                                    }
                                 }
                                 echo "
                              </tr>
                           </table>
                        </td>
                     </tr>
                  </table>";
            }
         }
         else
         {
   ?>
      <table border="0" width="300">
         <form method="post" action="<?php $_SERVER['PHP_SELF'] ?>">
            <tr>
               <td><input type="text" name="username" size="17" class="user" /></td>
               <td><input type="password" name="password" size="17" class="pass"/></td>
            <td>Запомни ме: <input type="checkbox" name="logged" value="1"/></td>
            </tr>
            <tr>
               <td></td>
               <td align="center"><input type="submit" name="login" value="Вход" class="lgb"/></td>
            </tr>
            <tr>
               <td align="center"><a href="register.php">Регистрация</a></td>
               <td align="center"><a href="">Забравена парола</a></td>
            </tr>
         </form>
      </table>
   <?php
         }
   ?>
</div>
 
trevata благодаря ти много стана но преди да съм ти дал точката ще кажеш ли как се унищожава сесията.Смисъл кат цъкна Изход да ми излиза от профила защото сега неще :D

Сега файла за изход представлява това
Код:
<?php
	session_start();
	session_destroy();
	header("Location: index.php");
?>

Също така ще може ли малко пояснения за това time()+3600*720 на колко време е равно това или да ми дадете линк от кадето да ги прочета
 
Код:
time()+3600*720
Това ти е равно на сегашното време в секунди от 1/1/1970 0:00:00 + 3600 секунди по 720, демек 720 часа. Това ти е равно на 30 дена. Най-точно казано, бисквитката ще изтече след 30 дни.

Код:
<?php 
session_start();
   if ($_SESSION['username']){ 
     session_destroy(); 
   }else{
     setcookie("logged", '', time() - 60 * 60);
   }
   header("Location: index.php"); 
?>
 

Back
Горе