MySQL Creating A Table Video Lecture | PHP for beginners - Software Development

hello guys and welcome to the 27th
tutorial I believe in the PHP
programming tutorial series now I
apologize for this short break I think
it's been about week or two since about
the video both I've been experiencing
some severe internet problems lately um
I'm in the process of having them fixed
so I should be back properly
in no time both before I start this
tutorial I wanted to just say that two
days ago on Halloween was the two year
anniversary of my channel so two years
since I've edited this accounts it's
been quite you know quite an exciting
experience to go up to so many
subscribers so I'd like to thank
everyone for that but let's enough of
that in enough of the random talk like
to go into the tutorial now in the
previous tutorial we learned about my
sequel I mean we learned how to
basically use PHP myadmin
on the browser to add a table to add
entries into that table born this
tutorial we're going to learn the first
step which is adding a table through
MySQL query I'm going to do that through
PHP so what you need to do is make sure
that your xampp is running and open up
phpMyAdmin and log in and in the
previous tutorial we created this users
table and basically what we're going to
do in this tutorial is we're going to
create this user's table what we're
going to do it just through PHP code so
we're going to create a called users -
okay so let's start off open up notepad
plus plus and just create your file call
this over a table dot PHP and what we
want to do is if you remember the final
part of the previous tutorial we learned
how to connect to my sequel database and
we're going to do that in this tutorial
but we will store that in a variable so
we'll create a variable called accounts
just do that and then just type give it
the value of my C whole underscore
connect and if you remember the three
parameters we need are first of all a
host which is localhost
the username which in my case is roots
in your case is whatever you set the
username to and the third parameter is
the password which is just password for
my test server right now and after that
we can type or Die and in question mark
my sequel on the score oops on the score
error and that will just show the my
sequel error if there's in if any of
these are wrong ok so now that we've
just gone back over the code that we
went through in the previous tutorial
let's just save this and we will go to
call it table PHP I'll see there's no
errors and that means all good to go it
connected so um the next thing we need
to do is select the table now if you go
back over here if you remember we
created let's go back to the root of the
PHP Melbourne we created a database
called accounts which is right here so
we click on that and our tables in here
so the next thing we need to do is
select the database and we can use this
so we can do this using the my sequel
underscore select on the scroll DB and
then all we need to do in brackets is
select the first parameter which is the
actual name of the database in our case
it is accounts you might have named your
something different and then put a comma
and the second parameter is going to be
our connection which you've got up here
as the variable account so put dollar
sign I can't forget my dollar signs
there okay so we have a semicolon there
and now on to the part where we do all
my sequel query so down here I'm first
of all going to create a variable here
called SQL and this is going to hold the
actual query that we're going to put
into the M into phpMyAdmin and down here
we're going to write our code my sequel
on the score query and in here in my
sequel query we need two parameters the
first parameter is the actual query that
we're going to run on the server so the
first parameter here it could be in
plain text but in our case is going to
be a variable this first parameter tells
the it tells
my sequel what to do and then the second
parameter is our connection which is
accounts
okay so right now this doesn't do
anything because this query SQL is blank
we haven't specified any any sort of
query inside here and the Creator we're
going to create today is going to be to
create a table so we can do that by
simply using the keyword create so
inside the - and quotation marks type
create and then just have a space and
then we need to type table because we go
be creating the database but in this
case we're creating a table so type
create table and after that we need to
give the table a name and what was it
called users okay so we're going to
create this as users - so so far we're
telling my sequel or saying create a
table and call it uses - so what we need
to do next in brackets
lastly we'll put this on two different
lines as I said you know it's red
statement by statement line by line so
lines don't mean anything
we're going to create two brackets
because our the information about this
table is held inside of brackets and
what we can do now is specify different
part of the table and separate them with
a comma so the way we can declare a
field in this table is simply by first
typing the name of that field and if we
go back to here let's click on structure
we can see we have all the information
about the different fields in this table
so we open notepad plus plus the first
form is ID so we'll just type ID and
then you put space and then you need to
specify the data type and as ideas a
number you type int which stands for
integer and the next thing we need to do
we need to specify this to be not no
because if this is no then it will just
be no the whole time but because once
it's auto increment we need every one of
the IDS to have and its own little
number you'll need to type not space
Nolen capsules and my sequel will
recognize this as saying that we don't
want it to be null and then the final
thing we need to specify for this is the
auto increment so we just type auto on
the scroll
increment and then that's what this line
here does is this create a table called
ID it says that the data type is integer
we want it to be not null and we also
want to auto increment this every time
and then what we do is add a comma now
you can go into the next line and the
next bit is you know fairly simple we're
going to specify the primary key for the
table so all you need to do is type
primary space key and in bracket you
want to specify the table sorry the
field though wants as a primary key and
in this case it's ID as we've typed out
here then put a comma and then the next
parameter we're going to create some
we're going to create our other tables
sorry all other fields so this one was
pretty difficult to create because we
wanted it to be not know and we wanted
to auto increment it but the next few
ones are going to be pretty simple
because all we want to do is just create
a simple field as a virtuoso if you go
here we have user name password first
last and about so all we need to do is
go into notepad plus plus and the first
thing we're gonna create is a is a
username I believe it was yeah that's
chips check it username so what we need
to do as we did with the ID wanna type
username and this just tells that we
want the field name to be username and
then only to do is type varchar and 20
in brackets and that is just saying the
data type is varchar' just like we
specify the integer up here and since we
don't need any of these it doesn't need
to be not null unless you want to
specify it as not null and it doesn't
need to occur in increments so now we
can just put a comment and go to the
next item and this should be password
I'm guessing is the same thing password
varchar 20 and then a comment then first
what was it if first as a varchar
20 comment and then last varchar' 20 I
don't need a comment for our last entry
so um I've just pretty much run through
all that without explaining much but now
because it was quite a chunky bit a bit
of code I wanted to just type it all out
you know as you're psyching out and now
you can go through it so if you go to
the face line what we typed this is
simply storing the my serial connection
with local hosted roots and password in
the variable accounts and the next line
that we've typed is my sequel select DB
and in brackets we have accounts and the
variable accounts and all this line does
is select the database name the counts
from the connection of accounts which is
this what we've connected here and this
isn't actually a my sequel query this is
just a normal string variable and all
we're doing in here is typing out our
query that we want to perform and
actually missed out they a semicolon
there my mistake and all this does is
holds the information what we want to
put into here so let's just go over it
quickly the first thing we do is take
the keyword create and table so we're
telling one to create a table and we
give it a name users two and then in
brackets and separated by commas we
specify each field of that table and we
can the first thing we type is the name
of their field and then the data type
and we've done that just name and
datatype sorry name the exciting name
datatype for most of these but because
we needed to specify some special rules
for the ID like not null and auto
increment we just type them out right
after it there so the final line
actually runs the my sequel query which
is my sequel underscore query and in
brackets it has the actual query as the
first parameter which is held in this
SQL variable and then the name of the
connection which is account in the
second parameter and I'll put my
semicolon there and that should now work
for us it should now create the table
hit save and go to table but PHP
and if we go over back to the accounts
database we now have uses to write here
so we can just look out the structure
and we have all of these here and all of
the things we created that's should be
identical I think and we can just easily
M where is it we can just enter put
entries in this database I'm not
familiar with this version of PHP
myadmin so I think it's import or no
it's not it's insert actually sorry we
can just insert values into the database
so you know ID is blank as with the
other ones username Bob password
password one two three again first name
Bob um last name I don't know Johnson
hit go and they've all inserted
correctly so we go back here see what
counts and users - we now have the entry
right here so that was the second my
sequel tutorial on how to create a table
using my sequel query in PHP in the next
tutorial we're going to look at how to
insert values into a table through PHP
which is probably what you've all been
waiting for it's probably the most
useful part of PHP in my sequel so
thanks for watching this video if you
have any questions don't hesitate to
leave a comment I will answer all your
questions click like on the video and
other favorites and also don't forget to
click that subscribe button to have
instant updates on every single video