therring Posted April 2, 2010 Share Posted April 2, 2010 if you scroll down you will see the comment i add to show line 29. Parse error: syntax error, unexpected T_STRING in /home/therring/public_html/login.php on line 29 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <?php //Database Information $dbhost = "localhost"; $dbname = "users"; $dbuser = "therring_argon"; $dbpass = "420test"; //Connect to database mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error()); mysql_select_db($dbname) or die(mysql_error()); session_start(); $username = $_POST[‘username’]; $password = md5($_POST[‘password’]); //line 29 is below $result = mysql_query(“SELECT * FROM user WHERE username=’$username’ and password=’$password’”); if (mysql_num_rows($result) != 1) { $error = “Bad Login”; include “login.html”; } else { $_SESSION[‘username’] = “$username”; include “memberspage.php”; } ?> </body> </html> Quote Link to comment https://forums.phpfreaks.com/topic/197331-parse-error/ Share on other sites More sharing options...
harristweed Posted April 2, 2010 Share Posted April 2, 2010 mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error()); mysql_select_db($dbname) or die(mysql_error()); should be $link_id = mysql_connect("$dbhost","$dbuser","$dbpass")or die("Could not connect: ".mysql_error()); mysql_select_db("$dbname", $link_id) or die(mysql_error()); then: $sql=“SELECT * FROM user WHERE username=’$username’ and password=’$password’ ”; $result=mysql_query($sql, $link_id); Quote Link to comment https://forums.phpfreaks.com/topic/197331-parse-error/#findComment-1035775 Share on other sites More sharing options...
cags Posted April 2, 2010 Share Posted April 2, 2010 @harristweed You don't need to pass a link identifier into the mysql_ functions, if non is passed PHP assumes you wish to use the link identifier created by the last call to mysql_connect. @therring I believe looking at your code the problem is the 'fancy' quotes that are used. Try using proper/standard single and double quote chars. $sql="SELECT * FROM user WHERE username='$username' and password='$password'"; Quote Link to comment https://forums.phpfreaks.com/topic/197331-parse-error/#findComment-1035807 Share on other sites More sharing options...
harristweed Posted April 2, 2010 Share Posted April 2, 2010 Hi Cags I know that it is not strictly required to pass an identifier but I have had problems with it in the past when not passing one and now always include it. Habit I guess. I think you could be right about the quotes. Quote Link to comment https://forums.phpfreaks.com/topic/197331-parse-error/#findComment-1035811 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.