Advanced PHP/MySQL

Have Queries? Ask us +91 72592 22234

Course Overview


Xpertised Offers Advanced and Personalized Instructor Led Online Classroom training on Advanced PHP/MySQL which gives you the opportunity to interact with a Advanced PHP/MySQL instructor and help you enhance yourself to meet the demands of the industry.

Learn from our instructors from the convenience of your home or office. Interact and learn live with trainers and other participants.

Course Content


Overview Of PHP

  • Static vs. Dynamic Web Sites
  • Dynamic Content from Databases
  • Developing Dynamic Internet Applications
  • Client-Side Scripting vs. Server-Side Scripting
  • Overview of PHP Advantages and Capabilities
  • Configuring PHP.INI
  • PHP vs. ASP

Introduction to the Apache Web Server

  • Apache Configuration Files
  • Configuring Apache for PHP
  • WWW Sites within Apache
  • Apache Virtual Hosts
  • Website Properties

Basic Scripting and Looping Constructs

  • PHP Scripting Fundamentals
  • Print Statement
  • Code Blocks
  • Primitive Data Types
  • Defining Constants and Variables
  • Looping Constructs
  • While
  • Do… While
  • For
  • Exit & Break

Conditional Constructs

  • True and False Expressions
  • If, Else and Elseif
  • Switch/Case Statement
  • The ? (Ternary) Operator
  • Timestamps

PHP Operators

  • Logical Operators
  • Relational Operators
  • Bitwise Operators
  • Other Operators

PHP Functions

  • Introduction to Functions
  • Declaring Functions
  • Scope
  • Passing Arguments to Functions
  • Local and Global Scope
  • Passing Arguments to Functions by Value and Reference
  • Returning Values from a Function
  • Using Include Files
  • The Require Statement
  • Recursion
  • Dynamic Function Calls
  • Predefined PHP Functions

Arrays in PHP

  • What are Arrays?
  • Usage of Arrays in PHP
  • Array Indexing
  • Initializing Arrays
  • Operating on Arrays
  • Sorting Arrays
  • One-Dimensional Arrays
  • Multi-Dimensional Arrays
  • Associative Arrays
  • Array Functions
  • Forms and Arrays in Web Applications

Working with Databases and Forms

  • Configuring PHP For Database Support
  • PHP's Database APIs
  • PHP's SQL API
  • MySQL vs. Access
  • MySQL vs. SQL Server
  • Database Drivers
  • Database Driver Class Wrappers
  • ODBC
  • Simple SQL Queries via PHP
  • Tracking Visitors with Session IDs
  • Populating Forms
  • Retrieving Data from Forms

Working with Data Files in PHP

  • Searching File Contents With Regular Expressions
  • Changing and Editing File Contents
  • Splitting and Joining Information Inside Files
  • String Functions
  • Regular Expression Functions
  • Reading, Writing and Deleting Files
  • Handling File Permissions
  • File Locking
  • Reading Directory Contents
  • Creating and Deleting Directories

Using Cookies with PHP

  • Purpose of Cookies
  • Cookie Myths
  • Setting Cookies
  • Retrieving Cookies
  • Expiring Cookies
  • Deleting Cookies
  • Storing Arrays in Cookies

Configuring and Using MySQL

  • MySQL as a Client/Server Solution
  • Introduction to MySQL Capabilities as a Powerful RDBMS
  • Installing and Configuring MySQL
  • Connecting to MySQL
  • PHP Functions Specific to MySQL
  • Executing SQL Calls
  • Select
  • Insert
  • Fetch
  • Update
  • Delete
  • Using PHP MyAdmin to configure MySQL

Miscellaneous PHP Tasks

  • Error Logging
  • Session Management & Maintaining State
  • Web Application Architecture
  • Using Environment Variables
  • Changing Execution by Redirecting to Other URLs
  • Embedding JavaScript within PHP
  • Using the HTTP Protocols to Pass Data
  • Showing Different Content to Different Browsers
  • Getting IP Addresses from Visitors 

Customer Reviews


Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.
-Waseem

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.
-Tanmoy

...more
Share:

For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for

Myself

My Team/Organization

I agree to be contacted over mail or phone

or
Call us at: +91 7259222234