PHP & MySQL Tutorial | Learn PHP From Scratch | Full Tutorial

This video will show you how you the concept procedural PHP and MySQL.

Resources
– Host PHP projects: https://www.cloudways.com/en/?id=918573
– Email: info@darynazar.com
– Instagram: https://www.instagram.com/codewithdary/
– Twitter: https://twitter.com/codewithdary
– GitHub: https://github.com/codewithdary
– Patreon: https://www.patreon.com/user?u=30307830

Coding Gear
– MacBook Pro: https://amzn.to/3qTMnGi
– Dell XPS: https://amzn.to/3Atp7Cm
– LG 34WN650-W: https://amzn.to/3G0XMbS
– Magic Trackpad 2: https://amzn.to/3Arp2ir
– Magic Mouse 2: https://amzn.to/346k5zC
– NAS: https://amzn.to/3rFf60U
– Sandisk SSD: https://amzn.to/3fNHcBB
– Rain Design Stand: https://amzn.to/3GTMeZ5

Recording Gear
– Rode NT-USB [Start]: https://amzn.to/3ApApXY
– Shure SM7B [Advanced]: https://amzn.to/3Arj5lv
– Rode PSA1: https://amzn.to/32pMCQ5
– Focusrite Scarlett 2i2: https://amzn.to/3FYZD0t
– XLR to XLR: https://amzn.to/3qVm2rC

Want to learn more?
– Courses: https://www.youtube.com/channel/UCkzGZ6ECGCBh0WK9bVUprtw/playlists

Code
– Source: https://drive.google.com/drive/folders/1asny74Bh80EbWWWS1ivsTIXjHWHS_S29?usp=sharing

Table of Content
0:00 introduction
04:26 Installing XAMPP
10:29 Installing a free code editor
16:49 PHP code in HTML
19:23 PHPINFO
22:49 The echo statement
26:28 The print statement
28:04 Comments in PHP
31:46 Line break
36:19 Variables & data types
42:37 Variables in echo/print
47:46 Data Types
52:01 Arrays
59:48 Associative Arrays
01:04:32 Multidmensional arrays
01:10:42 Exercises data type
01:28:12 Arithmetic operators
01:32:10 Assignment operators
01:36:17 Comparison operators
01:42:52 Increment & decrement operators
01:46:10 Logical operators
01:51:51 Conditional statements
01:58:57 Switch statement
02:02:55 While loop
02:05:41 Do while loop
02:09:27 For loop
02:16:50 Foreach loop
02:21:14 Introduction to functions
02:24:46 Creating our first function
02:28:43 Functions with arguments/parameters
02:33:27 Functions with return value
02:40:20 Global and local scope
02:42:39 Constants
02:48:01 How to include documents
02:57:15 How to require documents
02:59:57 Exercises functions
03:14:40 Introduction to built-in functions
03:17:22 Math built-in functions
03:20:17 String built-in functions
03:27:13 Array built-in functions
03:35:10 Date and time functions
03:45:57 Random number generator
03:48:29 Exercises built-in functions
04:00:14 Superglobals
04:05:15 Superglobal Post
04:09:36 Superglobal Get
04:13:02 Superglobal Session
04:17:35 Superglobal cookies
04:24:12 Superglobal Files
04:30:50 How to create a upload system
04:47:56 Create & write files
04:56:51 Read from a file
05:01:23 Script for a contact form
05:16:05 Introduction to databases
05:21:48 Creating a MySQL databas
05:25:35 Creating a MySQL table
05:35:07 Inserting data using MySQL
05:42:45 Selecting data using MySQL
05:48:14 Updating data using MySQL X
05:51:28 Deleting data using MySQL
05:53:55 Ordering data using MySQL
05:57:52 Creating a complete login & register system

#php #course #phpdevelopment #mysql

You May Also Like