• PHP is the most famous server-side language used to construct dynamic websites and it is an extensive language.
• Learn PHP and MySQL web development by understanding PHP functions and MySQL.
• Get these skills from infield experts.
• Techno is the institute under the supervision of leading development firm since 10+ years.

Introduction

• Why use PHP and MySQL?
• The PHP programming environment
• Overview of SQL

Setting up a Test Bed

• Decisions about a testing environment
• WAMP/MAMP
• Installing Apache, PHP and MySQL on your computer
• Testing on a remote Server
• Deciding on Development tools
• Using PhpMyAdmin

Overview of PHP

• Setting up a PHP page
• The php info () function
• Learning basic syntax
• Echoing HTML output to the browser
• The importance of comments
• Using single and double quotes

Variables in PHP

• Using loose typed variables
• Assigning variables
• Overview of numeric, string and other types
• Assigning a variable to itself

Logical operators

• Arithmetic operators
• Logical operators
• Comparisons
• Operator precedence
• Numbers in PHP
• Making calculations
• Using built-in numeric functions
• Incrementing and decrementing

Strings in PHP

• Concatenating strings
• Trimming strings
• Removing slashes and other harmful characters
• String functions

Control structures in PHP

• The If statement
• FOR loops
• While loops
• The Switch

Transferring information between PHP pages

• GET and POST
• Different form field types
• Self-referencing forms
• Form handlers

Database fundamentals

• Structuring a database
• Using tables
• Table relationships
• Common data types

Creating a database

• Using PhpMyAdmin
• Adding a table
• Populating a table with types and data
• Browsing a table

Getting PHP to connect to MySQL

• Using the MySQL connect () function
• Using the mysql_select_db () function
• Testing a connection
• Writing a sample error trap

Querying MySQL using PHP

• Writing SQL queries
• Using Select, Insert, Update and Delete
• Querying MySQL and returning results
• Interpreting the returned array

Building a Web Application

• Creating pages to:
• Add entries
• Modify entries
• List entries
• Filter entries

Security features

• Validating entries