|
|
|
|
Search using the drop down list, or further refine your search using keywords.
|
|
|
|
|
 |
|
|
PHP and MySQL
Programming Courses |
|
|
|
This four day course will cover the fundamentals of using MySQL, PHP and SQL - all essential ingredients in building dynamic web applications. This is a practical, exercise driven course designed to establish a firm grounding in each technology and to explore how they combine allowing you to build sophisticated, bespoke web applications.
This course is designed for those new to working with PHP, MySQL and SQL (there is a two-day version of this course for those with some existing knowledge of programming in PHP). Both PHP and MySQL are increasingly popular open-source technologies and this course has been designed to give you the skills to fully utilise the power and flexibility they offer.
Feel free to tailor the following course outline to your exact requirements if you wish.
|
|
Introduction
• Using MySQL for database design
• The Apache web server
• The PHP programming environment
• Overview of SQL - Structured Query Language
• Installing Apache, PHP and MySQL
Overview of PHP
• The PHP Info function
• Embedding PHP in web pages
• Sending output to the browser
• Manipulating strings
• Adding comments
• The heredoc syntax
Working with Variables
• Double and single quotes
• Variables and heredoc
• Initialising Variables
• Setting Server Variables
Operators
• Arithmetic operators
• Comparison operators
• Logical operators
Collecting data
• Using the post or get method in forms
• Using shortcuts to collect form input
• Using the query string
The Date function
• The built-in date() function
• Using numbers
• Using calculations
• Formatting numbers
• Incrementing and decrementing
Manipulating strings
• Trimming strings
• The strlen() function
• More string functions
• The strtolower() function
• The strtoupper() function
• The ucfirst() function
• The ucword() function
• The addslashes() function |
The phpmyadmin control panel
• Administrating PHP
• Building a database
• Database terminology
Introduction to SQL
• SQL commands
• Comments
• SQL statements
• Clauses
• Identifiers
• Examples of Clauses in SQL statements
• Commonly used Clauses
• Using conditionals
Using SQL with MySQL
• Common types in MySQL
• Common data types
• Full text search
• Table types
• Inserting data into a table
Database design
• Selecting data from a table
• SQL Commands
• Database normalisation
• Web interface to MySQL
• MySQL functions
Administration
• Putting it all together
Combining PHP and MySQL
• Mysql_connect()
• Mysql_query()
• Mysql_result()
• Selecting specific records
Data-driven applications
• Building a web interface
• Showing and inserting records
• Searching records
• Updating records
• Deleting records
• Publishing and testing your site
Questions and answers |
|
If you'd like to book by phone, or discuss your requirements;
 Courses provided by partners Media Training.
|
|
|
|
|
|
|
