Sending Data w/o Forms

Kudose

OK, this may be confusing, but I will do my best.

I have a site using frames. In this site there is a page called members.php

Members contains the page layout. In this page there is an include called showmembers.php which shows the members from the DB.

What I want to do is somehow link the usernames, in the showmembers.php file, shown to a page called profile.php, and profile.php will display all of the members profile info. The profile info will be stored in my DB so I would need it to pull out that memebrs specific info based on the link clicked. Does anyone know how to do this?

Can you give me a brief tutorial or code snipplet or something. I would really appreciate everything. Thank you in advance.

Ok, I already have the members page in the main frame, and the include('showmembers.php'); working, what I need is when you click a users name form the showmembers.php page, for it to go to a page called profile.php, I can do that much. But what I need to know is how to get the showmembers.php page to send the already known $username (becuase it pulls $username form the DB and uses a while statement to display it) to the page profile.php so no matter what username link they click, it pulls the correct username out of the DB and displays thier profile on profile.php

DigitalExpl0it

I just zoomed thru your post but al lyou need to do is a variable url link....

like this

<a href="profile.php?user=<? echo $username; ?>">User Joe</a>

so when you pull all the data out from the database on your members.php page just have it loop thru and create the link above...

example:

<?
// Database Conenction String ------Start------
		$connect = mysql_connect($hip, $duser, $dpass) or die ("Couldnt connect");
		$db = mysql_select_db($dname, $connect) or die ("Couldnt open Database");
		$sql = "select * from $table WHERE $locate = '$stripit' Order by $id_it ASC LIMIT $onset2,12";
		$sql_result = mysql_query($sql, $connect) or die ("Access Denied!");
		$count = mysql_num_rows($sql_result);
// Database Connection String -------End-------

while ($row = mysql_fetch_array($sql_result)){
		$username = $row["pname"];
?>
<a href="profile.php?user=<? echo $username; ?>"><? echo $username; ?></a>
<?
}
?>

then for your profile.php page

just do grab the variable user from the url string and place it in your sql statement like this

example:

<?
// Database Conenction String ------Start------
		$connect = mysql_connect($hip, $duser, $dpass) or die ("Couldnt connect");
		$db = mysql_select_db($dname, $connect) or die ("Couldnt open Database");
		$sql = "select * from table WHERE username = '".$_REQUEST["user"]."'";
		$sql_result = mysql_query($sql, $connect) or die ("Access Denied!");
		$count = mysql_num_rows($sql_result);
// Database Connection String -------End-------

while ($row = mysql_fetch_array($sql_result)){
		$username = $row["pname"];

// your code here		
}
?>

DigitalExpl0it

but if I was you id have a ID field in your database and only run the profiles off a users ID..

so instead of

Kudose

Ok, I do have an auto increment ID system setup as $userid.

Couple questions, bear with me please, I am ratehr new at this.

$sql = "select * from $table WHERE $locate = '$stripit' Order by $id_it ASC LIMIT $onset2,12";

What does this do?

$sql = "select * from table WHERE username = '".$_REQUEST["user"]."'";

And this

And the $count variable is never called. Why is this needed?

And I would just remane my current file name of profile.php to profile.php?user= Is this right?

Thank you for everything thus far.

rheroux

I think DigitalExploit might be using custom code of his own or something in his examples. Anyways, here's what you could do in the showmembers.php:

Hey, welcome to my page.  Here are the user's.
<?php
$dx = mysql_connect("localhost","someuser","somepass");
mysql_select_db("dbase");
$sql = "SELECT username, id FROM tbl_name";
$result = mysql_query($sql);
while($row = mysql_fetch_object($result))
{
?>
<a href="profile.php?id=<?=$row->id?>"><?=$row->username?></a><br>
<?php
}
?>

And in profile.php, you'd just have something like this:

<?php
$dx = mysql_connect("localhost","someuser","somepass");
mysql_select_db("dbase");
$sql = "SELECT * FROM tbl_name WHERE id = '$id'";
$result = mysql_query($sql);
while($row = mysql_fetch_object($result))
{
?>
Profile info for <?=$row->username?>.

Username: <?=$row->username?><br>
Localtion: <?=$row->location?><br>

And you'd just keep going on down the line for whatever else is in your user information table.

DigitalExpl0it

nope, you dont rename the profile.php to profile.php?user=

just put that into a <a href=""></a> tag

the sql statements were taken from a script I amde in the past as a example..

the $table I ahve defined else were like

$table = "user_account";

but you will not need a count statement in the profile.php page if you are just going to post all the infor from the one record specified from that user... thats why you use this in profile.php..

$sql = "select * from table WHERE username = '".$_REQUEST["user"]."'";

$_REQUEST["user"]

will look at the url sting (http://www.yourdomain.com/profile.php?user=joe)

and get the variable user..

$_REQUEST["user"] is like $user but for variables in a url string...

DigitalExpl0it

Originally posted by rheroux
$sql = "SELECT * FROM tbl_name WHERE id = '$id'";

id do this...

$sql = "SELECT * FROM tbl_name WHERE id = '".$_REQUEST["id"]."'";