Solved

Parse error unecpected T_STRING

Posted on 2008-10-20
5
330 Views
Last Modified: 2013-12-13
I am trying to create a members login page using php in dreamweaver. However, when I try to browse the login page in Internet explorer I get the followin error mesage.

Parse error: syntax error, unexpected T_STRING in C:\Inetpub\wwwroot\strictly-invite.co.uk\strictlyinvite files\html\website\login.php on line 18

I have a attached a snippet of my code including line 18. Can somebody please help as I have been stuck for exactly a week trying to figure out the problem!!
<?php
$dbhost = "localhost";
$dbname = "user";
$dbuser = "user";
$dbpass = "pass";
 
mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($user) or die(mysql_error());
 
session_start();
 
$username = $_POST[username];
$password = md5($_POST[password]);
 
$query = SELECT * FROM user where username= $'username' and password= $'password';
 
$result = mysql_query($query);
 
if (mysql_num_rows($result) != 1) {
$error = Bad Login;
    include login.html;
 
} else {
    $_SESSION[username] = $username;
    include welcome.php;
}
 
?>

Open in new window

0
Comment
Question by:rafique12
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 17

Expert Comment

by:HuyBD
ID: 22756021
change the line
$query = "SELECT * FROM user where username= '$username' and password= '$password'";

Open in new window

0
 
LVL 7

Expert Comment

by:mattaob
ID: 22756046
also be *VERY* careful allowing $_POST, $_GET or anyother untiltered code directly into a mysql statement - it's asking for sql injection trouble
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 22756062
$query = SELECT * FROM user where username= $'username' and password= $'password';

needs to be:

$query = "SELECT * FROM user where username= $'username' and password= $'password'";
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22756063
sorry, too slow...
0
 

Author Closing Comment

by:rafique12
ID: 31507754
Thankyou so much friend I had been stuck for a whole week and almost accepted defeat!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Many old projects have bad code, but the budget doesn't exist to rewrite the codebase. You can update this code to be safer by introducing contemporary input validation, sanitation, and safer database queries.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question