PHP MySQL database connections
4.5 (43 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
4,799 students enrolled
Wishlisted Wishlist

Please confirm that you want to add PHP MySQL database connections to your Wishlist.

Add to Wishlist

PHP MySQL database connections

Learn to connect to a MySQL database with PHP code how to select, update, delete, insert content to a MySQL database
4.5 (43 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
4,799 students enrolled
Created by Laurence Svekis
Last updated 6/2016
English [Auto-generated]
Current price: $10 Original price: $100 Discount: 90% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 2 hours on-demand video
  • 12 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • connect web pages to a mysql database
  • update insert delete and use mysql database content
  • connect to MySQL using procedural methods
  • connect to MySQL using mysqli object methods
  • connect to MySQL using PDO methods
View Curriculum
  • basic PHP and web coding knowledge
  • desire to learn
  • computer access

Learn how to use a MySQL database and access data within your PHP code.  MySQL is the most popular database used by PHP.  Its works really well and smoothly with PHP code and is an ideal solution for storing information and utilising that data within your web projects. 

Do you need a database within you website? Database can help with information management and run as a the data source for dynamic websites.   MySQL is the perfect solution for any size application.   Its fast and reliable and best of all easy to use.   

This course covers multiple methods of connecting to a MySQL database.  Avoid the confusion of only one way, we show you three ways to connect to a MySQL database via PHP code.

Top resources, source code and more is provided to get you started quickly.

  • Learn how to connect to a database
  • Create databases
  • Create tables
  • Insert records into a MySQL database
  • Return ids of inserted records
  • Delete records 
  • Update records
  • Create queries to interact with database content
  • phpmyadmin and how to use it

By the end of the course we show how to use a database within your PHP code

I am here to help you learn how to create your own websites and ready to answer any questions you may have.

Want to know more, what are you waiting for take the first step.  Join now to start learning how you too can add a database to your website today.

Who is the target audience?
  • web developers
  • application developers
  • anyone who needs to utilize a database and connect to it
Compare to Other MySQL Courses
Curriculum For This Course
37 Lectures
Learn how to connect and use mysql database from PHP
4 Lectures 14:19

Resources for setup

How to Create a database
PHP and Database access
8 Lectures 42:51
MySQLi Procedural database connection

MySQLi Object Oriented connection

PDO connection

Create a SQL query to create a database

Source Code

How to create a table mysqli

PDO create Table

Source Code Create Tables
PHP MySQL working with Databases MySQLi Procedural
9 Lectures 24:58
Insert into database MySQLi

Source Code

mysqli_insert_id return id value

Select from database PHP query

Source Code Query content

DELETE row from MySQL

Update content in your database

How to create query strings with phpmyadmin

Source Code MySQLi Procedural connection
PHP MySQL working with Databases MySQLi Object Oriented connection
7 Lectures 19:20
Insert query multi query into Mysql Object Oriented Connection

Source Files

Query Selection Object Oriented PHP connection

Source Files

Delete from mySQL database

Update data in your database

Source Code used in MySQLi Object Oriented connection
PHP MySQL working with Databases PDO connection
8 Lectures 20:35
PDO connection insert Data

Insert Into Database PDO connection

Source Code Insert

Select data from database

Delete rows using PDO connection

Update MySQL database

How to use prepare statements in PHP

Source Files
PHP MySQL connection Resources
1 Lecture 00:00
About the Instructor
Laurence Svekis
4.2 Average rating
14,323 Reviews
315,091 Students
188 Courses
Instructor, 18+yrs Web Experience

I'm here to help you learnachieve your dreams, come join me on this amazing adventure today

Providing Web development courses and digital marketing strategy courses since 2002.

Innovative technology expert with a wide range of real world experience. Providing Smart digital solutions online for both small and enterprise level businesses.

"I have a passion for anything digital technology related, enjoy programming and the challenge of developing successful digital experiences. As an experienced developer, I created my first computer applications in 1990, and my first website in 1998.  I enjoy sharing my knowledge with others and want to help you share in the wonderful opportunities that the internet provides."

"Learning, understanding with a strong passion for education.  The internet has provided us with new opportunities to expand and share knowledge."

Want to learn more about becoming a web developer, do you want to experience the freedom that technology provides for us? Learn how to bring amazing things to life online.  Technology connects us all in many ways.  It opens up doors to those who embrace it and learn how to make those connections real.

"My courses are designed to help you achieve your goals, learn and update skills"

Background : An experienced web application developer, having worked on multiple enterprise level applications, hundreds of websites, business solutions and many unique and innovative web applications.  Web application development areas of expertise include HTML, CSS, JavaScript, JQuery, Bootstrap, PHP and MySQL. Anything to do with web creation and digital experience. Passionate about everything to do with web application development, programming to online marketing with a strong focus on social media and SEO

"Understanding technology provides a means to better connect with users.  It also opens so many doors.   Knowledge is the key to success and I want to help you experience what technology has to offer. I'm passionate about web technologies, and look forward to sharing my knowledge and experience with you!"