learn@excellence.institute

Overview:

Welcome to "Ultimate PHP & MySQL Web Development & OOP Coding"! This comprehensive course is your gateway to mastering PHP, MySQL, and Object-Oriented Programming (OOP) for web development. PHP and MySQL are the backbone of dynamic web applications, and understanding how to leverage them effectively is essential for web developers. In this course, you'll learn how to build dynamic and interactive web applications using PHP, MySQL, and OOP principles.
  • Interactive video lectures by industry experts
  • Instant e-certificate and hard copy dispatch by next working day
  • Fully online, interactive course with Professional voice-over
  • Developed by qualified first aid professionals
  • Self paced learning and laptop, tablet, smartphone friendly
  • 24/7 Learning Assistance
  • Discounts on bulk purchases

Main Course Features:

  • In-depth coverage of PHP programming fundamentals and syntax
  • Practical projects and coding exercises for hands-on learning
  • Comprehensive instruction on MySQL database design, querying, and management
  • Exploration of Object-Oriented Programming (OOP) principles and techniques in PHP
  • Implementation of dynamic web applications with PHP and MySQL integration
  • Guidance on building secure and scalable web applications using best practices
  • Real-world case studies and examples showcasing PHP and MySQL applications in web development
  • Access to resources and tools for continued learning and practice in PHP, MySQL, and OOP coding

Who Should Take This Course:

  • Aspiring web developers looking to build a strong foundation in PHP and MySQL for web development
  • Students and professionals seeking to enhance their skills in building dynamic and interactive web applications
  • Programmers and developers interested in transitioning to a career in web development
  • Anyone interested in learning Object-Oriented Programming (OOP) principles and applying them in PHP coding

Learning Outcomes:

  • Master PHP programming fundamentals and syntax for web development
  • Understand MySQL database design, querying, and management
  • Apply Object-Oriented Programming (OOP) principles to PHP coding
  • Develop dynamic and interactive web applications using PHP and MySQL
  • Implement secure and scalable web applications following best practices
  • Gain practical experience through hands-on projects and coding exercises
  • Build a portfolio of web development projects showcasing proficiency in PHP, MySQL, and OOP coding
  • Stay updated with the latest advancements and trends in PHP and MySQL web development.

Certification

Once you’ve successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Assessment

At the end of the Course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven’t, there’s no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself.

  • Introduction
  • Setup On Windows
  • Setup On Mac
  • Setup On Linux
  • Online Code Editor
  • Basic File Syntax
  • Printing (echo)
  • Comments
  • Variables
  • Variable Data Types
  • Variable Naming
  • Constants
  • Arrays
  • Associative Arrays
  • Multidimensional Arrays
  • if Statement
  • if…else Statement
  • if…elseif…else Statement
  • Switch Statement
  • while Loop
  • do…While Loop
  • for Loop
  • foreach Loop
  • Break Statement
  • Continue Statement
  • Basic Function
  • Passing Function Arguments
  • Passing Function Arguments By Reference
  • Default Argument Value
  • Function Returning Values
  • Dynamic Function Calls
  • Variable Scope
  • Simple HTML Form
  • GET vs POST
  • $_SERVER [“PHP_SELF”]
  • Validating Form Data With PHP
  • Required Fields
  • Display Error Messages
  • Validate Name
  • Validate Email
  • Validate URL
  • Keep The Values In The Form
  • Read File (readfile())
  • Open, Read & Close A File (fopen(), fread(), fclose())
  • Read Single Line (fgets())
  • Check End-Of-File (feof())
  • Read Single Character (fgetc())
  • Write To File (fwrite())
  • Configure php.ini File For File Uploading
  • Front End HTML Upload Form
  • PHP Upload Script
  • Check If File Exists
  • Limit File Size
  • Limit File Type
  • MySQL vs MySQLi vs PDO
  • Creating A Database & Table (phpMyAdmin)
  • Connecting To A Database
  • Get Data Using SELECT Query
  • WHERE Property For Filtering
  • LIKE Property For Pattern Search
  • Sorting Results Using ORDER BY Property
  • Using JOINS
  • Insert Data Using INSERT Query
  • Get ID Of The Last Inserted Row
  • Insert Multiple Rows
  • Update Data Using UPDATE Query
  • Delete Data Using DELETE Query
  • Delete All Rows In A Table Using TRUNCATE Query
  • Delete Table Using DROP Query
  • Limit Data Selections Using LIMIT, ROWNUM
  • Create Table Using CREATE Query
  • Clone/Duplicate Table
  • Alter Table
  • Create Database
  • Drop Database
  • SQL Injection & Prepared Statements
  • What Is XML?
  • What Is SimpleXML?
  • Parse XML String
  • Parse XML File
  • Get Node Values
  • Get Node Values of Specific Elements
  • Get Node Values – Loop
  • Get Attribute Values
  • What Is The XML Expat Parser?
  • Initializing The XML Expat Parser
  • Load and Output XML Using DOM Parser
  • Looping Through XML Using DOM Parser
  • What Is AJAX?
  • Load Simple Data Using AJAX Front End
  • Load Simple Data Using AJAX Back End
  • Load Data From A Database Using AJAX
  • Send A Plain Text Email
  • Send A HTML Email
  • Email Attachments
  • PHPMailer Setup
  • Send Email Using PHPMailer
  • Send HTML Email Using PHPMailer
  • Email Attachments Using PHPMailer
  • What Is Object Oriented Programming (OOP)?
  • Basic Class With Variables
  • Functions
  • Constructor
  • Destructor
  • Inheritance
  • Multi Class Inheritance
  • Function Overriding
  • Public vs Private vs Protected
  • Interfaces
  • Constants
  • Abstract Class
  • Static Keyword
  • Final Keyword
  • Initiating Parent Constructor
  • die() Function
  • Custom Error Handler
  • Triggering An Exception
  • Exception Handling
  • Create Database & Table
  • User Class & Database Connection
  • Register User Form
  • Inserting User Data Into Database
  • Registration Form Field Validation
  • Securing User Password
  • Check If Username or Email Already Exists
  • Retain Data After Failed Registration
  • Validate an Integer Within a Range
  • Validate IPv6 Address
  • Validate URL – Must Contain QueryString
  • Remove Characters With ASCII Value > 127
  • Including & Requiring External PHP Files
  • Resource

Contents Not Found