PHP for Beginners: PDO, MySQL, phpMyAdmin

Learn PHP, PDO, and MySQL to create data-driven websites. Engage with practical exercises for clear understanding. Start your coding journey today!

  • Overview
  • Curriculum
  • Instructor
  • Review

Brief Summary

This course helps you learn how to use PHP and MySQL to build awesome, data-driven websites. You'll get clear explanations and practical exercises to build your skills step by step. It's beginner-friendly and designed to give you hands-on experience!

Key Points

  • Learn PHP, PDO, MySQL, phpMyAdmin
  • Every line of code is explained clearly
  • Hands-on exercises after each section
  • Create, read, update, delete (CRUD) records
  • Use Bootstrap for styling forms

Learning Outcomes

  • Create and manage a MySQL database using phpMyAdmin
  • Understand and implement CRUD operations
  • Build interactive forms with HTML and PHP
  • Style forms with Bootstrap and use Font Awesome icons
  • Connect PHP to a MySQL database using PDO

About This Course

Every line of code explained. Learn PHP, PDO, MySQL, phpMyAdmin to create data driven websites. Award winning teacher.

Welcome to PHP, PDO and MySQL for Beginners!

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, 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 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 download 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.

  • Create a database

  • Create database tables

  • Populate a database table manually via phpMyAdmin

Instructor

Profile photo of Coding Academy
Coding Academy

I have been teaching students for over 30 years and focus on delivering content in a clear and concise manner. As a national award-winning teacher, I am passionate about education and still teach in the classroom today. My online courses across subjects including coding, game development, and mathematics have attracted many thousands of students across over 120 countries.

Review
4.9 course rating
4K ratings
ui-avatar of Reginaldo Soares da Silva Junior
Reginaldo S. D. S. J.
5.0
9 months ago

Muito eficiente na abordagem, tornando fácil a assimilação do conteúdo. Excelente !!!

  • Helpful
  • Not helpful
ui-avatar of David Tomney
David T.
4.0
1 year ago

A good course, but a bit outdated as is part 1. This course is also a bit short.

  • Helpful
  • Not helpful
ui-avatar of Bradley S
Bradley S.
5.0
2 years ago

Well thought out and easy to follow.

  • Helpful
  • Not helpful
ui-avatar of Abiola Osota
Abiola O.
5.0
2 years ago

Awesome lessons. Thank you soo much

  • Helpful
  • Not helpful
ui-avatar of Collin Castel
Collin C.
5.0
2 years ago

I like the way this teacher gives his lessons.

  • Helpful
  • Not helpful
ui-avatar of Jose Moreta
Jose M.
5.0
2 years ago

The course explained every concepts on details, letting me understand the proccess of how to write code that actually works.

  • Helpful
  • Not helpful
ui-avatar of Vincent Phan
Vincent P.
4.0
2 years ago

it definitely was interesting but it was less explained than the first course. Also I was wondering why there is no part 3.

  • Helpful
  • Not helpful
ui-avatar of Philip W Strphenson
Philip W. S.
5.0
2 years ago

The course needs to be updated to reflect the changed UIs for Codeanywhere and Generate Data but it is still well-organized and usable.

  • Helpful
  • Not helpful
ui-avatar of David Saraiva
David S.
5.0
2 years ago

I enjoyed this course, was expecting it to be a bit more in depth, but it was still a great course and I enjoyed it.

  • Helpful
  • Not helpful
ui-avatar of Kevin Tousey
Kevin T.
2.5
3 years ago

The instructor is clear. However, I expected more since this is a level two course; in particular, I think there should have been a discussion about prepared statements (which were used, but not fully explained). Please consider updating this course to include more content.

  • Helpful
  • Not helpful
Leave A Reply

Your email address will not be published. Required fields are marked *

Ratings

Courses You May Like

Lorem ipsum dolor sit amet elit
Show More Courses