PHP show records from mysql

Question

Im blocked at following part of code...

i have config.php page, with following code inside:

<?php
// Start the session (pretty important!)
session_start();

// Establish a link to the database
$dbLink = mysql_connect('localhost', 'USER', 'PASS');
if (!$dbLink) die('Can\'t establish a connection to the database: ' . mysql_error());

$dbSelected = mysql_select_db('DATABASE', $dbLink);
if (!$dbSelected) die ('We\'re connected, but can\'t use the table: ' . mysql_error());

$isUserLoggedIn = false;  
$query      = 'SELECT * FROM users WHERE session_id = "' . session_id() . '" LIMIT 1';  
$userResult     = mysql_query($query);  
if(mysql_num_rows($userResult) == 1){  
$_SESSION['user'] = mysql_fetch_assoc($userResult);  
$isUserLoggedIn = true;  
}else{  
if(basename($_SERVER['PHP_SELF']) != 'index.php'){  
    header('Location: index.php');  
    exit;  
}  
}  
?>

Now i have another page, with following code inside:

<?php include_once('config.php'); ?>

<?php foreach($_SESSION['user'] as $key => $value){ ?>
<li><?php echo $key; ?> <strong><?php echo $value; ?></strong></li>
<?php } ?>

That code show me all informations stored in database, one by one..

I want to show informations, individualy in my page, something like:

<?php echo $email; ?>

etcetera..

Can someone explain me how to do that?

Thank you

why not remove some boiler plate from the code above and try to debug the above with something like PHPStorm? Your question would amount to "how do I query a database from php" and google has plenty of those — dendini
– dendini, Commented Aug 29, 2013 at 8:31

Yusuf Moola · Accepted Answer · 2013-08-29 08:29:02Z

2

You should output it like

<?php echo $_SESSION['user']['email'] ?>

assuming that 'email' is the column name in the users table.

answered Aug 29, 2013 at 8:29

Yusuf Moola

1787 bronze badges

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

1 Comment

Muzica Veche Over a year ago

Thank you very much my friend.. it's exactly what i want.. Ty !

aviv · Accepted Answer · 2013-08-29 08:31:01Z

2

Just address the relevant field in the associative array:

  <?php echo $value['email';?>

answered Aug 29, 2013 at 8:31

aviv

2,7947 gold badges36 silver badges48 bronze badges

Comments

marc_s · Accepted Answer · 2017-03-27 20:35:50Z

1

Use this in the config file:

$_SESSION['user']['email'] = mysql_fetch_assoc($userResult);

instead of this

$_SESSION['user'] = mysql_fetch_assoc($userResult);

in your code. You can pass as many columns you want to pass from your table.

And in another page use

foreach($_SESSION['user']['email'] as $key => $value)

instead of

foreach($_SESSION['user'] as $key => $value)

in your code.

Remember number of columns you pass in config file, all those columns should be called in this page.

edited Mar 27, 2017 at 20:35

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Aug 29, 2013 at 8:48

Ankur Dhanuka

1,2372 gold badges12 silver badges22 bronze badges

Collectives™ on Stack Overflow

PHP show records from mysql

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related