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> 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); 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'"; 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. Link to comment https://forums.phpfreaks.com/topic/197331-parse-error/#findComment-1035811 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.