Introduction to PHP and MySQL connections

Laurence Svekis
A free video tutorial from Laurence Svekis
Instructor, GDE, Application Developer
4.3 instructor rating • 350 courses • 624,432 students

Learn more from the full course

PHP connections to MySQL

Learn how to connect a MySQL database to your PHP application. Learn MySQLi connection code and Object oriented PHP

01:02:23 of on-demand video • Updated November 2019

  • Connection PHP code to MySQL database
  • Create tables, database and run queries using PHP code
English [Auto] Welcome to our course on ph P and creating my sequel database connections within this course we're going to be taking you through writing ph code in order to connect to my Secord database. My name is Lawrence I'm going to be your instructor for this course and I'm here to help you learn more about creating ph p code to connect to my sequel database. I've been creating web sites since 1999 and databases and ph P gather have allowed me to make some really amazing applications and I'm going to be sharing my knowledge with you within this course. We're going to be looking at how PSP and my sequel work together to allow you to create some really amazing stuff on line connecting your code to your database is what this course is all about. Learn how to add a database connection to your PSP application and connect that database which is required by so many applications allowing you to take those applications to the next level. This course covers writing P2P code both in procedural and object oriented coding. So we're going to be creating and connecting to a database and creating a database creating a database table setting up a database connection inserting data into our database selecting that data from the database updating the database content deleting data from the database and creating queries also creating queries in PSP my admin and we're going to be doing this in both procedural and object oriented coding so that you can get familiar with different styles of making these connections with your ph peacoat source code is also included to get you started quickly. We've got examples and samples for both coding options were included within this course. So everything you need is in one place connect your sequel. It's easy and it can bring your applications to the next level. Please note that this course does not cover the basics of HP and basic knowledge of p p is required as part of the course. It will not be covering page coding outside of the scope of the core summary and also setting up a local server is optional. We've got suggestions how you can set up a local machine. If you've already got one set up a local server if you want to use a web server you can do that as well. We're also going to be suggesting an editor if you already have an editor then you can go ahead and use that one. Or check out the one that we're going to be going over and discussing within the course start out by creating a settings file that can include all of our connection data to set up our database connection. Then we're going to show you how we can create that procedural connection creating a database. Also creating a table within that database as well inserting data into that database. So you know how we can write those queries. Selecting content from the database outputting it into our APHC code also updating the database deleting from the database and then we're going to show you how to do all of that again in object oriented fashion. So we're going to show you how to do the connection in object oriented creating a table inserting into the table selecting updating deleting and everything in between. We're also going to be working with THP. My admin and I show you some tricks using p p my admin in order to create those queries so you can write those queries within your code quicker. Courses designed to be a fast paced course to get you through the content quickly. And as mentioned we are going to focus only on the part of making those database connections within the course. So when you're ready let's begin making connections using P2P code to our database.