PHP MySQL Fundamentals from Scratch with Examples & Projects

Focused View

Pradnyankur Nikam

15:04:21

80 View

01 - PHP MySQL Installation & Run Your First PHP Program

001 Requirements for PHP & MySQL Installation.mp4

04:50

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.mp4

12:01

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

003 Download & Install MAMP on MAC Operating System.mp4

11:15

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

004 Download & Install LAMP on Linux Operating System.mp4

11:12

005 Your First PHP Program Hello World!.mp4

11:29

006 A brief overview of Bitnami WAMPMAMPLAMP stack manager tool.mp4

32:10

007 Download and Install Text Editor for PHP.mp4

04:33

external-links.txt

02 - Introduction to PHP and Basic Configuration Settings

001 What is PHP.mp4

03:34

002 History of PHP!.mp4

02:30

003 Lets understand PHP Syntax.mp4

01:53

004 Understand how PHP codes are executed on a web server.mp4

02:06

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

13:26

006 The echo & print functions in PHP.mp4

13:01

007 Embed HTML tags in PHP.mp4

06:22

008 Whitespace in PHP.mp4

04:13

009 Define and use PHP Variables.mp4

08:22

010 Define and use PHP Constants.mp4

06:22

011 Single quotes vs Double quotes.mp4

07:55

012 Are PHP codes case sensitive.mp4

05:45

013 How to add comments in PHP Program.mp4

06:21

03 - PHP Data Types

001 Data types in PHP.mp4

01:24

002 Boolean data type in PHP.mp4

05:06

003 Integer data type in PHP.mp4

05:14

004 Float or Double data type in PHP.mp4

03:55

005 String data type in PHP.mp4

04:11

006 Array data type in PHP.mp4

03:40

007 Object data type in PHP.mp4

04:57

008 Resource data type in PHP.mp4

03:08

009 NULL data type in PHP.mp4

04:49

04 - PHP Operators

001 What are operators & types of operators in PHP.mp4

01:30

002 PHP Arithmetic operators.mp4

03:41

003 PHP Assignment operators.mp4

04:50

004 PHP Comparison operators.mp4

09:07

005 Error Control Operators.mp4

03:27

006 PHP Increment & Decrement operators.mp4

05:31

007 PHP Logical operators.mp4

08:18

008 PHP String operators.mp4

03:48

009 PHP Array operators.mp4

07:21

05 - PHP Conditional Statements

001 What is conditional statement in PHP.mp4

01:08

002 PHP if statement.mp4

06:20

003 PHP if else statement.mp4

06:02

004 PHP if elseif else statement.mp4

08:20

005 PHP switch statement.mp4

10:02

06 - PHP Loop Statements

001 What is Loop & Types of loop statements in PHP.mp4

01:25

002 PHP while loop statement.mp4

06:20

003 PHP do while loop statement.mp4

04:11

004 The difference between while and do while statement in PHP.mp4

03:43

005 PHP for loop statement.mp4

05:36

006 PHP foreach loop statement.mp4

06:13

007 PHP break statement.mp4

06:31

008 PHP continue statement.mp4

04:36

07 - PHP Arrays

001 What is array & types of arrays in PHP.mp4

01:04

002 Indexed Arrays in PHP.mp4

16:48

003 Associative Arrays in PHP.mp4

10:29

004 Multidimensional arrays in PHP.mp4

07:40

005 Useful Array Functions in PHP.mp4

09:47

08 - Functions in PHP

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

04:14

002 String functions in PHP.mp4

10:43

003 Math functions in PHP.mp4

05:04

004 Array functions in PHP.mp4

11:17

09 - User Defined Functions in PHP

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

03:24

002 Define and use your first PHP function.mp4

05:43

003 Define functions with arguments in PHP.mp4

09:08

004 Define functions with default arguments in PHP.mp4

12:43

005 Define functions that return the value in PHP.mp4

07:45

006 What is constant & variable scope in PHP.mp4

07:11

10 - PHP Superglobals or Global variables

001 What are Superglobals or Global variables in PHP.mp4

01:00

002 PHP $GLOBALS global variable.mp4

003 PHP $ SERVER global variable.mp4

03:33

004 PHP $ ENV global variable.mp4

04:48

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

12:39

11 - PHP Date and Time

001 View and set timezone in PHP.mp4

09:19

002 Date time formatting in PHP.mp4

04:18

003 Some useful date time functions in PHP.mp4

13:48

12 - PHP Cookies & Sessions

001 The cookies & sessions in PHP.mp4

00:34

002 What are cookies & How to create cookies in PHP.mp4

07:03

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

07:47

004 How to update cookies in PHP.mp4

02:57

005 How to delete cookies in PHP.mp4

06:45

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

02:47

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

06:47

008 How to update session variables in PHP.mp4

02:38

009 How to delete session variables in PHP.mp4

03:50

010 The difference between cookies and sessions.mp4

09:03

13 - Building Web Pages in PHP

001 Create web page links and URLs in PHP.mp4

04:43

002 Pass variables and values via GET method.mp4

05:20

003 The importance of URL encoding in PHP.mp4

06:56

004 Retrieve or extract the values via POST method.mp4

05:29

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

08:39

006 Absolute path vs Relative path in PHP.mp4

12:47

007 How to redirect web pages in PHP.mp4

02:40

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

001 Contact-form-exercise-files.zip

001 Design a contact form using Bootstrap.mp4

07:26

001 bootstrap-4.1.1.zip

002 Get & display variable values from contact form.mp4

04:32

003 Validate contact form input values using PHP.mp4

20:48

004 Sanitize contact form input values using PHP.mp4

11:02

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

08:09

005 sendmail.zip

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

06:35

006 Mac-Postfix-Configuration-Setting.txt

007 PHP mail function to send emails.mp4

05:12

external-links.txt

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

001 Design a file upload form using Bootstrap.mp4

03:13

001 File-uploader-exercise-files.zip

002 Checkout the file upload settings in PHP.mp4

03:08

003 Temporary file variables while uploading.mp4

03:21

004 PHP file validation before upload.mp4

11:21

005 PHP move uploaded file to a specific location.mp4

04:04

16 - Introduction to MySQL database

001 Introduction to MySQL.mp4

02:31

002 Login to MySQL database server & execute basic SQL statements.mp4

06:36

003 Keywords, Identifiers, Constants and Clauses.mp4

02:24

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

01:31

005 How to create & use a database in MySQL.mp4

03:27

006 How to create a table in MySQL database.mp4

05:58

007 Update an existing table in MySQL.mp4

06:15

008 Delete or remove an existing table from MySQL database.mp4

01:58

009 Add data rows or records in MySQL table.mp4

06:09

010 View or retrieve data rows from MySQL table.mp4

02:39

011 Update data rows inside MySQL table.mp4

03:50

012 Delete or remove data rows from MySQL table.mp4

02:35

013 Important Data types in MySQL.mp4

01:29

014 Important Conditions & Operators in MySQL.mp4

08:19

015 Data grouping, sorting & dates in MySQL.mp4

09:29

016 Important SQL constraints in MySQL database.mp4

09:13

017 Learn how to design a relational database in MySQL.mp4

11:40

018 How to backup & restore database in MySQL.mp4

07:59

17 - Introduction to phpMyAdmin

001 Introduction to phpMyAdmin.mp4

07:04

002 Manage databases using phpMyAdmin.mp4

03:10

003 Manage database tables using phpMyAdmin.mp4

07:17

004 Managing table data rows using phpMyAdmin.mp4

03:38

005 Backup & restore MySQL database using phpMyAdmin.mp4

07:16

18 - Interacting with MySQL database using PHP

001 How do we interact with database management systems using PHP.mp4

02:05

002 How to connect to MySQL database using PHP.mp4

05:10

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

09:15

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

09:01

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

07:35

006 How to close MySQL database connection in PHP.mp4

03:57

19 - Single page user management system (Project)

001 Design user management page using Bootstrap.mp4

04:27

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

002 Connect to database, display records & close connection.mp4

10:25

003 Handle two form submission on single page.mp4

20:03

004 Get and validate POST variable values.mp4

15:48

005 Complete add user functionality.mp4

05:30

006 Complete delete user functionality.mp4

06:53

20 - Bonus Section

Description

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

What You'll Learn?

Design and develop fully functional dynamic websites & web applications.
Work on freelance jobs and projects related to PHP and MySQL.
Easily troubleshoot any PHP MySQL related errors or bugs.
Backup and restore PHP projects from and to live server.
Better understand programming concepts & logic with practical examples.
PHP fundamentals, form handling, email sending, user registration, design CMS etc.

Who is this for?

A school/college student who wants to learn PHP, MySQL for academic projects.

A freelancer/An employee for learning new skill to work on PHP projects.

A web developer to upgrade his/her website from static to dynamic.

A programmer who wants to learn web application development using PHP & MySQL.

What You Need to Know?

A computer or laptop to write & execute examples given in this course.

An internet connection only to download the necessary installer packages.

Basic HTML knowledge (optional) in order to create dynamic web pages.

More details

Description
PHP MySQL Fundamentals from Scratch with Examples & Projects
There are many online php courses with certificate. Some instructors teach fundamentals of PHP with MYSQL for Dynamic Websites, while some explain the concepts practically using php projects. In order to work on live projects, it is necessary to have practical understanding of php and mysql. Since, there are many courses, it is really difficult to guess which is the best php video tutorial for you. In order to clear your confusion, I've created this course for you. The course lectures are organized in such a way that you will learn php from scratch step by step. First we will understand php language fundamentals, then move to MySQL database and then complete a couple of php mysql projects.
Why should you take this PHP MySQL course?
This course contains 15+ hours of video content, 20+ sections, 130+ video tutorials. In short it have almost every important topic you need to learn as a PHP developer.
There are quizzes, do it yourself assignment challenges on each section. This is really important to know how much you understood, and if you are able to use the skill we learned so far.
You will learn PHP fundamentals as well as MySQL database development. Please Note: Every topic is discussed with examples.
We will also design PHP MySQL projects from scratch, relevant to the topics we've learned.
Lightning fast support to your queries: I personally respond to my students queries (within 1-24hours) via direct messages or on Q&A section of the course. I reply on weekends too. So If you have any question feel free to PM me or ask questions on Q&A section.
Lifetime access to all the content and future updates of this course.
30 days money back guarantee. (I am sure you will never need this)

You will learn PHP programming from scratch and effective database designing using MySQL database server for your websites or web applications. Steps involved in the learning process would be,
Step 1: You will require local development environment to write and test the examples covered in the course. So, We will start from PHP, MySQL installation and configuration.
Step 2: Then You will be introduced to PHP's most important, basic and fundamental topics like, data types, operators, conditional & loop statements, arrays, functions, date & time, cookies & sessions etc. After that, we will explore the skill required to develop web pages.
Step 3: When you are confident enough with PHP programming, we will learn database development using MySQL database server. We will understood database development using MySQL command line client tool as well as phpMyAdmin.
Step 4: When you have both the tools (PHP & MySQL), we will learn Interacting with MySQL database using PHP programming.
Step 5: Throughout your journey, you'll be asked to solve quizzes, complete do it yourself assignment challenges, solve coding exercises.

Do you know the Benefits of learning PHP & MySQL?
Probably, you already know the benefits of PHP & MySQL. That might be the reason you are exploring this course content. If you don't know, here are some of the benefits.
If you are a student, you can create academic projects.
PHP is simple and easy to understood. It will help you understood programming concepts quickly.
It is free & open source. You can design free/paid applications without worrying about license.
PHP has a large community of developers. And there are various PHP resources available like, video tutorials, articles/blogs, documentation, FAQ's, discussion boards etc. You can quickly get the help you need.
If you are completely new to PHP, I'll recommend you to Google "Benefits of PHP" and checkout the information available online.

What students say about this course? Checkout some of my students reviews for this course.
"I believe this is providing a detailed and thorough approach to learning PHP and MySQL. It seems to take a logical "step at a time" learning. echo "Nice job.";" By Brian Mellady

Watch introduction video & checkout "Curriculum" to see list of all sections and topics included in this PHP programming course.
Who this course is for:
A school/college student who wants to learn PHP, MySQL for academic projects.
A freelancer/An employee for learning new skill to work on PHP projects.
A web developer to upgrade his/her website from static to dynamic.
A programmer who wants to learn web application development using PHP & MySQL.

User Reviews

Rating

average 0

Total votes0

Focused display

Hi, I am Pradnyankur Nikam from Pune, Maharashtra, India. I'm an instructor, freelance web developer, PHP, MySQL & WordPress developer.After completing my post graduation in 2008, I started developing websites for myself, where I used to sell affiliate games & software. I learned online marketing & SEO (search engine optimization) skills by using which promoted my websites. While marketing my websites, I started working on freelance projects, where I got opportunities to further improve my skills.During my 10+ years freelancer carrier, I've helped hundreds of clients to build websites, APIs, troubleshoot errors, setup web servers and much more. I've practical experience of working on thousands of projects. And it would be my pleasure to share my experience with you.Experience: 10+ years as web developerSkills: Programming & Database Development (HTML5, CSS3, JavaScript, PHP, MySQL, WordPress)Other Skills: Online Marketing & SEO (Search Engine Optimization)Courses teaching: 2No. of students: 8000+No. of reviews: 1500+Why should you take my courses?The most important aspect in learning is PRACTICAL. As I told you above I've 10+ years of practical experience, I know how things are developed or how things work. In my courses I've taken practical approach to teach & explain course topics practically with examples. Also, There are Assignments, Quizzes, Do-It-Yourself coding challenges which will help you better understand the topics.What students say about my courses?Currently I've 2 courses with 1500+ reviews and hundreds of feedbacks. Checkout some of the feedbacks below,"I took many courses on Udemy. I think this is my best course I took Instructor is very motivated and try to help all of us. I sent private messages. His reply was so quickly. His responses were prices. Thank you so much Ankur" - Mohammad Aboud"I knew nothing about SQL before this course. I found it searching for how to install mysql. The course was very well structured and easy to follow. Thank you very much." - Mark DeNunzio"A good course for beginners to learn MySQL. Very clear and sincere effort by the teacher in teaching the concept." - Pushkal Singh"I believe this is providing a detailed and thorough approach to learning PHP and MySQL. It seems to take a logical "step at a time" learning." - Brian Mellady "the instructor was more than helpful throughout the course, especially when starting out." - Ishan MareddyWhat are you waiting for?Well, you can keep reading about me or keep browsing my courses. But the best way to know about me, my teaching style or course content is, to ENROLL. So, Enroll to my course and join me on this amazing learning journey.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.