PHP and MySQL Web Development

(Pearson-PHP-MYSQL-Labs) / ISBN : 978-1-61691-017-4
Lab
263 Reviews
Get A Free Trial

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

Download Course Outline

1

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
2

Storing and Retrieving Data

  • Opening and Reading a File
3

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
4

String Manipulation and Regular Expressions

  • Splitting Strings with Regular Expressions
5

Reusing Code and Writing Functions

  • Reusing the Code
  • Creating a Function
  • Using the Pass by Reference
  • Reversing a String Using Recursion and Iteration
6

Object-Oriented PHP

  • Creating an Instance of a Class
  • Implementing Function Overriding
  • Implementing Static Methods
  • Generating a Fizzbuzz Sequence
7

Error and Exception Handling

  • Creating a User-Defined Exception Class
  • Implementing Error Handling
8

Creating Your Web Database

  • Creating a Table
9

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
10

Advanced MySQL Programming

  • Declaring a Basic Stored Procedure
  • Declaring a Stored Function
  • Using Cursors and Loops
  • Creating a Trigger
11

Implementing Authentication Methods with PHP

  • Implementing a Simple Authentication Mechanism
12

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
13

Using Network and Protocol Functions

  • Verifying the URL and Email Address
14

Managing the Date and Time

  • Calculating Age
15

Generating Images

  • Creating a Simple Line Graph
16

Using Session Control in PHP

  • Creating a Simple Session
17

Integrating JavaScript and PHP

  • Creating Functions Using jQuery
18

Other Useful Features

  • Listing the Extensions Available to PHP
19

Debugging and Logging

  • Declaring a Custom Error Handler

PHP and MySQL Web Development

$139.99

Buy Now