php file upload by user id by mysql - Page 2

[diafol]

It's still wrong as an user could change their email and then you'd need to change the videos table too.

[garyjohnson]

Well, since I have such a small site I think I will be okay lol, but I want my users to have their own profile, only so they can see what videos they have uploaded, I have been looking into URL rewriting, do you know anyhting about this?

[diafol]

WHat do you want?

[garyjohnson]

I want when my users login to be able to click profile or account and be able to see all the videos which they uploaded.

[diafol]

You can do this via session user_id. Or if you want it to be accessible to bots for SEO / indexing, you can use a rewrite, something like:

www.example.com/profile/blax/

Rewritten from something like:

www.example.com/profile.php?username=blax

or

www.example.com/index.php?page=profile&username=blax

A mixture of both approaches will allow anybody to view anybody else's profile. But a matching session user_id will allow that user to edit his own page (e.g. show edit form).

[LastMitch]

@garyjohnson

is this is related:

http://www.daniweb.com/web-development/php/threads/433347/joining-two-database-tables-with-php#post1859387

to this thread?

[garyjohnson]

Crap I posted that onto the wrong forum, lol. Let me fix it