LogIn Routine

We need a routine to install in a website in developing for the login, made in this way:

HTML:
Page HTML with form for fill username (input type="text" name="login_username") and password (input type="password" name="login_password"),

PHP Routine:
enrollment verify for username on database: if login ok in $_SESSION['userid'] enroll id user and than redirect on a page /dashboard.php ( empty page) if user is not member redirect on page error /login/error.php?err_login=1

will be provided a database mysql with tables needed for login. Is strictly request that all routines will be correctly commented, penalty of non-payment for work

We also need a routine for enroll the user on the website made in this way:
HTML:
page with the form for users sign up with the following input fields

Username (input type="text" name="user_username"),
Password (input type="text" name="user_password"),
Email (input type="text" name="user_email"),
CountryFK (impostare a 0, input type="hidden" name="user_country" value="0")
TipologyFK (impostare a 0, input type="hidden" name="user_tipology" value="0")
IsBusiness (impostare a 0, input type="hidden" name="user_isbusiness" value="0")
IsVerified (impostare a 0, input type="hidden" name="user_isverified" value="0")

PHP:
user control through unique email address entered. If user exists and is validated (IsVerified = 1) load registration page with the error message /signup-client.php
if user exists, but is NOT validated (IsVerified = 0) send email with summary data with link for validation user(*1)

if user does not exist:
1. record data in to Database
2. send email with summary data with link for validation user(*1)

(* 1) = The email will contain a link to the page /login/validate.php?id=[iduser]. On this page you will need to check the status of user validation and, in case the user is not validate (IsVerified = 0), validate it by changing the field IsVerified=1 and redirect to the page /dashboard.php (blank page) .

Please structure the work as follows:

/sys/global.php => common variables
/sys/function.php => common functions (access to mysql, mysql closing connection, send email etc ...)
/login.html => HTML page with a form to login
/login.php => php page that includes routines for login
/dashboard.php => empty php page
/login/error.php => page that will print the value of the query string variable err_login
/signup-client.php => HTML page with a form to register
/write-user.php => PHP page that includes routines for database logging and email
/login/validate.php? id = [iduser] => php page that includes routines for user validation
/dashboard.php => php page that will print the value of the query string variable id_user

The structure of pages is strictly mandatory, such as inserting comments in each routine, otherwise the not paid of work.

SQL TABLE
==========
/*
SQLyog Community v9.50
MySQL - 5.5.20 : Database - cocontest
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`cocontest` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `cocontest`;

/*Table structure for table `users_clients` */

DROP TABLE IF EXISTS `users_clients`;

CREATE TABLE `users_clients` (
`UsersClientsPK` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
`Username` varchar(255) DEFAULT NULL,
`Password` varchar(255) DEFAULT NULL,
`Email` varchar(255) DEFAULT

Search All Jobs:

An Agency (a Ltd Company) For Hi-Level Websites Develop & Software - Or Long Bussiness Terms

Hello, (remark: Please don't send an automatic feedback with links. read till the end and answer only if you think you are qualified for our job for long bussiness terms, Thank You) We are looking for: An agency (a Ltd company) for Hi-Level websites develop & software...

Skills Required: Graphic Design , HTML , HTML5 , PHP , Website Design
  • Fixed Price Project
  • $8-$15
  • Job Expired

Developing Elegant And Responsive HTML5 ECommerce Site

The following attachment consist the project information and required features.Please read the attachment carefully...

Skills Required: AJAX , eCommerce , HTML5 , PHP , Website Design
  • Fixed Price Project
  • $10-$1600
  • Job Expired

EaselJS + HTML5 Site Builder (front-end Only)

Thanks for considering this project! I need someone to build the front-end (with some client-side functionality) for me. PROJECT An HTML5-based page that allows users to build webpages dynamically...

  • Fixed Price Project
  • $15-$25
  • Job Expired

Create Data Relational Application

Imagine an application with three main and related tables: 1. List name : Company,list name 2. Costumer contact info such as Name, Address, Phone,Age, etc. 2...

Skills Required: HTML5 , jQuery/ Prototype , Mobile Phone , MySQL , PHP
  • Fixed Price Project
  • $200-$300
  • Job Expired

Write Some Software

I have an HTML form that includes three input fields, namely: address, post number, city. What needs to be done is following: - When a user starts typing in street address, he/she has to receive autosuggestions from google's database...

Skills Required: HTML5 , JavaScript , PHP
  • Fixed Price Project
  • $10-$50
  • Job Expired

Prototype A OSX Server Webapp With Three Simple Components

I have a MAC OSX server and I need a simple prototype of a web app written in HTML5 to connect to it. Three basic components to the webapp: 1) Serving up basic pdf documents. 2) Serving up 3 example calendars from the Mac OSX Server CalDav server on a local host...

Skills Required: HTML5 , Mac OS , Mobile Phone
  • Fixed Price Project
  • $250-$750
  • 3 days, 10 hours left

Application Project 4

i want to develop an application like a web browser that connect only to my poker software and hosted in a web server can be connected with ios android windows device using any web browser players open my poker game and play through this web application more detail and feature will provide in the.

Skills Required: HTML5 , JavaScript , MySQL , PHP , Software Architecture
  • Fixed Price Project
  • $250-$500
  • 4 days, 10 hours left

Write Some Software

Hi, I require a Java based TCP listener "GPS gateway " which can read incoming data using threads. Since there will be a big load on the server for incoming connections, Big Load= 10,000 Devices reporting at an interval of 30 seconds...

  • Fixed Price Project
  • $250-$750
  • 5 days, 8 hours left

Wordpress Programmer

Seeking developer that specializes in coding and modifying WordPress We are looking for a developer who: - Is an expert at Wordpress - Experience coding a site from PSD to Wordpress...

Skills Required: HTML , HTML5 , PHP , PSD to HTML , Wordpress
  • Fixed Price Project
  • $25-$50
  • 5 days, 17 hours left

Website Abändern

Hallo, wir suchen einen Freelancer für die Überarbeitung unserer Website nach unseren Vorstellungen. Es müssen einige neue Grafiken auf die Site und unsere Preis- und Funktionsübersicht muss erneuert werden. Vorlagen und Vorstellungen haben wir schon, sodass das Konzept nur noch umgetzt werden muss

Skills Required: CSS , HTML , HTML5 , PSD to HTML , Website Design
  • Fixed Price Project
  • €30-€250
  • 1 week left

Job Details

  • Job Type
  • Fixed Price Job
  • Budget
  • €30-€250
  • Start Date
  • 02/06/2012 09:43:06 PM
  • Job Status
  • Job Expired