Book Description

Second Edition April 2015, revised and updated. Written from a series of college lectures on PHP and MySQL, this book is a practical look at programming. It starts with an introduction to PHP and then goes on to MySQL and how to use SQL with the PHP language. It provides an introduction to web programming, how to display data from a database and update data to the database. It explains issues that you encounter in real world situations and provides the basic code from which you can then use to further develop. It would be helpful if you have some HTML knowledge, but the examples should provide you with what you need to know. It would also be helpful to have had some experience in programming using one of the more popular languages such as Visual Basic, although this is not necessary. Many of the tutorials consists of a series of examples and tasks which illustrate each point and concentrate on simplified code so that you can see how they are used. * Introduction - Basic PHP concepts. * Variables - Variables, programming techniques and so on. * Forms and PHP - Posting data between forms. * Arrays - loops and array structures. * Basic PHP structures - include files and how to use them. * Functions - writing and using your own functions. * Posting Forms - how forms work. * Email Forms - an email form. * JavaScript - posting forms with JavaScript. * SQL and MySQL - Querying database tables using SQL. * An Example table - some example data. * Database Access - how to connect to a database. * Using PHP and MySQL - an example form. * Further PHP and MySQL - More PHP and MySQL. * OpenCart - an example of an Open Source project. * Error handling and debugging - Simple methods to find errors. * Cookies and sessions - When and where to use them. * Modifying Records - editing and updating databases with PHP and SQL. * Classes - An introduction to object orientated programming. * File Handling - Reading and writing to text files. * Regular Expressions and Validation - Some validation methods. * PHP security - Some methods to overcome this issue. * JQuery - An introduction to jQuery. * htaccess and php.ini - how to use them. * WordPress - an introduction to creating a WordPress Plugin.