TOIT Training

PHP and MySQL for Beginners

PHP and MySQL for Beginners
  • Overview
  • Curriculum
  • Reviews

 

This course introduces PHP and MySQL, two fundamental technologies for server-side web development. It highlights PHP as a scripting language that is adept at creating dynamic content for web pages, and MySQL as a reliable and scalable relational database management system. The focus is on PHP’s syntax and how it integrates with MySQL to perform database operations, such as creating, reading, updating, and deleting data. Participants learn to harness PHP’s server-side capabilities to handle form submissions, manage sessions, and build CRUD applications, while also gaining proficiency in designing and querying MySQL databases to store and retrieve web application data efficiently. The course lays the groundwork for developing data-driven websites and applications using PHP and MySQL.

  • 4 Sections
  • 42 Lessons
  • 0 Quizzes
  • 0m Duration
Expand All

 PHP Basics

16 Lessons 0 Quizzes
  • Course Introduction
  • Installing PHP
  • Your First PHP File
  • Variables & Constants
  • Strings
  • Numbers
  • Arrays
  • Multi-Dimensional Arrays
  • Loops
  • Booleans & Comparisons
  • Conditional Statements
  • Continue & Break
  • Functions
  • Variable Scope
  • Include & Require
  • Project Header & Footer

Forms & User Input

6 Lessons 0 Quizzes
  • Forms in PHP
  • XSS Attacks
  • Basic Form Validation
  • Filters & More Validation
  • Showing Form Errors
  • Redirecting Users

 MySQL Databases

11 Lessons 0 Quizzes
  • MySQL Introduction
  • Setting Up a MySQL Database
  • Connecting to a Database
  • Getting Data From a Database
  • Rendering Data to the Browser
  • The Explode Function
  • Control Flow Alt Syntax
  • Saving Data to the Database
  • Getting a Single Record
  • Deleting a Record
  • Finishing Touches

Beyond the Basics

9 Lessons 0 Quizzes
  • Ternary Operators
  • Sessions
  • Superglobals
  • Null Coalescing
  • Cookies
  • File System (part 1)
  • File System (part 2)
  • Classes & Objects (part 1)
  • Classes & Objects (part 2)

0

0 Ratings
5 Star 0%
4 Star 0%
3 Star 0%
2 Star 0%
1 Star 0%

Reviews

Free

Start Course

Retake Course

Are you sure you want to retake the course? This action will permanently delete all your progress in this course.

Course Includes

  • Install PHP and set up the environment
  • Create and execute PHP files
  • Work with PHP variables and constants
  • Manipulate strings in PHP
  • Perform calculations with numbers
  • Define and use arrays
  • Utilize multi-dimensional arrays
  • Implement loops (for, foreach, while, do-while)
  • Make use of booleans and comparison operators
  • Apply conditional statements
  • Control loop execution with continue and break
  • Create and call functions
  • Understand variable scope
  • Include and require files
  • Manage project structure with header and footer
  • Process forms and handle user input

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Buy for group

PHP and MySQL for Beginners
No groups Found

You don't have any groups yet

Create a group and add group members. Sync Group(s)