DaniWeb Forum Index > Web Development > PHP

Default Image?

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

Thread Solved

« First

•

Join Date: Oct 2006

Posts: 1,015

Reputation: ardav will become famous soon enough

Solved Threads: 130

ardav

Offline

Veteran Poster

Re: Default Image?

#21

Sep 20th, 2009

I don't see the point. htaccess will enable you to enter the url you want and the $_GET['username'] variable in the index.php page will then give you a hook to the db to extract the user's details. That's it. Cookies shouldn't really feature here. The htaccess method will work whether cookies are enabled, eaten, disabled etc etc.

There are 20 ways to boil an egg, but I think using cookies for this will leave it raw.

Have you tried my suggestion?

Last edited by ardav; Sep 20th, 2009 at 1:25 pm.

It's full of stars...

•

Join Date: Aug 2009

Posts: 20

Reputation: JayGeePee is an unknown quantity at this point

Solved Threads: 0

JayGeePee

Offline

Newbie Poster

Re: Default Image?

#22

Sep 20th, 2009

•

Originally Posted by ardav

I don't see the point. htaccess will enable you to enter the url you want and the $_GET['username'] variable in the index.php page will then give you a hook to the db to extract the user's details. That's it. Cookies shouldn't really feature here. The htaccess method will work whether cookies are enabled, eaten, disabled etc etc.

There are 20 ways to boil an egg, but I think using cookies for this will leave it raw.

Have you tried my suggestion?

I have tried it, but it dont seem to do anything... None of my member urls exist on my server... They all reside on my database.

www.Mysite.com/username

I bought this php script from a guy who closed down his website shortly after... So I had no way of contacting him with questions.

If mysite.com/somename dosnt exist on my server as a visible URL. Does this .htaccess file still work on a url thats not visible? I think this url is set in my script I bought, and the only evidence i have that its there is my admin panel, or my database.

I dont know if im going to get this to work...

•

Join Date: Oct 2006

Posts: 1,015

Reputation: ardav will become famous soon enough

Solved Threads: 130

ardav

Offline

Veteran Poster

Re: Default Image?

#23

Sep 20th, 2009

•

I have tried it, but it dont seem to do anything... None of my member urls exist on my server... They all reside on my database.

Obviously.

Use this with the htaccess file in place:

index.php - I wouldn't use this on the index.php, I'd change it to member.php or something, but it's your funeral.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
if(isset($_GET['username'])){
  $username = addslashes(htmlentities($_GET['username']));
  $recordset = mysql_query("SELECT * FROM users WHERE username = '{$username}'");
  if(mysql_num_rows($recordset) > 0){
     $data = mysql_fetch_array($recordset);
     $avatar = $data['avatar'];
 
     (... etc for all the fields you want ...)
 
  }else{
     //put message to screen if user doesn't exist
  }
}
if(isset($_GET['username'])){
  $username = addslashes(htmlentities($_GET['username']));
  $recordset = mysql_query("SELECT * FROM users WHERE username = '{$username}'");
  if(mysql_num_rows($recordset) > 0){
     $data = mysql_fetch_array($recordset);
     $avatar = $data['avatar'];

     (... etc for all the fields you want ...)

  }else{
     //put message to screen if user doesn't exist
  }
}

Last edited by ardav; Sep 20th, 2009 at 3:29 pm.

It's full of stars...

•

Join Date: Aug 2009

Posts: 20

Reputation: JayGeePee is an unknown quantity at this point

Solved Threads: 0

JayGeePee

Offline

Newbie Poster

Solved...

#24

Sep 20th, 2009

Solved... Thanks for your persistence, most people would of gave up on me. I didnt upload my .htaccess file right, the first way you told me to do it worked. Persistance pays off. Thanks.