PHP MySQL Fundamentals from Scratch with Examples & Projects

سرفصل های دوره

PHP for beginners: Learn PHP procedural programming with MySQL database. Design dynamic websites with PHP & MySQL.

01 - PHP MySQL Installation & Run Your First PHP Program

001 Requirements for PHP & MySQL Installation

002 Bitnami-WAMP-7.1.13-0-for-Windows-32-bit.zip

002 Bitnami-WAMP-7.1.13-0-for-Windows-64-bit.zip

002 Download & Install WAMP on Windows 10 Operating System

003 Bitnami-MAMP-7.1.13-0-for-MAC-32-bit-64-bit.zip

003 Download & Install MAMP on MAC Operating System

004 Bitnami-LAMP-7.1.13-0-for-Linux-64-bit.zip

004 Download & Install LAMP on Linux Operating System

005 Your First PHP Program Hello World!

006 A brief overview of Bitnami WAMPMAMPLAMP stack manager tool

007 Download and Install Text Editor for PHP

external-links.txt

02 - Introduction to PHP and Basic Configuration Settings

001 What is PHP

002 History of PHP!

003 Lets understand PHP Syntax

004 Understand how PHP codes are executed on a web server

005 View & modify PHP configuration setting, Display PHP errors and disable cache

006 The echo & print functions in PHP

007 Embed HTML tags in PHP

008 Whitespace in PHP

009 Define and use PHP Variables

010 Define and use PHP Constants

011 Single quotes vs Double quotes

012 Are PHP codes case sensitive

013 How to add comments in PHP Program

03 - PHP Data Types

001 Data types in PHP

002 Boolean data type in PHP

003 Integer data type in PHP

004 Float or Double data type in PHP

005 String data type in PHP

006 Array data type in PHP

007 Object data type in PHP

008 Resource data type in PHP

009 NULL data type in PHP

04 - PHP Operators

001 What are operators & types of operators in PHP

002 PHP Arithmetic operators

003 PHP Assignment operators

004 PHP Comparison operators

005 Error Control Operators

006 PHP Increment & Decrement operators

007 PHP Logical operators

008 PHP String operators

009 PHP Array operators

05 - PHP Conditional Statements

001 What is conditional statement in PHP

002 PHP if statement

003 PHP if else statement

004 PHP if elseif else statement

005 PHP switch statement

06 - PHP Loop Statements

001 What is Loop & Types of loop statements in PHP

002 PHP while loop statement

003 PHP do while loop statement

004 The difference between while and do while statement in PHP

005 PHP for loop statement

006 PHP foreach loop statement

007 PHP break statement

008 PHP continue statement

07 - PHP Arrays

001 What is array & types of arrays in PHP

002 Indexed Arrays in PHP

003 Associative Arrays in PHP

004 Multidimensional arrays in PHP

005 Useful Array Functions in PHP

08 - Functions in PHP

001 What are Built-in functions in PHP How to find and use functions in PHP

002 String functions in PHP

003 Math functions in PHP

004 Array functions in PHP

09 - User Defined Functions in PHP

001 What are user-defined functions Why we need user-defined functions

002 Define and use your first PHP function

003 Define functions with arguments in PHP

004 Define functions with default arguments in PHP

005 Define functions that return the value in PHP

006 What is constant & variable scope in PHP

10 - PHP Superglobals or Global variables

001 What are Superglobals or Global variables in PHP

002 PHP $GLOBALS global variable

003 PHP $ SERVER global variable

004 PHP $ ENV global variable

005 PHP $ GET, $ POST, $ FILES, $ REQUEST, $ COOKIE & $ SESSION global variables

11 - PHP Date and Time

001 View and set timezone in PHP

002 Date time formatting in PHP

003 Some useful date time functions in PHP

12 - PHP Cookies & Sessions

001 The cookies & sessions in PHP

002 What are cookies & How to create cookies in PHP

003 How to read cookies in PHP & Where cookies are stored

004 How to update cookies in PHP

005 How to delete cookies in PHP

006 What are sessions & How to create sessions or session variables in PHP

007 How to read session variables in PHP & Where session variables are stored

008 How to update session variables in PHP

009 How to delete session variables in PHP

010 The difference between cookies and sessions

13 - Building Web Pages in PHP

001 Create web page links and URLs in PHP

002 Pass variables and values via GET method

003 The importance of URL encoding in PHP

004 Retrieve or extract the values via POST method

005 PHP include & require functions and the difference between include & require

006 Absolute path vs Relative path in PHP

007 How to redirect web pages in PHP

14 - Build your own contact form from scratch using PHP (Project)

001 Contact-form-exercise-files.zip

001 Design a contact form using Bootstrap

001 bootstrap-4.1.1.zip

002 Get & display variable values from contact form

003 Validate contact form input values using PHP

004 Sanitize contact form input values using PHP

005 How to send emails from Localhost using PHP on Windows Operating System

005 sendmail.zip

006 How to send emails from Localhost using PHP on MAC Operating System

006 Mac-Postfix-Configuration-Setting.txt

007 PHP mail function to send emails

external-links.txt

15 - Build file upload system from scratch using PHP (Project)

001 Design a file upload form using Bootstrap

001 File-uploader-exercise-files.zip

002 Checkout the file upload settings in PHP

003 Temporary file variables while uploading

004 PHP file validation before upload

005 PHP move uploaded file to a specific location

16 - Introduction to MySQL database

001 Introduction to MySQL

002 Login to MySQL database server & execute basic SQL statements

003 Keywords, Identifiers, Constants and Clauses

004 Data Definition Language (DDL) & Data Manipulation Language (DML)

005 How to create & use a database in MySQL

006 How to create a table in MySQL database

007 Update an existing table in MySQL

008 Delete or remove an existing table from MySQL database

009 Add data rows or records in MySQL table

010 View or retrieve data rows from MySQL table

011 Update data rows inside MySQL table

012 Delete or remove data rows from MySQL table

013 Important Data types in MySQL

014 Important Conditions & Operators in MySQL

015 Data grouping, sorting & dates in MySQL

016 Important SQL constraints in MySQL database

017 Learn how to design a relational database in MySQL

018 How to backup & restore database in MySQL

17 - Introduction to phpMyAdmin

001 Introduction to phpMyAdmin

002 Manage databases using phpMyAdmin

003 Manage database tables using phpMyAdmin

004 Managing table data rows using phpMyAdmin

005 Backup & restore MySQL database using phpMyAdmin

18 - Interacting with MySQL database using PHP

001 How do we interact with database management systems using PHP

002 How to connect to MySQL database using PHP

003 How to create a new database & table in MySQL database using PHP

004 How to insert, update & delete data rows in MySQL database table using PHP

005 How to display data rows from MySQL database table using PHP

006 How to close MySQL database connection in PHP

19 - Single page user management system (Project)

001 Design user management page using Bootstrap

001 Single-page-user-management-system-exercise-files.zip

002 Connect to database, display records & close connection

003 Handle two form submission on single page

004 Get and validate POST variable values

005 Complete add user functionality

006 Complete delete user functionality

20 - Bonus Section

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training