Solved

Parse error unecpected T_STRING

Posted on 2008-10-20
5
327 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
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 142

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 142

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Things That Drive Us Nuts Have you noticed the use of the reCaptcha feature at EE and other web sites?  It wants you to read and retype something that looks like this.Insanity!  It's not EE's fault - that's just the way reCaptcha works.  But it is …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to count occurrences of each item in an array.

809 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