MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 30 lectures (2h 48m) | Size: 1.2 GB

Every line of code explained.

Learn PHP, PDO, MySQL & phpMyAdmin to create data driven websites. Award winning teacher

Create a database

Create database tables

Populate a database table manually via phpMyAdmin

Populate a database table via a CSV file

Populate a database table via a SQL dump

Connect to a database using a PHP PDO connection

Understand the CRUD acronym

Create records in a database table via PHP

Read records from a database table via PHP

Update records in a database table via PHP

Delete records from a database table via PHP

Use HTML forms to create, read, update and delete records

Use Bootstrap to style forms and tables

Have some knowledge of HTML and PHP

Internet access

A functioning PHP, MySQL and phpMyAdmin development environment of your choice. I will show you how to use CodeAnywhere including all set up. There is a free 7 day trial for those who would like to test it. Then is it only $3 per month. It is the best and easiest system I have found to enable me to support students.

Welcome to PHP, PDO and MySQL for Bners!

Last update: 24th September 2021

This course is intended for those who wish to develop their understanding and skills in PHP and MySQL in order to develop data driven websites.

Every line of code is explained as I teach. The lessons are kept short and to the point.

STUDENT REVIEW: "Patrick is an excellent, thorough and easy to understand teacher. I bought this course as soon as it was available because I was so impressed with his first course. Thank you Patrick!" 5 STARS

STUDENT REVIEW: "I learned a lot in this "close to real live" education. It was very helpful to get into connection with some important things close to PHP. By taking a look at bootstrap, t, SQL and little bit of CSS and other things was very helpful to get an overview of the most important tools and languages around PHP. I really love to listen to and learn from Patrick. He is giving very good and easy to understand comprehensive explanations, he is setting tasks that are a challenge but feasible and he is showing the solutions. By listening to all that and writing the code myself in the tasks I really learned a lot. Great Stuff !" 5 STARS

STUDENT REVIEW: "An amazing course. Very good for bners." 5 STARS

The unique difference about my courses is that you are given exercises to complete after each section. This enables you to try what you have learnt with my full support. Students who have taken this course appreciate the level of clear explanation and strengthening of their skills.

The course has been developed following years of teaching students in a real classroom environment and watching and analysing their reactions to new concepts. Therefore, each lesson has been designed to quickly help you understand the processes involved in connecting to and actively using databases within websites.

At the end of the course you will be able to:

create a database using phpMyAdmin

use a SQL dump to create a MySQL database table and populate it

use a CSV file to populate a MySQL database table

change database user permissions using phpMyAdmin

connect to a MySQL database using a PDO connection

understand the acronym CRUD

create, read, update and delete records using phpMyAdmin

create, read, update and delete records using PHP

create an input form using HTML

create, read, update and delete records by using a HTML form and PHP

use Bootstrap to style the input form

use Font Awesome to add some icons for edit and delete actions

present database table records in a table and style it using Bootstrap

THE DEVELOPMENT ENVIRONMENT

IMPORTANT: Please read carefully

You are free to use ANY development environment including the one that you are already using (if any). In this course, I show you how to and install Visual Studio Code and MAMP (both of which are FREE and available for Mac and Windows).

If you are unsure about which code editor option is best for you then I encourage you to contact me and I will be happy to discuss the options with you.

You can also follow this course using your own preferred code editor.

Once again, using Visual Studio Code with MAMP is OPTIONAL. You can use ANY suitable development environment of your choosing.

MY PROMISES TO YOU

As a registered teacher (yes, I teach in a real classroom every day), I strongly believe it is my job to ensure you feel totally supported when taking my classes. I therefore promise the following:

to respect you as a student and individual with your own learning needs

to be courteous and polite in our interactions

to answer your questions about the course content promptly

to fix any issues you may encounter with the lessons

to respond promptly to feedback

I really do look forward to welcoming you to this course. I am confident you will enjoy the approach of learning what each line of code actually means.

Join the course today.

ZOOM or Webex Meeting: I am more than happy to arrange a where I can help you set up Visual Studio Code and MAMP if you feel you need the additional support. Having the 1-1 support is useful in getting you up and running quickly if you are new to coding. Just send me a private message.

Due to the huge number of possible platforms and editors I cannot offer support for third party development environments. However, I will happily support you if using CodeAnywhere as it is the editor I use throughout this course.

Absolute bners to using MySQL with PHP or those wishing to refresh their basic skills.

This is NOT a course for advanced users.






DOWNLOAD
uploadgig.com