Jump to content

Parse error


therring

Recommended Posts

 

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

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

@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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

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.