What do you want to learn today?

Courses / PHP MySQL with Basic JavaScript : Integrated Course

PHP MySQL with Basic JavaScript : Integrated Course

Web development resume without PHP is like a lake without water. Complete that with this course!

Take this course and get:

  • 21 Live Classes
100% Money-Back Guarantee

Learn more

SAVE 37.5%

Price: 399 $209

- or - Request a Callback - or - Email us: courses@wiziq.com
Starts within 2 Weeks

6 Learners are taking this course

Course Highlights

  • PHP + MySQL + Beginner JavaScript - all in one course
  • You will learn how to create dynamic websites and web applications
  • Also includes project work + live lessons from an experienced teacher

About the Course

Language of Instruction: English

Course Description

Developing advanced web pages,industry standards, project conceptualization --- this course packs this and more.

 

Web pages (or mobile pages) are not going anywhere anytime soon. And, neither is the demand for PHP. Whether its your own personal project or a commercial project, PHP would be used either fully or in parts.

 

The goal of this course is to enable you to write dynamically generated web pages quickly using PHP in server side script, MySQL as database and JavaScript as client side script. This course will touch upon advanced topics like AJAX, concept of OOPs with PHP etc. You’ll also learn how to conceptualize and plan a project.

 

The course package:

 

  • 21 LIVE interactive online classes - interact with the teacher, ask questions, get feedback
  • Access to class recordings to review and revise on your pace, any number of times
  • Course classes: Weekend morning / evening PST times or regular class morning PST times (7-9 AM)
  • LIVE exercises for coding, installation, tuning, configuration etc. via screen sharing
  • Pre-requisite : Windows / Linux system with PHP and MySQL installed. If you don't have this, the instructor can help you install PHP and MySQL as well. You must know some HTML to take this course. If you don't know HTML, request 3 additional classes for HTML before the course starts @ $15 per class.

 

Course Content:

 

Topics: PHP, mysql, javascript

 

Introduction

  • The Origin of PHP
  • PHP is better than Its alternatives
  • How PHP works with the Web Server
  • Hardware and Software requirements and installation
  • PHP Pros and Cons
  • PHP: past, present and future (PHP 3.0, PHP 4.0, and PHP 5)
  • Strength of PHP

 

Basic PHP Development

  • How PHP scripts work
  • Basic PHP syntax
  • PHP variables
  • PHP data types
  • Displaying type information
  • Testing for a specific data type
  • Operators
  • Variable manipulation
  • Dynamic variables
  • String in PHP

 

Control Structures

  • The if statement
  • Using the else clause with if statement, multiple if, nested if.
  • The switch statement
  • Using the ? operator
  • Summary

 

Arrays

  • Single-Dimensional Arrays
  • Multidimensional Arrays
  • Casting Arrays
  • Associative arrays
  • Accessing arrays
  • Getting the size of an array
  • Looping through an array
  • Looping through an associative array
  • Examining arrays
  • Joining arrays
  • Sorting arrays
  • Sorting an associative arrays

 

Loops

  • The while statement
  • The do while statement
  • The for statement
  • Break & continue
  • Nesting loops
  • For each loops

 

Functions

  • Introduction of functions

 

PHP Library Function

  • Array functions
  • String functions
  • Date and time functions
  • Other important functions

 

User Defined Function

  • Defining a function with parameters and without parameters
  • Returning value from function
  • Dynamic function calls
  • Accessing variable with the global statement
  • Function calls with the static statement
  • Setting default values for arguments
  • Passing arguments to a function by value
  • Passing arguments to a function by reference

 

Working With the File System

  • Creating and deleting a file
  • Reading and writing text files
  • Working with directories in PHP
  • Checking for existence of file
  • Determining file size
  • Opening a file for writing, reading, or appending
  • Writing Data to the file
  • Reading characters

 

Working With Forms

  • Forms
  • Super global variables
  • The server array
  • A script to acquire user input
  • Importing user input
  • Accessing user input
  • Combine HTML and PHP code
  • Using hidden fields
  • Redirecting the user
  • File upload and scripts

 

Validation

  • Server side validation
  • Client side validation (Java script)

 

Classes And Objects

  • Introduction of Objects oriented programming
  • Define a class
  • Creating an object
  • Object properties
  • Object methods
  • constructors and destructors
  • Class constants, Access modifier,
  • Class inheritance
  • Abstract classes and methods
  • Object serialization
  • Checking for class and method existence
  • Exceptions
  • Summary

 

Introduction To Database

  • Introduction to SQL
  • Connecting to the MYSQL
  • Database creation and selection
  • Database table creation, update table structure
  • insert, update, delete data to a table
  • Fetch data from table, Acquiring the value, Joins, sub query
  • Finding the number of rows
  • Executing multiple queries

 

Cookies

  • The anatomy of a cookie
  • Setting a cookie with PHP
  • Deleting a cookie
  • Creating session cookie
  • Working with the query string
  • Creating query string

 

Session

  • What is session
  • Starting a session
  • Working with session variables
  • Destroying session
  • Passing session Ids
  • Encoding and decoding session variables

 

Disk Access, I/O, And Mail

  • File upload
  • File download
  • Environment variables
  • E-mail in PHP

 

AJAX (Asynchronous JavaScript and XML)

  • Introduction to AJAX
  • Introduction to XMLHttpRequest Object
  • Method and Properties of XMLHttpRequest
  • Application of AJAX in web application

 

Discussion of a project flow with core PHP, Discussion of database design with front end and backend UI.

 

About the Instructor

Gautam Mukherjee
Gurgaon, India

Gautam Mukharjee is a MCA from Punjab Technical University with 3+ years work experience in this field. He holds a Bachelors in Computer Applications as well as an O Level certification. He lives in India.

 

 

Testimonial
another excellent and very interesting class! I enjoyed it very much.
Discussion

Junk

15 Jul 2014

43 days 18 minutes ago

Live Help