-
Cart
Registering for this site is easy. Just fill in the fields below, and we'll get a new account set up for you in no time.
Sign in to your One Education account
Ultimate PHP & MySQL Web Development & OOP Coding
Ultimate PHP & MySQL Web Development & OOP Coding
£29 ex Vat
Take This Course OR
1 Year Access 
Level 7
14 Students -
3 weeks, 4 days
Overview
Master PHP & MySQL by learning all the web development features for creating websites.
The Ultimate PHP & MySQL Web Development & OOP Coding course covers the A-Z of PHP programming, equipping learners with in-demand industry skills needed to develop websites and applications. It will take you through the fundamentals of PHP and MySQL, starting from the very basics for those who are new to the field.
This practical training course will explore all the core features of MySQL, as well as best practices for cross platform development, taught by an experienced expert in the field. If you are looking to establish a career in programming or computer science, then this in-depth training will ensure you gain a competitive edge in the job market.
Course design
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
- Video lessons
- Online study materials
Certificate of Achievement
Endorsed Certificate of Achievement from the Quality Licence Scheme
Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £129.00. Please note that overseas students may be charged an additional £10 for postage.
CPD Certificate of Achievement from One Education
Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99.
Endorsement
This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an endorsed lesson. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website.
Method of Assessment
To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support.
Why Study This Course
It doesn’t matter if you are an aspiring expert or absolute beginner; this course will enhance your expertise and boost your CV with critical skills and an acknowledged certificate attesting to your knowledge.
TheUltimate PHP & MySQL Web Development & OOP Coding is fully available to anyone, and no previous lessons are needed to enrol. All One Education needs to know is that you are eager to learn and are over 16.
Course Curriculum
| Section 01: Introduction & Setup | |||
| Introduction | 00:02:00 | ||
| Setup On Windows | 00:15:00 | ||
| Setup On Mac | 00:11:00 | ||
| Setup On Linux | 00:12:00 | ||
| Online Code Editor | 00:03:00 | ||
| Section 02: Basics | |||
| Basic File Syntax | 00:05:00 | ||
| Printing (echo) | 00:06:00 | ||
| Comments | 00:05:00 | ||
| Variables | 00:06:00 | ||
| Variable Data Types | 00:07:00 | ||
| Variable Naming | 00:03:00 | ||
| Constants | 00:02:00 | ||
| Arrays | 00:05:00 | ||
| Associative Arrays | 00:06:00 | ||
| Multidimensional Arrays | 00:04:00 | ||
| Section 03: Control Structures | |||
| if Statement | 00:06:00 | ||
| if…else Statement | 00:02:00 | ||
| if…elseif…else Statement | 00:05:00 | ||
| Switch Statement | 00:06:00 | ||
| while Loop | 00:06:00 | ||
| do…While Loop | 00:03:00 | ||
| for Loop | 00:03:00 | ||
| foreach Loop | 00:05:00 | ||
| Break Statement | 00:02:00 | ||
| Continue Statement | 00:02:00 | ||
| Section 04: Functions | |||
| Basic Function | 00:03:00 | ||
| Passing Function Arguments | 00:03:00 | ||
| Passing Function Arguments By Reference | 00:04:00 | ||
| Default Argument Value | 00:02:00 | ||
| Function Returning Values | 00:05:00 | ||
| Dynamic Function Calls | 00:03:00 | ||
| Variable Scope | 00:04:00 | ||
| Section 05: Forms | |||
| Simple HTML Form | 00:07:00 | ||
| GET vs POST | 00:05:00 | ||
| $_SERVER [“PHP_SELF”] | 00:07:00 | ||
| Validating Form Data With PHP | 00:07:00 | ||
| Required Fields | 00:05:00 | ||
| Display Error Messages | 00:05:00 | ||
| Validate Name | 00:03:00 | ||
| Validate Email | 00:03:00 | ||
| Validate URL | 00:07:00 | ||
| Keep The Values In The Form | 00:04:00 | ||
| Section 06: File Handling | |||
| Read File (readfile()) | 00:02:00 | ||
| Open, Read & Close A File (fopen(), fread(), fclose()) | 00:04:00 | ||
| Read Single Line (fgets()) | 00:03:00 | ||
| Check End-Of-File (feof()) | 00:02:00 | ||
| Read Single Character (fgetc()) | 00:02:00 | ||
| Write To File (fwrite()) | 00:03:00 | ||
| Configure php.ini File For File Uploading | 00:02:00 | ||
| Front End HTML Upload Form | 00:04:00 | ||
| PHP Upload Script | 00:15:00 | ||
| Check If File Exists | 00:03:00 | ||
| Limit File Size | 00:05:00 | ||
| Limit File Type | 00:04:00 | ||
| Section 07: MySQL | |||
| MySQL vs MySQLi vs PDO | 00:05:00 | ||
| Creating A Database & Table (phpMyAdmin) | 00:06:00 | ||
| Connecting To A Database | 00:06:00 | ||
| Get Data Using SELECT Query | 00:10:00 | ||
| WHERE Property For Filtering | 00:03:00 | ||
| LIKE Property For Pattern Search | 00:02:00 | ||
| Sorting Results Using ORDER BY Property | 00:01:00 | ||
| Using JOINS | 00:08:00 | ||
| Insert Data Using INSERT Query | 00:04:00 | ||
| Get ID Of The Last Inserted Row | 00:02:00 | ||
| Insert Multiple Rows | 00:05:00 | ||
| Update Data Using UPDATE Query | 00:03:00 | ||
| Delete Data Using DELETE Query | 00:02:00 | ||
| Delete All Rows In A Table Using TRUNCATE Query | 00:02:00 | ||
| Delete Table Using DROP Query | 00:02:00 | ||
| Limit Data Selections Using LIMIT, ROWNUM | 00:04:00 | ||
| Create Table Using CREATE Query | 00:03:00 | ||
| Clone/Duplicate Table | 00:03:00 | ||
| Alter Table | 00:05:00 | ||
| Create Database | 00:02:00 | ||
| Drop Database | 00:02:00 | ||
| SQL Injection & Prepared Statements | 00:09:00 | ||
| Section 08: XML | |||
| What Is XML? | 00:02:00 | ||
| What Is SimpleXML? | 00:02:00 | ||
| Parse XML String | 00:08:00 | ||
| Parse XML File | 00:02:00 | ||
| Get Node Values | 00:02:00 | ||
| Get Node Values of Specific Elements | 00:03:00 | ||
| Get Node Values – Loop | 00:03:00 | ||
| Get Attribute Values | 00:02:00 | ||
| What Is The XML Expat Parser? | 00:02:00 | ||
| Initializing The XML Expat Parser | 00:10:00 | ||
| Load and Output XML Using DOM Parser | 00:02:00 | ||
| Looping Through XML Using DOM Parser | 00:03:00 | ||
| Section 09: AJAX | |||
| What Is AJAX? | 00:02:00 | ||
| Load Simple Data Using AJAX Front End | 00:08:00 | ||
| Load Simple Data Using AJAX Back End | 00:05:00 | ||
| Load Data From A Database Using AJAX | 00:08:00 | ||
| Section 10: Emails | |||
| Send A Plain Text Email | 00:04:00 | ||
| Send A HTML Email | 00:06:00 | ||
| Email Attachments | 00:17:00 | ||
| PHPMailer Setup | 00:03:00 | ||
| Send Email Using PHPMailer | 00:04:00 | ||
| Send HTML Email Using PHPMailer | 00:04:00 | ||
| Email Attachments Using PHPMailer | 00:02:00 | ||
| Section 11: Object Oriented Programming | |||
| What Is Object Oriented Programming (OOP)? | 00:03:00 | ||
| Basic Class With Variables | 00:04:00 | ||
| Functions | 00:05:00 | ||
| Constructor | 00:04:00 | ||
| Destructor | 00:02:00 | ||
| Inheritance | 00:06:00 | ||
| Multi Class Inheritance | 00:03:00 | ||
| Function Overriding | 00:03:00 | ||
| Public vs Private vs Protected | 00:05:00 | ||
| Interfaces | 00:04:00 | ||
| Constants | 00:03:00 | ||
| Abstract Class | 00:06:00 | ||
| Static Keyword | 00:03:00 | ||
| Final Keyword | 00:02:00 | ||
| Initiating Parent Constructor | 00:02:00 | ||
| Section 12: Error Handling | |||
| die() Function | 00:02:00 | ||
| Custom Error Handler | 00:04:00 | ||
| Triggering An Exception | 00:03:00 | ||
| Exception Handling | 00:05:00 | ||
| Create Database & Table | 00:04:00 | ||
| User Class & Database Connection | 00:15:00 | ||
| Register User Form | 00:09:00 | ||
| Inserting User Data Into Database | 00:10:00 | ||
| Registration Form Field Validation | 00:12:00 | ||
| Securing User Password | 00:03:00 | ||
| Check If Username or Email Already Exists | 00:11:00 | ||
| Retain Data After Failed Registration | 00:03:00 | ||
| Section 13: Advanced | |||
| Validate an Integer Within a Range | 00:04:00 | ||
| Validate IPv6 Address | 00:03:00 | ||
| Validate URL – Must Contain QueryString | 00:03:00 | ||
| Remove Characters With ASCII Value > 127 | 00:04:00 | ||
| Including & Requiring External PHP Files | 00:05:00 | ||
| Section 14 : Resource | |||
| Resource | 00:00:00 | ||
| Assignment | |||
| Assignment – Ultimate PHP & MySQL Web Development & OOP Coding | 3 weeks, 3 days | ||
| Order Your Certificate | |||
| Order Your Certificate QLS | 00:00:00 | ||
Related Courses
Intermediate
Intermediate
Important Links
- Affiliate
With a team of industry professionals producing and delivering our course content, you can be sure the skills and knowledge you learn are applicable to your career aspirations, whether that’s in management, administration or beyond.
0
0
Your Cart
Your cart is emptyBrowse Courses
Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year
Claim Offer & UpgradeMembership renews after 12 months. You can cancel anytime from your account.
Other Students Also Buy
-
Get Lifetime Access To Your Course£9.99 Add to basket+Add