mysql| procedure.
/******************************************************
File name:login.php3
Login Check
Code: PHP 4
Author: Kevin Lee < webwing@21cn.com >
Database:mysql.
Host:localhost Database:mydb
Table structure for table ' user '
--------------------------------------------------------
CREATE TABLE User (
ID smallint (6) not NULL auto_increment,
User varchar (a) not NULL,
passwd varchar (a) not NULL,
Name varchar (20),
Email varchar (30),
Level char (1),
Status char (1),
UNIQUE ID (ID)
);
--------------------------------------------------------
*******************************************************/
?>
<script language= "JavaScript" >
function back () {
History.back ();
}
function Winclose () {
SetTimeout ("Self.close ()", 10000);
}
</script>
?
$db _id = mysql_pconnect ("localhost", "root", "");
$sql = "SELECT id, User, passwd from user where user= '". $name. "' and passwd= '". $pwd. "'";
$result = Mysql_db_query ("MyDB", $sql);
$row = Mysql_fetch_array ($result);
$id = $row [id];
if ($id!= "") {
Session_Start ();
Session_register ("yn");
$yn = "Yes";
echo "echo "You have successfully landed ... "." <p> ";
echo "<center>". The window automatically closes after 10 seconds. </center> ";
echo "</body>
}
else {
echo "Account or password error!!! ";
echo "<P>";
echo "<center>";
echo "<a href=\" #\ "onclick=\" javascript:back () \ ">back</a>";
echo "</center>";
}
?>
