How to use PHP Session to View MYsql Database Tables?

Question

I am currently trying to create a PHP script whereby there is already a login script created and the user that successfully logs into the home.php is able to view the tables of the database he is logged into.

Is there any ways of retrieving the tables using the mySQL query like "SHOW TABLES"?

Here are some of my codes:

<?php
session_start();
if($_SESSION['id'])
{
    echo "Welcome ",$_SESSION['username']."<br>";
    echo "Click here to Logout :    ".'<br><a href="logout.php">Logout</a>';
}
else
{
    echo "You don't belong here!";
}



$tableSQL = "SHOW TABLES";

$tablesoutput = mysql_query($tableSQL);

print $tablesoutput;

?>

I think my codes are wrong as there are errors showing that access is denied to the database. Does it mean that I have to reconnect to the database even though I have a session established?

Jon Black · Accepted Answer · 2010-09-08 08:30:55Z

1

amend the following to suit your requirements:

<?php

$conn = mysql_connect("localhost","foo_dbo","pass") or die("Database error");

mysql_select_db("foo_db", $conn);

$result = mysql_query("show tables");

if(!$result) die("Invalid query: " . mysql_error());

while ($row = mysql_fetch_array($result)){
    echo $row[0], "<br/>";
    //do stuff with the table names
}

mysql_free_result($result);
mysql_close($conn);

?>

answered Sep 8, 2010 at 8:30

Jon Black

16.6k5 gold badges45 silver badges42 bronze badges

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

1 Comment

JavaNoob Over a year ago

Increased answer usefulness! Thanks!

deceze · Accepted Answer · 2010-09-08 08:17:23Z

0

A session only means that values stored in the $_SESSION variable are persisted across separate requests, but that's all. It does not "log a user into the database" nor does it keep a database connection open. You'll have to establish a database connection on every page load.

You also need to use mysql_fetch_assoc on the result of mysql_query. A simple print won't suffice.

answered Sep 8, 2010 at 8:17

deceze♦

525k89 gold badges806 silver badges954 bronze badges

2 Comments

JavaNoob Over a year ago

Instead of using fetch, can I also use mysql_result??

deceze Over a year ago

@Java Sure, if you so wish. You just need something more specialized to deal with MySQL results, something print can't do.

softcr · Accepted Answer · 2010-09-08 08:15:54Z

0

You need to connect to the database every time your skript is executed. The session has nothing to do with your database connection.

answered Sep 8, 2010 at 8:15

softcr

6203 silver badges10 bronze badges

Collectives™ on Stack Overflow

How to use PHP Session to View MYsql Database Tables?

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related