PHP MySQL database connections
4.5 (70 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,656 students enrolled

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 (70 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
6,656 students enrolled
Created by Laurence Svekis
Last updated 11/2019
English
English [Auto-generated]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • 13 articles
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Course content
Expand all 38 lectures 02:02:28
+ PHP and Database access
8 lectures 42:36
MySQLi Procedural database connection
09:56
MySQLi Object Oriented connection
03:21
PDO connection
04:42
Create a SQL query to create a database
06:10
Source Code
00:20
How to create a table mysqli
10:50
PDO create Table
06:41
Source Code Create Tables
00:35
+ PHP MySQL working with Databases MySQLi Procedural
9 lectures 24:47
Insert into database MySQLi
05:37
Source Code
00:08
mysqli_insert_id return id value
02:08
Select from database PHP query
07:09
Source Code Query content
00:05
DELETE row from MySQL
04:08
Update content in your database
02:07
How to create query strings with phpmyadmin
03:02
Source Code MySQLi Procedural connection
00:22
+ PHP MySQL working with Databases MySQLi Object Oriented connection
7 lectures 19:07
Insert query multi query into Mysql Object Oriented Connection
06:49
Source Files
00:13
Query Selection Object Oriented PHP connection
06:04
Source Files
00:09
Delete from mySQL database
02:16
Update data in your database
03:08
Source Code used in MySQLi Object Oriented connection
00:28
+ PHP MySQL working with Databases PDO connection
8 lectures 20:23
PDO connection insert Data
03:13
Insert Into Database PDO connection
05:25
Source Code Insert
00:17
Select data from database
02:02
Delete rows using PDO connection
02:23
Update MySQL database
02:41
How to use prepare statements in PHP
04:04
Source Files
00:18
Requirements
  • basic PHP and web coding knowledge
  • desire to learn
  • computer access
Description

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 this course is for:
  • web developers
  • application developers
  • anyone who needs to utilize a database and connect to it