PHP and mySQL Training Course and Workshop in Bangalore, Mysore, Chennai, Hyderabad, Pune, Mumbai, Delhi, Noida, Gurgaon, Kolkata

The PHP with MySQL training course will provide the skills and knowledge necessary to create dynamic database-driven websites. This course Includes demonstrations and hands-on exercises along with programming notes.

The Advanced PHP and MySQL training course delves deeper into topics introduced in basic PHP and MySQL training module and explores a number of intermediate to advanced topics. Discover ways to secure entire website and protect information in database. Learn how to design a database for optimum speed. Explore programming techniques that go beyond the fundamentals. Combine PHP with Flash, CSS and JavaScript to create some amazing web applications.

By attending PHP with MySQL workshop, delegates will learn to:

Discuss the concepts of PHP
Create PHP web pages
Develop a database-driven PHP application
Seek solutions to any PHP problems and further their knowledge

By attending Advanced PHP and MySQL workshop, delegates will learn to:

Develop a web application that allows users to create, preview, and send a customized Flash greeting card
Combine PHP with CSS to create dynamically styled web pages
Discover ways to gather useful information about visitors to their site and track user information
Create a secure script that allows visitors to upload files to the web server
Understand where to use arrays, loops and alternative conditional operators
Create, change, and remove records in a database
Learn how to design database tables to maximise speed and minimise data corruption
Perform advanced MySQL searches
Use MySQL joins to combine data from various tables and generate usable reports
Understand how to set up a secure website so that information cannot be intercepted and read during transmission
Learn how to encrypt and decrypt data
Use best practices to store data securely on a server so that it cannot be deciphered even by the server administrator

The PHP with MySQL class is suitable for those who have a working knowledge of HTML.

The Advanced PHP and MySQL class is suitable for those who have significant knowledge and skills with PHP and MySQL.

Background and History of PHP

Why PHP is so popular

Incorporating PHP into HTML

Using PHP to create HTML
Escaping characters
Comments

Processing Form Data

Displaying PHP variables as HTML
Receiving variables from a form and displaying them in the browser

Validating Form Data

Conditional tests
Exiting out of PHP

Sending Email from a Web Page

Use of different headers
Security and preventing server abuse

Embedded “Include”‘ and “Require” Files

Making life easy and your designs consistent

Exporting Data

Writing to a text file
Magic Quotes and Stripslashes
File permissions
Writing to a database
Creating a table in a database
MySQL Datatypes

Importing Data

Reading data from a database
Searching with SQL
Using loops to display multiple records
Creating a table with alternating row colors
Database backup tools

Creating Re-useable Functions

Declaring a function
Calling a function
Returning a value from a function

Password Protecting Pages and Data

Validating usernames and passwords with those stored in a database

Troubleshooting, Further Reading and Exploration

PHP and Flash
Useful websites

Security

Register globals
Webpage encryption
Creating a server certificate and key
Working with SSL in development environment
Making sure a page is always encrypted
Database encryption and decryption techniques

Integrating PHP and MySQL with CSS, JavaScript and Flash

Personalised Flash greeting card and a sticky form
Dynamic CSS menus
Breadcrumbs
Session variables

Advanced PHP

References
Alternative conditional operators
Arrays
Loops
Tracking user information
Using code to display images
Uploading files securely
Error reporting

Additional MySQL queries

Deleting
Updating and replacing
Fixing typos in MySQL
Limiting
Ordering
Case-sensitive searches

Database design for integrity and efficiency

Normalisation
Table Joins

Encarta Labs Advantage

One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
All courses are delivered by Industry Veterans
Get jumpstarted from newbie to production ready in a matter of few days

Trained more than 50,000 Corporate executives across the Globe
All our trainings are conducted in workshop mode with more focus on hands-on sessions

PHP and mySQL

COURSE AGENDA