0

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

0

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?

0

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.

0

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).

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.