About This Book Total length of this book is 308 pages, it includes two parts: 1. PHP MYSQL Programming for Beginners 2. PHP MYSQL Real World Code & Explanations. Part 1: "PHP MYSQL Programming" is a textbook for high school and college students; it covers all essential PHP MYSQL language knowledge . You can learn complete primary skills of PHP MYSQL programming fast and easily . The textbook includes a lot of practical examples for beginners and includes exercises for the college final exam, the engineer certification exam, and the job interview exam . Part 2: "PHP MYSQL Real World Code" includes a lot of PHP MYSQL practical examples & explanations for beginners . Through these useful examples & explanations, you can study PHP MYSQL programming skills in depth, master skillfully the PHP MYSQL coding knowledge, and become an expert of PHP MYSQL programming . These examples & explanations cover various types of PHP MYSQL programming skills, such as operators, statement, array, string, function, class, object, file processing, exception …… , which can be applied to the real PHP MYSQL programming work . Table of Contents Part One Programming for Beginners Chapter 1 What is PHP? Install PHP & MySQL ..... Chapter 2 Conditional Operator Arithmetical Operators ..... Chapter 3 Create an Array array element values ..... Chapter 4 Create a Form ..... Chapter 5 Date & Time String Functions ..... Chapter 6 Class Object ..... Chapter 7 What is MySQL? MySQL Data Type ..... Chapter 8 Require a File Include a File ..... PHP MySQL Q & A Questions Answers Part Two Real World Code & Explanations 01. The Greenwich Mean Time 02. Create some random numbers 03, Arithmetical calculation 04. Reverse a number 05. Reverse a string 06. Swap two numbers 07. Check prime number 08. Check if a string contains a specified word 09. The area of a triangle 10. The area of a rectangle 11. Print a triangle pattern 12. Print a diamond pattern 13. The sum from 1 to 100 14. Conversion between bin & dec 15. Conversion between miles & kilometers 16. The largest number among three numbers 17. Count characters & words 18. A 9x9 multiplication table 19. The greatest common divisor 20. The least common multiple 21. Login page 22. Select our favorite car 23. A simple calculator 24. Count how many persons visiting us 25. Select a website to visit 26. Upload a photo 27. Words processing 28. Using session 29. Using cookie 30. Create a MySQL database using PHP 31. Connect to a MySQL server using PHP 32. Create a table in an existing database 33. Insert data into a "members" table 34. Query the database and fetch data 35. Update data in a MySQL table 36. Use PHP to sort data from a MySQL table 37. Alter table and modify data 38. Delete a row from a MySQL table