[SOLVED] User Profiles

[DeanWhitehouse]

i have this code for the user profile link

<a href='user_profile.php?id=<?php echo $_SESSION['user_id']; ?>'>Settings</a><br>

now on the user_profile.php page how do i display this users profile, can i call all there details from the database using there user_id

[jonsjava]

yes. you would do something like this

$user = addslashes($_GET['id']);
$sql = "SELECT * FROM `table` WHERE `id`='{$user}' LIMIT 1;";

[DarkWater]

$id = $_GET['id'];

Then use a query like:

SELECT * FROM users WHERE user_id='$id';

 

And display everything appropriately. 

[DarkWater]

Of course, you'd error check and type cast though:

 

if (!isset($_GET['id']) {

    echo "Invalid user ID";

    // Do any includes for like, footers or w/e.

    exit();

}

$id =  (int) $_GET['id'];

[DeanWhitehouse]

how would i arrange this data

[jonsjava]

<?php
$user = addslashes($_GET['id']);
$sql = "SELECT * FROM `table` WHERE `id`='{$user}' LIMIT 1;";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
$username = $row['username']
//etc, etc, etc

[DeanWhitehouse]

i get this error

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/deanwhitehouse.awardspace.co.uk/test/user_profile.php on line 9

 

with this code

<?php
require_once 'db_connect.php';
require_once 'nav_bar.php';
require_once 'logged_in.php';

$user_id = addslashes($_GET['id']);
$sql = "SELECT * FROM `$user` WHERE `id`='{$user_id}' LIMIT 1;";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
$username = $row['user_name']

?>

[jonsjava]

i get this error

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/www/deanwhitehouse.awardspace.co.uk/test/user_profile.php on line 9

 

with this code

<?php
require_once 'db_connect.php';
require_once 'nav_bar.php';
require_once 'logged_in.php';

$user_id = addslashes($_GET['id']);
$sql = "SELECT * FROM `$user` WHERE `id`='{$user_id}' LIMIT 1;";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
$username = $row['user_name']

?>

That was sample code. is your DB set up that way?

[DeanWhitehouse]

this code is right but, it doesn't display anything from the database

<?php
require_once 'db_connect.php';
require_once 'nav_bar.php';
require_once 'logged_in.php';

$user_id = addslashes($_GET['id']);
$sql = "SELECT * FROM `$user` WHERE `user_id`='{$user_id}' LIMIT 1;";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
$username = $row['user_name']

?>

i tried changing it to this but, it still isn't displaying anything

<?php
require_once 'db_connect.php';
require_once 'nav_bar.php';
require_once 'logged_in.php';

$user_id = $_SESSION['user_id'];
$sql = "SELECT * FROM $user WHERE `user_id`='{$user_id}' LIMIT 0,1;";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
$username = $row['user_name']

?>

do i need to echo it?

[jonsjava]

yup. also, you don't have session_start() at the top.

[DeanWhitehouse]

no, db_connect.php has the session_start() on it also when i try to echo like this

<?php
require_once 'db_connect.php';
require_once 'nav_bar.php';
require_once 'logged_in.php';

$user_id = $_SESSION['user_id'];
$sql = "SELECT * FROM $user WHERE `user_id`='{$user_id}' LIMIT 0,1;";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
$username = $row['user_name']

echo "$username";
?>

 

i get an "unexpected" error with this, it doesn't expect the echo

[jonsjava]

<?php
require_once 'db_connect.php';
require_once 'nav_bar.php';
require_once 'logged_in.php';

$user_id = $_SESSION['user_id'];
$sql = "SELECT * FROM $user WHERE `user_id`='{$user_id}' LIMIT 0,1;";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);
$username = $row['user_name'];

echo "$username";
?>

forgot a ";"

[DeanWhitehouse]

o yer, soz my fault, i thought i had tried it with that added.

Thanks for all the help.