PHP-MYSQL

MY SQL training

SYLLABUS

IT Courses

PRICE

260£

Syllabus of PHP Training in Tutorsvalley

  • PHP & MySQL Course Syllabus
  • Introduction to Web & PHP
  • What is PHP?
  • The history of PHP
  • Why choose PHP?
  • Installation overview

First Steps

  • Embedding PHP code on a page
  • Outputting dynamic text
  • The operational trail
  • Inserting code comments

Exploring Data Types

  • Variables
  • Strings
  • String functions
  • Associative arrays
  • Array functions
  • Booleans
  • NULL and empty
  • Type juggling and casting
  • Constants

Control Structures: Logical Expressions

  • If statements
  • Else and else if statements
  • Logical operators
  • Switch statements
  • Control Structures: Loops
  • While loops
  • For loops
  • Understanding array pointers

User-Defined Functions

  • Defining functions
  • Function arguments
  • Returning values from a function
  • Multiple return values
  • Scope and global variables
  • Setting default argument values

Debugging

  • Common problems
  • Warnings and errors
  • Debugging and troubleshooting

Building Web Pages with PHP

  • Links and URLs
  • Including and requiring files
  • Modifying headers
  • Page redirection
  • Output Buffering

Working with Forms and Form Data

  • Building forms
  • Detecting form submissions
  • Single-page form processing
  • Validating form values
  • Problems with validation logic
  • Displaying  validation errors
  • Custom  validation functions
  • Single-page form with  validations

Working with Cookies and Sessions

 

 

 

  • Unsetting cookie values
  • Working with sessions

MySQL Basic

  • MySQL introduction
  • Creating a database
  • Creating a database table
  • CRUD in MySQL
  • Populating a MySQL database
  • Relational database tables
  • Populating the relational table

Using PHP to Access MySQL

  • Database APIs in PHP
  • Connecting to MySQL with PHP
  • Retrieving data from MySQL
  • SQL injection
  • Escaping strings for MySQL
  • Introducing prepared statements

Building a Content Management System (CMS)

  • Blueprinting the application
  • Building the CMS database
  • Establishing your work area
  • Creating and styling the first page
  • Making page assets reusable
  • Connecting the application to the database

Using Site Navigation to Choose Content

  • Adding pages to the navigation  subjects
  • Refactoring the navigation
  • Selecting pages from the navigation
  • Moving the navigation to a function

Application CRUD

  • Finding a subject in the database
  • Refactoring the page selection
  • Creating a new subject form
  • Processing form values and adding subjects
  • Passing data in the session
  • Validating form values
  • Creating an edit subject form
  • Using single-page submission
  • Deleting a subject
  • Cleaning up
  • Assignment: Pages CRUD
  • Assignment results: Pages CRUD

Building the Public Area

  • The  public appearance
  • Protecting page visibility

Regulating Page Access

  • User authentication overview
  • Admin CRUD
  • Encrypting passwords
  • Salting passwords
  • Adding password encryption to CMS
  • New PHP password functions
  • Creating a login system
  • Checking for authorization
  • Creating a logout page

Advanced PHP Techniques

  • Using  variable variables
  • Applying more array functions
  • Establishing global and static variable scope
  • Making a reference assignment
  • Using references as function arguments
  • Using references as function return values

Introduction to Object-Oriented Programming (OOP)

  • Introducing the concept and basics of OOP
  • Defining classes
  • Defining class methods
  • Instantiating a class
  • Referencing an instance
  • Defining class properties

OOP in Practice

  • Understanding class inheritance
  • Setting access modifiers
  • Referencing the Parent class
  • Using constructors and destructors
  • Cloning objects
  • Comparing objects

Working with Files and Directories

  • File system basics
  • Understanding file permissions
  • Setting file permissions
  • PHP permissions
  • Accessing files
  • Writing to files
  • Deleting files
  • Moving the file pointer
  • Reading files
  • Viewing directory content

Sending Emails

  • Configuring PHP for email
  • Sending email with mail()
  • Using headers
  • Reviewing SMTP
  • Using PHPMailer

327
Courses

1403
Members

120
Subjects

E
N
Q
U
I
R
Y