PHP Coding Problem

Question

prabhatrahul 0 Newbie Poster

16 Years Ago

hi,
I have one problem regarding retriving data from database. I have created one database in userrecord and its table name is tbl_user. I am trying to display the user information when thy logged in the syste. i.e view logged user profile. The code is as follow:

<?php
include("auth_user.inc.php"); // authrization page
$uname=$_SESSION; // logged user name
$connection=mysql_connect("localhost","root"," ");
mysql_select_db("userrecord",$connection);
$sql=("select * from table_user where uname ='$uname'");
$result=@mysql_query($sql,$connection);
$row=mysql_fetch_array($result);
?>
<html>
<head><title>User Account</title>
</head>
<body bgcolor="#33CCFF">
 Your Details Information Is Shown Below: 
First Name:<?php echo $row;?> 
Last Name:<?php echo $row;?> 
Address:<?php echo $row;?> 
E-Mail:<?php echo $row;?> 
Gender:<?php echo $row;?> 
User Name:<?php echo $row;?> 
</body>
</html>

The code echo $row is not displaying the record from database.

Regards,
Prabhat Kumar Jha

php

3 Contributors
5 Replies
107 Views
1 Day Discussion Span
Latest Post 16 Years Ago Latest Post by nav33n

nav33n 472 Purple hazed!

16 Years Ago

Remove @ before mysql_query. Use die(mysql_error()); ie., mysql_query($sql) or die (mysql_error());

R0bb0b 344 Posting Shark

16 Years Ago

I don't think I ever seen mysql_fetch_array used without some type of loop. How are you specifying which row of data you want to display in the url? This is how I would probably do it.

<?php
include("auth_user.inc.php"); // authrization page
$uname=$_SESSION['user']; // logged user name
$connection=mysql_connect("localhost","root"," ");
mysql_select_db("userrecord",$connection);
$sql=("select * from table_user where uname ='$uname'");
$result=@mysql_query($sql,$connection);

?>
<html>
<head><title>User Account</title>
</head>
<body bgcolor="#33CCFF">
<br>Your Details Information Is Shown Below:<br><br>
<?
$counter = 0;
while($row = mysql_fetch_array($result) && $counter < 1)
{
        $counter++;
        First Name:<?php echo $row['fname']; ?> <br>
	Last Name:<?php echo $row['lname']; ?> <br>
	Address:<?php echo $row['address']; ?> <br>
	E-Mail:<?php echo $row['email']; ?> <br>
	Gender:<?php echo $row['fname']; ?> <br>
	User Name:<?php echo $row['uname']; ?>
}
?>
</body>
</html>

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 1 · 2008-06-22T20:04:43+00:00

I don't think I ever seen mysql_fetch_array used without some type of loop.

You can. It will fetch only the 1st record.

prabhatrahul 0 Newbie Poster · Answer 2 · 2008-06-23T12:58:55+00:00

I don't think I ever seen mysql_fetch_array used without some type of loop. How are you specifying which row of data you want to display in the url? This is how I would probably do it.

<?php
include("auth_user.inc.php"); // authrization page
$uname=$_SESSION['user']; // logged user name
$connection=mysql_connect("localhost","root"," ");
mysql_select_db("userrecord",$connection);
$sql=("select * from table_user where uname ='$uname'");
$result=@mysql_query($sql,$connection);

?>
<html>
<head><title>User Account</title>
</head>
<body bgcolor="#33CCFF">
<br>Your Details Information Is Shown Below:<br><br>
<?
$counter = 0;
while($row = mysql_fetch_array($result) && $counter < 1)
{
        $counter++;
        First Name:<?php echo $row['fname']; ?> <br>
	Last Name:<?php echo $row['lname']; ?> <br>
	Address:<?php echo $row['address']; ?> <br>
	E-Mail:<?php echo $row['email']; ?> <br>
	Gender:<?php echo $row['fname']; ?> <br>
	User Name:<?php echo $row['uname']; ?>
}
?>
</body>
</html>

I have tried the code but error is :
Parse error: parse error, unexpected T_STRING in c:\phpdev5www\prabhat\user_profile.php on line 20

I.e First Name:<?php echo $row; ?> 
In this line <?php is not highlighted.

Please reply

nav33n 472 Purple hazed! Team Colleague Featured Poster · Answer 3 · 2008-06-23T13:24:34+00:00

1. You don't have session_start
2. Since you have while loop,

while($row = mysql_fetch_array($result) && $counter < 1)
{
$counter++;
First Name:<?php echo $row; ?> 
Last Name:<?php echo $row; ?> 
Address:<?php echo $row; ?> 
E-Mail:<?php echo $row; ?> 
Gender:<?php echo $row; ?> 
User Name:<?php echo $row; ?>
}

This part of the code will not work.
Try this.

<?php
session_start();
include("auth_user.inc.php"); // authrization page
$uname=$_SESSION['user']; // logged user name
$connection=mysql_connect("localhost","root"," ");
mysql_select_db("userrecord",$connection);
$sql=("select * from table_user where uname ='$uname'");
$result=@mysql_query($sql,$connection);

?>
<html>
<head><title>User Account</title>
</head>
<body bgcolor="#33CCFF">
<br>Your Details Information Is Shown Below:<br><br>
<?
$counter = 0;
while($row = mysql_fetch_array($result) && $counter < 1)
{
        $counter++;
        echo "First Name: ". $row['fname'] ."<br>";
        //.. and so on...
	
}
?>
</body>
</html>