PHP Web Development with MySQL

Web Application Development with PHP & MySQL

Ratings: 4.25 / 5.00




Description

Hi students,

welcome to my course Web Development with PHP & MySQL

This course will be an all in one solution that helps you to learn how to create a web application using PHP and MySQL, all at one place. This course is  a complete mixture of multiple technologies like HTML, CSS,  JavaScript, JQuery, Bootstrap and AJAX along with PHP and MySQL.

I am going to cover the following thing in detail:


  1. Introduction to PHP

    1. What is PHP

    2. Need of PHP

    3. Versions of PHP

    4. PHP Installation

    5. WAMP Server & XAMPP Server

  2. Getting Started

    1. Creating First PHP script

    2. Where to store PHP page.

    3. Things to remember when saving PHP page.

    4. Server configuration of Adobe Dreamweaver

  3. Variables in PHP

  4. Operators in PHP

    1. Types

      1. Unary

      2. Binary

      3. Ternary

    2. Classifications

      1. Arithmetic

      2. Relational

      3. Logical

      4. Assignment

      5. Bitwise

      6. String

    3. Operands and Expressions

  5. Conditional Statements in PHP

    1. If-Else

    2. Switch-Case

  6. Loops in PHP

    1. for

    2. while

    3. do-while

    4. foreach

  7. Functions in PHP

    1. Built-in Functions

    2. User defined functions

  8. Form Handling

    1. GET

    2. POST

  9. Email Sending

  10. State Management

    1. Cookies

    2. Sessions

  11. PHP Sanitization / Filters

  12. Validations in PHP

  13. Introduction to MySQL

  14. MySQL database connectivity with PHP

  15. Creating database

  16. Creating tables

  17. Creating columns and other constraints

  18. Creating Views,Stored Procedures and triggers

  19. Joins and relationships

  20. CRUD Operations using PHP and MySQL

  21. Object Oriented PHP

  22. Other things can be added if possible




What You Will Learn!

  • The students can be able to create web applications using PHP and MySQL
  • The students can be able to understand the concepts of client and server
  • The students get hands on experience of how things happen in PHP?
  • The students get in depth learning of MySQL relational database management system.
  • The students get be able to perform form handling using PHP.
  • The students will learn about state management in PHP [SESSIONS & COOKIES]
  • The student will learn how to connect PHP web application with MySQL database.
  • The student will be able to send and receive data to and from database.

Who Should Attend!

  • Beginner web designers
  • Intermediate web designers
  • Any one who want to learn web application development.