Database User authentication

Completado Publicado Feb 25, 2002 Pagado a la entrega
Completado Pagado a la entrega

I'ld like a basic user creation/user authentication PHP & MySQL solution. The solution will comprise a new user (creation) HTML form with username, password, verify password, email, name, surname fields. The associated PHP code that will check for the uniqness of the username in the database and it will either prompt the user for an alternate username or in the case that the username does not already exist in the database, the creation of the record (in table users with ID AUTO_INCRIMENT as the PK). Also the associated HTML form for ther login process i.e with field username & password and the PHP code for validation of these against the database. The PHP code should return an error message if the username and/or password the user provided is invalid (i.e. does not exist in the database) and it should create a unique sessionid (e.g. remote_ip_address+time+date+random number/string) and store it to the database in a table sessions which will reference the users table (i.e. the user can have one or more sessions) and also include the timestamp of the record .This session id should be stored as a cookie if cookies are enabled on the client or passed through the URL if cookies are [url removed, login to view] the PHP code that will verify the session id (either from the cookie or the URL parameter) against the database and against the IP address of the request (it should be the same as the one in the session id). If the session id does not exist or the ip's differ then the user should be asked to login again. Also it would be nice to have a cron job that will go and delete sessions that expired (i.e. are 12 hours old) say in hourly intervals. Any recomendations to a more robust and secure implementation is also [url removed, login to view] solution should be build using the session framework of PHP and the session id and password should be MD5 hashed. If the user closes the browser and then returns to a page that the validation of session occurs the user should be asked to re-enter their password.

## Deliverables

2 HTML Forms Login and Create new User 3 PHP files #1 Creation of User and SessionID #2 Validation of User and Creation of Session ID #3 Validation of Session ID 1 Script for removing expired Sessions (e.g. cron job) 1 Script for Creation of Database tables Details for installation of files. Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.

## Platform

Linux PHP4 & MySQL

Seguridad informática Administración de bases de datos Ingeniería MySQL PHP Arquitectura de software Verificación de software SQL Seguridad web

Nº del proyecto: #2840093

Sobre el proyecto

16 propuestas Proyecto remoto Activo Feb 27, 2002

Adjudicado a:

harsons

See private message.

$17 USD en 14 días
(1 comentario)
3.1

16 freelancers están ofertando un promedio de $111 por este trabajo

shethnc

See private message.

$85 USD en 14 días
(35 comentarios)
4.8
architechx

See private message.

$170 USD en 14 días
(3 comentarios)
4.7
sergelvw

See private message.

$169.15 USD en 14 días
(16 comentarios)
4.3
teamsgreen

See private message.

$144.5 USD en 14 días
(48 comentarios)
4.3
unthesis

See private message.

$42.5 USD en 14 días
(15 comentarios)
4.1
waynehunt

See private message.

$297.5 USD en 14 días
(13 comentarios)
4.0
sasajovanovicvw

See private message.

$85 USD en 14 días
(1 comentario)
2.8
technologyi2i

See private message.

$51 USD en 14 días
(8 comentarios)
2.5
acuteinc

See private message.

$42.5 USD en 14 días
(1 comentario)
2.3
zzzzzvw

See private message.

$55.25 USD en 14 días
(2 comentarios)
1.5
uasoftware

See private message.

$63.75 USD en 14 días
(1 comentario)
0.0
kevin8941

See private message.

$127.5 USD en 14 días
(0 comentarios)
0.0
shabang

See private message.

$85 USD en 14 días
(0 comentarios)
0.0
sdsmedia

See private message.

$255 USD en 14 días
(0 comentarios)
0.0
estan1

See private message.

$85 USD en 14 días
(0 comentarios)
0.0