Jump to content


almost all the way there, need a php boost

  • Please log in to reply
3 replies to this topic

#1 alwaysinit

  • Members
  • PipPipPip
  • Advanced Member
  • 60 posts

Posted 13 September 2006 - 07:55 PM

My site is so close to being ready(database-wise), but I just can't seem to figure out the profile creation aspect of it. I have (signup.php, login.php, memberarea.php, changephoto.php, changesetting.php) all working without problem. The member is in my database and can change all of thier info and photo. Then view those changes in "memberarea.php.
Now I'm working on my site's search engine and I've realized my members have no actual page, ID, or place to assign the link to them in the search results. So my visitors can see who's there, but not go to them.<--(this be my problem)
Do I need to create a subdomain for each musician? Or
Do they just get a special id#, and this id# is what MYSQLs thier info and photos into my templates when visitor tries to view that member's profile?

As it stands, my members have a profile that they can view and change when they login and click "Your Profile". But no one else can view it because I don't understand how to give the Member an identity that would be viewable by visitors browsing the sight.
What am I missing to make it to where visitors can view my members various profiles?
I know time and info are valuable things. Thanx to all responders in advance.

P.S. not sure if i'm allowed to post my site url here, but if I can let me know and i will. You will see more clearly what i mean.

#2 redarrow

  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 13 September 2006 - 08:06 PM

select the information form the database where id='$id'

then do a wile loop $record=myql_fetch_assoc($result);

then a link to the members information <a href"=members_information.php?id='$id'";>look at your information</a>

then on members_information

do a query like select * form xxxx where id='".$_GET['id']."'";

then a while loop to show members information via the link echo $result['information'];

good luck.

Wish i new all about php DAM i will have to learn

#3 gijew

  • Members
  • PipPipPip
  • Advanced Member
  • 240 posts
  • LocationCalifornia

Posted 13 September 2006 - 08:08 PM

I don't know how your tables are set up but you can just use the primary key in your user or musician database to identify each person.  Just create a link to a page that houses the profile or whatever else and make sure to append the musician id to that.  On that page, create a query that takes the musician ID from the URL using $_GET and query against that.
I'm considered good looking in some countries

#4 alwaysinit

  • Members
  • PipPipPip
  • Advanced Member
  • 60 posts

Posted 13 September 2006 - 08:43 PM

I think I sense what you guys are talking about. I'll try now and let u know

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users