Имам следната логин системата:
Искам ако потребителя има level 3 да му изведе някакъв текст. Редът ми се казва level, а колоната users
Код:
<?php
session_start();
include 'includes/config.php';
$username = trim(addslashes(htmlspecialchars($_POST['username'])));
$password = trim(addslashes(htmlspecialchars($_POST['password'])));
if($_SERVER['REQUEST_METHOD'] != "POST")
{
header('Location: index.php');
}
else
{
if(isset($username) && isset($password))
{
$newPass = md5("asd".$password."13");
$q = mysql_query("SELECT username, password FROM users WHERE username='$username' AND password='$newPass' LIMIT 1") or die(mysql_error());
if(mysql_num_rows($q) == 1)
{
$user = mysql_fetch_assoc($q);
$_SESSION['username'] = $user['username'];
$username = $_SESSION['username'];
$select = mysql_query("SELECT * FROM users WHERE username='$username'");
header('Location: index.php');
}
else
{
header('Location: index.php');
$_SESSION['error'] = "Грешно име или парола!";
}
}
}
?>