Parse error: syntax error, unexpected T_STRING on line 26 [closed]
Hello im having an issue with my code:
<?php
s开发者_StackOverflowession_start();
$host="localhost";
$username="root";
$password="power1";
$db_name="members";
$tbl_name="users";
$link = mysql_connect($host, $username, $password)or die("cannot connect. Please contact us");
mysql_select_db($db_name)or die("cannot select DB. Please contact us");
$queryString = $_SERVER['QUERY_STRING'];
$uemail = $_SESSION['$queryString'];
$query = "SELECT * FROM users WHERE email='$uemail'";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
if ($queryString == $row[activationkey]){
echo "Congratulations! You have succesfully activated you account. You may now login.";
$sql=("UPDATE users SET activationkey='' AND status='activated' WHERE username=".$row['username']);
if (!mysql_query($sql))
{
die('Error: ' . mysql_error());
}
}
}
?>
What do you think the issue is? Thanks
You are not closing a quote here:
$query = "SELECT * FROM users WHERE email=$uemail;
Replace it with:
$query = "SELECT * FROM users WHERE email='$uemail'";
$query = "SELECT * FROM users WHERE email=$uemail;
There is a double quote missing
$query = "SELECT * FROM users WHERE email='$uemail'";
Remember to escape all your parameters used in your sql statements!
You forgot to terminate this line with a quote
$query = "SELECT * FROM users WHERE email=$uemail;
$query = "SELECT * FROM users WHERE email='".$uemail."'";
$sql = ("UPDATE users SET activationkey='' AND status='activated' WHERE username='".$row['username']."'");
Remember to put single '
or double "
quotes at start and end of the val where datatype is varchar
精彩评论