• 01-4167615
  • 9851224985, 9851161198
  • info@iitnepal.edu.np
Follow us on:

PHP and MYSQL

Duration

2 Months

Career Option

Web developer

Group Size

2-10 Persons

Overview

Syllabus

  • Introduction of Web & PHP
  • Exploring Data Types
  • Control Structures: Logical Expressions
  • Control Structures: Loops
  • User-Defined Functions
  • Debugging
  • Building Web Pages with PHP
  • Working with Forms and Form Data
  • Working with Cookies and Sessions
  • MySQL Basics
  • Using PHP to Access MySQL
  • Building a Content Management System (CMS)
  • Regulating Page Access
  • Advanced PHP Techniques
  • Introduction to Object-Oriented Programming (OOP)
  • OOP in Practice
  • Working with Files and Directories
  • Sending Emails

Detail Study

  • Introduction of Web & PHP
    1. What is PHP?
    2. The history of PHP
    3. Why choose PHP?
    4. Installation overview
  • Exploring Data Types
    1. Variables
    2. Strings
    3. String functions
    4. Numbers part one: Integers
    5. Numbers part two: Floating points
    6. Arrays
    7. Associative arrays
    8. Array functions
    9. Booleans
    10. NULL and empty
    11. Type juggling and casting
    12. Constants
  • Control Structures: Logical Expressions
    1. If statements
    2. Else and elseif statements
    3. Logical operators
    4. Switch statements
  • Control Structures: Loops
    1. While loops
    2. For loops
    3. Foreach loops
    4. Continue
    5. Break
    6. Understanding array pointers
  • User-Defined Functions
    1. Defining functions
    2. Function arguments
    3. Returning values from a function
    4. Multiple return values
    5. Scope and global variables
    6. Setting default argument values
  • Debugging
    1. Common problems
    2. Warnings and errors
    3. Debugging and troubleshooting
  • Building Web Pages with PHP
    1. Links and URLs
    2. Using GET values
    3. Encoding GET values
    4. Including and requiring files
    5. Modifying headers
    6. Page redirection
  • Working with Forms and Form Data
    1. Building forms
    2. Detecting form submissions
    3. Single-page form processing
    4. Validating form values
    5. Problems with validation logic
    6. Displaying validation errors
    7. Custom validation functions
    8. Single-page form with validations
  • Working with Cookies and Sessions
    1. Working with cookies
    2. Setting cookie values
    3. Reading cookie values
    4. Unsetting cookie values
    5. Working with sessions
  • MySQL Basics
    1. MySQL introduction
    2. Creating a database
    3. Creating a database table
    4. CRUD in MySQL
    5. Populating a MySQL database
    6. Relational database tables
    7. Populating the relational table
  • Using PHP to Access MySQL
    1. Database APIs in PHP
    2. Connecting to MySQL with PHP
    3. Retrieving data from MySQL
    4. Working with retrieved data
    5. Creating records with PHP
    6. Updating and deleting records with PHP
    7. SQL injection
    8. Escaping strings for MySQL
    9. Introducing prepared statements
  • Building a Content Management System (CMS)
    1. Blueprinting the application
    2. Building the CMS database
    3. Establishing your work area
    4. Creating and styling the first page
    5. Making page assets reusable
    6. Connecting the application to the database
  • Regulating Page Access
    1. User authentication overview
    2. Admin CRUD
    3. Encrypting passwords
    4. Salting passwords
    5. Adding password encryption to CMS
    6. New PHP password functions
    7. Creating a login system
    8. Checking for authorization
    9. Creating a logout page
  • Advanced PHP Techniques
    1. Using variable variables
    2. Applying more array functions
    3. Building dates and times: Epoch/Unix
    4. Formatting dates and times: Strings and SQL
    5. Setting server and request variables
    6. Establishing global and static variable scope
    7. Making a reference assignment
    8. Using references as function arguments
    9. Using references as function return values
  • Introduction to Object-Oriented Programming (OOP)
    1. Introducing the concept and basics of OOP
    2. Defining classes
    3. Defining class methods
    4. Instantiating a class
    5. Referencing an instance
    6. Defining class properties
  • OOP in Practice
    1. Understanding class inheritance
    2. Setting access modifiers
    3. Using setters and getters
    4. Working with the static modifier
    5. Reviewing the scope resolution operator
    6. Referencing the Parent class
    7. Using constructors and destructors
    8. Cloning objects
    9. Comparing objects
  • Working with Files and Directories
    1. File system basics
    2. Understanding file permissions
    3. Setting file permissions
    4. PHP permissions
    5. Accessing files
    6. Writing to files
    7. Deleting files
    8. Moving the file pointer
    9. Reading files
    10. Examining file details
    11. Working with directories
    12. Viewing directory content
  • Sending Emails
    1. Configuring PHP for email
    2. Sending email with mail()
    3. Using headers
    4. Reviewing SMTP
    5. Using PHPMailer

     

Student Testimonials

Send Enquiry






Quick Enquiry
01-4167615
Find Us On
4th Floor, House no. 9, Yeti Plaza, Bagbazar -28, Kathmandu
Our Partners

Our Industry Partner

Our Industry Partners who helps our students for Internship and Job Placement.

Offshore Softtech
iFart Technology
Alpha Teds
Angel Sansar
Sugainc
CygnusTech
Our Clientele

Our Clients