T_CONSTANT_ENCAPSED_STRING

[NLT]

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\xampp\htdocs\hk\config.php on line 22

 

Code:

<?php

// require the hotels config file
require "../config.php";

// start the sessions
session_start();

// check if the user is signed in
if(!isset($_SESSION['username']))
{
Header("Location: ../index.php?error=signedout");
}
elseif(!isset($_SESSION['account']))
{
Header("Location: ../index.php?error=signedout");
}
// process all the queries in here

// do the user related ones
$assoc = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE username = '".$_SESSION['username']."'"));
$username = $assoc'['username']';
$ranknum = $assoc['rank'];

// parse the rank
$parseRank = mysql_fetch_assoc(mysql_query("SELECT * FROM ranks WHERE id = '{$ranknum}'
$rank = $parseRank['name'];

// get server status
$sStatus = mysql_fetch_assoc(mysql_query("SELECT * FROM server_status"));
$usersonline = $sStatus['users_online'];
$roomsloaded = $sStatus['rooms_loaded'];
$status = $sStatus['status'];

echo $assoc['rank']; exit();
if($assoc['rank'] < 6)
{
header("Location: ../index.php");
}


?>

 

On line 22;

$username = $assoc'['username']';

[wildteen88]

Your quotes are the wrong way round

$username = $assoc['username'];

 

Also this line will return an error too because you have left off ")); at the end of it

$parseRank = mysql_fetch_assoc(mysql_query("SELECT * FROM ranks WHERE id = '{$ranknum}'

 

[NLT]

Thank you for your quick reply!

I'm a  beginner, so I might come here and ask a lot.

 

Now, I got this;

Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\hk\config.php on line 30

$sStatus = mysql_fetch_assoc(mysql_query("SELECT * FROM server_status"));

 

// get server status
$sStatus = mysql_fetch_assoc(mysql_query("SELECT * FROM server_status"));
$usersonline = $sStatus['users_online'];
$roomsloaded = $sStatus['rooms_loaded'];
$status = $sStatus['status'];

[wildteen88]

Also this line will return an error too because you have left off ")); at the end of it

$parseRank = mysql_fetch_assoc(mysql_query("SELECT * FROM ranks WHERE id = '{$ranknum}'

 

[NLT]

// parse the rank
$parseRank = mysql_fetch_assoc(mysql_query("SELECT * FROM ranks WHERE id = '{$ranknum}'"))
$rank = $parseRank[name];

 

 

Parse error: syntax error, unexpected T_VARIABLE in C:\xampp\htdocs\hk\config.php on line 27

 

As soon as this config is done, I should be able to get on with it. Sorry about this.

[wildteen88]

You have left off the semi-colon at the end of the line.

[NLT]

Ahh, just noticed. Now, I did that, and I get more errors, great.

 

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\hk\config.php on line 21

 

Notice: Use of undefined constant username - assumed 'username' in C:\xampp\htdocs\hk\config.php on line 22

 

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\hk\config.php on line 26

 

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\hk\config.php on line 30

[fugix]

i would break it down into a few more lines than you are using. e.g

$assoc = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE username = '".$_SESSION['username']."'"));
$username = $assoc'['username']';
$ranknum = $assoc['rank'];

change to

$query = mysql_query("SELECT * FROM users WHERE username = '".$_SESSION['username']."'");
$assoc = mysql_fetch_assoc($query);
$username = $assoc['username'];
$ranknum = $assoc['rank'];

also, the mysql_fetch_assoc() errors you are receiving is because your queries are not correct. The undefined constant error is most likely due to your query failing

[NLT]

<?php
$host = "localhost";
$username = "root";
$password = "";
$dbname = "phoenix3";

$currentstyle = "Default";
$sitemail = 'yourmail@yourmail.tld';

$twitter = ""; //Twitter account

$language = 'en';
?>

[Pikachu2000]

Undefined constant warnings are caused by undefined constants.

[fugix]

Undefined constant warnings are caused by undefined constants.

however a constant isn't called in his script therefore the parser must be confused by his syntax.. since hes trying to call out username from his query but his query is failing

[Pikachu2000]

Syntax doesn't "confuse" the parser. There's an undefined constant being used in the code. The revised code needs to be posted, from the beginning to a point at least a few lines past the last indicated error/warning.

[mikosiko]

// do the user related ones

$assoc = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE username = '".$_SESSION['username']."'"));

$username = $assoc'['username']';

$ranknum = $assoc['rank'];

the undefined constant.... 

[fugix]

// do the user related ones

$assoc = mysql_fetch_assoc(mysql_query("SELECT * FROM users WHERE username = '".$_SESSION['username']."'"));

$username = $assoc'['username']';

$ranknum = $assoc['rank'];

the undefined constant....

yep, i know where the constant is where the error is triggered..and ive provided an explanation...first step is to fix the query..which im guessing isnt working because $_SESSION['username'] is not set..

[Pikachu2000]

The query's success or failure has nothing to do with that error at all.

[mikosiko]

that is not what you said before

"however a constant isn't called in his script therefore the parser must be confused by his syntax"

[fugix]

The query's success or failure has nothing to do with that error at all.

okay

[fugix]

The query's success or failure has nothing to do with that error at all.

its trying to fetch a row that doesnt exist since the query is failing

[Pikachu2000]

For the last time, the query's success or failure has nothing to do with the error. Mikosiko already pointed out the cause of the error, and it is not related to the query in any way.

[fugix]

And you'll se e that I corrected that error on one of my first posts

[Pikachu2000]

And the new error is unrelated to the query as well.

[fugix]

You are right about the second error. Honestly didn't even see that he posted another error. My appologies to you pikachu