Image
Image
Image
Image

PHP with MySQL

PHP | Workshop on PHP with MySQL

PHP is a general-purpose server-side scripting language originally designed for Web development to produce dynamic Web pages. It is one of the first developed server-side scripting languages to be embedded into an HTML source document rather than calling an external file to process data. MySQL is the world's most used open source relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This is a two day workshop designed for the beginners to understand the PHP Programming & its use with MySQL.

Topics to be Covered in the Workshop 

Installation:

  • Introduction PHP and Mysql
  • PHP Installation
  • MySQL Installation
  • Apache Installation.
  • XAMPP and WAMPP Installation

 PHP Basics:

  • Embedding PHP in HTML
  • Embedding HTML in PHP
  • Introduction Variable Using variables
  • Understanding Data Types Using Operators
  • Writing Statements and Comments Using Conditional Statements
  • If(), else if() and else if condition Statement

 Arrays and Custom Functions:

  • Creating an Array
  • Modifying Array Elements
  • Processing Arrays with Loops
  • Grouping Form Selections with Arrays Using Array Functions
  • Creating User-Defined Functions
  • Defining and Invoking Functions

 Creating basic programs with PHP:

  • Reading and Writing Files
  • Reading Data from a File
  • Writing Data to a File
  • Testing File Attributes.
  • Managing Sessions and Using Session Variables
  • Creating a Session and Registering Session Variables
  • Destroying a Session
  • Storing Data in Cookies
  • Setting Cookies
  • Retrieving Cookie Data
  • Dealing with Dates and Times
  • Executing External Programs

 Editing Records and Performing Queries:

  • Inserting Records
  • Editing and Deleting Records
  • Performing Queries
  • Retrieving Specific Columns
  • Filtering Records with a WHERE Clause
  • Using Operators
  • Sorting Records and Eliminating Duplicates
  • Limiting Results
  • Using Built-In Functions
  • Grouping Records
  • Joining Tables
  • Using Subqueries
  • Using Table and Column Aliases

 Using PHP with MySQL:

  • Managing Database Connections
  • Performing Queries
  • Processing Result Sets
  • Queries Which Return Data
  • Queries That Alter Data
  • Handling Errors
  • Using Ancillary Functions

 Creating Forms with HTML:

  • HTML Basics
  • Creating Forms with HTML

 Working with Databases and Tables:

  • Creating Databases
  • Creating Tables
  • Specifying Field Data Types
  • Selecting the Most Appropriate Data Type
  • Adding Field Modifiers and Keys
  • Selecting a Table Type
  • Altering Tables
  • Altering Table and Field Names
  • Altering Field Properties
  • Adding and Removing Fields and Keys
  • Altering Table Types
  • Backing Up and Restoring Databases and Tables
  • Backing Up Databases and Tables
  • Restoring Databases and Tables from Backup
  • Dropping Databases and Tables
  • Viewing Database, Table, and Field Information
  • Hands On & Project Documentation

Duration: The duration of this workshop will be two consecutive days, with eight hour session each day in a total of sixteen hours properly divided into theory and hands on sessions.

Certification Policy:

  • Certificate of Participation for all the workshop participants.
  • At the end of this workshop, a small competition will be organized among the participating students and winners will be awarded with a 'Certificate of Excellence'.
  • Certificate of Coordination for the coordinators of the campus workshops.

Eligibility: There are no prerequisites. Anyone interested, can join this workshop.

Our Clients

Image
LOOKING TO ORGANIZE ANY TRAINING ?

For any Training Requirement or Workshops

Image
Image
Image
Corporate Trainings
Workshops
Quick Links
© 2012- 2023 Innovians Technologies.