Solved

Parse error unecpected T_STRING

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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

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 …
Creating and Managing Databases with phpMyAdmin in cPanel.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

839 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