Home > Web Developer Courses
Introduction to PHP with MySQL (4 days)
- Price : £850 + VAT
- Level : Intermediate
- Version : PHP 5.4 + or PHP7
- Venue : Jubilee Campus, Nottingham
- Duration : 4 days
- Times : 9:30am - 4:30pm
This 4 day intensive PHP course introduces the concepts web server programming and the delivery of dynamic content via the web.
|Introduction to PHP with MySQL (4 days)A 4 day, Introduction to PHP with MySQL training course hosted in Nottingham, East Midlands.EventScheduled£850Book Now5||1st - 4th April 2019||Nottingham, East Midlands, UK||4||0 left||finished|
|Introduction to PHP with MySQL (4 days)A 4 day, Introduction to PHP with MySQL training course hosted in Nottingham, East Midlands.EventScheduled£850Book Now6||22nd - 25th July 2019||Nottingham, East Midlands, UK||4||6 left||book now|
|Introduction to PHP with MySQL (4 days)A 4 day, Introduction to PHP with MySQL training course hosted in Nottingham, East Midlands.EventScheduled£850Book Now6||4th - 7th November 2019||Nottingham, East Midlands, UK||4||6 left||book now|
This course includes
- 4 days trainer led in small groups (typical maximum 6)
- Your own printed course manual
- Course files & exercises to take away
- Professional environment with high spec computers
- Refreshments throughout the day
- Lunch provided
- Printed course certificate
- Post course support via email
- Access to our FREE workshop days
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 learn how 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.
By the end of this PHP course students will understand the structure of the PHP language and be able to use built-in functions and methods to create the following kinds of components :
- a private / secure members area
- validated web forms
- content management systems (cms)
- simple shopping carts
- forums / message boards
- file uploaders
This course is aimed at web designers and developers with little or no experience of PHP who wish to learn how to develop web pages using PHP and MySQL. To get the most out of this course, students MUST already have some experience hand-coding HTML.
You should already know your own coding tools and be confident creating static HTML pages. Experience of any other programming language would be an advantage, but as previously stated, no knowledge of PHP or MySQL is required though.
A course primer document can be sent to students attending this course upon request. This can provide you with some basic knowledge of PHP prior to the start of the course and help you get the most from the training.
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 and 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 MySQL part of the course demonstrates how to create and populate a MySQL database using phpMyAdmin 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.
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 course looks at dealing with encoding and sending email 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.
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 Statements - 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
- Email Communication
- Using Mail Servers (SMTP and Sendmail) for Client Communication
- Configuring E-mail Output Parameters
- 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
"The course was very good and has given me the grounding knowledge to continue improving..." - Peter @ Shilling Ltd
"Provided me with a great grounding of the language, exactly what I was after. Excellent." - Alpesh @ Government Office
"I enjoyed the course immensely and I thought Bjorn was an excellent trainer of PHP. I would definitly like to come back to do a similar course sometime." - Andrew @ Capital One
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 8 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.
This PHP course is run from our rooms on Jubilee Campus in Nottingham, which is part of the University of Nottingham's Innovation Park. These are 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.
Please note that all course prices exclude VAT.