What is Core PHP and My SQL?

PHP stands for PHP Hypertext Preprocessor. "PHP is an HTML-embedded scripting language. XPERT INFOTECH provides Core PHP and My SQL training according to the current requirement of IT industry. Much of its syntax is borrowed from C, Java and Perl with a couple of unique PHP-specific features thrown in. The goal of the language is to allow web developers to write dynamically generated pages quickly." When someone visits your PHP web page, your web server processes the PHP code. It then sees which parts it needs to show to visitors (content and pictures) and hides the other stuff (file operations, math calculations, etc.) then translates your PHP into HTML. After the translation into HTML, it sends the web page to your visitor's web browser.

MySql is a Database which is being connected to PHP. In this PHP & MySQL training Institute we will teach to build PHP website connected with MySQL database. . It is excellent for creating dynamic, database-driven Web sites. PHP (Hypertext Preprocessor) is a tool that lets you create dynamic web pages. PHP - enabled web pages are treated just like a regular HTML pages and you can create and edit them the same way you normally create regular HTML pages.

The course will take you through all you need to know to use PHP in creating an incredible web site. MySQL is the leading open source relational database management system and is extensively deployed around the world. Gain the skills needed to administer and maintain MySQL databases.

Before going through Core PHP and My SQL live project training candidate should have knowledge of given concepts listed below:

• Knowledge of HTML and CSS
• Knowledge of javascript
• Knowledge of C languages
• Knowledge of object oriented languages(C#, C++ etc)

Core PHP and My SQL Training provided by Real time PHP Developer of our company, has more than 4 years of domain experience.

• We will provide real time project training with code explanation and implementation.
• Our training modules are completely designed according to current IT market.
• After completion of 75% of course, student will go through Major Project Training, Live Project Training, Interview Preparation and Recruitment process in IT Industry.
• Student will go through the training of HTML, CSS and JavaScript as a complimentary package before starting of Core PHP and My SQL.
• We offer regular, fast track and weekend training in Core PHP and My SQL course.
• Study material is provided with the course which consist of concepts, examples and real time examples.

Download Required Software:

• Wamp Server
• Xampp Server
• My SQL

Benefits of Courses

• Website Developer
• Web Application Developer
• Web Services Developer

Core PHP Training provided by Real time Core PHP Developer of our company, has more than 5 years of domain experience.

• We will provide real time project training with code explanation and implementation.
• Our training modules are completely designed according to current IT market.
• After completion of 75% of course, student will go through Major Project Training, Live Project Training, Interview Preparation and Recruitment process in IT Industry.
• Student will go through the training of HTML, CSS and JavaScript as a complimentary package before starting of Core PHP.
• We offer regular, fast track and weekend training in Core PHP course.
• Study material is provided with the course which consist of concepts, examples and real time examples.

CORE PHP

• How PHP Works
• The php.ini File
• Basic PHP Syntax
• PHP Tags
• PHP Statements and Whitespace
• Comments
• PHP Functions
• Variables
• Variable Types
• Variable Names (Identifiers)
• Type Strength
• Variable Scope
• Constants
• Variable-Testing and Manipulation Functions
• PHP Operators
• Creating Dynamic Pages
• Single Quotes vs. Double Quotes
• Flow Control
• If Conditions
• Loops
• while
• do...while
• for
• break and continue
• Arrays
• Enumerated 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
• Two-dimensional Arrays
• Reading from Two-dimensional Arrays
• Looping through Two-dimensional Arrays
• Array Manipulation Functions
• PHP and HTML Forms
• HTML Forms
• How HTML Forms Work
• A Sample HTML Form
• Form Variables
• String Manipulation
• Formatting Strings
• Concatenation
• String Manipulation Functions
• Examples of String Functions
• Magic Quotes
• magic_quotes_gpc
• magic_quotes_runtime
• Recommendation on Magic Quotes
• 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
• Code Organization
• Simple SELECTs
• Introduction to the Northwind Database
• Some Basics
• Comments
• Whitespace and Semi-colons
• Case Sensitivity
• 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
• Sub queries, Joins and Unions
• Sub queries
• Joins
• Table Aliases
• Multi-table Joins
• Outer Joins
• Unions
• UNION ALL
• UNION Rules
• Inserting, Updating and Deleting Records
• INSERT
• UPDATE
• DELETE
• Managing Data
• Querying a Database

MySql Overview/PHP++

• MySql Methods and Properties
• Inserting and Updating Records
• MySql Prepared Statements
• Authentication with PHP and MYSQL
• A Database-less Login Form
• Session Control and Cookies
• Sessions
• Session Functions
• Cookies
• Sending Email with PHP
• JavaScript language fundamentals
• mail()
• Shortcomings of mail()
• PHPMailer
• 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
• Getting a Directory Listing
• Ajax with PHP
• Ajax Overview
• Ajax Technology Stack
• Ajax Implementations
• Installing and configuring HTML_Ajax Pear Module
• Ajax Server
• Ajax Client
• Creating a Dreamweaver site
• Site creation - basic
• Site creation - advanced
• Database connections
• Database basics
• Introduction to MYSQL
• Server behaviors
• Querying the database
• Building a MYSQL query using the Simple view
• Building a MYSQL query using the Advanced view
• Adding fields from the resulting records to your page
• Displaying and formatting query results
• Using Repeat Region to display multiple records
• Formatting results
• Paging through records
• Schemes for record set navigation
• Paging to first, last, previous, and next records
• Show region if...
• Selectively displaying information based on a conditional
• Disabling the first and previous record links if the first page of results is
• displayed
• Disabling the last and next record links if the last page of results is displayed
• Displaying the count of the number of records returned
• Creating master-detail views
• Overview of the importance of master-detail views and how they convey
• information
• Creating a master-detail view
• Advanced record sets and multi-table queries
• Method 1 - Simple record set with filter
• Method 2 - Advanced record set
• Method 3 - Advanced record set and multi-table Queries
• Dynamically populating forms
• Populating text fields, text areas, and hidden fields
• Populating selection lists, radio button lists, and checkboxes
• Building record insertion forms
• Building the insertion form by hand
• Allowing Dreamweaver to generate the record insertion form automatically
• Creating a page that confirms the record insertion
• Validating form entries using JavaScript behaviors
• Understanding stored procedures
• Advantages/disadvantages of stored procedures versus MYSQL
• Calling a stored procedure without passing parameters
• Passing input parameters to a stored procedure
• Manually constructing a form that allows the user to update a record
• Retrieving parameters from a stored procedure
• Updating records