Simple Mobile Shop in PHP MySQL with Source Code | Free Download |

The Simple Mobile Shop develop in PHP MySQL. Using CSS design, JavaScript, Backend PHP, Bootstrap, the main proposes of this web application to make faster and reliable. The customer before to buy need to register and login, it consists of two main components user side and admin side. The Admin can add update and delete information in admin area, the user they have their own username and password.

• Simple Mobile Shop
• Name of Project:     Simple Mobile Shop
• Language Used:      PHP
• Database Used:      My SQL
• Design Interface:    Bootstrap JavaScript, HTML, Ajax, JQuery,
• Browser:                  Opera Mozilla Google Chrome IE8,
• Software:                 WAMP/ XAMPP/ LAMP/MAMP

About System

How to setup this project

Step 1st. Download xampp

Step 2nd. Text editor notepad++ or Sublime

Step 3rd. Download the zip file/ Download winrar

Step 4th. Extract the file and copy “MobileShop-masterfolder

Step 5th. Paste inside root directory/ where you install xampp local disk C: drive D: drive E: paste: for xampp/htdocs,

Step 6th. Open PHPMyAdmin http://localhost/phpmyadmin

Step 7th. Create database name mobileshop

Step 8th. Import mobileshop.sql file given inside the zip package in SQL file folder

Step 9th. Run the script http://localhost/MobileShop-master

Step 10th. Password: Admin: haroun@gmail.com/ pass: 12345/ User: hr@ht.com / pass: 123

System Images

For a Little knowledge

Query Cache?

This lesson covers the query caching practical applications in improving you MySQL performance. It's another valuable component of MySQL that helps in maximizing the usage of commonly executed queries to lessen the time of retrieving records from your database tables.

Query Cache is a component of MySQL that caches the result of common queries executed and return to the user without having to re-execute the query each time. It stores syntax and results of SQL queries. If later this exact same query is to be executed, then the stored result can be used instead of having to search through all the affected tables in web applications, it normally happens that same queries are executed repeatedly.

Thus, it contributes to the network traffic, consumes a lot of memory and affects the overall performance of your server. With this, query caching minimizes some of the problems that may arise. Furthermore, the end results are extremely fast response times for business applications (data warehouses, business intelligence applications, web applications, OLTP systems, etc.

 Objectives

In this lesson, you should learn to:

• Understand query cache purpose in improving query performance in MySQL;
• Analyze query caching procedures
• Evaluate advantages of query caching;
• Activate query caching using query caching type in MySQL
• Monitor query cache storage requirements and variables.