₦airaland Forum

Hello pals,I need some help on the codes below. I am trying to display a user db data upon signed-in,but it keep showing blank. Kindly help me check what I might av done wrong.
Regards.
<?php
session_start();

include_once "images/connect_to_mysql.php";

if (isset($_SESSION['id'])) {

$sql = mysql_query("SELECT * FROM vault WHERE id='$id' LIMIT 1";
while($row = mysql_fetch_array($sql)){
$username = $row["username"];
$email = $row["email"];
$desc = $row["desc"];
$dep_type = $row["dep_type"];
$consg_code = $row["consg_code"];
$depositor = $row["depositor"];
$officer = $row["officer"];
$contact = $row["contact"];
$delivery = $row["delivery"];
$destination = $row["destination"];
}
}
?>

where did the variable, $id, come from?

If it is a development server, pls turn on all your error reporting and display. Also, run your mysql queries with a mysql administrative application to test it if it doesn't work as intended.

I av a column on the db named 'id' ,and i used it to save the session on the login page.

kok: I av a column on the db named 'id' ,and i used it to save the session on the login page.

What do you really want to do?

kok: I av a column on the db named 'id' ,and i used it to save the session on the login page.

From what i saw in your code, you're getting information from your database based on the $_SESSION['id']. Therefore, the variable $id should be declared with the value of $_SESSION['id']. Pls, turn your error reporting and display ON. You'll get the info am talking about.

<?php
session_start();

include_once "images/connect_to_mysql.php";

if (isset($_SESSION['id'])) {

$id = $_SESSION['id'];

$sql = mysql_query("SELECT * FROM vault WHERE id='$id' LIMIT 1";
while($row = mysql_fetch_array($sql)){
$username = $row["username"];
$email = $row["email"];
$desc = $row["desc"];
$dep_type = $row["dep_type"];
$consg_code = $row["consg_code"];
$depositor = $row["depositor"];
$officer = $row["officer"];
$contact = $row["contact"];
$delivery = $row["delivery"];
$destination = $row["destination"];
}
}
?>

Thanks to u guys. Much apology for reporting late.
I found my way thru it using
if (isset($_GET['id'])) {
$sql = mysql_query("SELECT * FROM vault WHERE id='$id' LIMIT 1" ;

But it still does not display output. I realize that wen I run a num row count to check user existence on db if (existCount = mysql_num_rows($sql);
if ($existCount == 0) {
header("location: index.php?msg=user_doesnt_exist";
exit();
}
it keep affirming "user_doesnt_exist",even when i manually enter data to the db. Any idea plz?