Certificate Programmes

Certificate in PHP & MySQL

Learn PHP and MySQL in detail โ€” from setting up the development environment to debugging and error handling.

LevelIntermediate
Duration45 Hours
Course fee19900
CampusesColombo ยท Kandy ยท Batticaloa
Certificate in PHP & MySQL <p>This comprehensive PHP Development course equips learners with the skills to build dynamic, database-driven web applications. You will learn to set up and configure Apache, MySQL, and PHP, understand PHP fundamentals, variables, data types, operators, control structures, arrays, and form handling. The course covers form validation, file uploading, sessions, cookies, superglobals, file and directory management, and code reuse using functions and included files. Learners will also explore Object-Oriented Programming concepts, including classes, objects, constructors, inheritance, polymorphism, interfaces, abstract classes, and encapsulation. With practical learning, this course provides a strong foundation for developing secure, efficient, and professional PHP-based web applications.</p><p><br></p><p></p><b>Setting Up The PHP Development Environmen</b>t&nbsp;<div><p></p><p></p><ul><li>Introduction to Apache, MySQL, and PHP&nbsp;</li><li>Stable/Production vs. Development Releases&nbsp;</li><li>Understanding how PHP Works&nbsp;</li><li>Server-Side vs. Client-Side Scripting&nbsp;</li><li>Installing PHP, Apache, and MySQL</li></ul><div><b>Understanding PHP: Language Basics</b></div><div><ul><li>Embedding PHP Scripts</li><li><span style="font-size:14.72px">Output data to a browser&nbsp;</span></li><li><span style="font-size:14.72px">Using the print() statement</span></li><li><span style="font-size:14.72px">Working with the echo() statement</span></li><li><span style="font-size:14.72px">Using the printf() statement</span></li><li><span style="font-size:14.72px">Using the sprintf() statement</span></li><li><span style="font-size:14.72px">Commenting your PHP code</span></li><li><span style="font-size:14.72px">Storing data in variables</span></li><li><span style="font-size:14.72px">Creating variables and setting data types</span></li><li><span style="font-size:14.72px">Creating and storing string variables (Text)</span></li><li><span style="font-size:14.72px">Working with integers (whole numbers)</span></li><li><span style="font-size:14.72px">Understanding floating point numbers (decimals)</span></li><li><span style="font-size:14.72px">Creating and working with Boolean values</span></li><li><span style="font-size:14.72px">Types of operators</span></li><li><span style="font-size:14.72px">Utilizing arithmetic operators</span></li><li><span style="font-size:14.72px">Utilizing arithmetic assignment operators</span></li><li><span style="font-size:14.72px">Utilizing comparison operators</span></li><li><span style="font-size:14.72px">Utilizing error control operators&nbsp;</span></li><li>Utilizing incrementing/decrementing operators</li><li><span style="font-size:14.72px">Utilizing logical operators&nbsp;</span></li><li><span style="font-size:14.72px">Understanding string&nbsp;</span><span style="font-size:0.92rem">operators&nbsp;</span></li></ul><div><span style="font-size:14.72px"><b>PHP Control Structures</b></span></div></div><div><div><ul><li><span style="font-size:14.72px">If statement โ€“ Else statement</span></li><li>Elseif statement</li><li><span style="font-size:14.72px">Switch statement&nbsp;</span></li><li><span style="font-size:14.72px">While statement</span></li><li><span style="font-size:14.72px">Do. While statement&nbsp;</span></li><li><span style="font-size:14.72px">For statement</span></li><li>Foreach statement</li><li>Break statement</li><li>Continue statement</li></ul><div><b>PHP Arrays</b></div><div><ul><li>Enumerated arrays</li><li>&nbsp;Initializing arrays</li><li>&nbsp;Appending to an array</li><li>&nbsp;Reading from arrays</li><li>&nbsp;Looping through arrays&nbsp;</li><li>Associative arrays&nbsp;</li><li>Initializing associative arrays&nbsp;</li><li>Reading from associative arrays</li><li>Looping through associative arrays&nbsp;</li><li>Super global arrays&nbsp;</li><li>Two-dimensional arrays&nbsp;</li><li>Reading from two-dimensional arrays</li><li><span style="font-size:0.92rem">Looping through two-dimensional arrays</span></li><li>Array manipulation functions</li></ul><div><span style="font-size:14.72px"><b>Handling Html form with PHP</b></span></div><div><ul><li>Capturing form data</li><li><span style="font-size:14.72px">Understanding form elements</span></li><li><span style="font-size:14.72px">Dealing with multi-value fields</span></li><li><span style="font-size:14.72px">Generating file uploaded form</span></li><li><span style="font-size:14.72px">&nbsp;Redirecting a form after submission</span></li><li><span style="font-size:14.72px">&nbsp;PHP form validation</span></li><li><span style="font-size:14.72px">&nbsp;PHP Form URL/e-mail</span></li></ul><div><span style="font-size:14.72px"><b>Passing Information With PHP</b></span></div></div><div><span style="font-size:14.72px"><u>Super global arrays</u></span></div><div><ul><li>Understanding variable scope&nbsp;</li></ul><ol><li>$GLOBALS</li><li>&nbsp;$_SERVER&nbsp;</li><li>$_GET&nbsp;</li></ol><ul><li>Retrieving URL variables</li></ul><ol><li><span style="font-size:0.92rem">&nbsp;$_POST</span></li><li><span style="font-size:0.92rem">&nbsp;$_REQUEST</span></li><li><span style="font-size:0.92rem">&nbsp;$_FILES</span></li><li><span style="font-size:0.92rem">&nbsp;$_SESSION&nbsp;</span></li></ol><ul><li><span style="font-size:0.92rem">Implementing session_destroy()</span></li></ul><ol><li><span style="font-size:0.92rem">$_COOKIE</span></li></ol></div><span style="font-size:14.72px"><b>Working with File And Directories</b></span></div><div><ul><li><span style="font-size:14.72px">Understanding file &amp; directory&nbsp;</span></li><li><span style="font-size:14.72px">Opening and closing a file&nbsp;</span></li><li><span style="font-size:14.72px">Coping, renaming and deleting a file&nbsp;</span></li><li><span style="font-size:14.72px">Working with directories</span></li><li><span style="font-size:14.72px">&nbsp;File Uploading &amp; Downloading</span></li></ul></div><div><span style="font-size:14.72px"><b>Reusing Code and Writing Functions</b></span></div><div><div><ul><li><span style="font-size:14.72px">Including files</span></li><li><span style="font-size:14.72px">require/require_once</span></li><li><span style="font-size:14.72px">User function</span></li><li><span style="font-size:14.72px">Defining and calling function</span></li><li><span style="font-size:14.72px">Default values</span></li><li><span style="font-size:14.72px">Variable scope</span></li><li><span style="font-size:14.72px">By reference vs.by value</span></li></ul><div><span style="font-size:14.72px"><b>OOPS</b></span></div></div><div><ul><li><span style="font-size:14.72px">Introductio</span></li><li><span style="font-size:14.72px">&nbsp;Objects</span></li><li><span style="font-size:14.72px">&nbsp;Declaring a class&nbsp;</span></li><li>The new keyword and constructor&nbsp;</li><li>Destructor</li><li>&nbsp;Access method and properties&nbsp;</li><li>using $this variable&nbsp;</li><li>Public, private, protected properties and methods&nbsp;</li><li><span style="font-size:14.72px">Static properties and method</span></li><li><span style="font-size:14.72px">&nbsp;Class constant Inheritance &amp; code reusability&nbsp;</span></li><li><span style="font-size:14.72px">Polymorphism&nbsp;</span></li><li><span style="font-size:14.72px">Parent &amp; self keyword&nbsp;</span></li><li><span style="font-size:14.72px">Abstract method and class&nbsp;</span></li><li><span style="font-size:14.72px">Interface&nbsp;</span></li><li><span style="font-size:14.72px">Final</span></li></ul></div><br><span style="font-size:14.72px"><br></span></div></div></div><div><span style="font-size:14.72px"><b><br></b></span></div><p></p></div>

๐Ÿš€ Your career pathway

Where the Software Engineering route can take you โ€” from here to a degree and a career.

1Certificate in Programming
โ†“
2Diploma in Software Engineering
โ†“
3HND in Computing
โ†“
4BSc Top-up Degree (UK)
โ†“
5MSc Software Engineering

Possible career roles

Software DeveloperWeb DeveloperFull-Stack EngineerMobile App DeveloperQA EngineerDevOps Engineer

๐ŸŒ Opportunities in: Sri Lanka ยท UK ยท Middle East

Students also explored

Apply / Enquire