MySQLi Essentials

Learn the most important MySQL database operations using MySQLi
4.4 (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.
2,381 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 17
  • 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 10/2015 English

Course Description

About a year ago, MySQLi is optional for PHP programmers. You can choose not to learn it. But now, MySQLi is necessary for you. Because the traditional method of using a few PHP built-in functions to operate MySQL database is gradually being abandoned.

For PHP programmers, this basically means you only have two options left when it comes to operating database. You can either choose MySQLi or PDO.

PDO is a lot more powerful than MySQLi. But by comparison, MySQLi is really simple to use and most importantly, much easier to learn, especially for new learners.

This course also contains all the basic MySQL database knowledge you need to learn before you can operate it.

You will learn the structure of a database and data type used by it. Then you will learn how to design a database.

After you have successfully created your very first database, next we will learn how to operate the database.

MySQLi class is a PHP tool that can help us operate database, but it would not be the first tool we learn. We will learn how to use PHPMyAdmin first.

We will learn how to manage database using PHPMyAdmin:

  • how to create and delete tables;
  • how to put new data into table;
  • how to update and delete data stored in table;

After you can proficiently use PHPMyAdmin, we will start to learn MySQLi.

First, we will learn how to get connected to database using the two options provided by MySQLi class.

I want the skills you learn from this course to be as complete as possible, therefore, we will also learn how to prepare for accidents, meaning what kind of pre-cautions we should take in case we cannot get connected to database.

After we can connect to database properly, we will learn the four main database operations using MySQLi class.

We will start with the most complicated operation: retrieving data from database.

Because I just came from the beginner stage one year ago, I still remember which parts are more likely to be confusing or tricky for new learners. Therefore, you will find we have lots of reviews during our study.

After you can retrieve data from database, we will learn how to select data you want and how to organize all the retrieved data.

Next, we will learn how to update and delete data already stored in the database. These two operations are easier and simpler by comparison.

In the end, we will learn how to put data into the database. You will need a few HTML techniques here. If you do not have any knowledge in HTML, don't worry, there is an HTML cram course for you.

In addition, we will also learn how to protect your database and make it as safe as possible, including how to deal with problems caused by special characters.

In the end, we will have a comprehensive review to make sure you have got everything.

What are the requirements?

  • Know how to instantiate a class and use class methods.
  • Know how to assign value to class property

What am I going to get from this course?

  • Manage database and table contents using PHPMyAdmin.
  • Use MySQLi class to operate MySQL database.
  • Create new database and table using PHPMyAdmin.
  • Retrieve data from database.
  • Organize data retrieved from database.
  • Update data stored in database.
  • Delete data from database.
  • Put new data into database.
  • Protect your database from problems caused by special characters.

What is the target audience?

  • anybody who wants to learn how to operate MySQL database

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: Things you should know about MySQL database before you can operate it.
what is MySQLi and what is MySQL database?
Preview
03:05
operating MySQL database using PHPMyAdmin
Preview
05:12
design your MySQL table
Preview
05:05
PHPMyAdmin demonstration: create your first database and table
04:16
Section 2: how to use MySQLi
get connected to database using MySQLi
06:14
demonstration of database connection
04:29
retrieving data: SELECT
06:34
demonstration of retrieving data
09:11
better organization of the retrieved data-- Part 1
04:22
better organization of the retrieved data-- Part 2
05:35
mid-term summary
01:49
UPDATE and DELETE
05:45
store new data: INSERT
03:17
HTML techniques you need to know
14:52
make a submit form
08:24
problems caused by special characters
04:01
final review
05:21

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

OnlyKiosk Tech, Making Your Efforts More Effective

No matter where and whom you take your lessons from, you will always have to do all the hard work yourself.

You have to spend time and efforts learning, understanding, memorizing and practicing new knowledge. This is NO short-cut here.

But a good course can show the best route and help you avoid traps and detours. You can achieve maximum productivity from your time and efforts.

Based on user feedback, tech development, and our new thoughts and inspirations, we will keep adding new contents and improving existing ones.

We will cover basics as well as advanced applications. You will learn smart and creative tech combinations as well.

Web development has been a popular area for years. The internet has accumulated tons of free tutoring videos and materials.

Even if you are stuck with questions you cannot solve, just post them on stackoverflow, you will have your answers within a few minutes.

With all the free tutoring materials and teachers, what is the point of creating this paid online course?

It depends on what you really want.

If you just want to have a rough idea of how web apps work and create some basic programs, then there is really no need for you to pay for any courses. Free internet information is more than enough to meet your demands.

If you want to be able to turn your design and idea into programs that are safe and efficient enough to be applied in real life and solve all kinds of challenge, then this course is perfect for you.  

We believe a good online course should also be a navigator, not just explaining coding concepts.

It should show you where the real destination is and most importantly, take you there in the most efficient way.  

Why we emphasize real destination?

First of all, you should know a program that can work is very different from a program that can survive in real life.

This is like playing a racing game on your phone is definitely not the same as driving a real car on a real track.

For example, in our PHP lesson, we will teach you how to create an upload program.

We have seen books and courses that only teach how to upload files.

If you run that program in real life, it will not last a day. It will do more damage than good.

For an upload program to work in real life, you need to check file type and size before letting any file being uploaded.

You also need to protect your program from uploading the same file repeatedly by keeping refreshing the uploading page.  

Uploaded files should be properly renamed and stored. Most importantly, this process must be automatic.

Uploaded files must also be retrievable, therefore information about uploaded files should also be automatically recorded into database.

If one step is missing, your upload program will not survive the real life environment.

This is why we emphasize real destination. We want to show you the whole picture, rather than just a segment of it.

Knowing the whole picture is what separates a trustworthy professional programmer from a coding amateur.

Apparently the road to the real destination is quite long.

This is why a good course should be a navigator. It should show students the best route.

When designing our course contents, we acknowledge and most importantly, take in consideration two very important facts:

Everybody forgets and you have other things going on in your life and can only partly devote to your study.

This means your study will be constantly interrupted and when you resume your study, you might find what you have learnt has become rusty.

As a result, all your new knowledge are built on a collapsing foundation. At the end of your study, you will find that despite you have spent time and money, but you just cannot make satisfactory progress. You thought you have learnt everything but just cannot put them together can create a functional program.

So how do we solve this problem?

We divide our whole course content into small segments. At the end of each segment, there will be a review session summarizing everything you have learnt from that session.

When you are creating APPs, we will give a review session on key knowledge as well.

Apart from review sessions, we will also help you control your study pace. You will often hear we tell you that if you cannot answer this quiz, do not proceed and review previous lessons.

The biggest card up our sleeve is our content table.

You might think our upload program lesson starts here. But actually our upload lesson has started long before that. We have started to lay foundations for you since we teach you how to create a file type detector.

We divide a complicated program into components and will only add one component at a time. Most importantly, every time we add a new component, we will review the previous components again.

In the very end, despite the program we are creating is long and complicated, you will be able to master everything. 

Ready to start learning?
Take This Course