PHP / MySQL

We also provide knowledge about Zend framework, Smarty, Joomla and Wordpress

We aim to provide manuals, self-help books and guide books that can improve the quality of your education. Each is written by an expert in his or her field and can be downloaded as an e-book.
PHP / MySQL
MySQL™ and PHP are two of the most popular open source technologies to emerge during the past decade. PHP is a powerful language for writing server-side Web applications. MySQL is the world's most popular open source database. Together, these two technologies provide you with a powerful platform for building database-driven Web applications.

This hands-on MySQL and PHP training course teaches attendees everything they need to successfully build data-driven Web sites using MySQL and PHP.We also provide knowledge about Zend framework, Smarty, Joomla and Wordpress
  1. PHP Basics
    1. How PHP Works
    2. The php.ini File
    3. PHP Statements and Whitespace
    4. PHP Functions
    5. Hello World!
    6. Variable Types
    7. Constants
    8. Variable-Testing and Manipulation Functions
    9. PHP Operators
    10. Creating Dynamic Pages

  2. Flow Control
    1. Conditional Processing
    2. If Conditions
    3. Loops

  3. String Manipulation
    1. Formatting Strings
    2. String Manipulation Functions
    3. Examples of String Functions

  4. Reusing Code and Writing Functions
    1. Including Files
    2. Require
    3. Require_once
    4. Auto_prepend_file and auto_append_file
    5. User Functions
    6. Defining and Calling Functions
    7. Default Values
    8. Variable Scope
    9. By Reference vs. By Value
    10. Form Processing

  5. PEAR:DB
    1. Advantages and Disadvantages of PEAR DB
    2. Why use a database abstraction layer?
    3. When not to use a database abstraction layer?
    4. Using PEAR DB

  6. Authentication with PHP and SQL
    1. A Database-less Login Form

  7. Regular Expressions
    1. Perl-compatible Regular Expression Functions
    2. Regular Expression Tester
    3. Regular Expression Syntax
    4. Form Validation Functions with Regular Expressions

  8. Session Control and Cookies
    1. Sessions
    2. Configuring Sessions
    3. Session Functions
    4. Cookies

  9. Sending Email with PHP
    1. Mail
    2. Shortcomings of mail()
    3. PHPMailer

  10. File System Management
    1. Opening a File
    2. Reading from a File
    3. Writing to a File
    4. File Locking
    5. Uploading Files via an HTML Form
    6. Directory Functions

  11. Object-Oriented PHP
    1. Building a Class and Object
    2. Working with Properties and Functions
    3. Private, Protected, Public modifiers
    4. Inheritance
    5. Interfaces
    6. Building a Web Page Object

  12. PHP XML Support
    1. Simple XML Object
    2. Executing XPath Queries
    3. DOM Interoperability
    4. Using XPath
    5. Applying Server side XSL Transformations
    6. Using XML in N-Tier Architecture
    7. Mixing PHP Objects and XML

  13. PEAR: HTTP_REQUEST MODULE
    1. Installing PEAR::HTTP_REQUEST with Dependencies
    2. HTTP_REQUEST Capability
    3. HTTP GET Request
    4. HTTP POST Request
    5. Programmatically Posting to a HTML Form
    6. Parsing the Response
    7. Building a Basic Authentication PHP Client

  14. XML RPC
    1. XML-RPC Implementations
    2. XML RPC Data-Types
    3. XML RPC Server
    4. XML RPC Client
    5. XML RPC Request and Response
    6. Exploring the XML RPC API

  15. PHP Web Services
    1. Web Service Technology Stack
    2. SOAP Soup
    3. Web Services with PHP
    4. Building a SOAP SERVER
    5. Consuming a Web Service
    6. Generating WSDL Dynamically
    7. Understanding Generated WSDL
    8. WSDL and SOAP Proxies

  16. Complex PHP Web Services
    1. Building Interoperable Web Services
    2. Generating and Handling SOAP Faults
    3. RPC Vs. Document Message Encoding
    4. Serializing the SOAP Envelope
    5. Web Service Best Practices

  17. Ajax with PHP
    1. Ajax Overview
    2. Ajax Technology Stack
    3. Ajax Implementations
    4. Installing and configuring HTML_Ajax Pear Module
    5. Ajax Server
    6. Ajax Client

  18. Smarty Templates
    1. Smarty Overview
    2. Installing and configuring Smarty Pear Module
    3. Setting up a Template
    4. Passing Data to the Template
    5. Smarty for Template Designers
    6. Smarty for Programmers
    7. Smarty in N-Tier Architecture

  19. Dynamic Web Sites
    1. Dynamic Web Site Basics
    2. Developing with a Local Server
    3. Developing with a Remote Server
    4. Defining a Dynamic Site in Dreamweaver
    5. Building a Simple Dynamic Application

  20. Passing Data Between Pages
    1. Understanding the HTTP Protocol
    2. Retrieving Data from the URL
    3. Sending Data with Hyperlinks
    4. Setting and Retrieving Cookies

  21. Sending Email from a Web Form
    1. Introducing SMTP Email Service
    2. Configuring your System to Send SMTP Email Messages
    3. Configuring your System to Send Email
    4. Writing the Code to Send a Message
    5. Understanding Objects, Methods, and Properties
    6. Creating the Web Form
    7. Emailing Dynamic Form Values
    8. Client-Side Form Validation

  22. Building a Tour Price Calculator
    1. Creating the Pages
    2. Building the Form
    3. Collecting, Processing, and Displaying the Data
    4. Adding Server-Side Form Validation
    5. Creating the Conditional Region
    6. Creating and Applying a Custom CSS Class
    7. Databases on the Web
    8. Introduction/Review of Databases
    9. Introduction to the Database Used in Class
    10. Connecting to the Database
    11. Retrieving Recordsets and Displaying Database Information

  23. Completing the Price Calculator
    1. Dynamically Populated Drop-Down Menus
    2. Creating Filtered Recordsets
    3. Revising the Calculation Script with Live Data
    4. Documenting Your Code with Comments

  24. Filtering and Displaying Data
    1. Generating URLs Dynamically
    2. Populating Page Layouts Dynamically
    3. Adding Dynamic Images and Formatting the Population Number
    4. Looking Up Foreign Table Data with SQL
    5. Planning the Application
    6. Creating Recordsets with Joins
    7. Inserting the Images and the ALT Attributes
    8. Implementing the Recordset Paging
    9. Passing Data to Other Applications

  25. Building Search Interfaces
    1. Preparing the Search Page and Creating the Search All Link
    2. Searching by Region: Building the Interfaces
    3. Searching by Country: Filtering by Form Variable
    4. Switching SQL Statements According to Environment Variables

  26. Authenticating Users
    1. User Authentication as a Web Application
    2. Building the Registration Pages
    3. Building the Log-in Page
    4. About Session Variables
    5. Restricting Access to Pages
    6. Managing Content with Forms

  27. Creating the Admin Section
    1. Creating the Form Interface
    2. Using Session Variables and Hidden Fields to Track Users
    3. Inserting the Record

  28. Building Update Pages
    1. Preparing the Pages
    2. Planning for the Master-Detail Pages
    3. Making the Detail Page Updateable

  29. Arrays
    1. Enumerated Arrays
      1. Initializing Arrays
      2. Appending to an Array
      3. Reading from Arrays
      4. Looping through Arrays

    2. Initializing Arrays
    3. Appending to an Array
    4. Reading from Arrays
    5. Looping through Arrays
    6. Associative Arrays
      1. Initializing Associative Arrays
      2. Reading from Associative Arrays
      3. Looping through Associative Arrays
      4. Superglobal Arrays
    7. Two-dimensional Arrays
      1. Reading from Two-dimensional Arrays
      2. Looping through Two-dimensional Arrays
    8. Array Manipulation Functions
    9. Conclusion

  30. PHP and HTML Forms
    1. HTML Forms
      1. How HTML Forms Work
      2. A Sample HTML Form
      3. Form Variables
    2. How HTML Forms Work
    3. A Sample HTML Form
    4. Form Variables
    5. Conclusion

  31. PString Manipulation
    1. Formatting Strings
      1. Concatenation
      2. String Manipulation Functions
      3. Examples of String Functions
    2. Concatenation
    3. String Manipulation Functions
    4. Examples of String Functions
    5. Magic Quotes
      1. magic_quotes_gpc
      2. magic_quotes_runtime
      3. Recommendation on Magic Quotes
      4. Conclusion

  32. Reusing Code and Writing Functions
    1. Including Files
      1. require
      2. require_once
      3. auto_prepend_file and auto_append_file
    2. User Functions
      1. Defining and Calling Functions
      2. Default Values
      3. Variable Scope
      4. By Reference vs. By Value
    3. Defining and Calling Functions
    4. Default Values
    5. Variable Scope
    6. By Reference vs. By Value
    7. Form Processing
      1. Code Organization
    8. Conclusion

  33. Simple SELECTs
    1. Introduction to the Northwind Database
    2. Some Basics
      1. Comments
      2. Whitespace and Semi-colons
      3. Case Sensitivity
    3. SELECTing All Columns in All Rows
    4. SELECTing Specific Columns
    5. Sorting Records
      1. Sorting By a Single Column
      2. Sorting By Multiple Columns
      3. Sorting By Column Position
      4. Ascending and Descending Sorts
    6. The WHERE Clause and Operator Symbols
      1. Checking for Equality
      2. Checking for Inequality
      3. Checking for Greater or Less Than
      4. Checking for NULL
      5. WHERE and ORDER BY
    7. The WHERE Clause and Operator Words
      1. The BETWEEN Operator
      2. The IN Operator
      3. The LIKE Operator
      4. The NOT Operator
    8. Checking Multiple Conditions
      1. AND
      2. OR
      3. Order of Evaluation
    9. Conclusion

  34. Subqueries, Joins and Unions
    1. Subqueries
    2. Joins
      1. Table Aliases
      2. Multi-table Joins
    3. Table Aliases
    4. Multi-table Joins
    5. Outer Joins
    6. Unions
      1. UNION ALL
      2. UNION Rules
    7. Conclusion

  35. Inserting, Updating and Deleting Records
    1. INSERT
    2. UPDATE
    3. DELETE
    4. Conclusion

  36. Managing Data
    1. Querying a Database
      1. mysqli() Overview
      2. mysqli Methods and Properties
      3. Inserting and Updating Records
      4. mysqli Prepared Statements

  37. PEAR:DB
    1. Advantages and Disadvantages of PEAR DB
      1. Why use a database abstraction layer?
      2. When not to use a database abstraction layer?
    2. Using PEAR DB

  38. Authentication with PHP and SQL
    1. A Database-less Login Form
    2. Conclusion

  39. Regular Expressions
    1. Perl-compatible Regular Expression Functions
      1. preg_match()
      2. preg_replace()
      3. Regular Expression Tester
    2. Regular Expression Syntax
      1. o Start and End ( ^ $ )
      2. Number of Occurrences ( ? + * {} )
      3. Common Characters ( . \d \D \w \W \s \S )
      4. Grouping ( [] )
      5. Negation ( ^ )
      6. Subpatterns ( () )
      7. Alternatives ( | )
      8. Escape Character ( \ )
    3. Form Validation Functions with Regular Expressions
    4. Conclusion

  40. Session Control and Cookies
    1. Sessions
      1. Configuring Sessions
      2. Session Functions
      3. Regular Expression Tester
    2. Cookies
    3. Conclusion

  41. Sending Email with PHP
    1. mail
      1. Shortcomings of mail()
      2. Session Functions
    2. HPMailer
    3. Conclusion

  42. File System Management
    1. Opening a File
      1. fopen
    2. Reading from a File
      1. fgets()
    3. Writing to a File
      1. fwrite
    4. File Locking
      1. flock
    5. Uploading Files via an HTML Form
    6. Getting File Information
    7. More File Functions
    8. Directory Functions
      1. Getting a Directory Listing
 
Tools:
IDE Dreamweaver 8
Web ServerApache 3.4,IIS 6.0
Database MySQL / SQL Server 2005 / Postgre SQL
Web Framework Zend 0.1.5
All trainings are done with REAL TIME PROJECTS
Training Duration : 3 months
Class Allotment:3 days in a week
Training Fee: Rs. 5,000 only
 
Apply for :