ComputerScienceExpert
$18/per page/
Please script the following pages (this uses PHP and MySQL):
Â
-Please script the following pages (this uses PHP and MySQL):
Â
-Create a login page called login.php, where you can enter your Employee_ID and Employee_Password.
-After clicking submit, it should then take the values you have entered and query the Employee table for them.
-If a matching record is found, it should then display a new page called success.php, which shows a welcome message.
-If a matching record is not found, it should display a new page called failure.php, which displays an error and provides a link back to the login page.
Â
-- phpMyAdmin SQL Dump-- version 4.5.1-- http://www.phpmyadmin.net---- Host: 127.0.0.1-- Generation Time: Jul 31, 2016 at 09:21 PM-- Server version: 10.1.13-MariaDB-- PHP Version: 7.0.8SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";SET time_zone = "+00:00";/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8mb4 */;---- Database: `phpproject`---- ------------------------------------------------------------ Table structure for table `customer`--CREATE TABLE `customer` (`Cust_ID` char(5) NOT NULL,`Cust_Fname` char(10) NOT NULL,`Cust_Lname` char(12) NOT NULL,`Cust_Password` char(8) NOT NULL,`Cust_email` char(15) DEFAULT NULL,`Cust_address` char(30) DEFAULT NULL,`Cust_city` char(12) DEFAULT NULL,`Cust_state` char(2) DEFAULT NULL,`Cust_zip` char(9) DEFAULT NULL,`Locked_flag` char(1) DEFAULT NULL,`Emp_ID` char(3) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1;---- Dumping data for table `customer`--INSERT INTO `customer` (`Cust_ID`, `Cust_Fname`, `Cust_Lname`, `Cust_Password`,`Cust_email`, `Cust_address`, `Cust_city`, `Cust_state`, `Cust_zip`,`Locked_flag`, `Emp_ID`) VALUES('1', 'Tim', 'Jones', 'abc123', 'tj@faux.com', '2365 Romrog Way', 'Funk', 'NE','68940', NULL, NULL),('2', 'Richard', 'Treadaway', 'abc1231', 'rt@rhyta.com', '454 American Drive','De Springs', 'FL', '32435', NULL, NULL),('3', 'Wanda', 'Bryant', 'abc12311', 'Wb@teleworm.us', '4316 Sweetwood Drive','Aurora', 'CO', '80010', NULL, NULL),('4', 'Linda', 'Flanagan', 'abc12321', 'LF@rhyta.com', '959 Zimmerman Lane','Los Angeles', 'CA', '90057', NULL, NULL),('5', 'Justin', 'Dow', 'abc12311', 'jd@teleworm.us', '4668 Baker Avenue','Arlington', 'TX', '76010', NULL, NULL);-- ------------------------------------------------------------ Table structure for table `employee`, where you can enter your Employee_ID and Employee_Password.
-After clicking submit, it should then take the values you have entered and query the Employee table for them.
-If a matching record is found, it should then display a new page called success.php, which shows a welcome message.
-If a matching record is not found, it should display a new page called failure.php, which displays an error and provides a link back to the login page.
Â
-- phpMyAdmin SQL Dump-- version 4.5.1-- http://www.phpmyadmin.net---- Host: 127.0.0.1-- Generation Time: Jul 31, 2016 at 09:21 PM-- Server version: 10.1.13-MariaDB-- PHP Version: 7.0.8SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";SET time_zone = "+00:00";/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8mb4 */;---- Database: `phpproject`---- ------------------------------------------------------------ Table structure for table `customer`--CREATE TABLE `customer` (`Cust_ID` char(5) NOT NULL,`Cust_Fname` char(10) NOT NULL,`Cust_Lname` char(12) NOT NULL,`Cust_Password` char(8) NOT NULL,`Cust_email` char(15) DEFAULT NULL,`Cust_address` char(30) DEFAULT NULL,`Cust_city` char(12) DEFAULT NULL,`Cust_state` char(2) DEFAULT NULL,`Cust_zip` char(9) DEFAULT NULL,`Locked_flag` char(1) DEFAULT NULL,`Emp_ID` char(3) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1;---- Dumping data for table `customer`--INSERT INTO `customer` (`Cust_ID`, `Cust_Fname`, `Cust_Lname`, `Cust_Password`,`Cust_email`, `Cust_address`, `Cust_city`, `Cust_state`, `Cust_zip`,`Locked_flag`, `Emp_ID`) VALUES('1', 'Tim', 'Jones', 'abc123', 'tj@faux.com', '2365 Romrog Way', 'Funk', 'NE','68940', NULL, NULL),('2', 'Richard', 'Treadaway', 'abc1231', 'rt@rhyta.com', '454 American Drive','De Springs', 'FL', '32435', NULL, NULL),('3', 'Wanda', 'Bryant', 'abc12311', 'Wb@teleworm.us', '4316 Sweetwood Drive','Aurora', 'CO', '80010', NULL, NULL),('4', 'Linda', 'Flanagan', 'abc12321', 'LF@rhyta.com', '959 Zimmerman Lane','Los Angeles', 'CA', '90057', NULL, NULL),('5', 'Justin', 'Dow', 'abc12311', 'jd@teleworm.us', '4668 Baker Avenue','Arlington', 'TX', '76010', NULL, NULL);-- ------------------------------------------------------------ Table structure for table `employee`