Database User authentication

In Progress

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

Skills: Computer Security, Database Administration, Engineering, MySQL, PHP, Software Architecture, Software Testing, SQL, Web Security

See more: the email address is invalid, invalid web address, invalid email error, invalid email address message, address is invalid, php login script creation, unique user, md5, database security, cookie store, php script store email mysql, secure mysql user authentication php, php program email validation, secure authentication, nice html form, php mysql cookie, delete session files php script, html authentication, security check php code, php secure sessions, linux email security, email creation request form, email validation check, disabled job, mysql delete mysql database tables

About the Employer:
( 11 reviews ) Ptolemaida, Greece

Project ID: #2840093

Awarded to:

harsons

See private message.

$17 USD in 14 days
(1 Review)
3.1

16 freelancers are bidding on average $111 for this job

shethnc

See private message.

$85 USD in 14 days
(35 Reviews)
4.8
architechx

See private message.

$170 USD in 14 days
(3 Reviews)
4.7
sergelvw

See private message.

$169.15 USD in 14 days
(16 Reviews)
4.3
teamsgreen

See private message.

$144.5 USD in 14 days
(48 Reviews)
4.3
unthesis

See private message.

$42.5 USD in 14 days
(15 Reviews)
4.1
waynehunt

See private message.

$297.5 USD in 14 days
(13 Reviews)
4.0
sasajovanovicvw

See private message.

$85 USD in 14 days
(1 Review)
2.8
technologyi2i

See private message.

$51 USD in 14 days
(8 Reviews)
2.5
acuteinc

See private message.

$42.5 USD in 14 days
(1 Review)
2.3
zzzzzvw

See private message.

$55.25 USD in 14 days
(2 Reviews)
1.5
uasoftware

See private message.

$63.75 USD in 14 days
(1 Review)
0.0
shabang

See private message.

$85 USD in 14 days
(0 Reviews)
0.0
kevin8941

See private message.

$127.5 USD in 14 days
(0 Reviews)
0.0
sdsmedia

See private message.

$255 USD in 14 days
(0 Reviews)
0.0
estan1

See private message.

$85 USD in 14 days
(0 Reviews)
0.0