Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

PHP & MySQL - The Ultimate Web Development Training

Name: PHP & MySQL - The Ultimate Web Development Training
Rating: 4.5 (3 reviews)

Master PHP & MySQL with our ultimate web development training and build dynamic, robust web applications with ease!

Created byEDUCBA Bridging the Gap

Last updated 7/2024

English

What you'll learn

PHP Fundamentals: Understand PHP syntax and structure. Embed PHP in HTML and manage PHP scripts. Work with variables, constants, and data types.
CakePHP Framework: Install and configure CakePHP. Utilize the MVC architecture for web applications. Implement routing, session management, and error handling
Yii PHP Framework: Install and set up the Yii framework. Create and manage basic and advanced pages using MVC. Develop sophisticated web applications
Practical Web Application Development: Build a complete web application from scratch. Develop essential components like headers, footers, and contact forms.
Laravel PHP Framework: Install and configure Laravel. Understand routing, middleware, and request handling. Utilize Laravel features like controllers, cookies
Advanced Laravel Techniques: Implement localization, session management, and form validation. Use AJAX and email handling in Laravel applications
Server-Side Programming with PHP: Set up a server and create PHP programs. Handle forms and input types using GET and POST methods. Build XHTML output.
Advanced Server-Side Programming: Work with arrays and custom functions. Read, write, and manage files, including CSV operations. Retrieve data from MySQL.
By completing this course, students will gain a comprehensive understanding of PHP and MySQL, equipping them with the skills needed to develop applications.

Course content

8 sections • 241 lectures • 28h 13m total length

Introduction to PHP Part 19:28
Explore PHP and MySQL for web application development, from prerequisites like HTML, CSS, and JavaScript to server-side scripting, dynamic pages, and embedding PHP in HTML.
Introduction to PHP Part 29:52
PHP runs on Windows, Unix, Linux, and Mac OS as an open-source, secure server-side scripting language that works with Apache or IIS and connects to databases like MySQL and Oracle.
Introduction to PHP Part 33:06
Discover how a basic PHP file is interpreted by the PHP interpreter on the server to generate dynamic HTML, with pages served to the browser and data retrieved from databases.
Installation Steps for PHP Part 111:52
Learn how to install PHP, set up a web server with Apache, and integrate MySQL, using Xampp for an all-in-one solution on Windows.
Installation Steps for PHP Part 211:04
Install Xampp on Windows, select components and the installation folder, then start the control panel, resolve port 80/443 conflicts, and test with localhost to run PHP files from docs/htdocs.
Basic PHP Code Demo8:50
Master running php files locally with xampp by starting apache and using localhost to load index.html or demo.php. Learn the php syntax with echo to display text.
Writing First PHP Script Part 17:03
Learn to write and embed your first PHP script in an HTML page using echo, PHP rules, and comments with case-sensitive variables, displaying output.
Writing First PHP Script Part 27:28
Explore PHP comments as non executable text that documents code, including single-line hash or // and multi-line /* */ styles, and write and run your first PHP script in HTML.
Writing First PHP Script Part 33:20
Run your PHP script in the browser by saving it in your docs folder and opening localhost/first_script.php. Learn newline characters and single-line and multi-line comments; variables are case sensitive.
PHP Case Sensitivity8:20
Explore how PHP keywords like if, else, and echo are not case sensitive, while variables are case sensitive. Learn start and end tags, semicolon termination, and single- and multi-line comments.
Variables Description Part 16:29
Explore PHP variables, constants, and data types, and learn naming rules, case sensitivity, and valid variable names using the dollar sign.
Variables Description Part 25:48
Understand how to create PHP variables by assignment; ensure names don’t start with a number and avoid special characters, with strings requiring quotes and values displayable via echo or print_r.
Variables Example9:39
Explore creating and displaying PHP variables, including $name and $age, using echo and print_r, and concatenation with the dot operator in a localhost PHP file.
Removing Variables Description5:00
Learn to use PHP variables, echo values like hello world, and manage variable values across a script, including variable variables and unsetting with unset to avoid errors.
Removing Variables Example6:47
Demonstrate PHP variable variables, showing how $$name references $city, then explain emptying and unsetting variables, and the resulting undefined variable errors when a variable is unset.
Variable Scope Description Part 16:18
Explore PHP variable scope, including local, global, and static, and how loosely typed data types affect variables across functions in a script.
Variable Scope Description Part 26:09
Explore local scope with same-named variables across functions and their function-limited access. Understand global variables and accessing them inside functions via the global keyword, and static variables that preserve values.
Variable Scope Examples Part 112:48
Explore PHP variable scope with a function demo, showing how local and global variables behave inside and outside the function using the global keyword.
Variable Scope Examples Part 26:14
Explore how global variables are accessed and modified inside functions, illustrate parse errors when globals aren't declared, and show static variables preserving state and PHP constants.
PHP Constants Description4:07
Explore PHP constants, how they differ from variables, and how to define them with define; learn global accessibility, uppercase naming conventions, immutability, and keyword restrictions.
PHP Constants Example2:46
Define PHP constants with the define keyword, assign a name and value (for example 25), and echo them anywhere in the script; use the third parameter to enable case-insensitive access.
PHP Datatypes Description Part 113:59
Explore PHP data types such as integers, floating point numbers, and booleans. Understand decimal, octal, and hex formats and integer ranges like -2 billion to 2 billion.
PHP Datatypes Description Part 26:45
Explore PHP datatypes, including booleans, strings, arrays, objects, and null, with practical examples of boolean display, string quoting, array indices, and a basic object class.
PHP Datatypes Example Part 19:18
Explore PHP data types by assigning integers (including negative, octal 047 and hex 0xBB), floats, and booleans, and use the dump function to reveal each variable's type and value.
PHP Datatypes Example Part 28:39
Explore booleans: true and false, and how zero affects conditionals. Learn string literals with quotes, and create a three element array with zero-based indexing and fixed size.
PHP Datatypes Example Part 310:54
Explore PHP datatypes by building a class with properties and methods, creating objects, and printing property values with a foreach loop and echo.
PHP Typecasting Description7:58
Explore how PHP typecasting converts values to a chosen data type before assignment, enabling integers, floats, and strings, and how mixed-type operations may lose data.
PHP Typecasting Example7:32
See how PHP typecasting converts an integer and a float for addition, producing a float result like 2.1, and how values become integer, float, or string.
Operators Arithmetic Operators Description Part 17:23
Explore PHP arithmetic operators, learning how plus, minus, multiply, divide, and modulus combine operands to produce output, including how strings are treated as zero in addition.
Operators Arithmetic Operators Description Part 25:16
Learn how PHP arithmetic operators work, including subtraction, multiplication, division, and modulus, with practical examples using x and y to show negative results and remainders.
Arithmetic Operators Example11:42
Explore PHP arithmetic operators including addition, subtraction, multiplication, division, and modulus, using $x, $y, and $z, and observe how PHP handles strings and integers with echo outputs.
Assignment Operators Description5:27
Explore PHP assignment operators, including basic assignment, addition, subtraction, multiplication, division, and modulus, and learn how to assign values or expressions to variables.
Assignment Operators Example8:27
Demonstrate assignment operators in PHP, including basic assignment, addition, subtraction, multiplication, division, and modulus, with variables x and y and echoed outputs.
String Operators Description2:38
Explore PHP string operators, focusing on the concatenation operator (.) to join two strings and the concatenation assignment operator (.=) to append text to a variable.
String Operators Example4:49
Explore PHP string operators by building and concatenating names with the dot operator and the concatenation assignment operator, showing how variables combine into a complete name.
Increment Decrementoperators Description5:13
Learn how increment and decrement operators in PHP work, including pre-increment and post-increment, and pre-decrement and post-decrement, to increment or decrement a variable's value and return the result.
Increment Decrementoperators Example3:12
Explore pre-increment and post increment, as well as pre-decrement and post decrement operators in PHP, seeing how they alter x and the echoed value and comparing pre vs post behavior.
Comparision Operator Description10:33
Learn how PHP comparison operators evaluate values and types, returning true or false. Include equal, identical, not equal, not identical, greater than, less than, and their greater-or-equal and less-or-equal variants.
Comparision Operator Examples Part 17:38
Explore PHP comparison operators with practical examples, comparing variables x and y using equal, identical, and not equal operators, and observe how type and value affect boolean results.
Comparision Operator Examples Part 28:36
Explore PHP comparison operators, including not equal and not identical, and examine greater than, less than, and their equal variants across value and type.
Logical Operators Description3:55
Explore PHP logical operators, including and (&&), or (||), xor, and not, with syntax examples and the basics of evaluating true or false conditions.
Logical Operators Example10:50
Explore how logical operators work in PHP with practical examples of and, or, xor, and not, using variables x, y, and z to evaluate true and false conditions.
Conditional Operators Description1:48
Master the conditional operator, or ternary operator, which evaluates a condition and executes statement one if true or statement two if false using the question mark and colon syntax.
Conditional Operators Example2:45
Practice the PHP conditional (ternary) operator by comparing two variables, x and y, printing 'x is greater' when x > y, else printing 'y is greater', and observing the output.
Array Operators Description4:26
Explore PHP array operators, including union, equality, identity, inequality, and non-identical checks, and learn how each operator compares arrays and handles duplicates with specific syntax.
Array Operators Example part 17:20
Explore array operations in PHP by creating two arrays, applying the union operator to merge them, and comparing arrays with equality and identity operators.
Array Operators Example part 25:36
Explore how PHP array operators evaluate equality and identity by comparing keys, values, and types. Learn how the identical, not identical, and not equal operators yield true or false results.
Operators Final Description2:18
Explore the categories of PHP operators, including unary, binary, conditional, ternary, and assignment operators, and see how arithmetic, string, logical, comparison, and array operators power PHP code.
Operator Precedence Description Part 18:24
Explore PHP conditional statements and loops, mastering if, if else, and if else if else, their syntax, and how conditions drive which statements run.
Operator Precedence Description Part 29:32
Learn how if, else if, and else control flow select blocks by condition, and how switch statements use cases, default, and break to control execution.
Operator Precedence Example Part 15:47
Understand how PHP operator precedence controls expression evaluation, from multiplication before addition to braces altering order, with pre-increment and pre-decrement examples.
Operator Precedence Example Part 22:56
Explore operator precedence and associativity in PHP, highlighting parse errors from non-associative same-precedence operators and how less-than-equals-to and equals-to influence evaluation.
Operators Conclusion1:30
Explore arithmetic, assignment, comparison, logical, string, and array operators in PHP expressions. Understand operator precedence and associativity, including non-associative cases, then preview conditional statements in PHP.
Conditional Statements Description Part 13:38
Understand how PHP operator precedence determines the order of execution in expressions with multiple operators, as multiplication precedes addition in the five plus two into three example.
Conditional Statements Description Part 26:55
Explore how operator precedence and associativity shape PHP expressions, including clone and new, arithmetic, bitwise, comparison, and logical operators, with examples.
Conditional Statements Example Part 111:33
Explore php conditional statements by evaluating conditions with if, else, and else if, using x values and true and false conditions to control output.
Conditional Statements Example Part 25:27
Explore PHP conditional statements with if, else if, and else, using a name variable to print the matching result, followed by an introduction to the switch statement and case structure.
Looping Statements Description Part 18:23
Learn why PHP looping statements are needed to execute code blocks a specific number of times, and master the for loop, while loop, do while loop, and for each loop.
Looping Statements Description Part 29:30
Explore looping statements in PHP, including the while loop, the do while loop, and the for each loop, with syntax and examples that cover initialization and iteration.
Looping Statements Examples Part 18:07
Explore practical for and while loop examples in PHP, covering initialization, braces, condition, increments, and break usage, with output illustrating less than versus less than or equal to.
Looping Statements Examples Part 28:01
Explore looping statements in PHP, including while loops, do-while loops, and for each loop with increment and decrement. See echo outputs and how break and continue control flow.
Break Continue Description4:41
Explore break and continue statements to control loop execution in PHP, exiting loops early or skipping current iterations, with practical while-loop examples.
Break Continue Example5:05
Demonstrate break and continue in PHP by looping with while, for, do-while, and foreach, and illustrate how conditional statements like if and switch influence control flow.
User Defined Functions Description Part 18:26
Explore PHP functions, including built-in and user-defined ones, and learn naming, syntax, how to define and call functions, and how to pass arguments to perform operations and return results.
User Defined Functions Description Part 29:12
Explore how PHP functions accept arguments, pass single or multiple values, use default argument values, and return results with the return statement, illustrated by display name and add numbers.
User Defined Functions Example Part 16:31
Learn how to create and call user defined functions in PHP, pass arguments (values or variables), and echo messages with practical examples.
User Defined Functions Example Part 26:56
Pass multiple values to a function using variables and literals, set a default name, and return results to display operations like adding two numbers.
User Defined Functions Conclusion1:06
Review PHP function types, including built-in and user defined functions, and learn about passing single or multiple arguments, default values, and returning values from functions.
Arrays Indexed Arrays Description Part 16:44
Learn how PHP arrays store data with indexed arrays, access elements by zero-based indices, and create arrays using the array function in two ways.
Arrays Indexed Arrays Description Part 23:05
Create an indexed PHP array with values like mac, Joe, and rock, then use count to get its length. Loop from 0 to length-1 to retrieve each value with $names[$i].
Indexed Array Example5:21
Explore creating an indexed PHP array, retrieving values with a for loop, and determining length with the count function, using a name list example (mac, rock, joe).
Associative Array Description3:33
Learn how associative arrays use string keys to reference values, contrasting them with indexed arrays. Create and access such arrays with key value syntax and loop through them using foreach.
Associative Array Example5:05
Create and retrieve associative arrays in PHP with key-value pairs like name and salary, display each entry, use a for each loop to iterate, and introduce multidimensional arrays.
Multidimensional Array Description4:47
Learn how to create and access multidimensional arrays in PHP, using two- and three-dimensional structures, with examples of nested arrays for name, age, and salary, and looping to retrieve values.
Multidimensional Array Example6:42
Create and access a PHP multidimensional array built from inner detail arrays (name, age, salary) using indexing and foreach to display values.
Array Functions Description8:33
Explore essential PHP array functions to create and manipulate arrays, change key cases, count values, and add or remove elements in indexed, associative, and multidimensional arrays.
Array Functions Example Part 14:49
Explore PHP array functions by creating arrays with array(), indexing to display values, looping with for, and changing associative key cases with array_change_key_case.
Array Functions Example Part 25:36
Explore PHP array functions by counting values with array_count_values, removing with array_pop, and adding with array_push, while noting key and value behavior in associative and indexed arrays and basic sorting.
Array Sorting Functions Description Part 17:00
Explore PHP array sorting functions to sort arrays in ascending or descending order by numeric or string values, using sort and rsort with various sort flags.
Array Sorting Functions Description Part 27:20
Explore PHP array sorting functions, including sort, ksort, rsort, and user-defined comparator sorts, using various sort flags to sort by values or keys in ascending or descending order.
Array Sorting Functions Examples Part16:01
Explore PHP array sorting with sort for indexed arrays, rsort for descending order, and the a sort function for associative arrays by value, plus ksort and krsort for keys.
Array Sorting Functions Examples Part27:45
Learn to create a user defined comparator for usort in PHP, sorting a number array and an associative array, returning -1, 0, or 1, and display the results.
Array Sorting Functions Examples and Conclusion1:16
Learn PHP array sorting functions with practical examples, including normal sort, key-based sorting, associative value sorting, and user defined sorting. Review indexed, multidimensional, and associative arrays and array functions.
Superglobals Globals Description6:16
Explore PHP super globals, built-in variables with global scope accessible from any file, function, or class, introduced in PHP 4.1.0. Learn how to access global variables using the globals array.
Superglobals Globals Example3:26
Learn to use the $GLOBALS superglobal to access and modify global variables inside a function, as x and y update from 10 and 20 to 30.
Superglobals $Server Description Part 17:24
Explore PHP's $_SERVER superglobal, learning how headers, paths, and script locations are accessed at runtime, with elements like PHP_SELF, SERVER_ADDR, SERVER_NAME, and SERVER_PROTOCOL.
Superglobals $Server Description Part 26:04
Discover PHP's $_SERVER superglobal and how it returns current request details, including http headers (accept, language, encoding, user agent) and server data (host, remote address, script uri).
Superglobals Get Description4:42
Access and use the $_GET super global to retrieve form data and URL parameters sent by the get method, illustrated with demo html and php examples.
Superglobals Get Example4:55
Explore how to submit a form with the get method and access the submitted value using $_GET, echoing the result, while using $_SERVER and $_PHP_SELF to reference the current file.
Superglobals Post Request Description Examples5:56
Learn how the $_POST super global retrieves form data submitted via post, use the action attribute and PHP_SELF, and compare it with $_GET and $_REQUEST to handle input securely.
Get Post Comparision5:17
Compare the get and post methods in PHP, detailing how data is sent (URL vs HTTP headers), limits and security, and when to use post for sensitive or binary data.
File Inclusion Description9:48
Learn PHP file inclusion with include and require to share headers and footers across pages. Compare warnings versus fatal errors when files are missing and when to prefer each.
File Inclusion Examples8:00
Learn how to include php files with include and require, share variables like $name across files, and handle missing files with warnings or fatal errors.
File Read Functions Description Part 19:35
Explore PHP file read operations and file system functions, including read file, f open with modes, f read, and f close, to read, write, and manage files.
File Read Functions Description Part 24:37
Explore PHP file read functions, including f gets for reading a line. Understand f u f function end-of-file checks and f get c reads, with valid opened file pointers.
File Read Functions Examples Part 110:36
Explore PHP file reading with read file function and f open, then read and close via f read, file size, plus opening in read, write, and x modes.
File Read Functions Examples Part 27:04
Explore reading text files in PHP by opening a file with f open, reading lines with f gets, looping with f eof, and reading characters with f get c.
File Write Description2:40
Explore PHP file write functions like fwrite and fopen in write mode, handling a file pointer and string contents, with an optional length and a return value of bytes written.
File Write Example5:01
Learn to write to a file in PHP using f open in write mode, f write, and f close to save details.txt and verify the output.
File Upload Description9:42
Upload files to a server with PHP and an HTML form, moving from a temporary directory to a final destination.
File Upload Example Part 111:37
Configure php.ini to enable file uploads, then build HTML form with input type equals to file and multipart/form-data that posts to file underscore upload dot PHP, saving file on server.
File Upload Example Part 28:32
Learn PHP file upload handling by checking for existing files in the target directory and moving uploads from the temporary name with move_uploaded_file, with clear success or error messages.
File Upload Example Part 38:03
Learn the PHP file upload workflow—from selecting files in HTML to moving them to the server, handling duplicates, and viewing file name, tmp name, and size, plus include/require basics.
File Handling Conclusion0:46
Learn to handle files in PHP, including using include and require to include one file into another, opening, reading, and writing file contents, closing them, and uploading different file types.
PHP Cookies Description9:20
Cookies track users by storing data on the client and sending it with requests; set cookies with setcookie before HTML, access via $_COOKIE, delete by expiry, and check enabled status.
PHP Cookies Example Part 16:24
Learn how to create, set, and retrieve cookies in PHP using the set cookie function, including naming, expiry, and path, and how to check and modify cookie values.
PHP Cookies Example Part 26:54
Create, modify, and retrieve cookies in PHP, using the city cookie to store values, then delete by setting a past expiry date, and check cookies enabled via $_COOKIE.
PHP Sessions Description6:59
Learn how PHP sessions store variable values on the server to maintain state across pages, using session_start and the $_SESSION global, with retrieving, modifying, and destroying session data.
PHP Sessions Example6:17
Start a session with session_start, set and retrieve variables using $_SESSION, modify and unset them, and destroy the session, noting that it ends when the browser is closed.

Introduction to CakePHP1:35
Explore CakePHP, version 3.3 red velvet open-source PHP MVC framework with layered architecture, community extensions, and fast execution; learn installation on XAMPP, WAMP, or LAMP, and access docs at cakephp.org.
Overview of CakePHP5:09
Discover CakePHP, an open source PHP MVC framework that simplifies building, deploying, and maintaining web applications with templating, caching, SEO-friendly URLs, built-in validation, and a clear request cycle.
History and Features4:51
Explore the history of CakePHP, its model-view-controller architecture, and key roles like dispatcher, controllers, actions, and models; this framework emphasizes modular design, agile development, and easy debugging.
Installation Of CakePHP12:11
Install CakePHP by verifying requirements, setting up vamp stack, installing and verifying Composer, creating a CakePHP project with Composer, and exploring the folder structure from bin to webroot.
Configuration9:43
Explore how to configure a CakePHP app, including debugging, app namespace, web root paths, database connections with data sources, and email transport configurations.
Demo Example6:11
Develop a CakePHP MVC demo that prints hello world using a simple model, controller, and view, with dot ctp views and a dispatcher routing requests.
Routing8:04
Learn CakePHP routing by mapping URLs to controller actions with static methods or a scope route builder, and use the connect method with URL templates, defaults, and options.
Understanding MVC3:20
Learn how controllers, models, and views interact in CakePHP, define actions, load models, render views, and route and redirect requests using routes.php and the app controller.
Database Connectivity6:33
Learn how CakePHP connects to a database, configure the MySQL connection, create a users table, and perform CRUD operations using the table registry and a users controller.
Database Controllers6:40
Learn to build a database controller using the table registry and cake ORM to insert a user with a hashed password via a post request.
Insertion of Records5:22
Create a user input template and a form in cakephp, submit to users/add, hash the password, and verify record insertion in the users table via the database.
Viewing the Records8:25
Learn to view all records from the users table by using the table registry, get and find methods; configure routes to call users index and render results in a table.
Updating the Records11:44
Learn how to update a database record in CakePHP using the table registry and get, find, and save methods, with an edit route and user controller.
Deleting the Records5:47
Delete a record in CakePHP by using the Table Registry get method to fetch the users table, call delete with the ID, and update routes, controller, and user feedback.
Session Management3:28
Learn how CakePHP handles sessions and cookies, including accessing the session object, writing and reading data, deleting and destroying sessions, and renewing the session.
Cookie Management2:13
Learn how to manage cookies in PHP using the cookie component class, including writing, reading, checking existence, and deleting cookies in CakePHP, with sessions as the related concept.
Error Handling9:20
Learn how CakePHP handles errors and exceptions, using default error trapping, debug flags, and a sample exception controller with try-catch and throws for out of range errors.

Introduction to Yii Framework6:44
Explore the open source php framework yii, its mvc pattern and component based architecture, with relational and nosql databases, authentication, authorization, layered caching, and code generation for rapid development.
Understanding MVC Framework3:50
Master the MVC framework—model handles data and logic, view renders the UI, and controller routes requests to connect model and view for scalable, extensible PHP web apps.
Environmental Setup1:24
Master the environmental setup of the E framework by installing via composer or archive, selecting basic or advanced templates, and downloading the tar file as the first step.
Understand Application Structure5:04
Understand the application structure by exploring the downloaded package's folders: assets, config, controllers, models, views, vendor, and web, its mvc-driven entry point and installation on a cross-platform web server.
Yii Framework Installation5:01
Install the Yii framework from a tar archive without composer, verify the WAMP server, set the PHP path, and create a new application via the command line.
Creating a Basic Page7:25
Create a basic page in the E framework by configuring the app, printing a hello world output via the site controller's speak action, and rendering it in the view.
Creating a Basic Page Continues7:17
Build a basic page in PHP using a framework by wiring controllers, views, and actions, rendering output with a message parameter, and handling routes and get requests with HTML-encoded output.
Understanding Yii Controllers6:43
Understand how EA controllers process requests and generate responses, acting as intermediaries between models and views through actions like login and contact that render outputs.
Understanding Routing Structure8:03
Discover how to create a new controller and map URL patterns to routes in a Yii PHP application. Explore module id, controller id, and action id.
Displaying output0:38
Explore how output is displayed by wiring a cookie validation key in web.php, associating the user and identity classes, and rendering via the first controller's index action for an iframe.
What is Model10:12
Implement business logic and data rules through models in mvc architecture, manage data via the controller, and display results in view; support attributes, labels, captcha verification, mailer use, and scenarios.
Understanding Views5:43
Explore how views display output in web app using PHP, html, and JavaScript. Learn to edit templates and encode input with html encode and html purifier to prevent cross-site scripting.
Understanding Views Continues7:25
Explore rendering views in a PHP web app, using HTML purifier, passing parameters from a controller, and printing an about view with email and phone details.
Widgets5:07
Explore widgets in the E framework as reusable client-side HTML, CSS, and JS components. Learn to create a widget, render it via site controller, and display a Bootstrap progress bar.
Yii Layouts10:26
Learn how Yii layouts organize common HTML sections in a dedicated view layouts folder, using head, begin body, and end body, to deliver consistent headers, footers, and widgets across pages.
Routing Yii Framework8:51
Explore how actions in the Yii framework are defined as public methods in controllers, returning responses and routing outputs, including redirects to external URLs like google.
Actions Yii Framework6:41
Explore how routing maps URLs to controllers and views in the E framework, using the URL manager and rules to resolve actions like index, login, and contact.
Cookies and Sessions8:49
Explore cookies and sessions, their roles in http requests, and the differences between client-side cookies and server-side sessions in PHP.
Cookies and Sessions Continues5:01
Learn how cookies are managed in PHP, including language cookies and existence checks, and how the E framework opens, uses, and destroys sessions, highlighting their differences.
About File Upload9:12
Build a PHP file upload feature using an UploadImageForm model with image validation, then handle post requests in the site controller to save files to uploads folder and render view.
Flash Data Concept5:54
Explore how flash data uses session data to carry a message to the next request, then auto deletes, with a bootstrap alert rendered in the view.
File Upload Continued0:46
Learn how to upload image files in PHP and MySQL apps, validate jpeg and png types, and save uploads to the framework's root uploads directory.
Creating HTML Forms9:28
Learn to create html forms in the e framework using the widget's active form class, model validation, and active record. Build a registration form with username, password, email, and photos.
More on HTML Forms8:09
Shows how to build a bootstrap-styled HTML form with the active form class in the e framework, including username, password, email, and photos fields, from begin to end.
Database Access4:52
Configure database connections with the E framework by editing db.php, using DSN, host, and credentials to access relational databases like MySQL and NoSQL through the framework’s database access object API.
Gii Extension10:09
Discover the Gii extension in the E framework, a web-based code generator that creates models, crud operations, controllers, forms, and modules, demonstrated with a user table.
Controller Generator5:35
Explain how the controller generator creates a controller class with actions and a preview, then cover the form, module, and extension generators for rapid code scaffolding.

Introduction to Project10:07
Learn how PHP enables dynamic, server-side development, distinguish static from dynamic sites, and build a simple PHP web application (home, about, services, contact) using HTML, CSS, JavaScript, PHP, and Bootstrap.
Creating a Project4:20
Install the xampp server, start apache and mysql, then create a project folder in htdocs and structure images, css, and js folders for your php pages on localhost.
Creating Header and Footer Page12:19
Create reusable header and footer in PHP by saving as header.php and footer.php and including them, using a bootstrap nav bar with a brand and a services dropdown.
Creating Home Page8:27
Create the home page with index.php by including header.php and footer.php, then style the content using a Bootstrap container and a separate CSS file.
Creating Home Page Continue6:37
Create a centered home page section with text overlays using h2/h3 tags and divs, apply a background image with cover sizing, and adjust colors and positioning.
Creating About Us Page8:38
Build an about us page in PHP by creating about.php, including header and footer, integrating Bootstrap and CSS, and styling with a background image and centered heading.
Creating About Us Page Continue6:45
Apply practical CSS techniques by using id and class selectors, testing internal vs external CSS, and adjusting margins, font sizes, and colors for a simple about us page.
Creating All Services Page8:52
Learn to build a services page that highlights five offerings—lead generation, demand generation, email marketing, account profiling, and appointment generation—using PHP and HTML structure.
Creating All Services Page Continue6:25
Learn to create five PHP service pages for lead generation, demand generation, email marketing, account profiling, and appointment generation, with separate PHP files and simple styling.
Creating Contact Us Page9:21
create the contact us page by building a two-column layout with a Google Maps embed and a Bootstrap form, using a PHP file and including the header.
Creating Contact Us Page Continue9:00
Build a simple contact us form with name, contact number, and email, plus submit and reset buttons, with labels and colors, and mail submission via PHP that redirects.
Code For Sending Email9:43
Explain how to create a PHP mail_send.php to collect name, mobile, and email from a contact form, build a message, and send it to an admin with subject 'inquiry'.
Output of the Project2:54
Explore how a PHP-driven project uses a reusable header and footer to create dynamic pages, integrate Google Maps, and handle a contact form with success or failure messages.

Introduction and Installation10:08
Discover how Laravel, a PHP framework, follows the MVC pattern with bundles, migrations, and Artisan CLI, and learn environmental setup, configuration, routing, and controllers, plus installation via Composer.
Routing4:41
Explore basic routing in Laravel by mapping the url to controllers, defining routes in app/http/routes.php, and returning views like welcome with get and post functions.
Configuration of Laravel5:50
Explore Laravel configuration through its config directory, detailing app, database, and environment settings, including app.php and database.php, and learn to manage maintenance mode with artisan.
Middleware Laravel7:35
Explore Laravel middleware as the middleman between request and response, learn to create and register global and route middleware with PHP artisan, and apply authentication checks.
Middleware Example9:30
Create a role middleware with php artisan, register it in kernel, attach it to root middleware and routes, build a controller, and route a role url to display the role.
Terminable Middleware9:06
Explore terminal middleware in Laravel, which runs after the response and uses a terminate method with request and response, and see how global middleware is registered in kernel and routes.
Controllers12:38
Learn how Laravel controllers connect views and models, create a demo controller with artisan, and apply middleware to routes or the controller to manage requests and show uri and method.
Request Feature9:33
Explore how Laravel handles request and response by using path, is, and url methods to retrieve the requested uri and full url, with hands-on route and controller setup.
Retrieving Inputs with Request Laravel9:58
Retrieve inputs in laravel using the input method or request instance properties for both get and post, then route to user/register with form including name, username, password and csrf token.
Retrieving Inputs with Request Laravel Continues8:58
Explore a Laravel post register function that uses a request parameter to retrieve name, username, and password, then prints these values for verification.
Response2:38
Learn how to return responses in Laravel, route from routes.php, and display strings or data like parameters and arrays in the browser, with cookies and sessions covered in upcoming chapters.
Cookies8:18
Learn how to create and manage cookies in Laravel by setting and retrieving cookie values in a controller, routing them to URLs, and inspecting browser outputs.
Views10:44
Learn how Laravel views separate presentation from logic in MVC and are stored in resources/views. Pass data to views via routes, and share across views with app service provider boot.
Redirection5:14
Explore redirections in laravel by redirecting to a named route, configuring routes.php, and connecting views like test.php and test two to share data.

Laravel Localization9:38
Explore Laravel localization by creating language directories under resources/lang and lang.php translation files for English, French, and German, then build a localization controller and routes to display translated messages.
Sessions Laravel11:25
Explore how Laravel manages sessions as server-side data, with drivers like cookies, array, and Redis, and learn to access, store, and delete session data.
Creating Forms6:10
Creating Forms Continues7:29
Create a Laravel form with HTML inputs for username, email, and password, add checkbox and radio options, and map the form to a route to test on localhost:800.
Validations5:57
Learn how Laravel validations handle incoming data, use validation rules, and bind errors to views via the session, with a hands-on example validating username and password in a login form.
More on Validations7:22
Learn to build a login form with HTML and Laravel validation, show errors in a div class 'alert alert-danger' using a foreach over $errors, and route to a validation controller.
Laravel and AJAX7:12
Implement Ajax with Laravel by building a view, wiring a jQuery Ajax call to a post route, and handling json responses to update the message on the page.
More on Ajax3:27
Learn to implement ajax in a Laravel MVC app by building an ajax controller with an index method returning a JSON message, routing it, and displaying it in the browser.
Laravel and E-mail6:30
Learn how to send emails in Laravel using Swift Mailer, using Blade templates and a sample mail controller to configure to, from, subject, and data.
Error Handling5:28
Learn how Laravel handles errors through the handler class, using report and render methods, and create custom error views to display friendly 404, 500, and other error pages.
Database Chapter7:56
Learn Laravel database connectivity with MySQL, Postgres, SQLite, and SQL Server, and master inserting, deleting, updating, and retrieving records via controllers and views.
Database Connectivity6:53
Learn how to set up Laravel database connectivity with MySQL by configuring .env, creating demo db in phpMyAdmin, and running php artisan migrate to generate users and password resets tables.
Retrieving from Database10:21
Explore retrieving records from a Laravel app: fetch user data from the users table, display id, name, and email in a blade view, using a controller and route setup.
Database Insertion8:20
Learn how to insert records into a database using the Laravel framework, including creating a controller, an insert form, and a database insert operation that redirects after success.
Inserting to Database Continued5:15
Create a web form with a table layout for username input and a submit button, then route and insert the data into a MySQL database using PHP controllers.
Output Updating Records8:38
Build a user update view with a form, CSRF token, and post action to edit and update records in a Laravel PHP and MySQL setup, illustrating the CRUD flow.
Security5:36
Discover how Laravel secures web applications with authentication, password hashing via hash make and hash check, secure cookies, and artisan command-line tools for secure development.
Updating Records Laravel7:08
Build a Laravel update controller with index, show, and edit methods to fetch users, render the user edit view, and apply updates via a database update query.
Updating Records Laravel Continues7:10
Learn updating user records in Laravel by building show and edit blade views under resources/views, listing users with edit links and handling updates that display 'record updated'.

Setting up Server8:09
Set up and start your web server, install PHP, and test the setup to enable server-side programming that generates dynamic pages in a test environment.
Creating a Simple file in PHP9:48
Install and configure a local web server stack (Apache, MySQL, PHP) with Xampp, start the server, and test PHP by creating a simple file and viewing it at localhost.
Creating Sample PHP Program6:43
Learn to create your first PHP program, print hello world, and generate HTML on the server using PHP print statements, quotes, and here docs, and view it via localhost.
Using Variables in PHP7:35
Building XHTML Output6:29
Explore how PHP generates XHTML output by string manipulating variables, concatenation, escaping quotes, and using here docs to build HTML tables like name and address, preserving line breaks.
Using HEREDOC7:00
Explore how to use heredoc in PHP to output HTML with preserved formatting and variable interpolation. Switch between PHP and XHTML to embed dynamic values in a table.
Generating HTML with PHP Extra Examples6:14
Generate HTML with PHP by creating XHTML documents, declaring variables, and echoing outputs with breaks, while exploring PHP variable types and arrays via var_dump.
Generating HTML with PHP Extra Examples Continues7:50
Explore PHP arithmetic and assignment operators, variables, and HTML output using echo and print to perform addition, subtraction, multiplication, division, modulo, and type-aware comparisons with var_dump.
PHP and Forms8:31
Learn how XHTML forms work with PHP, embed PHP in XHTML, and use the date function to format date and time, handle get or post data, and generate XHTML responses.
Example PHP and Forms5:58
Explore sending form data from HTML to PHP. Build ask name.html and greet user.php, using a get method, input name, label, and submit, plus PHP date for server time.
Form Get Method6:57
define form inputs with a name attribute for server processing, use a submit button and action, and choose the get method to pass data via the URL in PHP.
Form Post Method7:52
Compare the post method, which sends form data in the body for better security, with get, and explore PHP super globals like $_GET, $_POST, and $_REQUEST.
Multiple Input Type9:02
Explore how PHP's $_REQUEST super global retrieves both GET and POST data, and practice extracting from dropdowns, radio buttons, and checkboxes with a Monty Python quiz example.
Example Multiple Input Type6:07
Build a PHP form handler that processes input types via post, using radio buttons with the same name and checkboxes with individual names, retrieving data with $_REQUEST to render results.
PHP and XHTML Forms Extra Examples11:25
Explore handling multi-type form data by embedding PHP in an XHTML form, extracting inputs with $_REQUEST, and building output with a here doc; add form validation and CSS styling.
PHP and XHTML Forms Extra Examples Continues9:19
Explore PHP form handling and XHTML form examples with post and self-referencing actions, validate inputs, and echo submitted name, email, website, comment, and gender.
If Conditions8:31
Explore PHP control structures, including if else, switch, while and for loops, using comparison operators and booleans to drive decisions and flow in XHTML-based examples.
If Else Conditions5:50
Master PHP if, else, and else if to evaluate booleans, print conditional outputs, and structure code within HTML pages using variables, random numbers, and nested conditions.
Multiple If Else7:23
Build a PHP page that uses a random number between 1 and 8 to trigger chained if-else statements, displaying eight-ball images via img tags and handling errors.
Comparison Operators Part 18:43
Learn to use comparison operators in PHP, including equals, not equals, less than, greater than, and their combinations, and apply them in an if-else driven program that simulates dice rolls.
Comparison Operators Part 212:08
Explore PHP comparison operators and logical operators, learning to craft if and elseif blocks with and, or, and xor. Build hands-on examples that evaluate multiple conditions for dynamic web pages.
Logical Operators2:22
Explore using logical operators to simplify if statements, compare values with switch constructs, and employ break and default cases to write compact, robust PHP control flow.
Switch Case Condition8:56
Create a dynamic web page using PHP switch case to display eight ball images based on a random number, and extend with a while loop for a dice rolling game.
Loops Condition7:51
Explore for and while loops in PHP, detailing initialization, condition, and incrementation, and apply them to a dice rolling game to count sixes with optional break logic.

One Dimensional Array10:31
Explore one dimensional arrays in PHP, learning how to create, fill, and access elements, including zero-based indexing and using for each loops.
Print R Function4:15
Explore using PHP to print arrays and random elements with the print_r function. Learn debugging techniques by inspecting arrays and outputs.
Associative Array7:59
Master associative arrays in PHP using string keys for name-value pairs, note that order is undefined, and extend to multidimensional arrays for a card deck using $_GET and $_POST.
Multidimensional Array7:49
Demonstrate using a multidimensional array to model a deck of cards, access card values, and deal five cards to a player with rank and suit in PHP.
For Each Loop with Array6:45
Master foreach loops in PHP to simplify array management, iterating through single and multidimensional arrays to print values and access element data.
Working with Examples9:55
Walk through building and iterating associative arrays in PHP, using nested foreach loops to output a dynamic HTML list of languages with details and a reference link.
For Each Loop for Associative Array9:51
Creating Functions9:40
Create functions to encapsulate your code and manage complexity. Learn variable scope and session variables to persist values across requests, illustrated by rolling dice with random numbers.
Variables in Functions5:54
Define and call a PHP function named roll die inside a for loop, encapsulating dice logic and exploring global scope with the global modifier and returning data from functions.
Returning Data Variable from Function6:31
Learn how to return data from functions using a get_name example, then explore session variables for persisting data across requests with per-user session IDs.
Returning Data Variable from Function Continues5:04
Learn how to use PHP sessions to track rolls of a die, manipulating $_SESSION data with a function, and persist totals across requests.
File Functions9:46
Master PHP file manipulation with f open, f write, and f close to read and write text and CSV files, and work with file and directory functions.
Writing into CSV File5:01
learn how to write data into a csv file with php using a foreach loop and fputcsv, then read csv or text files with fopen and fgets.
Reading From CSV File6:50
reads data from a csv file in php, parses lines into an array, builds sql insert statements from csv columns, and demonstrates listing files with open dir and read dir.
Directory Functions8:42
Explore directory functions in PHP, including opendir, readdir, and chdir, to iterate through files, build an array, and generate hyperlinks to directory contents.
Retrieving Data from My SQL6:46
Establish a data connection in PHP to MySQL using localhost, a username, and a password, then run a select star from the contact table and display results in HTML.
Displaying Result from Database7:11
Learn to display results from a database in PHP by using nested loops to fetch rows with while, extract fields with foreach, and print as an associative array.
Displaying in XHTML Table7:58
Show how to display SQL data with PHP and MySQL in XHTML tables, using while and foreach loops and a definition list, with CSS styling for presentation.

Requirements

Basic Understanding of HTML/CSS: Familiarity with HTML and CSS is necessary to understand how PHP integrates with these technologies for web development.
Basic Programming Knowledge: Some experience with programming concepts and languages (e.g., JavaScript, Python, etc.) will be beneficial for understanding PHP syntax and logic.
Web Development Fundamentals: Knowledge of how web servers and browsers interact, as well as an understanding of client-server architecture, will be helpful.
Computer with Internet Access: A reliable computer with a stable internet connection is essential for accessing course materials, software downloads, and online resources.
Software Installation: Ability to install software like PHP, MySQL, and a local development environment (e.g., XAMPP, WAMP, or MAMP) on your computer.
Text Editor/IDE: Familiarity with a text editor or Integrated Development Environment (IDE) such as Visual Studio Code, Sublime Text, or PHPStorm.
Motivation to Learn: A willingness to learn and practice coding regularly to gain proficiency in PHP and MySQL.
No advanced programming skills are required, and beginners with a basic understanding of web development will find the course accessible and informative.

Description

Introduction

This comprehensive course is designed to take you from a novice to an expert in PHP and MySQL, the backbone of dynamic and interactive web development. With a step-by-step approach, the course covers fundamental concepts, advanced techniques, and best practices for building robust web applications.

Section 1: PHP Fundamentals

The first section introduces the basics of PHP, starting with an overview of its role in web development. You will learn the essential syntax, how to embed PHP in HTML, and the basic structure of PHP scripts. The section covers the installation of PHP on various operating systems, ensuring that you have the right environment for development. Key topics include writing your first PHP script, understanding PHP's case sensitivity, and working with variables, constants, and data types. This section lays a strong foundation, making you comfortable with PHP basics before moving on to more advanced topics.

Section 2: CakePHP - Web Application Development with CakePHP

This section dives into CakePHP, a powerful PHP framework that simplifies web application development. You will learn about its history, features, and the MVC architecture it uses. The lectures cover everything from installation and configuration to advanced topics like routing, session management, and error handling. By the end of this section, you'll be equipped to build and manage web applications using CakePHP efficiently.

Section 3: Project - Web Application Development with Yii PHP

The Yii framework is another popular PHP framework that enhances productivity and performance. This section guides you through the Yii framework's installation and configuration, understanding its MVC framework, and creating basic pages. You'll explore advanced features such as controllers, routing, and working with views. Practical projects will solidify your understanding, enabling you to build sophisticated web applications with Yii.

Section 4: Project on PHP - Developing Web Applications

In this hands-on section, you'll apply what you've learned to develop a complete web application. Starting with project creation, you'll build essential components like headers, footers, and various pages (home, about us, services, contact us). You'll learn to code for sending emails and implement all functionalities to bring your project to life. This practical approach ensures you gain real-world experience in web development.

Section 5: Laravel PHP Framework Training

Laravel is renowned for its elegance and simplicity. This section introduces you to Laravel, covering installation, routing, configuration, and middleware. You'll explore Laravel's powerful features like controllers, request handling, response, and cookies. The section ensures you understand how to leverage Laravel to build scalable and maintainable web applications.

Section 6: Advanced Laravel PHP Framework Training

Building on the basics, this section delves into advanced Laravel topics. You'll learn about localization, session management, form creation, validation, AJAX, and email handling. The database chapter covers connectivity, data retrieval, insertion, updating records, and security. This section prepares you to tackle complex web application requirements using Laravel.

Section 7: XHTML - Server Side Programming with PHP

Understanding server-side programming is crucial, and this section focuses on PHP's server-side capabilities. You'll set up the server, create PHP programs, and build XHTML output. The lectures cover form handling, GET and POST methods, and various input types. Practical examples and exercises ensure you can handle server-side programming tasks effectively.

Section 8: XHTML - Advanced Server Side Programming with PHP

The final section takes server-side programming to the next level. You'll work with arrays, create and manage functions, and handle files (reading, writing, CSV operations). Advanced topics include directory functions, retrieving data from MySQL, and displaying results in XHTML tables. By the end of this section, you'll be proficient in advanced server-side programming with PHP.

Conclusion

This course provides a thorough understanding of PHP and MySQL, covering both foundational and advanced topics. By the end of the training, you'll be well-equipped to build dynamic, interactive, and robust web applications. Whether you're a beginner or looking to enhance your skills, this course offers the knowledge and practical experience you need to succeed in web development.

Who this course is for:

Aspiring Web Developers: Individuals looking to start a career in web development or enhance their existing skills with PHP and MySQL, two of the most widely used technologies for building dynamic websites and applications.
Students and Graduates: Those pursuing computer science or software engineering degrees who want to gain practical, hands-on experience with web development technologies.
Career Changers: Professionals from other fields who are interested in transitioning into web development and need a comprehensive, practical foundation in PHP and MySQL.
Freelancers and Entrepreneurs: Freelancers and small business owners who want to build or improve their own websites or web applications, and need to understand PHP and MySQL for effective project management.
Developers Seeking New Skills: Experienced developers familiar with other programming languages who want to add PHP and MySQL to their skill set to broaden their capabilities and marketability.
Hobbyists and Enthusiasts: Individuals passionate about web development who enjoy learning new technologies and want to experiment with building dynamic web applications.
This course caters to a wide range of learners, from those new to programming to seasoned developers looking to expand their expertise.

PHP & MySQL - The Ultimate Web Development Training

What you'll learn

Explore related topics

Course content