Php Mysql Training sscsworld kolkata

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

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
Flow Control
1. Conditional Processing
2. If Conditions
3. Loops
String Manipulation
1. Formatting Strings
2. String Manipulation Functions
3. Examples of String Functions
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
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
Authentication with PHP and SQL
1. A Database-less Login Form
Regular Expressions
1. Perl-compatible Regular Expression Functions
2. Regular Expression Tester
3. Regular Expression Syntax
4. Form Validation Functions with Regular Expressions
Session Control and Cookies
1. Sessions
2. Configuring Sessions
3. Session Functions
4. Cookies
Sending Email with PHP
1. Mail
2. Shortcomings of mail()
3. PHPMailer
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Creating the Admin Section
1. Creating the Form Interface
2. Using Session Variables and Hidden Fields to Track Users
3. Inserting the Record
Building Update Pages
1. Preparing the Pages
2. Planning for the Master-Detail Pages
3. Making the Detail Page Updateable
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
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
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
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
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
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
Inserting, Updating and Deleting Records
1. INSERT
2. UPDATE
3. DELETE
4. Conclusion
Managing Data
1. Querying a Database
  1. mysqli() Overview
  2. mysqli Methods and Properties
  3. Inserting and Updating Records
  4. mysqli Prepared Statements
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
Authentication with PHP and SQL
1. A Database-less Login Form
2. Conclusion
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
Session Control and Cookies
1. Sessions
  1. Configuring Sessions
  2. Session Functions
  3. Regular Expression Tester
2. Cookies
3. Conclusion
Sending Email with PHP
1. mail
  1. Shortcomings of mail()
  2. Session Functions
2. HPMailer
3. Conclusion
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 :