-
Administering MySQL Database by Using phpMyAdmin
After watching this video; you will be able to create users and assign permissions by using phpMyAdmin.
-
Comparing MySQLi and PDO
After watching this video; you will be able to compare different methods to connect MySQL with PHP.
-
Configuring a Network Service in Linux
After watching this video; you will be able to start and stop a network service.
-
Configuring the MySQL Server
After watching this video; you will be able to create a user and a database in MySQL.
-
Connect MySQL with PHP by Using PDO
After watching this video; you will be able to insert; update; delete; and retrieve data by using PDO.
-
Connecting PHP with MySQL
After watching this video; you will be able to connect PHP with the MySQL database server.
-
Create a Stack
After watching this video; you will be able to install LAMP and then connect PHP with the MySQL server.
-
Creating a Table and Adding Data
After watching this video; you will be able to create a table and add data in MySQL.
-
Creating Connections with PDO
After watching this video; you will be able to create connections by using PDO.
-
Creating Database and Tables by Using PDO
After watching this video; you will be able to create database and tables in MySQL by using PDO.
-
Creating Databases and Tables by Using MySQLi
After watching this video; you will be able to create database and tables by using MySQLi.
-
Creating Transactions and Autocommit by Using PDO
After watching this video; you will be able to create transactions and autocommit by using PDO.
-
Creating Transactions by Using MySQLi
After watching this video; you will be able to create transactions with MySQLi.
-
Deleting Data by Using MySQLi
After watching this video; you will be able to delete data by using MySQLi.
-
Deleting Data by Using PDO
After watching this video; you will be able to delete data by using PDO.
-
Editing a File in Linux
After watching this video; you will be able to edit a file using the vi editor.
-
Executing Multiple Statements with MySQLi
After watching this video; you will be able to use multiple statements with MySQLi.
-
Handling Errors by Using PDO
After watching this video; you will be able to use error handling with PDO.
-
Inserting Data into a Database by Using MySQLi
After watching this video; you will be able to insert data into database by using MySQLi.
-
Inserting Data into a Database by Using PDO
After watching this video; you will be able to insert data into database by using PDO.
-
Installing and Configuring MySQLi
After watching this video; you will be able to install and configure MySQLi.
-
Installing and Configuring PDO
After watching this video; you will be able to install and configure PDO.
-
Installing MySQL on Linux
After watching this video; you will be able to install MySQL on Linux.
-
Installing PHP Packages
After watching this video; you will be able to install PHP packages in Linux.
-
Installing phpMyAdmin
After watching this video; you will be able to install and use phpMyAdmin to add and view data.
-
Installing the Apache Web Server
After watching this video; you will be able to install the Apache web server on Linux.
-
Installing the Linux Operating System
After watching this video; you will be able to install the Linux operating system.
-
Retrieving Data from Database by Using MySQLi
After watching this video; you will be able to retrieve data from database by using MySQLi.
-
Retrieving Data from Database by Using PDO
After watching this video; you will be able to retrieve data from database by using PDO.
-
Securing the MySQL Installation
After watching this video; you will be able to set password for the root user in MySQL.
-
Selecting Data from MySQL Database
After watching this video; you will be able to select data from the MySQL table and display the table.
-
Storing Data in a Table in RDBMS
After watching this video; you will be able to store data in a table in RDBMS.
-
The Architecture of Linux
After watching this video; you will be able to describe the Linux architecture.
-
Updating Data by Using MySQLi
After watching this video; you will be able to update data by using MySQLi.
-
Updating Data by Using PDO
After watching this video; you will be able to update data by using PDO.
-
Using Decision-making Operators in PHP
After watching this video; you will be able to use if...else statements and switch operators for controlling flow.
-
Using Loops in PHP
After watching this video; you will be able to use while and for loops in PHP.
-
Using Persistent Connections with MySQLi
After watching this video; you will be able to use persistent connections with MySQLi.
-
Using Prepared Statement with MySQLi
After watching this video; you will be able to use prepared statement with MySQLi.
-
Using Prepared Statements with PDO
After watching this video; you will be able to use prepared statements with PDO.
-
Using Stored Procedures with MySQLi
After watching this video; you will be able to use stored procedure with MySQLi.
-
Using Stored Procedures with PDO
After watching this video; you will be able to use stored procedure with PDO.
-
Verifying the HTTPd Daemon
After watching this video; you will be able to start and verify the HTTPd daemon on Linux .
-
Verifying the MySQL Database
After watching this video; you will be able to start and verify the MySQL service on Linux.
-
Viewing Apache Logs
After watching this video; you will be able to view the access and error logs of the Apache web server.
-
Working with the Linux Command Line
After watching this video; you will be able to work with the Linux command line.
-
Connect MySQL with PHP by Using MySQLi
After watching this video; you will be able to insert; update; delete; and retrieve data by using MySQLi.
-
Mysql Connect
PHP is a very popular server-side scripting language. In this video; Andy Alfred demonstrates how to use PHP to connect to a MySQL database.
-
Reading Files from Paths in
PHP provides some built-in methods to access and read data from files stored on your server. In this video; Andy Alfred discusses some functions that open and read the saved files via file paths.
-
Reading Files from Pointers in
During PHP development; you may need to save some data to a file on your server. In this video; Andy Alfred discusses some functions that allow you to save file data to disk.
-
Reading from a MySQL Database Table
PHP is a server-side scripting language designed for web development but also used as a general-purpose programming language. In this video; Andy Alfred demonstrates how to use PHP to retrieve unused records stored in a MySQL database table.
-
Single Quotes vs. Double Quotes in Strings
In PHP; string variables are enclosed in both single quotes and double quotes.In this video; Andy Alfred demonstrates the differences between single and double quote strings in PHP.
-
Sorting Arrays
Array manipulation is a common theme in PHP programming. Arrays are often an ideal data structure for storing similar kinds of data in one location. PHP provides quite a few built-in functions to sort data. In this video; Andy Alfred demonstrates how to use some built-in functions in PHP to make sure arrays stay in order.
-
Strings with HEREDOC and NOWDOC
In PHP; the built-in HEREDOC and NOWDOC strings allow you to deal with very long strings. In this video; Andy Alfred discusses how to use the HEREDOC and NOWDOC string formats in PHP.
-
Uploading a File to a Server
PHP allows a user to upload files to your server by using the $_FILES variable; which contains all the data you need to validate; process; and save the file data coming from a client browser. In this video; Andy Alfred demonstrates how to work with the $_FILES variable.
-
Using the SimpleXML Extension
PHP contains a few different ways to work with the XML data format. In this video; Andy Alfred demonstrates how to use the simpleXML extension.
-
Validating Required Form Input Fields
Information that is entered into any form on the web must be properly validated before the form is submitted. This ensures the transfer of legitimate data. In this video; Wesley Miller demonstrates how to use PHP to check for empty form field submissions and provide error feedback to the user if an empty submission is attempted.
-
Working with Associative Arrays in
Associative arrays are used to store each object with an associated key. In this video; Wesley Miller discusses how to create an associative array; how to loop through its elements to obtain information about each key; and its associated value.
-
Working with Built in String Functions
PHP provides a few built-in functions for working with strings that just makes it easy to work with. In this video; Andy Alfred demonstrates how to work with built-in string functions.
-
Working with Decision Statements in
Decision statements are typically a key part of any web script and generally occur in the form of if…else statements or switch statements. In this video; Wesley Miller demonstrates how to write a basic if…else statement and a switch statement in PHP.
-
Working with Indexed Arrays in
In PHP; arrays are used to store lists of objects. In this video; Wesley Miller discusses how to create an indexed array.
-
Working with JSON
PHP has built-in functions for easily working with JavaScript Object Notation or JSON; which is a lightweight protocol to transfer data between the client and the server. In this video; Andy Alfred demonstrates how to work with JSON.
-
Working with Math Functions
PHP is a very popular server-side scripting language used by millions of web servers today. In this video; Andy Alfred demonstrates how to use the math functions minimum and maximum; which are built into PHP.
-
Working with the $_SERVER Variable
In PHP; the built-in $_SERVER variable helps you collect valuable user statistics for tracking the traffic to your web page. In this video; Andy Alfred discusses some of the key metrics available from the $_SERVER variable.
-
Working with the Date() Function
In PHP; you can use the built-in date function to format a date either with the actual words for the day and the month of the year or just a numeric representation of the date. In this video; Andy Alfred demonstrates how to use the date function to get the different formats of dates.
-
Working with the GET Method
PHP is a popular scripting language used by web servers world over. In this video; Andy Alfred demonstrates how to get form data from a client browser to the PHP server by using the GET variable.
-
Working with the POST method
PHP is a popular server-side scripting language used by millions of web servers. In this video; Andy Alfred demonstrates how to get your data from my client browser to your PHP server using the Post variable.
-
Working with Variable Variables
In PHP if you’re not familiar with the concept of a variable you won’t get far. In this video; Andy Alfred discusses how and why to work with variable variables in PHP.
-
Writing Files
PHP provides some built in methods for us to use to accomplish the task of accessing and reading data from files on the server. In this video; Andy Alfred discusses a few functions that open and read the saved files primarily via file pointers.
-
Writing Simple Mail Forms
PHP can be used to create a form and send its data to another location. In this video; Wesley Miller demonstrates how to create a basic contact form that has two text input fields; a text area input field and a submit button.
-
Deleting Data from a MySQL Database Table
It is very common to see PHP used in conjunction with a MySQL database. In this video; Andy Alfred demonstrates how to use PHP to delete records stored in a MySQL database table.
-
Equal vs. Identical
In PHP; the double-equal sign operator is used mainly in decision making logic. However; the triple-equal sign or identity operator is relatively unknown. In this video; Andy Alfred explores the similarities and differences between the equal and identical operators.
-
Implementing User-Defined Functions
In PHP a user can write custom functions in PHP as part of their web application to implement functionality that is not provided by built-in PHP libraries. In this video; Wesley Miller discusses how to create custom functions with and without input arguments and return values.
-
Inserting into a MySQL Database Table
PHP is often used as a general-purpose programming language. In this video; Andy Alfred demonstrates how to use PHP to insert a record into a MySQL database table.
-
The Include and Require Statements
In PHP; you can use both the include and require statements to pull in an external file to your script at runtime. In this video; Andy Alfred discusses how to use the include and require functions.
-
Updating a MySQL Database Table
PHP contains a few different ways to work with the XML data format. In this video; Andy Alfred demonstrates how to use PHP to update records stored in a MySQL database table.
-
Introducing the Zend Framework 2
After watching this video; you will be able to describe what the Zend Framework is and identify the advantages and disadvantages associated with using it when creating PHP applications.
-
Module Directory Structure
After watching this video; you will be able to recognize the folder structure for a typical Zend module as well as the required files contained in the module.
-
MVC Fundamentals
After watching this video; you will be able to describe the MVC (Model-View-Controller) pattern and the overall functionality it provides.
-
Web Server Configuration
After watching this video; you will be able to configure the DocumentRoot settings for the server to point to the public subfolder of your Zend project.
-
Zend Controllers
After watching this video; you will be able to configure controller files to add a controller and views to your ZF2 project.
-
Zend Forms
After watching this video; you will be able to configure Zend forms in your ZF2 project.
-
Zend Module Fundamentals
After watching this video; you will be able to describe the concept of Zend modules and the benefits they provide in a PHP application.
-
Zend ModuleManager
After watching this video; you will be able to configure the Zend ModuleManager to load a module.
-
Zend Views
After watching this video; you will be able to configure Zend views in your ZF2 project.
-
Adding a Service Locator
After watching this video; you will be able to describe the purpose of a service locator and how to add one to your Zend application.
-
Adding a Table to a Zend View
After watching this video; you will be able to add a table to a Zend View and configure the controller to use the view.
-
Configuring the TableGateway Object
After watching this video; you will be able to write the code to initialize and configure the TableGateway object in your Zend application.
-
Creating a TableGateway Object
After watching this video; you will be able to write the code to create a TableGateway object that allows the model to communicate with the database.
-
Creating a Test Zend Module
After watching this video; you will be able to work with the Zend Framework to add various components used in a typical PHP application.
-
Creating a Zend Form
After watching this video; you will be able to create a Zend form and recognize the contents a typical form contains.
-
Creating a Zend Module Using the ZFTool
After watching this video; you will be able to work with the ZFTool to automatically create a Zend module for your project and recognize the files and folders it creates.
-
Creating Module Files
After watching this video; you will be able to manually create the files needed in a custom Zend module.
-
Creating Module Folders (for custom module)
After watching this video; you will be able to manually create the folder structure for a custom Zend module.
-
Development Environment Requirements
After watching this video; you will be able to identify the prerequisite applications needed to be able to use the Zend framework.
-
Framework Fundamentals
After watching this video; you will be able to describe what an application framework is and the benefits of using a framework when creating a PHP project.
-
Installing Composer
After watching this video; you will be able to download; install; and configure the Composer tool for dependency management in PHP.
-
Installing PHP
After watching this video; you will be able to download; install; and configure the appropriate PHP files for the operating system on your development computer.
-
Installing the Zend Framework 2
After watching this video; you will be able to download; install; and configure the Zend Framework 2 and use Composer to add Zend as a project dependency.
-
Installing the Zend Skeleton Application
After watching this video; you will be able to install and recognize the file structure of the sample Zend skeleton application and how it can be used as a starting point for your project.
-
Installing the ZFTool Using Composer
After watching this video; you will be able to use the composer tool to install the ZFTool and describe the functionality it provides.
-
Configuring Routes
After watching this video; you will be able to configure Zend routes to the appropriate controller in your ZF2 project.
-
Installing MySQL
After watching this video; you will be able to install and configure MySQL on your development computer for use in Zend applications.
-
Creating a Model
After watching this video; you will be able to configure a model using the exchangeArray function to handle data from the database.
-
Configuring the Database Connection
After watching this video; you will be able to write the code to configure the database adapter to connect to the database.
-
Working with Cookies
Cookies allow browsers to store bits of information on your computer; so that the browser can remember certain things like preferences; or settings; for the websites you visit. In this video; Andy Alfred demonstrates how to work with cookies in php to make web sites even better.
-
PHP Applications with the Zend Framework: Modifying Your Zend Application
After watching this video, you will be able to work with Zend to add advanced features to a PHP application.
-
PHP Applications with the Zend Framework: Authenticating Specific Areas of the Application
After watching this video, you will be able to configure your Zend application to include HTTP authentication for specific areas of your site.
-
PHP Applications with the Zend Framework: Using the Poedit Tool
After watching this video, you will be able to install and use the Poedit tool to create translation files for use with Zend.
-
PHP Applications with the Zend Framework: Internationalization Fundamentals
After watching this video, you will be able to describe the concepts associated with internationalization and the i18n standard supported by Zend.
-
PHP Applications with the Zend Framework: Adding Site Authentication
After watching this video, you will be able to configure your application to include HTTP authentication for the entire site.
-
PHP Applications with the Zend Framework: Adding Zend\Mail
After watching this video, you will be able to configure your application to use Zend\Mail to send e-mail notifications.
-
PHP Applications with the Zend Framework: Adding Internationalization (Part 2)
After watching this video, you will be able to configure your Zend application to include internationalization.
-
PHP Applications with the Zend Framework: Adding Internationalization (Part 1)
After watching this video, you will be able to configure your Zend application to include internationalization.
-
PHP Applications with the Zend Framework: Configuring the MVC for Pagination
After watching this video, you will be able to edit the model, view, and controller to include pagination for displaying data.
-
PHP Applications with the Zend Framework: Adding Breadcrumb Navigation
After watching this video, you will be able to configure your Zend application to include a breadcrumb navigation bar.
-
PHP Applications with the Zend Framework: Customizing the Layout
After watching this video, you will be able to configure your Zend application to customize the layout including the header and footer.
-
PHP Applications with the Zend Framework - Exercise: Retrieving Data from MySQL
After watching this video, you will be able to work with Zend to configure an application to read data from a database.
-
PHP Applications with the Zend Framework: Adding the Pagination Bar
After watching this video, you will be able to configure your application to include the pagination navigation bar.
-
PHP Applications with the Zend Framework: Configuring the Delete Action
After watching this video, you will be able to write the code to delete data from the database.
-
PHP Applications with the Zend Framework: Configuring the Edit Action
After watching this video, you will be able to write the code to edit data in the database.
-
PHP Applications with the Zend Framework: Configuring the Add Action
After watching this video, you will be able to write the code to add data from the browser to the database.
-
PHP Applications with the Zend Framework: Configuring the Read Action
After watching this video, you will be able to write the code to read data from the database and display it in the browser.
-
PHP Applications with the Zend Framework: Zend Models and Data Persistence
After watching this video, you will be able to describe how Zend handles data persistence and the models available for Zend to communicate with the database.
