4hana
-
Posts
2 -
Joined
-
Last visited
Never
4hana's Achievements
Newbie (1/5)
0
Reputation
-
Hi Thanks for your help, i replaced the code but i still get the same error. Fatal error: Call to a member function mysql_query() on a non-object in on line 37
-
Hi I get the following error when i load my login page. Fatal error: Call to a member function query() on a non-object on line 35 Below is the code: <?php // database connect script. require 'dbconnect.php'; if($logged_in == 1) { die('You are already logged in, '.$_SESSION['username'].'.'); } ?> <html> <head> <title>Login</title> </head> <body> <?php if (isset($_POST['submit'])) { // if form has been submitted /* check they filled in what they were supposed to and authenticate */ if(!$_POST['username'] | !$_POST['s_password']) { die('You did not fill in a required field.'); } // authenticate. if (!get_magic_quotes_gpc()) { $_POST['username'] = addslashes($_POST['username']); } $check = $db_object->query("SELECT username, password FROM student WHERE username = '".$_POST['username']."'"); if (DB::isError($check)) { die('That username does not exist in our database.'); } $info = $check->fetchRow(); // check passwords match $_POST['s_password'] = stripslashes($_POST['s_password']); $info['password'] = stripslashes($info['password']); $_POST['s_password'] = md5($_POST['s_password']); if ($_POST['s_password'] != $info['password']) { die('Incorrect password, please try again.'); } // if we get here username and password are correct, //register session variables and set last login time. $_POST['uname'] = stripslashes($_POST['uname']); $_SESSION['username'] = $_POST['username']; $_SESSION['password'] = $_POST['s_password']; $db_object->disconnect(); ?> <h1>Logged in</h1> <p>Welcome back <?php echo $_SESSION['username']; ?>, you are logged in.</p> <A HREF="http://igor.gold.ac.uk/~mas01lo/introduction.php"><center><h3>Relations</ h3></center></A> <center><h3>Please Click relations to access the database relations index.</center></h3> <br><hr> <?php } else { // if form hasnt been submitted ?> <h1>Login</h1> <form action="<?php echo $_SERVER['PHP_SELF']?>" method="post"> <table align="center" border="1" cellspacing="0" cellpadding="3"> <tr><td>Username:</td><td> <input type="text" name="username" maxlength="40"> </td></tr> <tr><td>Password:</td><td> <input type="password" name="s_password" maxlength="50"> </td></tr> <tr><td colspan="2" align="right"> <input type="submit" name="submit" value="Login"> </td></tr> </table> </form> <?php } ?> </body> </html> Any help would be much appreciated.