Login script with user only pages
Posted: Sun May 29, 2011 3:42 am
LOGIN.PHP:
I have registered username and password for main.php.
MAIN.PHP:
Why does the message "Welcome" come up when i have not logged on?
Code: Select all
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password="root"; // Mysql password
$db_name="globalbattle"; // Database name
$tbl_name="usersystem"; // Table name
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$username=$_POST['username'];
$password=$_POST['password'];
$username = stripslashes($username);
$password = stripslashes($password);
$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);
$sql="SELECT * FROM $tbl_name WHERE username='$username' and password='$password'";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){
session_register("username");
session_register("password");
header("location:main.php");
}
else {
echo "Wrong Username or Password";
}
?>MAIN.PHP:
Code: Select all
<?
session_start();
if(!session_is_registered(username)){
echo "Welcome";
}
?>