Only echos id, username, and email address

Question

2.00/5 (1 vote)

See more:

In my code

PHP

<?php
 session_start(); 
mysql_connect("host","username","password");
mysql_select_db("database");

$id = $_GET['id'];
?>
<?php print htmlentities($_SESSION['dbUser']['id'], ENT_QUOTES, 'UTF-8'); ?><br>
<?php print htmlentities($_SESSION['dbUser']['username'], ENT_QUOTES, 'UTF-8'); ?><br>
<?php print htmlentities($_SESSION['dbUser']['fname'], ENT_QUOTES, 'UTF-8'); ?><br>
<?php print htmlentities($_SESSION['dbUser']['lname'], ENT_QUOTES, 'UTF-8'); ?><br>
<?php print htmlentities($_SESSION['dbUser']['email'], ENT_QUOTES, 'UTF-8'); ?><br>
<?php print htmlentities($_SESSION['dbUser']['rank'], ENT_QUOTES, 'UTF-8'); ?><br>
<?php print htmlentities($_SESSION['dbUser']['picture'], ENT_QUOTES, 'UTF-8'); ?><br>
<?php print htmlentities($_SESSION['dbUser']['dob_month'], ENT_QUOTES, 'UTF-8'); ?><br>
<?php print htmlentities($_SESSION['dbUser']['dob_day'], ENT_QUOTES, 'UTF-8'); ?><br>
<?php print htmlentities($_SESSION['dbUser']['dob_year'], ENT_QUOTES, 'UTF-8'); ?>

It only echos the id, the username, and the email address...How could i fix this?

Posted 24-Nov-13 2:53am

Member 10421693

Add a Solution

Comments

enhzflep 24-Nov-13 9:06am

Hard to say. Are you sure the other fields actually contain something?

What's the result of <?php var_dump($_SESSION['dbUser']);?>?

Member 10421693 24-Nov-13 9:13am

It said
array(3) { ["id"]=> string(1) "1" ["username"]=> string(5) "Admin" ["email"]=> string(18) "admin@example.com" } ?

enhzflep 24-Nov-13 9:26am

Okay then, that confirms my suspicion - the other fields don't exist.
I'd have a closer look at the part of your code that sets id, username and email - you've either forgotten to set the other values or the variables that you think hold the data, dont actually have anything in them. - I'm not actually sure what happens try to set an array e;lement with the contents of a variable that's undefined or null.

Member 10421693 24-Nov-13 9:34am

But the database is filled properly and has the fname and lname etc. filled

enhzflep 24-Nov-13 9:51am

I'm sure it does. But you still have to get the information from the database and put it into the $_SESSION variable at some point.

The code you've shown above doesn't perform this task - that happens somewhere else. So, as I suggested earlier - find the part of the code that does put the id,username & email values into the $_SESSION variable.

Member 10421693 24-Nov-13 10:09am

I'm sorry this is gonna sound silly but...what would that part of the code look like exactly?

enhzflep 24-Nov-13 10:30am

Nah, it's just something you've not covered yet - doesn't sound silly to me.

It's a bit hard to guess from here. It's the sort of thing that we can often do effortlessly, unconsciously - yet trying to describe the exact process (which is uncertain) can be exceedingly difficult.

I would probably do a search first-off for $_SESSION['dbUser'] - if that didn't help, I'd try it again with double-quotes around dbUser, i.e $_SESSION["dbUser"] - naturally, you could search for an assignment, by adding ['email'] = or ["email"] = ~~(without quotes)~~ to the search terms. This would prevent you from getting a search-hit on any of the code in your original post.

But, it's also possible that the value 'dbUser' isn't hard-coded. It may be held as a string inside a variable. In which case, I'd search for $_SESSION[$

So, the list of search terms I'd try would be in order:

$_SESSION['dbUser']
$_SESSION["dbUser"]

$_SESSION['dbUser']['email']
$_SESSION['dbUser']["email"]

$_SESSION['dbUser']['email']=
$_SESSION['dbUser']['email'] =
$_SESSION['dbUser']["email"]=
$_SESSION['dbUser']["email"] =

etc, etc.

Basically, I'd consider that
(a) if the array keys were hardcoded, that they could be wrapped in single ' quotes, or with doubles "
(b) the keys could be held in variables, so you'd get [$ or [ $ as a part of the term.
(c) that you're looking for an assignment, so you'd find ]= or ] =

As you can probably appreciate - you're looking for a basic pattern, though one that cold take a variatey of forms. Being familiar with the code or the style of the person that wrote it often helps. So too, can you get hints in the process of examining unsuccessful search results.

Damn this lateral thinking gig! :) :laugh: (its ever so hard to describe the thought process)

Member 10421693 24-Nov-13 10:49am

Oh God im getting so confused now :P i think i've found where the session is made but it says " $_SESSION['dbUser'] = $row; "
and the row thing is " $row = $stmt->fetch(); "

enhzflep 24-Nov-13 11:07am

:laugh: :chortle: :holds-belly:

I know the feeling - of finding just when you think you've got it, it's even further away again - I also remember the twists and turns, which make it easier next time. How do you reckon I had a clue where to look so far? (Hint: it certainly wasn't from getting it right, or books - bitter experience)

I'd vaguely considered an assignment like that too, though didn't want to muddy the water any more, if that's possible!

Since it's just a single assignment to the session variable, one that successfully copies over 3 of the fields, it sounds like the query may not be returning values for any of the other fields.

What I often find helpful, is to print the actual sql query that is about to be executed, before copying it into phpMyAdmin and running it manually. It gets a little more involved if your using mysqli or PDO extensions, but that's the basic process.

You could always do a var_dump of $row too - though it will only show the same as the original var_dump did, in this case.

I think it sounds most likley that the SQL query isn't returning anything other than the 3 fields you're getting. Pretty sure it would just fail if the query was 'bad', so I guess that the other fields are simply not being selected.

I Might have to grab another coffee and charge-up my crystal-ball batteries. ;P
Let me know how you go, caffeine is rarely unhelpful for me. :)

Member 10421693 24-Nov-13 11:28am

Aha thanks for the help i really appreciate it. Okay so...fname and lname is all working now (I put this in the login page -
$_SESSION['dbUser']['fname']=$fname;
$_SESSION['dbUser']['lname']=$lname;
$_SESSION['dbUser']['rank']=$rank;
)
But now rank isn't working...the dump session says :
array(6) { ["id"]=> string(1) "1" ["username"]=> string(5) "Admin" ["email"]=> string(18) "admin@example.com" ["fname"]=> string(5) "Mason" ["lname"]=> string(3) "Day" ["rank"]=> NULL }

enhzflep 24-Nov-13 11:57am

:reaches for glass-cleaner:
Great stuff! You're welcome. Since you're assigning something to ["rank"] you're getting something back - problem is that the 'something' you're assigning doesn't hold anything, you're getting NULL. Confused? :D

$rank seems not to have a value. Have a closer look at that variable and where (if) it it's value is set.

Member 10421693 24-Nov-13 12:34pm

YYYYESSS! It's working now! I was only selecting username, email, and id from the table -.- changed it to * and now it all works

enhzflep 24-Nov-13 12:41pm

Goooooooal!

Glad it worked out for ya. :)

CHill60 24-Nov-13 13:09pm

Well done ... you should post a summary of this (or even the comment stream) as a formal solution

enhzflep 24-Nov-13 13:25pm

Thanks Chilli.
The problem is solved, which was my only aim. Though, I understand that without something formal, the question will remain in the unanswered list. I'm a bit tired to put something coherent together just now. Can do so after I've slept.

I certainly wouldn't take offence if you chose to do so earlier.

Thanks for reminding me that questions answered in comments remain 'unanswered'. :thumbsup:

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

enhzflep · Answer 1 · 2013-11-24T20:07:00

The problem ended-up being solved via a discussion in the comments section, however in the interests of removing it from the unanswered questions list, I'll try to summarize the problems and the steps taken to mediate them.

As the question indicates, only a few of the requested fields of the $_SESSION variable were holding any data, as confirmed by the use of var_dump.

After looking for the place in the code that the assignment was made to the $_SESSION var, it was found that all of the available data was added in a single statement - one which assigned the row returned by an SQL query.

Upon yet closer inspection, it seemed that of the 10 expected values, only three of them were actually requested. That is to say, rather than a "SELECT * FROM _someTable_ WHERE _someCondition" type query, the actual query was more along the lines of "SELECT _field1_, _field2_, _field3_ FROM _someTable_ WHERE _someCondition_"

A reasonably easy fix in retrospect. Just remember kids - remote-debugging, M.U.D - style at 4am isn't a wise idea. It's probably also a good idea, when writing parts A & B, where B depends on A, to make sure A is doing what you think it is before moving onto step B.