[RESOLVED] PHP Welcome

Arnora

Hi All

My last question was with regards to SESSIONS and COOKIES. I've got this working nicely now no longer will people be able to view this information without following the login script lovely.

But no I want to add a little more personality to my pages with a small Welcome script.

I've managed to write most of the required script, to find the database and select the correct information. However I am having trouble with my echo statement.

Below is my script if someone could please look it over and help me I would appreciate it.

<?php 
session_start();
if (@$_SESSION['auth'] !="yes")
{
	header("location:(hidden for protection)");
	exit();
}
	include("(this is the file which connects to the database)");
	$cxn = mysqli_connect($hostname, $username, $password, $database)
	            or die ("Could not connect to server");
	$sql = "SELECT FirstName,LastName FROM (hidden for protection)
               WHERE Username='{$_SESSION['logname']}'";
  	$result = mysqli_query($cxn,$sql)
                               or die("Could not execute query");
  	$row = mysqli_fetch_assoc($result);

?>

include html here

<?php echo "Welcome $FirstName $LastName" ?>

include html here

So am I missing something (been staring at this for hours now, tunnel vision setting in) last time I missed a SINGLE character "_" from the session script and it drove me mad for days. Is it that easy now? Re-reading "PHP for Dummies" is not helping me either, just takes up more time 😛 .

Thank you all again
Arnora

Krik

First just wanted to mention the php bb tags help us see the code better. There are several icons just above where you enter you questions or replies, three of them are for code (#), HTML (<>) and php (PHP). They help us a lot to more quickly answer your question.

Now to your question.

The problem is how you reference your SQL results

<?php echo "Welcome $FirstName $LastName" ?>

should be

<?php echo "Welcome $row['FirstName'] $row['LastName']" ?>

I have to add one last comment. While you can use mysqli for procedural access to a database, at least for myself, it is very odd as mysqli was primarily designed for object oriented database access. I have to wonder where you learned to do it that way. I can't imagine any tutorial or book would have you use mysqli that way.

Arnora

Ok been playing with this so far I have

<?php 
session_start();
if (@$_SESSION['auth'] !="yes")
{
	header("location:index.php");
	exit();
}
	include("db.inc");

$connection = mysql_connect($hostname,$username,$password)
					or die ("Could not connect to server");
$db = mysql_select_db($database,$connection)
				or die ("Could not connect to database");
$sql = "SELECT FirstName,LastName FROM Distributors
           WHERE Username ='{$_SESSION['logname']}'";
$result = mysql_query($sql)
        or die("Couldn't execute query for result");
if(mysql_num_rows($result)>0)   //there are results returned 
{
 $row = mysql_fetch_array($result); 
 extract($row); 
 }
?>

notice this time I give up hiding names 😛

with a section of HTML code here I have the echo request

<?php echo " Welcome $FirstName $LastName "; ?>

which gives me the error

Notice: Undefined variable: FirstName in E:\domains\w\blah blah blah\current.php on line 34

being the echo line.

now as above the file db.inc includes my server connections, host, password and such. I already know these are correct as the index page requires a login to get to this page current.php.

I've checked and triple checked the spellings for the table and column selections and yet (as far as I can tell) I am getting zero results from my table.

I have added 2 different rows in this table for testing purposes and can use the same select query from phpmyadmin to receive results (obviously without the session) does this mean then that my session is recording the wrong info?

Help me please this is driving me insane 😛

Arnora

Krik;10962142 wrote:
First just wanted to mention the php bb tags help us see the code better. There are several icons just above where you enter you questions or replies, three of them are for code (#), HTML (<>) and php (PHP). They help us a lot to more quickly answer your question.

Now to your question.

The problem is how you reference your SQL results
<?php echo "Welcome $FirstName $LastName" ?>
should be
<?php echo "Welcome $row['FirstName'] $row['LastName']" ?>
I have to add one last comment. While you can use mysqli for procedural access to a database, at least for myself, it is very odd as mysqli was primarily designed for object oriented database access. I have to wonder where you learned to do it that way. I can't imagine any tutorial or book would have you use mysqli that way.

😛 Thanks for the code hints I'll be sure to use them correctly in the future as you see my above post was in writing when you replied.

As for the mysqli I've removed the "i" from this I pulled the script from a tutorial and noticed the "i" after the fact.

Thanks again for the reply I'm testing it now
Arnora

Arnora

Ok tested this and the result was

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in E:\domains\w\blah blah blah\current.php on line 34

Line 34 being the echo line

Arnora

Thanks all I did it myself again