Home > Web Developer Courses
Introduction to PHP with MySQL (4 days)
This four day PHP course introduces web designers to the PHP programming language and the delivery of dynamic content for the web. There is a focus on connecting to MySQL databases via PHP and working with live content.
Our top priority is your safety. Courses will be limited to 4 delegates per session with strict social distancing restrictions in place. The University have put in special measures to ensure all areas within our building are sanitised regularly. Special attention is paid to the cleaning of desks, chairs, screens, keyboards, mousemats and mice.
Due to the situation, the on-site restaurant is not yet open, so we are unable to provide catered lunches until further notice. We encourage you to bring lunch and refreshments, although we will have drinks and refreshments available with a good supply of hand sanitiser and antibacterial wipes.
Click here to see our full Covid-19 Secure statement.
- Price : £850 + VAT
- Level : Intermediate
- Version : 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.
|-||East Midlands, UK||4||0 left||finished|
|-||East Midlands, UK||4||0 left||finished|
|-||East Midlands, UK||4||0 left||full|
This PHP course includes
- 4 days trainer led in small groups
- Your own printed course manual
- Course files & exercises to take away
- Choice of PC or Mac for training
- 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.
PHP Course Highlights
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
PHP Course Feedback - 4.9 out of 5.0 stars
"The amount of knowledge that the trainer had on the subject. - A really well structured course with good practical exercises." - Jack @ Brush Electrical Machines
"Trainer's knowledge of the subject - " - Jocelyn @ The University Of Nottingham
"Good introduction to how to construct loops, arrays etc. and nice to have working example of how to build parts of a CMS. - Fantastic course, well presented and have already recommended to others." - Adam
"Good explanation of PHP and MySql - Great course, would like to attend the open days" - Douglas
"Bjorn knew his topic. There were no questions I had that Bjorn did not answer and they were all answered impeccably. The course flowed neatly from one section to the other and the pace was just right. - I feel that I came away buzzing with knowledge about how to achieve what it is that I need to do. I feel confident that I will be able to create the code I want now and I know the resources to turn to if I get stuck." - Rob
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 15 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.