4
Before Install XAMPP ROOT privilege required Incapable with Unix/BSD Incapable with some Linux Distribution Red-Hat related or similar Linux Distribution Service are related to below must be halted Web Servings SQLs FTPs

5
Download XAMPP Use Command: ‘wget’ to Download: Does not have wget: Debian Based: apt-get install wget Other refer the man page to install wget Download in your home directory by default

15
Project: A computer store database Including all information of a computer Similar the cases as the same as the customer require Correct errors, ether the datatype or data in Database. Delete the record when computer was sold out.

19
Create Database What happened with Latin1?: Does not support Non-Latin Words: That also means can’t store Chinese character Some of the Computer Brands or Model are Chinese: 清華同方 超瑞 X200 Too much Non-Latins accidentally stored will crash MySQL

36
Situation – Customers Request A Customer Request for any Computers bigger than 13 Inches Also, He does not need too detail of computer specification Result:

37
Situation – Sold When a item was sold, it must be removed from database: Aspire V3-551G was sold: Result:

38
Thoughts: Linux is a ultra-flexible platform, but somehow complex I recommend XAMPP to beginners because to setup such environment on Linux is a lot of hassle and sometimes need patients to troubleshooting.