PHP Tutorial - 23 - Adding Tables to MySQL Database

[russellsolid]

he likes the number 20

[repalmore]

Love your tutorials but I do know of a field can and should have null ability. One example is Address2 If you don't have an apartment number or suit, there is no need for that field to be populated. Another might be MiddleInit. Not every one has a middle name. The examples could go on quite detailed but it is a needed function. Keep up the good work.

[lalaliam]

is their not a more secure way than just 1 password to store data?

[djhchew]

yaaayyy... thanx alot.. i just created my first table..

[28306dc]

hard as hell!

[TheLegend1245]

Is it the same as creating a Mysql table and a PHP form to connect?

[stumblinbear]

"...And we'll, finally, be creating our frst computer game.. :P

...Well creating the registration form too it." :'(

[bilguitei]

i love you.u r saving my life dude.I like the way u talk as well.it's actually fun

[DJBerserk]

"...and we'll (finally) be creating our first computer game!"

mfw c':

[pupmommydad]

6:52 - "In the next tutorial, we're gonna be creating our first computer game."

Me: "WHAT?!?!"

6:57 - "... Or at least the registration form."

Me: "Awwww...."

[arvids817]

How to add auto_inceremnt field on phpmyadmin?

[stefbabydave]

I have learned. thanks but I admit I obtuse long I realize these things .. but I must learn it because part of my major. this my major subject...

[stefbabydave]

I have learned. thanks but I admit I obtuse long I realize these things .. but I must learn it because part of my major. this my major subject.

[jago125]

had to do this in mysql commandline oh the fun :P but had a template luckily :)

[th2]

great vid

[StevenCarline]

null filed means that they CAN be empty (they are null by default)

so when you creating some form in php with optional fields, values inputed by user can be empty and no error will apper when he press sumbit button because database does not require value in this field

[ethanownz]

You use the null field, if you want to let the user have an optional field such as telephone number or something that they might now want to enter.

[AISim]

You have taught me Python, JAVA and now this. Sir, I am in a great debit to you.

[Dragonblix]

I'm using the cPanel hosting service, which allows me to access and create MySQL Databases and tables, the only problem is that is that it continues to tell my that i cannot access because of an incorrect username or password, however, it never gives me the option of signing in. Can anyone remedy this problem?

[RebornAc3]

@Dragonblix The will provide you with username and password, if they don't email the administrators.

[Krivudalo]

I making blog site , and i wondering can i store my post (content of post, date of release...; by content i think images , videos , html coding ) , please help me , i stuck there !!???

[Krivudalo]

Can i put primary key for username , so each username will be different ???

will it be good idea

[Maniack017]

@Krivudalo

auto_increment is what makes it different(makes it go 1 up everytime).

Primary Key is there because id mainly organises the players.

[HawxTeamDelta]

your soon to be famous!!

[samiwistler]

PHP gurus

[Jajaja2011Jajaja]

For example, if you had a table of household's and a table of people in each household. The table of people would have a different person in each row, and also a foreign key column with an id that matches the primary key (id) of the household they are in:

[Jajaja2011Jajaja]

Primary keys are also needed when you have a row in a different table referencing a column in another table (when you have what is called a 1 to many relation between 2 tables is a good example of when you need that). In that case you have a Foreign Key column in the "many table" referencing the primary key in the "one table".

[Jajaja2011Jajaja]

id is what is called the "Primary Key". Each primary key is unique, so that when you want to select a specific row in the database, you can be assured that you will get the row you want (because there could be 2 or people with the name "Bob" for example, but each "Bob" would have a different Primary Key.

[FlyingBroMan]

I would pay for a DvD with these tutorials in it...just so you know... ;)

[autom4]

null is used for optional info... duhh :)

[gunner4192]

If i had money i would invest in you. :)

[alex007152]

same host here :D cheers for bluehost

[wittyadrian]

Great tutorial!

Last time I worked with this stuff was about 1-2 years ago, so this was perfect for refreshing my memory.

[xXLiverpoolFCXx]

i think..

...

.... you are the best :)

[999america]

excellent videos....

[Jugdesi]

Great work on explaining how to add and make database. What you should explain first are the requirements. If you were to build a website what will the requirement me. Get the point. Alway explain what your doing. Great work :)

[topvirus2k9]

i am using a different host but i cant get the auto number here is my host theepichost.info please help im stuck

[kwaizimodo]

in your vedio you asked "why anyone wont to add some NULL value to the database and if any one know you hope to tell you " may i tell you :

you need the Null value in case the recored which inclue these Nulls Will modify later specially when you talk about the historical data inserting

example

id | EmpID | Job ID | Date_Of_Join_Job | Date_Of_Leave_Job | This_Record_Is_Active | Record_Active_Date | Record_Deactive_date. Date_Of_Leave_Job  , Record_Deactive_date MUST Accept Null

[derekmcgoldrick]

I love this guy. I was nearly in tears trying to sort this out. 10/10

Great step by step, crystal clear instructions.

[VaticanIscariot]

so far its been quite useful

[xbugster]

mysql_query('CREATE TABLE `name` (id BIGINT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id))');

[iamawesometoo]

Hey, I actually do have something that uses null fields. I'm making a dictionary with conjugation and declension tables. Some words are defective, such as the word "can" which has no future tense, so all of its future tense fields will be null.

[mangoprojects]

Thank you, Bucky. - behind vfx

[demonicsaint666]

Wow you actually make sense compared to every other video I've watched. greatly appreciated.

[blahbaa86]

Really good tutorial. it was very helpful.

[saadlulu]

why would anyone make a null field, well the answer is simple bucky..

think of it this way, u have few employees and some of them will have null as a value for commission that means they will never get commission,while some others will have a value of 0, meaning that they will have commission sometime while they work, but not at the current time.

[ministooges]

Thank you. Great video.

[tuleo554]

PHP, Ajax and SQL made easy :)

tulesblog(dot)(com)/ajax-tutor­ial

[Techn0Junki3]

xampp also has phpmyadmin

[freid001]

thank you this is so use full thanks!!!!!

[afsoun3000]

How do you inset values for multiple rows in a table? This Tut. shows only 1 row of values..but when you have more what's the easiest and fastest way? thanks

[windowsexplore]

1 to 23... hmmm.........

so far...

the best php tutorial on youtube

only my opinion

Much oblidge.

[tavsprezidents]

@windowsexplore the same. I'be been searching for really good tutorials and skilful teachers to learn these all stuff. Explaining all stuff if 5/5 so far. :)

Thanks.

[jegsmeganu]

You've got the talent given by G-d for FREE so use it and share it for FREE.

Just like SCIENCE. SCIENCE is SHARING OF KNOWLEDGE

[honeykiss1]

thanks alot dude you are the best......this is the most helpful tutorial ever! especially for my school work! you rOcK!

[bladejsc1997]

I would null it for like, field questions on a test for employees.

[32penn]

get ulmb so much better

[SomaVIII]

The reason for NULL is so that that value doesn't have to be assigned at any given time so say in a social network if you used NOT NULL on comments or friends you would have to set it as soon as you make a user or something( the value could be empty/0 though ).  Allot of PHP developers don't know actual SQL just the essentials.

[jsmith19810808]

If any of you think thats complex you should try doing JOINS, if you wanted a user to sign up, putting their comments or whatever or posts in another table and making a foreign key from the user id to the post, links them in and allows for optimised querying. 1 - many relationship.

[ariaane]

The New Boston- you rock!

Thanks for the tutorial- it has proved to be very helpful

[GdiUplineTeam]

Hello! Very nice tutorials and I learn how to create a database and table. It's been 3 months that I'm looking tutorials like this very clear. Anyway, I still have a problem I want to make a website with multiple users and still confused how to create signin, sign up and profile.....Someody can help me? Hoping THENEWBOSTON will hear my prayer.....

[SomaVIII]

If you still interested in a while I'm going to start my Web Developers Tutorials which will be using PHP as the Scripting language and MySQL as the database. We will be creating a socialnetwork and other things like blogs photohost and probably a few more any idea on what you would like to see in the projects let me know.

[dtrance71157]

Your lessons are really helpful to newbies.There is a plenty of tutorials on creating databases,but they dont teach how to create MySQL Tables.You are a great teacher !

[cobby32]

Why did you set ID as a BIGINT but then put 1000 in the length/value column? BIGINT will never be more than 20 anyway.

[cobby32]

Sorry, 100.

[jsmith19810808]

It can be any but you have to take appreciation to memory size of your DB, if its not going to be that big but for productional purposes they can become huge so selecting an optimised datatypes crucial to database development.

I develop on databases as part of my day job, with PHP and Ajax.

[cobby32]

I was pointing out that the value was redundant.

[jsmith19810808]

I am sorry think I may have missed that but you dont even need to put mysql_error() in at all, thats an object of PHP if you like, its good though for debugging purposes.

If you go into the source code you can see all the functions like that for databases, how the default debugger works, I have a test machine for PHP, with xdebug on it (strictly not meant for productional servers), then I have a virtual machine on that server to run a production fully blown apache server, a VPS solution.

[gnomsin]

Best tutorials ever, that I've used anyway. Came across you looking for just some php information, and you basically answered enything I needed to knot. And.... I like you're style.

[voteforgod]

really good tutorials. what makes them so good is that youre moving really slowly, methodic and exactly forward. no steps are being skipped, which is more very common among most sites and tutorials.

thumbs up.

[alexjb4]

Thanks man your tutorials really helped! I finally have a working search engine!

[D34tho]

you will add a table and i will add 4 chairs haha

[lorentefoe]

Thank you so much... I have been looking all over the internet for this.

[appi3hein]

On my host I can't select 'Primary', what i have to do?

3:30

[appi3hein]

Already solved it.

[ddstar]

This guy obviously doesn't now anything about MySQL performance issues or how to properly store a password field.

[SriLankanAirlines]

i got it sir :D :D :D :D

[dreamstartmedia]

thanks for your tutorials thanks man oh

i have web templats that need a database

to run the templats need a username ...password.. you know

and i wanted to host my own database on my home server ,please tell me how and what i should do i will be more than happy to hear from you thanks again

[mectoonTube]

Awesome!

Its getting clearer and clearer by the second!

Thank you!

[alwayssmiling62]

Dude you are AWESOME! YOu helped sooooo much! Thanks!!!!

[lra7]

Great tutorials Thanks!!!!

[tipupuma]

Hi

I have making connation with Mysql data but i dont no how to make a table a mian like to make php login in dreamwaver i have conntacion but no record set i dont know to make that so pleas help

[Aleque]

thank alot!

[WolfenSystems]

A null field comes in handy if your table is picking up data that is not always used in each case. If you set it to not null and that field is not used in that instance, then the user will have to put in a bogus piece of information to be able to post the input. It is a very useful tool in some cases.

[beastlt12]

Very much appreciated! These tutorials are getting better and better

[omymonkey]

PHPmyAdmin is so sweet. When I first started learning databases and sql, I started with MySQL and learned the sql commands manually from command line. =D I kind of had something against using phpadmin, although i'd heard of it. I thought it might spoil me, and make me forget whats going on behind the scenes, but damn its so convenient. I think I'll start using it. Thx.

[Session01Hijack]

Not bad. It couldve been a little bit more informative. b.g. more detailed,

Btw.... key fields are characters/special properties that make data uniquely defined. Usually associated with a relational database.

Nice tutorial though... i'm sure that it would help newbies greatly.

[cheesylard]

you rock. it's a shame that not a lot of people know about your tutorials, though.

[thenewboston]

haha thanks. im just gonna keep putting out more and more tutorials and hopefully more people will find out about me soon!

[Niel8181]

@thenewboston I'm busy with a browser game - and website development project for the last 8 months,

and because you tutorials are so great i link everybody to your tutorials.

And i will keep doing that to anyone i meet ;)

Keep up the good work! You help people alot and i don't know how to thank you properly for that. Thank you.

[Alpeche21]

@cheesylard Lol, 2 years later he's famous!

[hexenlead]

great vid, real informative.

thanks