دوره آموزش PHP & MySQL مقدماتی

سرفصل هاو محتوای دوره آموزش PHP & MySQL مقدماتی


پیش نیاز: HTML، آشنائی با JavaScript

سرفصل‌های کلی دوره:

Introduction:

        What Does PHP Do?

         A Brief History of PHP

         Installing PHP

         A Walk Through PHP

         Web Server Installation and Configuration

         HTTP and Server Side Scripting

         Programming Tools

Language Basics 1:

         Lexical Structure

         Data Types

        -  (Integers,Floating Point Numbers, Booleans …)

        - Strings

        - Arrays 

        - Objects and Resources

         Variables

Language Basics 2:

         Expressions and Operators:

       -  If, switch

       - while, for, foreach,declare

       - continue and break,exit and return

         Including Code

         Embedding PHP in Web Pages

Functions:

          Calling a Function

          Defining a Function

          Variable Scope

          Function Parameters

          Return Values

          Variable Functions

          Anonymous Functions

          String Functions (building, dissecting, searching, and modifying)

          Array Functions (notation and functions for constructing,processing, and sorting arrays)

Web Techniques 1:

          HTTP Basics

          Variables

         Server Information

         Processing Forms:

           - Methods

            -Parameters

            -Automatic Quoting of Parameters

            -Self-Processing Pages

            -Sticky Forms

            -Multivalued Parameters

            -File Uploads

            -Form Validation

          Setting Response Headers

          Maintaining State

            - Cookies

            - Sessions

          SSL

MySQL and SQL:

         Database Basics

            - IntroducingRelational Databases

            - Terminology

         Quick Start Guide

         MySQL Command Interpreter and Tools

         Managing Databases, Tables, and Indexes

         Inserting, Updating, and Deleting Data

         Querying with SQL SELECT

         Join Queries

         Modifying the Database

         Functions

Object-OrientedProgramming in PHP:

         Introducing the concept and basics of OOP 

         Defining classes

         Defining class methods 

         Instantiating a class 

         Referencing an instance 

         Defining class properties 

         Understanding class inheritance 

         Setting access modifiers 

         Using setters and getters

         Working with the static modifier

         Reviewing the scope resolution operator 

         Referencing the Parent class 

         Using constructors and destructors

         Cloning objects

         Comparing objects 

Using PHP to AccessMySQL:

         Choosing Database APIs in PHP

         Connecting to MySQL with PHP 

         Retrieving data from MySQL 

         Working with retrieved data

         Creating records with PHP

         Updating and deleting records with PHP 

         SQL injection 

         Escaping strings for MySQL 

         Introducing prepared statements

Practical Project: OnlineStore with Shopping Card

         User Management

         Working with Files/Images

         Online Payment

         Security