Course Details

PHP and MYSQL Classes

Course description

PHP MySQL Training is designed for Software Testing Professionals with a need to understand the PHP/MySQL in enough detail along with its simple overview, and practical examples. PHP MySQL Training will give you enough ingredients to start with base from where you can take yourself at higher level of expertise.

PHP is a programming language which is important for connecting and manipulating databases. The most popular and well known data base system used with PHP is MySQL.

Course Outline

Introduction • Why use PHP and MySQL? • The PHP programming environment • Overview of SQL Setting up a Test Server • Decisions about a testing environment • WAMP/MAMP • Installing Apache, PHP and MySQL on your computer • Testing on a remote Server • Deciding on Development tools • Using PHPMyAdmin

Overview of PHP • Setting up a PHP page • The phpinfo() function • Learning basic syntax • Echoing HTML output to the browser • The importance of comments • Using single and double quotes Variables in PHP • Using loose typed variables • Assigning variables • Overview of numeric, string and other types • Assigning a variable to itself Logical operators • Arithmetic operators • Logical operators • Comparisons • Operator precedence Numbers in PHP • Making calculations • Using built-in numeric functions • Incrementing and decrementing Strings in PHP • Concatenating strings • Trimming strings • Removing slashes and other harmful characters • String functions

Control structures in PHP • The If statement • FOR loops • While loops • The Switch Transferring information between PHP pages • GET and POST • Different form field types • Self-referencing forms • Form handlers Database fundamentals • Structuring a database • Using tables • Table relationships • Common data types Creating a database • Using PHPmyAdmin • Adding a table • Populating a table with types and data • Browsing a table with SQL Getting PHP to connect to MySQL • PHP5 and MySQL5 security features • Using mysqli_connect() • Testing a connnection • Mysqli and prepared statements • Using a positional placeholder • Writing a sample error trap Querying MySQL using PHP • Writing SQL queries • Using Select, Insert, Update and Delete • Querying MySQL and returning results • Interpreting the returned array Building a Web Application • Manipulating dynamic pages: - Add entries - Modify entries - List entries - Filter entries - PHP and XML Security features • Validating entries