uCertify

PHP and MySQL Web Development

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

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

Why Do Learners Love This Course?

Any questions?
Check out the FAQs

Still have unanswered questions and need to get in touch?

Contact Us Now

PHP and MySQL Web Development

$139.99

Buy Now

Related Courses

All Courses