Please use your knowledge about html5 (client-side), php (server-side), and MySQ
ID: 3831894 • Letter: P
Question
Please use your knowledge about html5 (client-side), php (server-side), and MySQL (database), to develop a simple banking website with 4 basic features: log in (20 points), log out (20), deposit (25 points), withdraw (25 points), and get balance (10 points). Please make sure that all 5 features can perform correctly.
Your html web page should follow the format below:
After log in:
/*sample banking (longin - checkBalance - deposit - withdraw) dataset*/
CREATE DATABASE `classicmodels`;
USE `classicmodels`;
/*Table structure for table `customers` */
DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers` (
`lastName` varchar(50) NOT NULL,
`firstName` varchar(50) NOT NULL,
`email` varchar(100) NOT NULL,
`password` varchar(10) NOT NULL,
`balance` int(11) DEFAULT NULL
);
/*Data for the table `employees` */
insert into `customers`(`lastName`,`firstName`,`email`,`password`,`balance`) values
('Murphy','Diane','dmurphy@edu.com','123456',500),
('Patterson','Mary','mpatterso@edu.com','123456',1000),
('Firrelli','Jeff','jfirrelli@edu.com','123456',2000),
('Patterson','William','wpatterson@edu.com','123456',200),
('Bondur','Gerard','gbondur@edu.com','123456',50),
('Bow','Anthony','abow@edu.com','123456',0),
('Jennings','Leslie','ljennings@edu.com','123456',300),
('Thompson','Leslie','lthompson@edu.com','123456',20000),
('Firrelli','Julie','jfirrelli@edu.com','123456',15000),
('Patterson','Steve','spatterson@edu.com','123456',900);
Title Lab3 HTML and web programming banking example Email Deposit Password Submit Withdraw Submit Submit Get balance Log out Frame 1 Frame 2 TableExplanation / Answer
Client-side scripting — which includes HTML and CSS — is any code that runs within a web browser. This means that the web browser temporarily downloads all the files from a web server and, in turn, displays a static web page; you would be able to view these files even if you lost your Internet connection (as long as you left your web browser open). JavaScript most commonly used client-side scripts.
JavaScript
Most of us think that JavaScript is somewhat related to Java because of its name. But it’s not true!!! JavaScript is not related to Java; just it is having syntactic similarity.
Actually, when JavaScript was invented at Netscape, its name was LiveScript. In May 1995 JavaScript was written in only 10 days by Brendan Eich who was working at Netscape. In December 1995 after receiving trademark license from Sun Microsystems (home of Java), the name JavaScript was adopted. We use JavaScript with HTML and CSS at the front end for validating a form, animating the HTML document.
Simply JavaScript makes a web page more interactive. JavaScript does all validation operation to the browser side and saves data from mismatching to the server side which can cause the crash of the database.
One more interesting fact about JavaScript is that we can make games using HTML Canvas and JavaScript. There are many games developed using JavaScript. Some examples are Frog hop, Backgammon, Checkers, Tic Tac Toe and so many. HTML canvas is used for drawing graphics on the web page with the help of JavaScript. It can be used to draw graphs, make photo compositions or to do simple animations.
JavaScript is a fascinating language and has its wide end use. JavaScript is world’s most popular and most widely used language.
A database is the organized collection of data which helps a user to populate different data in a well-structured format. A database system is computer software application, it interacts with the user, middleware application, and database to capture and analyze data. Well, known Database systems include MySQL, PostgreSQL, MongoDB, Microsoft SQL Server, Oracle, Sybase, SAP HANA and many others. The database system is generally portable for different DBMS systems as well as incorporate with others system using SQL standard.
As recent trends in IT culture, every system or application need to work with large amount of data sets which may be in, rough or unstructured formats. Database system helps to deliver solutions with the kind of different approaches. MySQL is the open source database application software systems, which helps the developer to develop the user-friendly environment. The scope of MySQL system is available with every working application and provides developers work in flexible systems.
MySQL system is open for every soft-technology user who wants to work with a flexible and strong database.