zzz
-
Posts
1 -
Joined
-
Last visited
Never
We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.
PHP User Login System Problem...!!
in Editor Help (PhpStorm, VS Code, etc)
Posted
im running win98 /PHP4.0.5 / MYsqlWIN32
i am trying to setup a login system for my project at school...
my Table structure for table `registrationform`
i have 4 related php.files here to do with the login system -memberlogin.php / login.php / connect_db.php / and common_lib.php
1)login.php
[PHP] <?php $str = "<font class=\"success\"> Member Area</font>"; if($login == "error") { $str = "<font face=verdana color=red><b>LOGIN ERROR!: </font><font color=black>Wrong Username Or Password</b></font>"; } elseif($login == "blocked") { $str = "<font face=verdana color=red><b>YOUR ACCESS HAS BEEN BLOCKED!</b></font>"; } elseif($login == "session") { $str = "<font face=verdana color=red><b>SESSION ERROR!: <font color=black>User Already Connected. Please Logout First</font></b></font></center>"; } elseif($login == "") { } elseif($login == "logout") { $str = "<font class=\"success\">User <font color=blue>$User_Login</font> Logged Out</font>"; } else { $str = "<font face=verdana color=red><b>LOGIN ERROR!: </font><font color=black>Wrong Username Or Password</b></font>"; } include("connect_db.php"); include("common_lib.php"); ?> <html> <head> <title>Login Page</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link href="mainstyle.css" rel="stylesheet" type="text/css"> <script> function focus_login() { document.login_form.User_Login.focus(); } </script> </head> <body bgcolor="#FFFFFF" onLoad="focus_login();"> <br><br><font class="maintitle"><center>Welcome to WebMedic HealthNet</center></font><br> <center> <table width="40%" border="0" cellspacing="0" cellpadding="0"> <tr><td colspan="center" border=0 bordercolor="#FFFFFF" align="left"><?php echo " $str "; ?></td></tr> </table> </center> <center> <table width="40%" border="0" cellspacing="0" cellpadding="0" style="border: #003366; border-style: solid; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; font-size: 10pt;"> <tr> <td colspan=2 class="title" valign="center"> WebMedic HealthNet Member Login</td> </tr> <form name="login_form" method="post" action="memberlogin.php"> <tr> <td colspan=2 class=content> </td> </tr> <tr> <td width="35%" align=right class=details> User Name: </td> <td class=content width="65%"> <input class="textbox" type="text" name="User_Login"> </td> </tr> <tr> <td colspan=2 class=content> </td> </tr> <tr> <td width="35%" align=right class=details> Password: </td> <td class=content width="65%"> <input class="textbox" type="password" name="User_Password"> </td> </tr> <tr> <td colspan=2 class=content> </td> </tr> <tr class="content"> <td colspan=2 align="center"> <input class="button" name="signin" type="submit" value="Sign In"> <input class="button" name="close" type="submit" value="Close" onClick="window.close();"> </td> </tr> <tr class="content"><td align=left><font class="success">New User? <a href="memreg.php">Sign Up</a></font></td> <td align=right><font class="success"> </font></td> </tr> <tr class="content"> <td height="12" colspan=2> <center> </center> </td> </tr> </form> </table> </center> </body> </html> <?php if($status == "usersuccess") { echo "<script>alert('You successfully signed up!</script>"; } ?> [/PHP]2)memberlogin.php
[php] <?php session_start(); //connect to the DB include ("connect_db.php"); include ("common_lib.php"); //set up the query $User_Login = $Member_ID; $User_Password= md5($Member_Pass); $query = "SELECT * FROM registrationform WHERE User_Login='".$Member_ID."' AND User_Password='".$Member_Pass."'"; //run the query and get the number of affected rows $result = mysql_query($query, $connection) or die('error making query'); $myrow = mysql_fetch_array($result); $affected_rows = mysql_num_rows($result); if($affected_rows <> 0) { $_SESSION['Session_Member_ID'] = $User_Login; //register user in session $_SESSION['Session_Member_Pass'] = $myrow["User_Password"]; } else { $relative_url = "login.php?login=error"; redirect($relative_url); } ?> [/php]3)common_lib.php
[php] <?php function redirect($url) { $relative_url = $url; header("Location: http://".$_SERVER['HTTP_HOST'] .dirname($_SERVER['PHP_SELF']) ."/".$relative_url); exit; } function display_time_date() { //get login time/date $today = getdate(); $month = $today['month']; $day = $today['mday']; $year = $today['year']; $hours = $today['hours']; $minutes = $today['minutes']; $seconds = $today['seconds']; if($seconds < 10) { $seconds = "0".$seconds; } if($minutes < 10) { $minutes = "0".$minutes; } $txt = "AM "; if($hours >= 12) { $hours = $hours - 12; $txt = "PM "; } if($hours < 10) { $hours = "0".$hours; } $Member_ID = strtolower($_SESSION['Session_Member_ID']); $query = "SELECT * FROM registrationform WHERE Member_ID = '$Member_ID'"; $result = mysql_query($query) or die('error making query'); $myrow = mysql_fetch_array($result); $Member_Name = $myrow[Member_Name]; echo "<font class=\"success\">Member logged in : ".$Member_Name; echo " | "; echo "Connected on $day $month, $year at $hours:$minutes:$seconds $txt </font>"; } function Format_Date($unformatted_date) { $year = substr($unformatted_date,0,4); $month = substr($unformatted_date,5,-3); $day = substr($unformatted_date,8,9); $formatted_date = $day ."/" . $month ."/" . $year; return $formatted_date; } ?> [/php]4)connect_db.php
[php] <?php $connection = mysql_connect("localhost", "z", "z") or die(mysql_error()); mysql_select_db("registration", $connection) or die(mysql_error()); ?> [/php]when i run http://localhost/login.php the login page is ok, but when i try to login(no matter with correct username/password or incorrect usernae/password) the error message "error making query" appear..it there a problem in my codes?connection to databse problems??or...??i'm so screw up with it ..i don't know what to do to fix it!!please help me..anyone:((???Thanks in advanced..