4hana Posted March 1, 2006 Share Posted March 1, 2006 HiI get the following error when i load my login page.Fatal error: Call to a member function query() on a non-object on line 35Below 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><?phpif (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. Quote Link to comment Share on other sites More sharing options...
shocker-z Posted March 1, 2006 Share Posted March 1, 2006 replace [code]$check = $db_object->query("SELECT username, password FROM student WHERE username = '".$_POST['username']."'");[/code]with[code]$check = $db_object->mysql_query("SELECT username, password FROM student WHERE username = '".$_POST['username']."'");[/code]I think your problem was u used query instead of mysql_query.. Quote Link to comment Share on other sites More sharing options...
4hana Posted March 1, 2006 Author Share Posted March 1, 2006 HiThanks 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 Quote Link to comment Share on other sites More sharing options...
shocker-z Posted March 1, 2006 Share Posted March 1, 2006 Are the mysql libarys installed on the machine? because it sounds like a possible problem with that.. can you create a page called phpinfo.php and just put this code in <?phpphp_info(); ?>and then look to see what it says in MySQL area.. if it's not there then that means MySQL is not installed properly Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.