PHP MySQL & CodeIgniter Course: Complete Guide

Explore core data types such as strings, integers, floating point numbers, booleans, arrays, objects, null values, and resource, and see how each stores and represents data in PHP.

Learn to declare PHP variables with a dollar sign, understand valid names, case sensitivity, and styles like underscore and camel case, plus basic arithmetic and string concatenation.

Explore strings in PHP, defining text with double or single quotes, embedding variables in double quotes, and using backslashes to escape characters, with practical examples of output.

Explore PHP operators, including assignment and comparison operators, such as double and triple equals and not equal; apply increment, decrement, pre/post forms, and use logical and ternary operators.

Manage arrays of odd numbers in PHP, using indices to access elements and display results in the browser. Add, remove, and count items, and fetch the first and last elements.

Learn how to manipulate arrays in php using array functions such as push, pop, unshift, shift, array_merge, sort, and reverse to manage lists and combine arrays.

Learn how to manage PHP arrays by using keys and values, printing entries with echo, adding new items, and extracting keys and values with array_keys and array_values.

Explore php conditions and comparison operators in a login form, showing how to compare user input with stored values and validate numeric versus string input.

Explore how switch case in PHP evaluates cases like red, blue, and green, using break and default to determine and display your favorite color.

Explore the four PHP looping constructs—while, do-while, for, and foreach—and learn how to increment counters, break or continue, and iterate arrays with keys and values.

Learn how to use PHP's date function with custom formats and separators, and explore include and require for modular files and database connections, with error handling for missing files.

Create a simple login form with username and password, submit via post, capture data with $_POST in PHP, guard against undefined inputs, and encrypt passwords before storage.

Create an employees table in a demo database with an auto-incrementing id, name, email, and phone fields, then insert and verify sample records like Jane Doe and John Doe.

Learn to secure php pages using sessions: start a session on login, validate username and password, store the username in $_SESSION, redirect to the dashboard, and implement logout with session_destroy.

Create a new employee form using bootstrap, capturing name, email, and phone number, validating required fields, and saving the data to the database within a PHP, MySQL, and CodeIgniter setup.

Create a single employee details page in a CodeIgniter app that retrieves a user by id via GET and displays data in a table with edit and delete actions.

Create and link the single employee edit page from the dashboard, populate the form with current details, and update name, profession, email, and phone using the update button.

Explore the difference between frameworks and content management systems, compare Laravel, WordPress, Joomla, and Drupal, and learn why WordPress is presented as the first choice to get started.

Identify essential skills and object oriented programming concepts for the PHP MySQL & CodeIgniter course, with Bootstrap front end, Sublime Text editor, and per-lesson command sections.

Install CodeIgniter locally by using a local development server, verify PHP 7.4.1, download the current CodeIgniter release 3.1.11, extract to a project folder, and access it via localhost.

Learn to locate the application controller and welcome view, edit the welcome message, and create your first global hello world page in a PHP MySQL and CodeIgniter project.

Explore the coordinator project's folder structure, including application, system, and user guide folders, and see how model, view, and controllers are configured.

Configure CodeIgniter for development by managing the config folder, loading necessary packages, libraries, helpers, and configurations, and setting up database options, base URL, and default controller.

Explore how CodeIgniter handles controllers and views, using a welcome controller with an index method and additional functions, and how to load views and handle non-existent pages.

Discover how to add extra data to a web page through controllers, load and store it, and output it with echo using the third segment.

Learn how URI segments in CodeIgniter map to the controller, the method, and the additional data, and how adjusting segment values changes the browser output.

Learn two methods to capture a page URL in CodeIgniter using base_url and site_url, with localhost examples and linking to a specific controller.

Create a default home controller in CodeIgniter, load a homepage view with a bootstrap template, adjust the default controller, and streamline the header and footer into a shared base.

Learn how to remove index.php from CodeIgniter URLs by adding an .htaccess file and adjusting the base index settings. See how this change fixes routing and keeps the application working.

Add a new public function in the CodeIgniter home controller to collect registration data from the register page, mapping name and email inputs, then test in the browser.

Create the users table in the database by defining user_id as auto_increment primary key, a datetime user_date for registration, and fields for username and password, then insert user data.

Create a simple sidebar on the dashboard that exposes employee and job management actions, enabling add, read, update, and delete operations and linking to lists of employees and jobs.