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
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
- PHP Basics
- How PHP Works
- The php.ini File
- PHP Statements and Whitespace
- PHP Functions
- Hello World!
- Variable Types
- Constants
- Variable-Testing and Manipulation Functions
- PHP Operators
- Creating Dynamic Pages
- How PHP Works
- Flow Control
- Conditional Processing
- If Conditions
- Loops
- Conditional Processing
- String Manipulation
- Formatting Strings
- String Manipulation Functions
- Examples of String Functions
- Formatting Strings
- Reusing Code and Writing Functions
- Including Files
- Require
- Require_once
- Auto_prepend_file and auto_append_file
- User Functions
- Defining and Calling Functions
- Default Values
- Variable Scope
- By Reference vs. By Value
- Form Processing
- Including Files
- PEAR:DB
- Advantages and Disadvantages of PEAR DB
- Why use a database abstraction layer?
- When not to use a database abstraction layer?
- Using PEAR DB
- Advantages and Disadvantages of PEAR DB
- Authentication with PHP and SQL
- A Database-less Login Form
- A Database-less Login Form
- Regular Expressions
- Perl-compatible Regular Expression Functions
- Regular Expression Tester
- Regular Expression Syntax
- Form Validation Functions with Regular Expressions
- Perl-compatible Regular Expression Functions
- Session Control and Cookies
- Sessions
- Configuring Sessions
- Session Functions
- Cookies
- Sessions
- Sending Email with PHP
- Mail
- Shortcomings of mail()
- PHPMailer
- Mail
- File System Management
- Opening a File
- Reading from a File
- Writing to a File
- File Locking
- Uploading Files via an HTML Form
- Directory Functions
- Opening a File
- Object-Oriented PHP
- Building a Class and Object
- Working with Properties and Functions
- Private, Protected, Public modifiers
- Inheritance
- Interfaces
- Building a Web Page Object
- Building a Class and Object
- PHP XML Support
- Simple XML Object
- Executing XPath Queries
- DOM Interoperability
- Using XPath
- Applying Server side XSL Transformations
- Using XML in N-Tier Architecture
- Mixing PHP Objects and XML
- Simple XML Object
- PEAR: HTTP_REQUEST MODULE
- Installing PEAR::HTTP_REQUEST with Dependencies
- HTTP_REQUEST Capability
- HTTP GET Request
- HTTP POST Request
- Programmatically Posting to a HTML Form
- Parsing the Response
- Building a Basic Authentication PHP Client
- Installing PEAR::HTTP_REQUEST with Dependencies
- XML RPC
- XML-RPC Implementations
- XML RPC Data-Types
- XML RPC Server
- XML RPC Client
- XML RPC Request and Response
- Exploring the XML RPC API
- XML-RPC Implementations
- PHP Web Services
- Web Service Technology Stack
- SOAP Soup
- Web Services with PHP
- Building a SOAP SERVER
- Consuming a Web Service
- Generating WSDL Dynamically
- Understanding Generated WSDL
- WSDL and SOAP Proxies
- Web Service Technology Stack
- Complex PHP Web Services
- Building Interoperable Web Services
- Generating and Handling SOAP Faults
- RPC Vs. Document Message Encoding
- Serializing the SOAP Envelope
- Web Service Best Practices
- Building Interoperable Web Services
- Ajax with PHP
- Ajax Overview
- Ajax Technology Stack
- Ajax Implementations
- Installing and configuring HTML_Ajax Pear Module
- Ajax Server
- Ajax Client
- Ajax Overview
- Smarty Templates
- Smarty Overview
- Installing and configuring Smarty Pear Module
- Setting up a Template
- Passing Data to the Template
- Smarty for Template Designers
- Smarty for Programmers
- Smarty in N-Tier Architecture
- Smarty Overview
- Dynamic Web Sites
- Dynamic Web Site Basics
- Developing with a Local Server
- Developing with a Remote Server
- Defining a Dynamic Site in Dreamweaver
- Building a Simple Dynamic Application
- Dynamic Web Site Basics
- Passing Data Between Pages
- Understanding the HTTP Protocol
- Retrieving Data from the URL
- Sending Data with Hyperlinks
- Setting and Retrieving Cookies
- Understanding the HTTP Protocol
- Sending Email from a Web Form
- Introducing SMTP Email Service
- Configuring your System to Send SMTP Email Messages
- Configuring your System to Send Email
- Writing the Code to Send a Message
- Understanding Objects, Methods, and Properties
- Creating the Web Form
- Emailing Dynamic Form Values
- Client-Side Form Validation
- Introducing SMTP Email Service
- Building a Tour Price Calculator
- Creating the Pages
- Building the Form
- Collecting, Processing, and Displaying the Data
- Adding Server-Side Form Validation
- Creating the Conditional Region
- Creating and Applying a Custom CSS Class
- Databases on the Web
- Introduction/Review of Databases
- Introduction to the Database Used in Class
- Connecting to the Database
- Retrieving Recordsets and Displaying Database Information
- Creating the Pages
- Completing the Price Calculator
- Dynamically Populated Drop-Down Menus
- Creating Filtered Recordsets
- Revising the Calculation Script with Live Data
- Documenting Your Code with Comments
- Dynamically Populated Drop-Down Menus
- Filtering and Displaying Data
- Generating URLs Dynamically
- Populating Page Layouts Dynamically
- Adding Dynamic Images and Formatting the Population Number
- Looking Up Foreign Table Data with SQL
- Planning the Application
- Creating Recordsets with Joins
- Inserting the Images and the ALT Attributes
- Implementing the Recordset Paging
- Passing Data to Other Applications
- Generating URLs Dynamically
- Building Search Interfaces
- Preparing the Search Page and Creating the Search All Link
- Searching by Region: Building the Interfaces
- Searching by Country: Filtering by Form Variable
- Switching SQL Statements According to Environment Variables
- Preparing the Search Page and Creating the Search All Link
- Authenticating Users
- User Authentication as a Web Application
- Building the Registration Pages
- Building the Log-in Page
- About Session Variables
- Restricting Access to Pages
- Managing Content with Forms
- User Authentication as a Web Application
- Creating the Admin Section
- Creating the Form Interface
- Using Session Variables and Hidden Fields to Track Users
- Inserting the Record
- Creating the Form Interface
- Building Update Pages
- Preparing the Pages
- Planning for the Master-Detail Pages
- Making the Detail Page Updateable
- Preparing the Pages
- Arrays
- Enumerated Arrays
- Initializing Arrays
- Appending to an Array
- Reading from Arrays
- Looping through Arrays
- Initializing Arrays
- Appending to an Array
- Reading from Arrays
- Looping through Arrays
- Associative Arrays
- Initializing Associative Arrays
- Reading from Associative Arrays
- Looping through Associative Arrays
- Superglobal Arrays
- Initializing Associative Arrays
- Two-dimensional Arrays
- Reading from Two-dimensional Arrays
- Looping through Two-dimensional Arrays
- Reading from Two-dimensional Arrays
- Array Manipulation Functions
- Conclusion
- Enumerated Arrays
- PHP and HTML Forms
- HTML Forms
- How HTML Forms Work
- A Sample HTML Form
- Form Variables
- How HTML Forms Work
- A Sample HTML Form
- Form Variables
- Conclusion
- HTML Forms
- PString Manipulation
- Formatting Strings
- Concatenation
- String Manipulation Functions
- Examples of String Functions
- Concatenation
- Concatenation
- String Manipulation Functions
- Examples of String Functions
- Magic Quotes
- magic_quotes_gpc
- magic_quotes_runtime
- Recommendation on Magic Quotes
- Conclusion
- magic_quotes_gpc
- Formatting Strings
- Reusing Code and Writing Functions
- Including Files
- require
- require_once
- auto_prepend_file and auto_append_file
- require
- User Functions
- Defining and Calling Functions
- Default Values
- Variable Scope
- By Reference vs. By Value
- Defining and Calling Functions
- Default Values
- Variable Scope
- By Reference vs. By Value
- Form Processing
- Code Organization
- Conclusion
- Including Files
- Simple SELECTs
- Introduction to the Northwind Database
- Some Basics
- Comments
- Whitespace and Semi-colons
- Case Sensitivity
- Comments
- SELECTing All Columns in All Rows
- SELECTing Specific Columns
- Sorting Records
- Sorting By a Single Column
- Sorting By Multiple Columns
- Sorting By Column Position
- Ascending and Descending Sorts
- The WHERE Clause and Operator Symbols
- Checking for Equality
- Checking for Inequality
- Checking for Greater or Less Than
- Checking for NULL
- WHERE and ORDER BY
-
The WHERE Clause and Operator Words
- The BETWEEN Operator
- The IN Operator
- The LIKE Operator
- The NOT Operator
- Checking Multiple Conditions
- AND
- OR
- Order of Evaluation
- Conclusion
- Introduction to the Northwind Database
- Subqueries, Joins and Unions
- Subqueries
- Joins
- Table Aliases
- Multi-table Joins
- Table Aliases
- Multi-table Joins
- Outer Joins
- Unions
- UNION ALL
- UNION Rules
- Conclusion
- Inserting, Updating and Deleting Records
- INSERT
- UPDATE
- DELETE
- Conclusion
- Managing Data
- Querying a Database
- mysqli() Overview
- mysqli Methods and Properties
- Inserting and Updating Records
- mysqli Prepared Statements
- Querying a Database
- PEAR:DB
- Advantages and Disadvantages of PEAR DB
- Why use a database abstraction layer?
- When not to use a database abstraction layer?
- Using PEAR DB
- Advantages and Disadvantages of PEAR DB
- Authentication with PHP and SQL
- A Database-less Login Form
- Conclusion
- Regular Expressions
- Perl-compatible Regular Expression Functions
- preg_match()
- preg_replace()
- Regular Expression Tester
- Regular Expression Syntax
- o Start and End ( ^ $ )
- Number of Occurrences ( ? + * {} )
- Common Characters ( . \d \D \w \W \s \S )
- Grouping ( [] )
- Negation ( ^ )
- Subpatterns ( () )
- Alternatives ( | )
- Escape Character ( \ )
- Form Validation Functions with Regular Expressions
- Conclusion
- Perl-compatible Regular Expression Functions
- Session Control and Cookies
- Sessions
- Configuring Sessions
- Session Functions
- Regular Expression Tester
- Cookies
- Conclusion
- Sessions
- Sending Email with PHP
- mail
- Shortcomings of mail()
- Session Functions
- HPMailer
- Conclusion
- mail
- File System Management
- Opening a File
- fopen
- Reading from a File
- fgets()
- Writing to a File
- fwrite
- File Locking
- flock
- Uploading Files via an HTML Form
- Getting File Information
- More File Functions
- Directory Functions
- Getting a Directory Listing
- Opening a File
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 :
