PHP and MySQL Web Development
(Pearson-PHP-MYSQL-Labs) / ISBN : 978-1-61691-017-4
About This Course
Gain skills and expertise in Web development with PHP and MySQL Web Development performance-based labs. Performance-based labs simulate real-world, hardware, software & command line interface environments and can be mapped to any text-book, course & training. The labs offer hands-on experience on the topics like sorting and retrieving data; designing and creating Web database; administrating and programming advanced MySQL; generating images; social media integration and authentication; building a shopping cart; and many more. The labs covers all the concepts related to Web development and help you become a Web developer.
Skills You’ll Get
Hands-On Labs
60+ LiveLab | 00+ Minutes
PHP Crash Course
- Creating a Form
- Creating a Dynamic Form
- Declaring Constants
- Using Arithmetic Operators
- Concatenating Strings
- Using the Ternary Operator
- Using the Type Operator
- Creating an Output Form
- Using the if Statement
- Using the if-else Statement
- Using the switch Statement
- Using the while Loop
- Using the for Loop
- Using the foreach Loop
- Using the do-while Loop
Storing and Retrieving Data
- Opening and Reading a File
Using Arrays
- Creating an Array
- Inserting and Retrieving Values from an Array Using the foreach Loop
- Creating a Multi-dimensional Array
- Sorting an Array
- Generating a Random Value
- Loading Arrays from a File
String Manipulation and Regular Expressions
- Splitting Strings with Regular Expressions
Reusing Code and Writing Functions
- Reusing the Code
- Creating a Function
- Using the Pass by Reference
- Reversing a String Using Recursion and Iteration
Object-Oriented PHP
- Creating an Instance of a Class
- Implementing Function Overriding
- Implementing Static Methods
- Generating a Fizzbuzz Sequence
Error and Exception Handling
- Creating a User-Defined Exception Class
- Implementing Error Handling
Creating Your Web Database
- Creating a Table
Working with Your MySQL Database
- Inserting Values into a Table
- Retrieving All the Attribute Values Using an Asterisk
- Retrieving the Data from Multiple Tables
- Retrieving the Data in Sorted Order
- Using Aggregate Functions
- Using the GROUP BY and HAVING Clauses
- Retrieving the Limited Number of Rows from the Table
- Using the NOT IN Operator
- Updating a Table
- Modifying a Table Definition
- Dropping a Table
Advanced MySQL Programming
- Declaring a Basic Stored Procedure
- Declaring a Stored Function
- Using Cursors and Loops
- Creating a Trigger
Implementing Authentication Methods with PHP
- Implementing a Simple Authentication Mechanism
Interacting with the File System and the Server
- Creating an HTML Form for File Upload
- Displaying the Uploaded Files
- Displaying the Directory List of the Uploaded Files
Using Network and Protocol Functions
- Verifying the URL and Email Address
Managing the Date and Time
- Calculating Age
Generating Images
- Creating a Simple Line Graph
Using Session Control in PHP
- Creating a Simple Session
Integrating JavaScript and PHP
- Creating Functions Using jQuery
Other Useful Features
- Listing the Extensions Available to PHP
Debugging and Logging
- Declaring a Custom Error Handler