MySQLi For Beginners
4.1 (21 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,580 students enrolled
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 (21 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,580 students enrolled
Last updated 2/2017
English
Current price: $10 Original price: $60 Discount: 83% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 3 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
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).
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.

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 17 Lectures Collapse All 17 Lectures 01:33:10
+
Introduction
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
09:42

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

Creating a Database Table
03:38
+
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
04:43

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

Pulling Multiple Records
09:11

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

Different Result Types
05:26
+
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
09:25

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

Updating and Seeing Affected Rows
04:46
+
Security
3 Lectures 26:29

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

Escaping
12:33

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

Prepared Statements for Inserting
08:14

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
05:42
+
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
02:48

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
02:14

Request a Course
00:22
+
Bonus Material
2 Lectures 01:17
Bonus Lecture: Certificate of Completion
01:03

Bonus Lecture: Course Discounts
00:14
About the Instructor
Stone River eLearning
4.3 Average rating
12,752 Reviews
239,374 Students
187 Courses
230,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.