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
do not bid if you are a company or not time wasting freelancer . -- .Quality Graphic designer. html 5 , can start working from now. and you must a pro... very Quality fast and understanding requirement fast . thanks!
All i want is a mobile app for iOS(iPad & iPhone), Android and a Mobile website. There will be 2 apps: one for USERS/CUSTOMERS one for BUSINESS OWNERS (Manager Application) USER/CUSTOMERS (iPhone, Android APP ) The costumer who comes to the restaurant or cafe chooses the seat that he/she wants
Hi, The company would require a Wordpress developer who is specialised in HTML5/PHP/CSS3 in order to make slight alternations to our subsidiary company website, making slight alternations per week as required by our product manager to match our software's modern design updates...
Hello, The project is to build a website tool for searching domain name availability. The tool will check availability of domain names and provide screenshots/previews of the domain names to users...
I have my source code, I need to do some changes, nothing big. I need to add on Authorize.net payment gateway. I need to add another module for Cruises and Car rental (I have source code, for car rental), I need to change the way software calculate price of hotel rooms and other stuff..
I need help porting the design of my project into Kendo UI. The application has a mobile focus on iphone first and a lot of progress has been made. However, I have a deadline coming up and need additional help...
We are zeene.co a Peruvian startup specialized on content aggregation. In this project you will provide a simple validation and writing functionality for email input box...
hello friends in market already many mobile youtube scripts available. but here i want something different it it. i want a youtube based admin panel script. in admin panel i able add new youtube videos manually. mean i add youtube watch link. to related categories...