PHP MySQL database connections
4.7 (40 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,434 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.7 (40 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,434 students enrolled
Created by Laurence Svekis
Last updated 6/2016
English
Current price: $10 Original price: $100 Discount: 90% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 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
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 is the target audience?
  • web developers
  • application developers
  • anyone who needs to utilize a database and connect to it
Students Who Viewed This Course Also Viewed
Curriculum For This Course
37 Lectures
02:01:14
+
Learn how to connect and use mysql database from PHP
4 Lectures 14:19


Resources for setup
00:03

How to Create a database
04:13
+
PHP and Database access
8 Lectures 42:51
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:29

How to create a table mysqli
10:50

PDO create Table
06:41

Source Code Create Tables
00:42
+
PHP MySQL working with Databases MySQLi Procedural
9 Lectures 24:58
Insert into database MySQLi
05:37

Source Code
00:10

mysqli_insert_id return id value
02:08

Select from database PHP query
07:09

Source Code Query content
00:08

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:28
+
PHP MySQL working with Databases MySQLi Object Oriented connection
7 Lectures 19:20
Insert query multi query into Mysql Object Oriented Connection
06:49

Source Files
00:17

Query Selection Object Oriented PHP connection
06:04

Source Files
00:12

Delete from mySQL database
02:16

Update data in your database
03:08

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

Insert Into Database PDO connection
05:25

Source Code Insert
00:23

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:23
+
PHP MySQL connection Resources
1 Lecture 00:00
Resources
00:00
About the Instructor
Laurence Svekis
4.2 Average rating
13,052 Reviews
289,419 Students
183 Courses
Instructor, 18+yrs Web Experience

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

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!"