Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add MySQLi For Beginners to your Wishlist.

Add to Wishlist

MySQLi For Beginners

A quick and helpful lesson on database integration using the MySQLi extension.
4.1 (20 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.
3,578 students enrolled
Last updated 4/2016
$10 $60 83% off
1 day left at this price!
30-Day Money-Back Guarantee
  • 1.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Work with a MySQL database with PHP to build applications that depend on a database connection. This course covers all required elements of MySQLi from working with data to security.
View Curriculum
  • Will require a webserver (Apache or Nginx) with PHP 4.1 or greater (although a higher, preferably the latest version, is better), and MySQL installed.
  • Students will also require database management software such as Sequel Pro (Mac), HeidiSQL (Windows) or MySQL workbench (Linux).

The course teaches MySQLi, a way to connect to databases within PHP. It covers connecting to the database, and using all the features required to build fast, scalable applications that use a database connection. It covers essential concepts like security, and best practices with using the data retrieved from the database.

Benefits of MySQLi

  • An object-oriented interface
  • Support for prepared statements
  • Support for multiple statements
  • Support for transactions
  • Enhanced debugging support
  • Embedded server support

A knowledge of PHP and MySQL is recommended for this course.

Who is the target audience?
  • Anyone with basic knowledge of PHP, database experience not required but is helpful, as this is demonstrated.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 15 Lectures Collapse All 15 Lectures 01:31:58
1 Lecture 05:21

Download the course files here.

Preview 05:21
Getting Started with MySQLi
3 Lectures 21:15

How to connect to a database using database software.

Preview 07:55

Using MySQLi to connect to a MySQL database and how to handle errors connecting so we can display an error to users.

Connecting Using PHP

Create a database that we'll be able to work with during the series.

Creating a Database Table
Fetching Results
3 Lectures 19:20

How to query the database for a single record, and how to examine the data with PHP.

Pulling Single Records

How to pull multiple records from the database and how to examine the data with PHP.

Pulling Multiple Records

The different result types we can choose from once we've queried the database for data.

Different Result Types
Getting Results
2 Lectures 14:11

Count either total results in the database table, or counting the amount of results that have been returned using a specific query.

Counting Results

Update records and find out how many records have been affected by the query we execute.

Updating and Seeing Affected Rows
3 Lectures 26:29

Escaping data we get from another souce, such as a user, so we can protected against SQL injection.


Learn how SQL injection works and what can happen if the appropriate steps are not taken to escape data.

Prepared Statements for Inserting

Using prepared statements to send multiple values to a query, automatically escaping them to protect against SQL injection. Specifically deals with inserting data.

Selecting Prepared Statements
Finishing Up
3 Lectures 05:24

How to use the MySQLi method to free up result data, helping to speed up the application.

Freeing Results

Using prepared statements to send multiple values to a query, automatically escaping them to protect against SQL injection. Specifically deals with selecting data.

Closing the Database Connection

Request a Course
About the Instructor
4.2 Average rating
11,215 Reviews
229,324 Students
185 Courses
220,000+ Happy Udemy Students

At Stone River eLearning, technology is all we teach. If you're interested in programming, development or design - we have it covered. 

Check out our huge catalog of courses and join the over 370,000 students currently taking Stone River eLearning courses. We currently offer 100+ different technology training courses on our Stone River eLearning website and are adding new courses on hot and trending topics every month. A subscription option is available for those with a real passion for learning.

Report Abuse