GetDotted Domains

Viewing Thread:
"PHP / MySQL Security"

The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.

Fri 29/10/04 at 16:25
Regular
"Lisan al-Gaib"
Posts: 7,093
Can anyone point me in the right direction to allow secure logging in of users on a PHP based site using session vars and a mySQL backend database? Preferably encrypted so third prty's cant view data being passed back and forth?

Cheers. Away soon, so It'll be tomorrow before i can reply.
Mon 01/11/04 at 08:35
Regular
"Lisan al-Gaib"
Posts: 7,093
Cheers. MD5 and Session vars are the way I'm going. MD5 was causing me problems as the mysql database only stored 16 chars as a max. MD5 is 32. Simple fix, increase database field to 32. Cool. Cheers!
Sat 30/10/04 at 12:47
Regular
"NULL"
Posts: 1,384
monkey_man wrote:
> For logins I made a script that checks the form password against a
> password stored online, then makes a cookie saying 'true' or 'false',
> depending. The user can't set their own cookies for my domain, so
> this way doesn't give away the password but is secure enough.

A user with the right software could easily set a cookie on their PC saying true or false. Wouldn't be too hard at all - a cookie is only a text file.
Fri 29/10/04 at 19:24
Regular
"Pouch Ape"
Posts: 14,499
Tyla wrote:
> you still bound to
> get the occassional user like myself, who deletes all his cookies
> after every session!:)

Then you have to sign again!

For logins I made a script that checks the form password against a password stored online, then makes a cookie saying 'true' or 'false', depending. The user can't set their own cookies for my domain, so this way doesn't give away the password but is secure enough.
Fri 29/10/04 at 18:32
Regular
"l33t cs50r"
Posts: 2,956
Nimco wrote:
> Use something like the MD5 encryption algorithm to encrypt your
> passwords and place them encrypted in the database. Then when you
> want a user to login, store the MD5 encrypyted password they enter in
> a cookie and compare to the database. This way the password is never
> seen in it's unencrypted form.

Shouldn't rely on cookies anymore. Especially due to Privacy laws now in force. Although MD5 would work well like this, you still bound to get the occassional user like myself, who deletes all his cookies after every session!:)
Fri 29/10/04 at 18:31
Regular
"l33t cs50r"
Posts: 2,956
Pandaemonium wrote:
> Can anyone point me in the right direction to allow secure logging in
> of users on a PHP based site using session vars and a mySQL backend
> database? Preferably encrypted so third prty's cant view data being
> passed back and forth?
>
> Cheers. Away soon, so It'll be tomorrow before i can reply.

I always thought is was as esy as deciding wether to use POST or GET? MD5 is a good way to go, otherwise use HTTPS
Fri 29/10/04 at 17:19
Regular
"NULL"
Posts: 1,384
Use something like the MD5 encryption algorithm to encrypt your passwords and place them encrypted in the database. Then when you want a user to login, store the MD5 encrypyted password they enter in a cookie and compare to the database. This way the password is never seen in it's unencrypted form.
Fri 29/10/04 at 16:25
Regular
"Lisan al-Gaib"
Posts: 7,093
Can anyone point me in the right direction to allow secure logging in of users on a PHP based site using session vars and a mySQL backend database? Preferably encrypted so third prty's cant view data being passed back and forth?

Cheers. Away soon, so It'll be tomorrow before i can reply.

Freeola & GetDotted are rated 5 Stars

Check out some of our customer reviews below:

Great services and friendly support
I have been a subscriber to your service for more than 9 yrs. I have got at least 12 other people to sign up to Freeola. This is due to the great services offered and the responsive friendly support.
My website looks tremendous!
Fantastic site, easy to follow, simple guides... impressed with whole package. My website looks tremendous. You don't need to be a rocket scientist to set this up, Freeola helps you step-by-step.
Susan

View More Reviews

Need some help? Give us a call on 01376 55 60 60

Go to Support Centre

It appears you are using an old browser, as such, some parts of the Freeola and Getdotted site will not work as intended. Using the latest version of your browser, or another browser such as Google Chrome, Mozilla Firefox, or Opera will provide a better, safer browsing experience for you.