Extend your understanding of PHP by learning how to connect to a MySQL database using the PDO class. This step-by-step course will take you from creating a simple database, connecting to it, displaying records, updating, deleting, and even using Bootstrap and Font Awesome icons to make your pages look fantastic.
Every line of code is explained as I teach. The lessons are kept short and to the point.
OVER 1700 STUDENTS CURRENTLY TAKING THIS COURSE
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, emmet, 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 beginners." 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 carefully developed based on my 30+ years of teaching students in real classrooms and online. After carefully watching and analysing their reactions to new concepts I know what works and what does not work. Therefore, each lesson has been designed to quickly help you understand the processes involved in using a MySQL database and interacting with it using PHP to Create, Retrieve, Update and Delete records (CRUD).
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
I am so confident that you will love this course that I have opened up the first 2 sections of lessons for you to watch for FREE.
Learn from a national award-winning teacher. Patrick has over 30 years teaching experience and still teaches in a real classroom as well as online. He was awarded “Outstanding Teacher of the Year” in the UK National Teaching Awards and has been featured in the Financial Times, Computer Weekly, ISP World, and others.
Remember, that you will have full access to my support during the course. If you have any questions please feel free to contact me (patrick@coding.academy) and ask. You will see exactly how responsive I am to students enquiries.
