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 

1.       Installation:

1.1    Introduction PHP and Mysql

1.2    PHP Installation

1.3    MySQL Installation

1.4    Apache Installation.

1.5    XAMPP and WAMPP Installation

2.       PHP Basics:

2.1.    Embedding PHP in HTML

2.2.    Embedding HTML in PHP

2.3.    Introduction Variable Using variables

2.4.    Understanding Data Types Using Operators

2.5.    Writing Statements and Comments Using Conditional Statements

2.6.    If(), else if() and else if condition Statement

3.       Arrays and Custom Functions:

3.1.    Creating an Array

3.2.    Modifying Array Elements

3.3.    Processing Arrays with Loops

3.4.    Grouping Form Selections with Arrays Using Array Functions

3.5.    Creating User-Defined Functions

3.6.    Defining and Invoking Functions

4.       Creating basic programs with PHP:

4.1.    Reading and Writing Files

4.2.    Reading Data from a File

4.3.    Writing Data to a File

4.4.    Testing File Attributes.

4.5.    Managing Sessions and Using Session Variables

4.6.    Creating a Session and Registering Session Variables

4.7.    Destroying a Session

4.8.   Storing Data in Cookies

4.9.    Setting Cookies

4.10.Retrieving Cookie Data

4.11.Dealing with Dates and Times

4.12.Executing External Programs

5.       Editing Records and Performing Queries:

5.1.    Inserting Records

5.2.    Editing and Deleting Records

5.3.    Performing Queries

5.4.    Retrieving Specific Columns

5.5.    Filtering Records with a WHERE Clause

5.6.    Using Operators

5.7.    Sorting Records and Eliminating Duplicates

5.8.   Limiting Results

5.9.    Using Built-In Functions

5.10.Grouping Records

5.11.Joining Tables

5.12.Using Subqueries

5.13.Using Table and Column Aliases

6.       Using PHP with MySQL:

6.1.    Managing Database Connections

6.2.    Performing Queries

6.3.    Processing Result Sets

6.4.    Queries Which Return Data

6.5.    Queries That Alter Data

6.6.    Handling Errors

6.7.    Using Ancillary Functions

7.       Creating Forms with HTML:

7.1.    HTML Basics

7.2.    Creating Forms with HTML

8.      Working with Databases and Tables:

8.1.    Creating Databases

8.2.   Creating Tables

8.3.   Specifying Field Data Types

8.4.   Selecting the Most Appropriate Data Type

8.5.   Adding Field Modifiers and Keys

8.6.   Selecting a Table Type

8.7.   Altering Tables

8.8.   Altering Table and Field Names

8.9.   Altering Field Properties

8.10.                     Adding and Removing Fields and Keys

8.11. Altering Table Types

8.12. Backing Up and Restoring Databases and Tables

8.13. Backing Up Databases and Tables

8.14. Restoring Databases and Tables from Backup

8.15. Dropping Databases and Tables

8.16. Viewing Database, Table, and Field Information

9.       Hands On & Project Documentation

 Duration: The duration of this workshop will be two consecutive days, with 6-7 hour session each day in a total of 12-14 hours.

 Certification Policy:

  • Certificate of Merit for all the workshop participants from Innovians Technologies.
  •  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:  It's a basic level workshop so there are no prerequisites. Anyone interested, can join this workshop.

Fee:  Rs. 1000/- (inclusive of all Taxes) per participant.

Our Clients

Organize a Workshop at your campus
  • calendar
Tell A Friend