Name: MySQL - PHP による HTML フォームの検証 (filter_var) (MySQL - HTML Form Validation with PHP (filter_var))
Uploaded: 2021-01-14T10:12:52.000Z
Duration: 23 min 23 s
Description: VoiceTubeの動画で発音を聞きながら英語表現を覚えよう！学べる英語：

creating these classes requires equipment and service.

If you appreciate this education, please think about going to Eli the computer guy dot com and offering a one time or monthly recurring donation.

As you know, I am the line a computer guy in In today's class, we're going to be doing a form validation with PHP.

So basically, we're going to create an HTML form, and that form is going to submit about variable values to a p, a P script.

That PHP script is then going to verify its going to validate that those variables are the types of variables that they are supposed to be.

If they're the types of variables that they're supposed to be, it will then insert those variables into a my sequel table.

And if not, it will simply print down to the screen and basically say, bad email or bad age, eh?

So when we're talking about form validation, this is an important thing.

When you're thinking about dealing with databases is what we're trying to do here is make sure that we don't get bad data into a database.

Now, A lot of times people are worried about bad data going into a database.

They're thinking about things such as hackers again, things like such a sequel.

How do I keep a hacker from trying to do something with the database?

The problem is, the problem is, is most of the time when you start having issues with your database, and when you start having issues with your data, it's not actually hackers and nefarious actors and Chinese folks and all that kind of stuff.

In reality, it's normally stupid users, right users, just fat fingers something when they're plugging something into a field in HTML form.

And then, if you don't have any kind of validation to tell the user that there's a problem when they get submit, that will get dumped into your table.

And then you know you get enough people doing that and you will run into a lot of problems because the data in your database I will not be good quality data.

And then, if that's the case, your database isn't really that valuable anymore.

So it is important to understand that what we're going to be doing today is we're simply going to be validating variables so I did a class before talking about sanitizing variable.

So that was where Let's say you want to strings.

You want a name or you one email address something like that.

Sanitizing a variable is where you use the filter underscore of our function in order to go through and clean out anything that is not a normal string.

It cleans out any of those types of things.

So if somebody is trying to submit a hyperlink using the name field using filter underscore bar, any sanitizing variable will clean out all of those tax.

That's what we're going to be doing today.

We're simply going to be validating that the variables coming in look like what those types of variables we're supposed to be so in.

The example we're gonna be doing is we're going to be validated.

An email address on email address should be, you know, the front name it should be.

An at sign should be the back of a name dot com biz info.

So if somebody submit something that looks like that that will be then be able to be inserted into the database if they insert something without the dot com orb is whatever else it will fail out of.

Submit something Well, that without the act, it will fail out.

So basically all we're doing is we're validating that the variables that the PHP script is dealing with more or less look like they're supposed to look.

The cool part with validation is again you can validate first off of ends.

For the age you can validate off of domain names you can validate off of email addresses you validate off of I p addresses you convey.

Validate a lot of different types of variables again.

So if you're gonna be pumping this into a database, you can make sure at least at least the variables.

Look what they're supposed to look again as an important thing to understand, with security and dealing with your database is you have to have mall to pull levels of security in your infrastructure to make sure that the dad and everything goes in is how it's supposed to be.

So the validation is one way to do that so you can sanitize variables.

You can do multiple steps to make sure that at the end of the day, the data going into your database this is good data as you're going to get.

So with that, let's go over the computer and I can show you how this works.

So here we are, back at my lab environment again.

I'm running a bunch of desktop 18.4 Lt s N e u bahn to desktop that you're running should should work for this particular project that we're doing I am running this within a virtual machine and virtual box.

I have this running on my Mac book pro in order to get the full A lamp stack on this you want to desktop?

With that, I was able to install a packet, my sequel and PHP there.

I have not modifying any of the default configurations.

PHP not I and Ivy hosts anything like that literally.

The only thing that I have done other than the default configuration to simply dumped in a p A P folder within the Apache root directory guest.

So I have some place to dump all the scripts, Eh?

So the first thing that we're gonna do is we're gonna go.

We're gonna take a look at our my sequel database.

So you go down to show applications, you go up to search do terminal, then you bring up your command prop from here again.

You User name is Bob Space Life MP To ask for the password and enter password A super secret.

123456 And now, when are my sequel database server from here?

We have a number of databases here again.

The database that we're gonna be dealing with today is the class d Be very important that you know what database and what tables you're interacting with eso.

Since we know that we're going to do use class D B to drop into the class database from their new show tables to see what tables that we're dealing with.

And the table that we're going to be dealing with today is I have created this table called E Mail.

So basically, this is a very simple form.

It's going ask her name, it's going to ask for an egg and it's going to ask for an email address.

And then it was going to dump into this my sequel database.

So describe email sign up so we just know what this table looks like.

It inner and so we can see is we have an I D.

This is just a primary key is an auto increment, Justin just a unique i d for for the for the table.

Then we have a day that is an editor and then we have email that is also text So very simple.

Four fields, one auto increment, one age to text from that.

If we just wanted to go take a look and see what records already in here.

Go Hey, if you actually do the sequel statement, right, it works.

Number one, a name of Bob and 80 of 12 and email address of Bob at bob dot com Again to remember with this form validation.

When we're doing the email validation today, this is not verifying again.

You have to think about that like this isn't verifying that the email address is correct.

It's simply a validating that it looks like an email address right front, part at back part dot something.