3. MySQL Database Tables Creation PHP Script Logic Tutorial

Learn to script table creation into your MySQL database to establish all of the software system's tables using PHP and SQL syntax. We are establishing all of the data storage tables that will be required for specific applications on the social networking website.

[MrEighteens]

dude, your god's gift to webdevelopers... --i love your humor during the video

[jerdes]

If you guys are using Xampp by example and want to use root as username without using a password. You need to put null value to the third argument in order to be able to pass the db name as fourth argument. The syntax of mysqli_connect will be: $db_conx = mysqli_connect("localhost", "root", null, "social");

Hey Adam, thanks a lot for theses tutorials, even if english isn't my first language, you speak very clearly and make this easily understanable for foreign language speaker and newb like me.

Comment created OK :)

[johnfit]

You the Man Adam ! .. Learned so much just by following you step by step.. Each day I'm learning how code works.. 

[FnooneXnoname]

Adam i have  tell you that you help me very much in my programming carrier. Thanks bro 

very good video also that question / answer is good for reseting forgot passwords

[robeire]

Fantastic tutorial, many thanks from Ireland. Wish I found your channel sooner. I'll buy you a few beers!

[PawanMall]

Amazing work Adam, I'm very excited about what you're doing.

[alexanderarman]

Hello Adam,

I could not get the codes to work but the old one I had copied from your site back in January "Developphp" worked like a charm. I really can't tell the difference between the 2 but I would love to know.

Thanks for all your help and effort!
You are Great!

[kadiahzaman]

WOW i did it right i thought i wouldnt be able to but i won, thanx buddy ur so awesome.
I use WAMP and working on it cause my host server isn't functioning well with me.
And fox watch out one little comma mistake can mess up ur work. 

[HoesFOSHOdotcom]

YES!!! So stoked for this! I've been waiting for months!

[felipedacruz]

Another great aproach to create your own queries is to download "MySQL Workbench" (for free), diagram everything VISUALLY, export the script and run it with phpmyadmin! :D

[carstenschulze]

fantastic tutorial greetings from germany !!

[fellifel]

Creates other tables but fails to create the "users tables", not sure why .Still troubleshooting though, share ur thoughts . !

[BarathKamalanathan]

i sean another good lesson frm you, brother

[NataliePureSunshine]

THANK YOU THANK YOU THANK YOU! This is so helpful and well constructed <3

[MrTeferiZ]

Dear Adam
before I go directly to my question, I would like to thank you for your usual support and programming practice. .?
I want your advice on how to build my own sports betting website. ..what is the suitable and/or preferable DATABASE, Best Web tool etc
Thank you in advance

[mostafaghotby]

"Absolutely Fantastic! It is a course I would recommend to anyone.

[kevininalu]

why are you writing UNIQUE KEY username (username, email)?
shouldnt it be: UNIQUE KEY(username, email)??

[adeptux]

question: why does the last line have username twice? and why is it once in the paranthesis and once outside the paranthesis?

[reidoo]

Hey Adam, LOVE your videos. Thanks so much for putting them together, they're great to follow along. Question for you though. In my db_conx file to connect to the database, I am getting a success. Then, when i FTP'd my filed to create all the different tables in the database, I am not getting ANY to work. Any reason for this?