> PHP >

Course Overview

Login to bookmark this course

Course 3: Talking to a MySQL Database in PHP

Dive into MySQL databases: from connection, creation, queries to security, all in PHP.

  • 1529 students
  • EN Captions
  • EN Script
  • Certificate of Completion

Your Guides

About this course

Woh, this is episode 3 of our Epic PHP series!

Yep, and this one is all about databases:

  • What the heck is a database anyways?
  • Connecting to MySQL
  • Creating a database and tables
  • INSERT queries
  • SELECT queries
  • UPDATE and DELETE queries
  • Using PDO in PHP to run queries
  • Limiting Results
  • Avoiding SQL Injection Attacks
  • Prepared Statements
  • Optional Function Arguments

Other episodes from this series:

Next courses in the PHP: Get Started section of the PHP Track!

10 Comments

Sort By
Login or Register to join the conversation
Neal O. avatar Neal O. 7 years ago

Is there going to be a 4 episode for the PHP series that covers inserting, updating and deleting data? Your tutorials are the best I have found on the web but several seem to be stuck in limbo with lots of unfinished sections. I would challenge you to look at all the available tutorials and finish them before throwing out more Symfony 3 stuff. Probably could be accomplished in a months time. Looking forward to a productive new year learning with KnpUniversity.

1 | Reply |

Hey Neal!

Yes, we have a lot of threads going :). I promise we'll be looking more into this series to make sure it's complete. And thanks for the nice words - I want people to be able to go from zero to hero all in one place. The specifics for ep4 aren't planned yet - but I just added your suggestions to our planning document.

Thanks!

| Reply |
Default user avatar Gilron Charles weaverryan 7 years ago

I would really love to see an episode 4 also

| Reply |
Default user avatar Anne Bonham 7 years ago

Love the series, thanks! Can't wait to learn how to connect the form submissions to the db!

1 | Reply |
Wahyu A. avatar Wahyu A. 5 years ago

How can i complete this course ? I have watched it all but it still "You're through this course
complete - get started!" there is not any challenge yet

| Reply |

Hey Wahyu,

Are you logged in to your account? If so, please, look at the list of chapters - there should be a "tick" icon on every chapter title in the list. Find those that do not have ticks and watch the video til the end. If you still have this problem - please, write to us via our contact form: https://symfonycasts.com/co... and we will look at your account and give you some tips what else you have to do to finish the course 100%.

Cheers!

| Reply |