php mysql login

questions · #1 25-Sep-2006, 18:34

how do i check the username and password that on the database? Currently, i only have one static username and password. How can do if aaa username password is matach on database it will bring the user to "ab.php" page, if ccc usernane and password is ddd is match from database go to "cd.php page" i know i can use switch case but i have hundred of different used base on their accesslevel.

PHP Code:


$_SESSION['logged'] = '';
    $_SESSION['user'] = '';

    $user = isset($_POST['user'])? $_POST['user'] : '';
    $pass = isset($_POST['pass'])? $_POST['pass'] : '';
    
    
    $sql = "select * from tableuser where username='$user' AND passowrd ='$pass'";
    
    
    /* authenticating user - one account system*/
    if (($user == 'test') and ($pass == 'password')) {
        $_SESSION['logged'] = 1;
        $_SESSION['user'] = 1; //put user-id, if you have any
        header('location:welcome.php');
    } else {
        if (!empty($user) and !empty($pass)) {
            $errorMsg= 'Invalid username/password';
        }
    }
?>

<form name="form1" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">

USERNAME: <input type="text" name="user" value="" />
PASSWORD: <input type="password" name="pass" value="" />

input type="button" value="Login" onclick="return frmLogin();"/>
<div id="erro_msg">
<?php echo isset($login_msg)? $login_msg : ''; ?></div>

</form>[/php]

HelloMoto · #2 22-Oct-2006, 19:00

The password and username are usually in the site itself. Just go look for a file named sql.php or mysql.php and the information is in the file.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cpanel downgrade MYSQL 4.1.X to MySQL 4.0.xx	Webhosting-live	Web Hosting Forum	1	01-Sep-2006 03:54
php and mysql	vladimy	MySQL / PHP Forum	2	28-May-2005 06:17
PHP, MySQL, WML	skyloon	MySQL / PHP Forum	0	05-Mar-2004 08:53
[script] Password Protect web pages/site using PHP and MySQL	JdS	PHP Code Library	0	23-Jul-2003 11:02
Windows: From only £20p/y,Linux: from $10p/m. ASP, ASP.NET, PHP, Free MySQL, +More	EyotaHosts	Web Hosting Advertisements & Offers	0	28-Jun-2003 14:54

php mysql login

Re: php mysql login