Back to Courses
Ultimate PHP & MySQL Web Development Course & OOP Coding
Unlock the secrets of PHP and MySQL web development with this comprehensive course. Learn the basics of PHP and MySQL and object-oriented programming (OOP) concepts to create dynamic and interactive websites and web applications.
Course Highlights
Step into the digital age with power and precision as you unravel the intricacies of the Ultimate PHP & MySQL Web Development Course & OOP Coding. This journey doesn’t just introduce you to coding; it invites you to command the world of web development with expertise. From the foundational stone of setup and introduction to the towering complexities of advanced techniques, every step you take will amplify your understanding and dexterity.
Navigating through this course, you’ll find yourself adeptly maneuvering through PHP’s control structures, crafting functions with finesse, and designing forms that seamlessly integrate into diverse platforms. Grasping file handling will be a breeze, while MySQL will transform you into a maestro of database operations. But that’s not all! Learn to seamlessly integrate XML, utilize the efficiency of AJAX, and manage emails effectively, all while developing a profound understanding of the tenets of Object Oriented Programming.
As the course reaches its zenith, it’s not just about coding but mastering error handling, ensuring your codes run smoothly, and tapping into a reservoir of resources that will be your compass in the vast sea of web development. By the end, you won’t just be a coder; you’ll be a craftsman of the web, ready to sculpt digital masterpieces.
Learning outcome
- Learn the basics of PHP programming, including variables, data types, operators, and control structures.
- Learn how to connect to a MySQL database and perform basic database operations.
- Create dynamic and interactive websites and web applications using PHP and MySQL.
- Learn about OOP concepts in PHP, such as classes, objects, inheritance, and polymorphism.
- Learn about more advanced PHP topics, such as file handling, XML, AJAX, and emails.
Course media
Why should I take this course?
- Learn the most in-demand web development skills.
- Create dynamic and interactive websites and web applications.
- Boost your career prospects and earn a higher salary.
- Join a community of thousands of successful PHP developers.
- Learn from experienced and passionate instructors.
Career Path
- PHP Developer
- Web Developer
- Full-Stack Developer
- Software Engineer
- Database Administrator
Requirements
- Basic understanding of programming concepts.
- Access to a computer with PHP and MySQL installed.
- Eagerness to dive into the world of web development.
Course Curriculum
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 | 00:00:00 | ||
Don't just take our word for it
Amazing workshop.
Very informative for the freshers like me. Learned a lot of things about digital marketing. I'm really thankful.
Aarini Sinha 
It was a great experience. The course was jampacked with excellent information. And when I needed help, Skill-up helped me with technical problems instantly. Fast feedback.
Varsha Sivamohan 
I am currently signed on to several courses with skill up. I have just finished my second one. The courses are informative and good for all types of learners. I recommend them.
Judith Taylor 
The support team was FANTASTIC!!! Very quick to respond and even though I was nervous as I am not good at tests, they made me feel comfortable.
I am very grateful for the support
Charlie Anderson 
Completed the Level 3 Mental Health Support Worker course, very good and highly recommend it.
Very good course, enjoyed it thoroughly and important in my line of work as a Support worker.
Parmjit Dosanjh 
I am pleased to have completed my online course in Mental Health First Aid with SkillUp. All the modules were detailed & comprehensive with review questions, which really helped me to grasp the information & prepared me well for the mock test & final exam.
Shan 
I was a bit nervous about the course but I gave a try,it's perfect and I still can't believe I paid a peanut to acquire such a course,the sliding show and introduction was well understood.i will recommend skill up to anyone interested to persuade a meaningful career,and also to the support team keep doing the good work.💪
Sara Nana 
1 Year Access 
62 Students 
10 hours, 6 minutes 
