DaniWeb Forum Index > Web Development > PHP

Profile Based Website help

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Oct 2009

Posts: 18

Reputation: enzo420 is an unknown quantity at this point

Solved Threads: 0

enzo420

Offline

Newbie Poster

Profile Based Website help

Oct 19th, 2009

Hi all, so I'm looking to make a social network style site, just to help me understand php so please don't say anything about reinventing the wheel.

I'm looking for a way that when a user clicks on a name in the member list that it sends them to profile.php?id= so that profile.php can use it to identify whose profile they are looking for and can load the data for the profile from a mysql table.

member list

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
mysql_connect("localhost", "root", "") or die (mysql_error());
mysql_select_db ("phplogin");
$result = mysql_query ("SELECT * FROM users WHERE username=enzo");
@$row = mysql_fetch_array($result);
$id = $row['id'];
echo '<a href="profile.php?id="$id">Enzo's Profile</a>';
?>
 
<?php
mysql_connect("localhost", "root", "") or die (mysql_error());
mysql_select_db ("phplogin");
$result = mysql_query ("SELECT * FROM users WHERE username=enzo");
@$row = mysql_fetch_array($result);
$id = $row['id'];
echo '<a href="profile.php?id="$id">Enzo's Profile</a>';
?>

profile

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$currentprofile = $_GET ['id'];
mysql_connect("localhost", "root", "") or die (mysql_error());
mysql_select_db ("phplogin");
$result = mysql_query ("SELECT * FROM users WHERE id=$currentprofile");
@$row = mysql_fetch_array($result);
echo $row['profileinfo'];
$currentprofile = $_GET ['id'];
mysql_connect("localhost", "root", "") or die (mysql_error());
mysql_select_db ("phplogin");
$result = mysql_query ("SELECT * FROM users WHERE id=$currentprofile");
@$row = mysql_fetch_array($result);
echo $row['profileinfo'];

is it wise to keep the profile info and "about me" user input text in a mysql table?

someone needs to write a decent tutorial on profiles that are user editable, people want to try recreate facebook/myspace to see how it works, its not about reinventing anything.

thanks, enzo

•

Join Date: Oct 2009

Posts: 18

Reputation: enzo420 is an unknown quantity at this point

Solved Threads: 0

enzo420

Offline

Newbie Poster

Oct 19th, 2009

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
echo '<a href="profile.php?id="$id">Enzo's Profile</a>';
?>
 
echo '<a href="profile.php?id="$id">Enzo's Profile</a>';
?>

ive spotted the " after the = sign, wasnt supposed to be there but $id doesnt seem to contain anything?

•

Join Date: Apr 2005

Posts: 1,405

Reputation: ShawnCplus is a glorious beacon of light

Solved Threads: 225

ShawnCplus ShawnCplus is offline

Offline

Code Monkey

Oct 19th, 2009

•

Originally Posted by enzo420

Help with Code Tags

PHP Syntax (Toggle Plain Text)
echo '<a href="profile.php?id="$id">Enzo's Profile</a>';
?>
 
echo '<a href="profile.php?id="$id">Enzo's Profile</a>'; ?>
ive spotted the " after the = sign, wasnt supposed to be there but $id doesnt seem to contain anything?

If you're trying to get the value of $id in that string then you have to concatenate because you're using single quotes.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
echo '<a href="profile.php?id=' . $id . '">Enzo's Profile</a>';
 
echo '<a href="profile.php?id=' . $id . '">Enzo's Profile</a>';

GCS d- s+ a-->? C++(++++) UL+++ P+>+++ L+++ E--- W+++
N+ o K w++(---) O? !M- V PS+>++ PE+ Y+ PGP !t- 5? X- R tv+
b+>++ DI+ D G++>+++ e+ h+>++ r y+
PMs asking for help will not be answered, post on the forums. That's what they're there for.

•

Join Date: Oct 2009

Posts: 18

Reputation: enzo420 is an unknown quantity at this point

Solved Threads: 0

enzo420

Offline

Newbie Poster

Oct 19th, 2009

thanks for your reply shawn, i got it sorted,

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<div id="apDiv12">
<?php
$connect = mysql_connect("localhost", "root", "") or die (mysql_error());
$connect;
mysql_select_db ("phplogin");
$result = mysql_query ("SELECT * FROM users WHERE username='jackflash'");
$row = mysql_fetch_array($result);
$id = $row['id'];
echo ('<a href=profile.php?id='.$id.'>Jack Flash</a>');
?>
</div>
<div id="apDiv12">
<?php
$connect = mysql_connect("localhost", "root", "") or die (mysql_error());
$connect;
mysql_select_db ("phplogin");
$result = mysql_query ("SELECT * FROM users WHERE username='jackflash'");
$row = mysql_fetch_array($result);
$id = $row['id'];
echo ('<a href=profile.php?id='.$id.'>Jack Flash</a>');
?>
</div>

•

Join Date: Apr 2005

Posts: 1,405

Reputation: ShawnCplus is a glorious beacon of light

Solved Threads: 225

ShawnCplus ShawnCplus is offline

Offline

Code Monkey

Oct 19th, 2009

•

Originally Posted by enzo420

someone needs to write a decent tutorial on profiles that are user editable, people want to try recreate facebook/myspace to see how it works, its not about reinventing anything.

thanks, enzo

As for this, if you're just using it as a learning experience then it should be just that. It's not a very good learning experience if you just follow someone else's tutorial. The point of recreating something is to learn from the reverse engineering of it.

"Hmm, they have user profiles what is a user profile though. Let's see, a user has a name, and a phone number and an email address. But, oh, look a user has an ID too, that's probably the unique key."

"User's have friends but how do they do that? Ahh, I see, it's really just a list of user ids that they are friends with. But... I know that just storing a list of IDs breaks normalization so they probably have a many-to-many relationship of users. That makes more sense..."

Stuff like that.

(As an aside, echo doesn't need () it's not a function it's a language construct)