Sorry. Im new in php, below is my login page, login function, welcome message and homepage. Thanks.
LOGIN FUNCTION
[PHP]<?php
extract ($_POST);
mysql_connect(" localhost","roo t","")
or die("Cannot connect to the server");
mysql_select_db ("dreamzdesign" )
or die("Cannot connect to the database");
$sql="select username from membership where username='$user name'";
$result=mysql_q uery($sql)
or die("Cannot execute query1");
$num=mysql_num_ rows($result);
if($num==1) //email valid
{
$sql="select username from membership where username='$user name' and password='$pass word'";
$result2=mysql_ query($sql)
or die("Cannot execute query");
$num2=mysql_num _rows($result2) ;
if($num2>0)
{
setcookie("User name", $username, time() + 60 * 60 * 24 * 5);
include("homepa ge.php");
}
else //message send to login.php when wrong password
{
$message="The username, $username exists, but you have not entered the correct password! Please try again.<br>";
include("login. php");
}
}
elseif($num==0) //message send to login.php when email not valid
{
$message="The username you entered does not exist! Please try again.<br>";
include("login. php");
}
?>[/PHP]
LOGIN PAGE
[HTML]<html>
<head>
<title>DreamZDe sign</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
background-color: #232122;
}
body,td,th {
color: #FFFFFF;
}
a:link {
color: #FFFFFF;
}
a:visited {
color: #FFFFFF;
}
a:hover {
color: #CCCCCC;
}
a:active {
color: #CCCCCC;
}
-->
</style></head>
<body>
<p><img src="image/top%20banner.jp g" width="955" height="200">
</p>
<p align="center">[PHP]<?php echo $message;?>[/PHP]You MUST login before can use our services. If you don't have username please register <a href="register. php">here.</a> </p>
<form action='do_logi n.php' method='post'>
<p align="center"> Name : &nb sp;
<input type='text' name='username' size='24' maxlength='24'>
</p>
<p align="center"> Password :
<input type='password' name='password' size='24' maxlength='24'>
</p>
<p></p>
<p>
<center>
<input type='submit' name='submit' value='login' />
</center>
</form>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p><img src="image/bottom%20banner .jpg" width="955" height="46"></p>
</body>
</html>[/HTML]
WELCOME MESSAGE
[HTML]<html>
<head>
<title>Welcom e <? echo $username; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
[PHP]<?php
foreach ($_COOKIE as $key => $value)
?>[/PHP]
<h1 align="center"> <? echo $value; ?>, welcome to DreamZDesign !</h1>
</body>
</html>[/HTML]
HOMEPAGE
[PHP]<?php
foreach ($_COOKIE as $key => $value)
?>
[/PHP]
[HTML]<html>
<head>
<title>DreamZDe sign</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
background-color: #232122;
}
body,td,th {
color: #FFFFFF;
}
a:link {
color: #FFFFFF;
}
a:visited {
color: #FFFFFF;
}
a:hover {
color: #CCCCCC;
}
a:active {
color: #CCCCCC;
}
-->
</style></head>
<body>
<p><img src="image/top%20banner.jp g" width="955" height="200"><a href="homepage. php"><img src="button/home.jpg" width="90" height="24" border="0"></a><a href="design.ph p"><img src="button/design%20zone.j pg" width="103" height="24" border="0"></a><a href="gallery.p hp"><img src="button/gallery.jpg" width="102" height="24" border="0"></a><a href="cart.php" ><img src="button/cart.jpg" width="68" height="24" border="0"></a><a href="forum.php "><img src="button/forum.jpg" width="51" height="24" border="0"></a><a href="faq.php"> <img src="button/faq.jpg" width="79" height="24" border="0"></a> <a href="aboutUs.p hp"><img src="button/about%20us.jpg" width="86" height="24" border="0"></a><a href="contactUS .php"><img src="button/contact%20us.jp g" width="121" height="24" border="0"></a>
</p><p align="center">
</p>
<h1 align="center">[PHP]<? echo $value; ?>[/PHP], welcome to DreamZDesign !</h1>
<p><img src="image/main%20page.jpg " width="890" height="540"></p>
<p><img src="image/bottom%20banner .jpg" width="955" height="46"></p>
</body>
</html>[/HTML]
127
