Course Dates
- No course dates are available...
The combination of PHP and MySQL are today's leading open source web development platform. This PHP server side scripting language has evolved from being merely a source of dynamic web content to providing the connectivity and infrastructure of many modern day web businesses. PHP is flexible enough for any developer to create anything from Content Management Systems (CMS) and forums to simple polls and fully fledged e-commerce systems.
The MySQL database engine is the natural partner for most PHP implementations and has a proven track record, powering high-traffic web sites such as Facebook, Wikipedia and YouTube.
This PHP course with MySQL introduces the concepts web server programming and the delivery of dynamic content via the web. Our aim is to provide students with the constructs of the PHP language and a good understanding of connecting to MySQL databases so that they are able to start implementing both simple and more complex web solutions. An emphasis is placed on learning the techniques to create a solid foundation for developing dynamic web sites.
Course Requirements
This course is aimed at developers with little or no experience of PHP who wish to develop web pages using PHP and MySQL.
To get the most out of this course, students should already have some experience hand-coding HTML. As previously stated, no knowledge of PHP or MySQL is required though.
Course Description
The PHP course starts by introducing PHP and looking at what the language is capable of and even some of its limitations. This is useful so that students are able to put into context which web components are best created with PHP and MySQL and which should be created using other technologies.
Setting up a testing server is covered so that students are able to test their websites locally without needing to have a PHP enabled space hosted online. Included in this is a look at configuring the php.ini file that is used to control the PHP interpreter. Students are welcome to bring along their own laptops if they would like to practically do this with help from the course trainer.
The course then investigates the structure of PHP syntax and the use of variables. This is followed by brief look at various data types and the ability to type cast in PHP. Conditional statements and looping constructs are a particularly early focus in the course as these will allow students to make data based decisions and iterate though processes and results to produce content; the grass roots of any dynamic web page.
The course then looks at both predefined and user functions which can optimise web programming processes by creating reusable code that reduces and even negates the need to rewrite existing code. Many of these functions work particularly well with the array data type.
The input and output section of the course deals with manipulating and formatting information using the vast number of built in PHP string functions. These are important as much of PHP is about preparing information for display on a web page. There is also an extensive look at reading and writing files to the web server which offers a means of allowing users to safely upload files to private or public areas on the server via simple HTML forms.
The course introduces regular expression support in PHP. This helps make data validation a relatively easy process and means that checking form content can take only a couple of lines of code.
Once session variables and cookies are introduced it is then possible to create secure login areas and track user interaction within your website. For many attending the PHP course, this is one of the key pieces of functionality that most are extremely eager to implement. This is all explained alongside with a good background of the security implications of using these features.
The MySQL part of the course demonstrates how to create and populate a MySQL database using both phpMyAdmin and SQL Manager as well with SQL statements directly from PHP. Once the database is ready, the course focuses on querying and managing information within the database using native SQL queries.
Finally the course looks at dealing with encoding and sending via PHP. Although this is often straight forward, most web hosts will require prior authentication with an SMTP server. This will be covered using the PHP Mailer class as well as the basic PHP mail command.
Course Trainer
Bjorn has had a very special interest in software development ever since writing his first programs in Basic on the TRS-80 back in the early 80s. With experience writing code in everything from M68000 assembler to PHP, he has worked as both a freelance developer and as a software development team leader. With 5 years experience in PHP, working on everything from bespoke content management systems to ecommerce implementations, he is able to pass on all the skills needed to help students start developing their own dynamic solutions.
Course Location
This PHP course is run from our rooms in Nottingham's prestigious Lace Market area which is a part of the city's main commercial district. This is serviced by a state-of-the-art tram system allowing easy access to the city centre as well as direct hourly rail services from London, Liverpool, Manchester, Birmingham, Derby and Leicester.
Course Details
- Course Duration :
4 days | 9.30am - 5pm - Course Location :
Lace Market, Nottingham, UK - Course Price :
£595 - Software Version :
PHP 5
Course Overview
The course covers the following areas :
- Introduction to Web Server Programming
- Overview of PHP Capabilities
- Setting up a Testing Server
- Overview of Development Environments
- Basic Scripting Syntax
- PHP Code Blocks
- Print & Echo Statements
- Basic Language Constructs
- Defining Constants and Variables - Data Types
- Conditional Constructs - if, else, elseif
- Nesting Conditions
- Looping Constructs - do, while, for, foreach
- Introduction to Functions
- Variable Scope
- Passing and Returning Arguments through Functions
- Using Include Files
- Predefined PHP Functions
- Array Functions
- Input and Output
- String Functions
- Regular Expression Functions
- Reading, Writing and Deleting Files
- Reading Directory Contents
- Working with Forms - GET and POST
- Authentication and Authorization
- Data Validation
- User and Session Tracking
- Working with Cookies
- Tracking Visitors with Session IDs
- MySQL Database Connectivity
- Building a MySQL database
- PHP's SQL API
- Connecting to MySQL
- Simple SQL Queries via PHP to SELECT, INSERT, DELETE and UPDATE Database Records
- Executing SQL Calls
- Email Communication
- Using Mail Servers (SMTP and Sendmail) for Client Communication
- Configuring E-mail Output Parameters