Name: MySQL - HTML ハイパーリンクと PHP($_GET) を使用したレコードの INSERT (MySQL - INSERT Records with HTML Hyperlinks and PHP($_GET))
Uploaded: 2021-01-14T10:10:43.000Z
Duration: 25 min
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.

And in today's class, I'm going to show you how to insert records into your my sequel database tables using simple hyperlinks.

So, up until this point, we have been using HTML forms, and we've been using a method called Post to be able to give the variable of values from the HTML forms to your pH.

Be script parses the data and is able to insert it into your my sequel database tables.

Well, today we're going to using a method called Get So the method, called Get actually passes a full U R L to your PHP script.

And within that Earl are the variable names and the values for the variable names.

So before were where we were using a dollar sign underscore post In order to recover the value of variables.

Now we will use dollar sign, underscore, get to recover those values.

We will then turn of those values into PHP.

Variables wants their PHP variables Will didn't just simply plug it into an insert sequel statement within our PHP script, and then that will get imported into our my sequel database tables.

So it is important to understand, whenever you're dealing with it again, things like my sequel in PHP and all that type of thing that there are multiple different ways to be able to present data to your script so that your scripts are able to parse them.

And so using hyperlinks happens to be one of those ways.

So the warning warning for the day is simply that you have to look at the situation where you are going to be using the get method to determine if it is appropriate for what you are trying to.

So the nice thing about a get method versus a post method is, since you're passing of the variables and the values that sit through an actual U R L string, you can in fact bookmark that you are l string right?

So if you're gonna be interacting within my sequel database, let's say to get reports right, so Let's say you want to pull a report.

You wanna pull the report based off of certain criteria where something is blah, blah, blah, right?

Well, if you use a get method in order to pull the report when the nice parts is is you can actually just copy that fool, you are l You can book market, And then whenever you want that specific report, instead of having to go through a form or something else, you can simply click on the earl.

Whoa, it is there it is right in front of you.

On the other hand, if you're going to be doing something like inserting data updating data within your my secret database tables and you're you something something like get get method that could be just an absolutely, utterly ridiculous security Cool, because again, basically sense.

You're passing variables and values simply through a you, Earl, you know, that's that's really easy to dork with like like there's bad security.

And then there is passing inserts through.

On the other hand, though, On the other hand again, a lot of people get really hypercritical.

I would never do that, but something to think about again.

The demonstration I'm going to show you today is a simple little voting app.

Basically, you can vote Yes, you can vote no where you can vote.

Both write something to think about is you may not want to put this kind of voting app into a production environment, right?

You don't want tens of thousands of users to be hammering a little voter app like I'm showing you today passing inserts using a hyperlink.

But on the other hand, to be thinking about is, you know, if you have a small group, let's say you have a little office group of like 20 people and you're trying to determine, you know, do you want to order sushi today?

Do you want to order pizza today, or does the person not care whether you order both?

You know this is the type of thing we're literally you can create three hyperlinks.

You can email this basically to everybody in your group and everybody.

You just go click, click, click click, click, click, click, click, click, click, and then you sent there any tally it up.

So I do really want to reinforce this idea that when you think about security, right, security, to be clear is very important.

But you have to think about the situation right?

The security than is required when you're going to be putting something, you know, Internet facing for your customers, for your clients, for your users.

The security that's required there is entirely different than the security required.

If you're just trying to figure out again whether or not you're gonna be ordering sushi or pizza, and this is the type of like a little app literally.

I think I wrote this thing in like, four minutes, and that was with me, like coming up with the idea.

I came up with the idea I wrote the HTML code around PHP code.

I created the database table in four minutes, and that's with me having to pull this out of my butt.

So just imagine again, if you're used to doing this type of thing again, using something like these hyperlinks can just be a very easy way to be a insert values into a table.

And then again, you just do a little tally script, you know, figure out you know, which is more sushi, pizza or both, and go from there.

So that is that is the warning for today.

Think about the situation where you're going to be using to get method to get method is really nice.

Easy, fast, insecure Ximena again, depending on what you're doing can be utterly insecure as hell.

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

I'm using a bunch of desktop 18.4 Lt s But again, anyone to desktop should be fine for you.

I'm running with this within a virtual machine within virtual box, and I happen to be using a Mac book pro in order to get the full lamp stack.

Lennox unpacking my sequel in PHP, I used a tool called Task Settle Ta s k s E l.

That allows you to very easily install the lamp stack.

I have not modified any of the default configurations.

I have not modified pH Pete and I and II or the V host nor anything else.

The only thing that I have done is I have created a PHP folder within the Apache Root Directory.

Just give me some place to dump all of my PHP scripts in one place, too, to keep it organized.

In order to create the scripts, I am using the simple G edit text editor that comes with a bun to desktop again.

This is similar to know pad and Windows or text edit within the Mac OS Basically again when I'm doing very simple code.

I like using a simple text editor just to show you you don't not need a fancy I d.

Your script editor or anything like that in order to create these small scripts.

Go for the first thing that we're going to d'oh is we're going to go and we're going to take a look at our my secret database again because we always want to understand the environment that we're dealing it.

So you go down the left hand corner and clip show applications that you go up type of terminal.

You hit Enter and we get to the command problem from here.

And we under my sequel database From here, we'll do a show.

Make sure we know what databases are in this particular server on the database that we care about Is this class D B from here?

What we're gonna do is going to use class D d B if I spell it class D B.

So this will drop us into our class D V database from here.

We then do show tables to see what tables we're dealing with here again, remember, remember, computers do not guess what you mean.

You either put in there right syntax or it's wrong again, and little things like like for me, like So this is a table that will be dealing with today.