Dear all,
I’m developing an online reservation system, I’m facing problem to display username (after they were logged-in), here is my coding:
I’ve the following form, for user to input:
Username:
Password:
File: authuser.php
[code]<?php
include(‘info.config’);
//check for required fields
$myusername=$_POST[‘username’];
$mypassword=$_POST[‘password’];
if (!$myusername || !$mypassword) {
header(“Location: ./test2.html”);
exit;
}
//setup names of database and table to use
//$db_name = “sptt”;
$table_name = “pendaftaran”;
//connect to server and select database
$connection = mysql_connect("$host", “$user”, “$password”)
or die(mysql_error());
$db = mysql_select_db($database, $connection) or die(mysql_error());
//build and issue query
$sql = “SELECT * FROM $table_name WHERE
username = ‘$myusername’ AND
password = ‘$mypassword’”;
$result = mysql_query($sql) or die (mysql_error());
//get the number of rows in the result set
$num = mysql_numrows($result);
//print a message and set a cookie if authorized,
//or redirect elsewhere if unauthorized
if ($num != 0) {
$cookie_name = “auth”;
$cookie_value = “ok”;
$cookie_expire = “0”;
$cookie_domain = “127.0.0.1”;
$cookie_username = “$myusername”;
$cookie_password = “$mypassword”;
setcookie($cookie_name, $cookie_value, $cookie_expire,
“/” , $cookie_domain, 0);
setcookie($cookie_username, $cookie_password);
$display_block = "
<p><strong>Welcome $myusername:</strong></p>
<ul>
<li><a href="secretA.php">secret page A</a>
</ul>";
} else {
header(“Location: ./test2.html”);
exit;
}
?>
File: secretA.php
[code]<?php
if($_COOKIE[auth] == “ok”) {
$user="$cookie_username";
}else{
$user=“Guest”
}
?>
What I want is, after user logged-in, their name will display in page secretA.php. If they didn’t logged in, the message will be ‘Welcome Guest’. I think maybe is something wrong in secretA.php. Please help, urgently need your help. Thank you, regards.