Open / Close contact form

PHP And MySQL

Course Overview

PHP is a popular general-purpose server scripting language that is especially suited for making dynamic and interactive Web pages.

Introduction To Php

  • Discuss the history of PHP
  • Identify the need of PHP
  • Learn about PHP tools and setup
  • Write a simple PHP script
  • Learn about user I/O
  • Use PHP to generate HTTP headers
  • Pass variable via URL

Form Handling In Php

  • Use the GET method
  • Use the POST method
  • Retrieve data from forms using the form method
  • Use the hidden fields

Using Variables And Expressions In Php

  • Define identifiers
  • List the data types
  • Use variables and constants
  • Define scope of variables
  • Use the HTTP environment variables
  • Use the assignment operator
  • Use local variables
  • Use global variables
  • Use static variables

Php Operators

  • Use Arithmetic operators
  • Use Logical operators
  • Use rational operators
  • Use Bitwise operators
  • Use Assignment operators
  • Use String operators
  • Use Increment and Decrement operators

Conditional Statements In Php

  • Use the If statement
  • Use the Switch statement
  • Use the Ternary (?) operator

Flow Control In Php

  • Use Loops
  • Use Jump statements
  • Define a function
  • Use built-in PHP functions
  • Create a user- defined function
  • Pass arguments to a function
  • Return values from a function
  • Use a recursive function

Working With Arrays

  • Define an array
  • Create and use arrays
  • Merge arrays
  • Use single and multidimensional arrays
  • Use array- related functions

Handling Databases With Php

  • Discuss about Database APIs
  • Connect to the database
  • Use data access functions
  • Perform SQL queries using PHP
  • Build HTML tables using SQL queries

Working With Cookies

  • Set a cookie
  • Retrieve a cookie in PHP
  • Delete a cookie
  • Identify problems with cookies

Session Management In Php

  • Define a session
  • Work with the session
  • Start the session
  • Register the session
  • End the session
  • Work with the php.ini file

Handling E-Mail With Php

  • Send e-mails
  • Attach files with e-mails
  • Explain the OOP concepts
  • Explain inheritances
  • Create classes
  • Create constructors
  • Create and use objects

Introduction To Mysql As An Open Source Database

  • List the advantages of MySQL over other RDBMA
  • Differentiate MySQL with other RDBMS.
  • List the advantage of PHP in MySQL.

Installing And Configuring Mysql

  • Evaluate various distributing options to MySQL.
  • Install MySQL on Windows Platform
  • Install MySQL on Linux platform
  • Configuring MySQL using scripts
  • Initializing MySQL at the startup
  • Install MySQL
  • Configure MySQL using customization scripts

Using Mysql

  • Create a database
  • Explain a data type
  • Identify the different types of data
  • Create a table
  • Explain the use of Normalization
  • Identify the different forms of Normalization
  • Explain the concepts of Indexes and Referential Integrity

Implementing The Sql Queries Using Mysql-1

  • View and alter the database
  • Retrieve data from a table
  • Modify the table definitions
  • Delete table definitions
  • Modify the database
  • Use Select command
  • Use Select command with WHERE clause
  • Modify the table structure
  • Drop the table

Implementing The Sql Queries Using Mysql-Ii

  • Work with Keys
  • Work with Indexes
  • Manipulate tables
  • Manipulate tables with INSERT, MANIPULATE, UPDATE and DELETE
  • Using Order BY
  • Using the Group By Command

Using Joins

  • Know the basic concepts and reason behind joining tables
  • Use Equi-join
  • Use Outer- join
  • Use self-join
  • Use multiple Select queries in a single Select query
  • Use UNION with the query

Using Basic Functions In Mysql

  • Use GROUP BY and HAVING clause in MySQL queries
  • Use the Mathematical functions
  • Use the date functions
  • Use String information function
  • Use the system information functions

Controlling And Managing Mysql Database

  • Create User Account
  • Allocate appropriate privileges to users
  • Alter privileges
  • Using GRANT command to assign privileges to user
  • Using REVOKE command to alter privileges granted to users

Enquire Now

Learn Adobe Photoshop
Your name:
Email address:
Phone number:
Message:

Our google reviews

Other related courses