Profile help!

[Ratee]

I need help with this script...... i get the error...  'Undefined index: username in C:\wampnew\www\login and register\profile.php on line 28!'

 

 

<?php

 

require("include/connect.php");

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

    echo("Please enter a members profile to view.");

    die();

} elseif($_GET['id'] == "") {

echo("Please enter a members profile to view.");

    die();

}

$pid = mysql_real_escape_string(preg_replace("@[^a-z0-9]@i","",$_GET['id']));

 

$check = mysql_num_rows(mysql_query("SELECT id FROM tut_users WHERE id='{$pid}'"));

 

if($check !="1")

{

  echo("Member does not exist.");

  require("footer.php");

  die();

    }

   

$sql = mysql_query("SELECT * FROM tut_users WHERE id='{$pid}'") or die(mysql_error());

$fetch = mysql_fetch_assoc($sql) or die(mysql_error());

$username = mysql_real_escape_string(preg_replace("@[^a-z0-9]@i","",$fetch['username']));

echo("Member Profile Of: {$username} <br />

" );

?>

 

Could someone please help me thanks...

[Maq]

I can't read any of that, all I can see is a rainbow.

[Ratee]

sorry.....

 

 

I need help with this script...... i get the error...  'Undefined index: username in C:\wampnew\www\login and register\profile.php on line 28!'

 

 

<?php

require("include/connect.php");
if(!isset($_GET['id'])) {
    echo("Please enter a members profile to view.");
    die();
} elseif($_GET['id'] == "") {
echo("Please enter a members profile to view.");
    die();
} 
$pid = mysql_real_escape_string(preg_replace("@[^a-z0-9]@i","",$_GET['id']));

$check = mysql_num_rows(mysql_query("SELECT id FROM tut_users WHERE id='{$pid}'"));

if($check !="1")
{ 
   echo("Member does not exist.");
   require("footer.php");
   die();
    }
    
$sql = mysql_query("SELECT * FROM tut_users WHERE id='{$pid}'") or die(mysql_error());
$fetch = mysql_fetch_assoc($sql) or die(mysql_error());
$username = mysql_real_escape_string(preg_replace("@[^a-z0-9]@i","",$fetch['username']));
echo("Member Profile Of: {$username} <br />
" );
?>

 

Could someone please help me thanks...

 

[Maq]

Where's line 28?  There's only 27 lines of code there.

 

In the future, place

OR

tags around your code.

[Ratee]

there is no line 28 thats what i dont get

[ManiacDan]

"Undefined index" means you used syntax $like['this'] and 'this' was not a member of $like. 

 

This code contains your only reference to ['username']

 

$sql = mysql_query("SELECT * FROM tut_users WHERE id='{$pid}'") or die(mysql_error());
$fetch = mysql_fetch_assoc($sql) or die(mysql_error());
$username = mysql_real_escape_string(preg_replace("@[^a-z0-9]@i","",$fetch['username']));

Clearly $fetch does not contain username.  are you sure table tut_users contains a column called 'username'?

[Ratee]

Thankyou i solved it now:D