How to pull a User Variable from the database and display it in html/php

Question

In my database I've created a table called accounts. The accounts table contains: id, username, password, points.

This is the code I'm running to pull and display the Points variable.

$user = $_SESSION['sess_user'];
$sql = mysql_query("SELECT points FROM accounts WHERE username='".$user."'");
$points = $sql;

Then a bit further down I use this in html.

<p>Welkom, <?=$_SESSION['sess_user'];?>! Dit is jouw Managerpaneel. Je hebt momenteel <?=$points?> Managerpunten.</p>

Now, it does show the session Username, but it doesn't display anything for points :( it just completely skips it.

Any ideas?

Zoe - Save the data dump · Accepted Answer · 2019-05-25 13:53:42Z

1

You are not actually fetching your results. mysql_query() returns a resource ID. You need to pass this to a function like mysql_fetch_assoc() to get your actual results.

$sql = mysql_query("SELECT points FROM accounts WHERE username='".$user."'");
$row = mysql_fetch_assoc($sql);
$points = $row['points'];

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO, or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.

edited May 25, 2019 at 13:53

Zoe - Save the data dump

28.4k22 gold badges130 silver badges163 bronze badges

answered Apr 16, 2014 at 17:26

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3542248 Over a year ago

Right now I'm getting this. Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\member.php on line 6

John Conde Over a year ago

It looks correct. Try using mysql_error() to see what mysql says.

user3400389 · Accepted Answer · 2014-04-16 17:30:17Z

0

you are missing this:

$row = mysql_fetch_array($sql);
$points = $row['points'];

for more info: mysqlfetcharray

answered Apr 16, 2014 at 17:30

user3400389

3671 gold badge6 silver badges21 bronze badges

Collectives™ on Stack Overflow

How to pull a User Variable from the database and display it in html/php

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related