Solved

Parse error unecpected T_STRING

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Hacked File Timestamps 4 49
WordPress TK Title 8 24
RDBMS and No sql database 4 38
How can I upload multiple images from a HTML form? 2 18
Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Part of the Global Positioning System A geocode (https://developers.google.com/maps/documentation/geocoding/) is the major subset of a GPS coordinate (http://en.wikipedia.org/wiki/Global_Positioning_System), the other parts being the altitude and t…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

914 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now