0

Here is my plan to create a highly dynamic website with user login/registration and editable profile with pictures:

1.I'll setup only 1 MySQL database for collecting users registration forms and also the same db for login. Pictures will also be stored in this db(like profile pics, or else).

2.A flash login form will check only email and password of the db to check whether the user is valid.

3.A php processes data and if returned true it'll start a new session for that user and will be redirected to the profile page and the rest of the information of that user is then retrieved from db and fills different fields inside that page.

Q1:What is the best collation i should use for username and pass inside MySQL db? Q2:This is the first time i'm doing this, just wanna make sure that i'm the track and is there any tips or suggestions, something that will guide through?

Your answers are appreciated.

Kourosh
  • 608
  • 1
  • 13
  • 34
  • You might be better off storing the images in the file system. Use some form of bucket system to spread the images to folders. And I'd recommend you go for UTF8 – JohnP Mar 19 '11 at 09:37
  • Thanks john, would you please explain a little bit about the bucket system? or any website that has tuts of what you mean? I tried UTF8_Unicode_ci, but its not case sensitive. I couldnt find something like "UTF8_Unicode" all of them has "ci" at the end. – Kourosh Mar 19 '11 at 09:40
  • 1
    Have a look at this : http://stackoverflow.com/questions/3748/ for pros/cons against DB vs Files and this : http://stackoverflow.com/questions/191845/ for how best to store in the file system – JohnP Mar 19 '11 at 09:43
  • Why do you want case sensitive? if you want cs, then you might have to switch to latin_general. Not too sure about it – JohnP Mar 19 '11 at 09:45
  • cause the login uses email add and pass and specially pass i think needs to be case sensitive. For some unknown reasons all available options in phpMyAdmin has this ci at the end. – Kourosh Mar 19 '11 at 09:54
  • 2
    umm, you shouldn't be storing the pass in plaintext in the first place. The password should be a hash which you then compare to. – JohnP Mar 19 '11 at 10:15

0 Answers0