MySQLi For Beginners

A quick and helpful lesson on database integration using the MySQLi extension.
4.2 (18 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,577 students enrolled
$19
$60
68% off
Take This Course
  • Lectures 15
  • Length 1.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2013 English

Course Description

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.

What are the requirements?

  • 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).

What am I going to get from this course?

  • 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.

What is the target audience?

  • Anyone with basic knowledge of PHP, database experience not required but is helpful, as this is demonstrated.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
05:21

Download the course files here.

Section 2: Getting Started with MySQLi
07:55

How to connect to a database using database software.

09:42

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

03:38

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

Section 3: Fetching Results
04:43

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

09:11

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

05:26

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

Section 4: Getting Results
09:25

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

04:46

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

Section 5: Security
12:33

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

08:14

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

05:42

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

Section 6: Finishing Up
02:48

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

02:14

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

Request a Course
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Stone River eLearning, 200,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.

Ready to start learning?
Take This Course