2. Application Security: Local Test Environment Setup - XAMPP

Step 1: Download XAMPP from www.apachefrie...
Step 2: Configure XAMPP (httpd.conf - Apache server configuration)
Search for Listen 80 and change port to 81
Step 3: phpmyadmin - Database setup for Demo apps
a. Access localhost:81/phpmyadmin/index.php
b. Create database basics and execute following queries
CREATE TABLE jsdemo(fname VARCHAR(30),lname VARCHAR(30),address VARCHAR(250),phone VARCHAR(10));
CREATE TABLE dbdemo(fname VARCHAR(30),lname VARCHAR(30),address VARCHAR(250),phone VARCHAR(10));
c. Create database vsocial and execute following queries
CREATE TABLE users(username VARCHAR(30),password VARCHAR(25),fname VARCHAR(30),lname VARCHAR(30),address VARCHAR(250),pic VARCHAR(250));
CREATE TABLE admins(username VARCHAR(30),password VARCHAR(25),fname VARCHAR(30),lname VARCHAR(30),address VARCHAR(250),pic VARCHAR(250));
CREATE TABLE bloggers(username VARCHAR(30),password VARCHAR(25),fname VARCHAR(30),lname VARCHAR(30),address VARCHAR(250),pic VARCHAR(250));
CREATE TABLE blogs(author VARCHAR(30),title VARCHAR(250),body VARCHAR(1500));
CREATE TABLE messages(username VARCHAR(30),message VARCHAR(300),sender VARCHAR(30));
INSERT INTO `admins`(`username`, `password`) VALUES('admin','admin');
INSERT INTO `admins`(`username`, `password`) VALUES('Steve','steve');
INSERT INTO `admins`(`username`, `password`) VALUES('Bob','bob');
Step 4: Download Demo Apps from
github.com/sar...
github.com/sar...
Step 5: Put Demo apps in XAMPP-htdocs
C:\xampp\htdocs\
Step 6: Access Demo Apps using Browser
JavaScript & HTML Basic app:
localhost:81/Basics/JS/withoutJS.html
localhost:81/Basics/JS/withJS.html
localhost:81/Basics/JS/DOMjs.html
Database Basic app:
localhost:81/Basics/DB/Main.html
vSocial:
localhost:81/Vsocial/Home.php