Getting URL info into Script

Kudose

Ok, I have had an ongoing issue, got help from lots of people, which is greatly appreciated I might add, and I just one issue left. I need to pull the $id variable out of the URL and post if into my script to complete the profile viewing process. Here is my code:

<?

include('dbinfo.inc.php');

echo" <table width='50%'border='0'><tr><td>Profile for user: $username</td></tr>";

$query = "SELECT * FROM users WHERE userid='".$_REQUEST['$id']."'";
$result = mysql_query($query);
while($row = mysql_fetch_object($result)){

echo"
<tr><td><left>Name:</left></td>
<td><center> $fname $lname </center></td></tr>

";
}

?>

There are no parse errors, it shows all of the data except for the vaiables. I need to know how to get my userid variable out of the URL which looks like this:

profile.php?id=$id

Lets say hypothetically that the $id is one (i.e. profile.php?id=1)

How do I get that one out of there and get it into my script so I can get the rest of the info from the DB?

Thanks in advance.

cgraz

use

$query = "SELECT * FROM users WHERE userid='" . $_GET['$id'] . "'";

or for older versions of PHP

$query = "SELECT * FROM users WHERE userid='" . $HTTP_GET_VARS['$id'] . "'";

Cgraz

Kudose

Didnt work with either of them 🙁

You can see for yourself @ http://kcnites.ionichost.com then click members, then one of thier usernames.

Thank you though, any other suggestions?

seby

you need to add a variable to your $row

how are you connecting to the database, all i see is $query =

example your query should look something like this:

$results = @mysql_query("SELECT * FROM users WHERE userid='" . $HTTP_GET_VARS['$id'] . "'");
         while($row = mysql_fetch_row($result)){ 

$id = $row[your ROW here];
$var = $row[another ROW];

}

you have to assign $id to a the $row of you ID.

Kudose

I connect to my DB through include('dbinfo.inc.php');

seby

Okay, Then all you have to do is assign a $row to your $id like i explained above.

do you know what row is ID?

seby

cgraz, what do you mean by 'older' ?

$HTTP_GET_VARS works with 4.2.3+

Kudose

Revised code as follows:

<?

include('dbinfo.inc.php'); //connects to DB

echo" <table width='50%'border='0'><tr><td>Profile for user: $username</td></tr>";

$query = "SELECT * FROM users WHERE userid='" . $HTTP_GET_VARS['$id'] . "'";
$result = mysql_query($query);
while($row = mysql_fetch_object($result)){

$id = $row["userid"];
$fname = $row["fname"];
$lname = $row["lname"];

echo"
<tr><td><left>Name:</left></td>
<td><center> $fname $lname </center></td></tr>

";
}

?>

The script is still doing the same thing, no parse errors, but displaying nothing. I am fairly new at this, so please don't get all that upset with me if it seems like I am an idiot.

DB CONTAINS IN THIS ORDER:

userid
username
password
fname
lname
age
email
city
state
homepage
profile
profileimg

cgraz

I think you need to use mysql_fetch_array rather than mysql_fetch_object

You can always print your query or use mysql_error() for error checking also, but you are using mysql_fetch_object incorrectly.

Cgraz

seby

Kudose, That is ok. We all had to start somewhere 🙂

Change:

$id = $row["userid"]; to $id = $row[0];
$fname = $row["fname"]; to $fname = $row[3];
$lname = $row["lname"]; to $lname = $row[4];

your mysql query is incorrect.

try this:

$result = @mysql_query("SELECT * FROM users WHERE userid='" . $HTTP_GET_VARS['$id'] ."'");
   while($row = mysql_fetch_array($result)) { 

$id = $row[0]; 
$fname = $row[3];
$lname = $row[4]; 

}

Kudose

Using this code:

<?

include('dbinfo.inc.php');

echo" <table width='50%'border='0'><tr><td>Profile for user: $username</td></tr>";

$query = "SELECT * FROM users WHERE userid='" . $HTTP_GET_VARS['$id'] . "'";
$result = mysql_query($query);
echo $result;
if(!$result){ print(mysql_error());
} else {
while($row = mysql_fetch_array($result)){

$id = $row["userid"];
$fname = $row["fname"];
$lname = $row["fname"];

echo"
<tr><td><left>Name:</left></td>
<td><center> $fname $lname </center></td></tr>
";

}
}

?>

It prints out "Resource id#2" and then the rest of the page, w/o variables.

Kudose

seby:

<?

include('dbinfo.inc.php');

echo" <table width='50%'border='0'><tr><td>Profile for user: $username</td></tr>";

$result = @("SELECT * FROM users WHERE userid='" . $HTTP_GET_VARS['$id'] . "'");
while($row = mysql_fetch_array($result)){

$id = $row[0];
$fname = $row[3];
$lname = $row[4];

echo"
<tr><td><left>Name:</left></td>
<td><center> $fname $lname </center></td></tr>
";

}

?>

Gets me the all the table print, but still no variables.

cgraz

change your code to this

<? 

include('dbinfo.inc.php'); 

echo "<table width='50%'border='0'><tr><td><font face='Tahoma' size='2'><b>Profile for user: $username</b></td></tr>"; 

$query = "SELECT * FROM users WHERE userid='1'"; 
$result = mysql_query($query) or die(mysql_error()); 
echo $result . "<br>"; 

while($row = mysql_fetch_array($result)) { 

print "<tr><td align=left><b>Name:</b></td>\n"; 
print "<td><center>" . $row["fname"] . " " . $row["lname"] . "</center></td></tr>"; 

} 

// the bracket above closes the while loop. What does this one do?
} 

?>

and post the link so I can see what it does.

Cgraz

Kudose

2 new questions:

- Would it be easier to some how get my showmemebrs script that send the variable URL to post the variable to the profile.php?id=$id script?

is there a way to get my code to look like yours does with out having to do all of the color clicking stuff in the forum?

[/SIZE]

Kudose

yay, kinda of.

http://kcnites.ionichost.com/

click members, then a username

It gives me the name print out finally, but shows Rescource id#2 again and spits out the same real name for both usernames.

cgraz

The best way to do it is to pass the id variable in the url, then grab it and use in your query. In the code I gave you, i just substituted the id with 1 to see if it would work.

Also, to get the php highlighting, put your php code within

[ p h p ] php code goes here [ / p h p ]

(except i put spaces between the brackets and php and /php. When you use it, don't use any spaces.

Hmm, the resource id #2 is weird. I've seen it before in other people's work, but I'm not too sure what it means. Try getting rid of the mysql_error() part.

Cgraz

Kudose

on the showmembers.php page, the link is

<a href='profile.php?id=$id'>Memeber Name </a>

Which goes to the script we are working on.

When reverting to this script


<? 

include('dbinfo.inc.php'); 

echo "<table width='50%'border='0'><tr><td><font face='Tahoma' size='2'><b>Profile for user: $username</b></td></tr>"; 

$query = "SELECT * FROM users WHERE userid='".$HTTP_GET_VARS['$id']."'"; 
$result = mysql_query($query) or die(mysql_error());  

while($row = mysql_fetch_array($result)) { 

print "<tr><td align=left><b>Name:</b></td>\n"; 
print "<td><center>" . $row["fname"] . " " . $row["lname"] . "</center></td></tr>"; 

} 

?>

I get:

PROFILE FOR USER: blank like before

The $HTTP_GET_VARS doesnt seem to be woprking or something
🙁

cgraz

should probably be $_GET['id']

Cgraz

Kudose


<? 

include('dbinfo.inc.php'); 

echo "<table width='50%'border='0'><tr><td><font face='Tahoma' size='2'><b>Profile for user: $username</b></td></tr>"; 

$query = "SELECT * FROM users WHERE userid='". $GET['$id'] ."'"; 
$result = mysql_query($query) or die(mysql_error());  

while($row = mysql_fetch_array($result)) { 

print "<tr><td align=left><b>Name:</b></td>\n"; 
print "<td><center>" . $row["fname"] . " " . $row["lname"] . "</center></td></tr>"; 

} 

?>

Give the same 🙁

cgraz

cause you're using $GET['id']

Look closer at my last post. should be $_GET['id']

Cgraz