We need a routine to install in a website in developing for the login, made in this way:
Page HTML with form for fill username (input type="text" name="login_username") and password (input type="password" name="login_password"),
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:
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")
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.
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 */;
/*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
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...
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...
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...
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...
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...
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.
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...
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...
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