PHP Tutorial – 23 – Adding Tables to MySQL Database
June 12th, 2010 by CGI & PHP.com
www.youtube.com click that link if u wanna watch this video in high def! subscribe to my channel!
Popularity: 22% [?]
Flash PHP MySQL CMS – Content Management System Website Tutorial CS3 + CS4
MySQL Tutorial
PHP and MYSQL – Connecting to a Database and Adding Data
Sams Teach Yourself MySQL in 24 Hours
Pagination Tutorial for PHP MySQL Programmers – Web Intersect Paging Database Results
Installing WAMP and Creating a MySQL Database
June 12th, 2010 at 7:37 am
You can make a field Null if you have to fill something in which isn't needed, think of a phone number, or of the name of your cat's mom.
June 12th, 2010 at 8:19 am
Wow you actually make sense compared to every other video I've watched. greatly appreciated.
June 12th, 2010 at 8:53 am
Really good tutorial. it was very helpful.
June 12th, 2010 at 8:57 am
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.
June 12th, 2010 at 9:18 am
Thank you. Great video.
June 12th, 2010 at 9:45 am
PHP, Ajax and SQL made easy
tulesblog(dot)(com)/ajax-tutorial
June 12th, 2010 at 9:51 am
xampp also has phpmyadmin
June 12th, 2010 at 10:07 am
thank you this is so use full thanks!!!!!
June 12th, 2010 at 11:05 am
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
June 12th, 2010 at 12:02 pm
1 to 23… hmmm………
so far…
the best php tutorial on youtube
only my opinion
Much oblidge.
June 12th, 2010 at 12:35 pm
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
June 12th, 2010 at 1:29 pm
thanks alot dude you are the best……this is the most helpful tutorial ever! especially for my school work! you rOcK!
June 12th, 2010 at 2:14 pm
I would null it for like, field questions on a test for employees.
June 12th, 2010 at 2:31 pm
get ulmb so much better
June 12th, 2010 at 3:16 pm
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.
June 12th, 2010 at 3:30 pm
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.
June 12th, 2010 at 3:57 pm
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.
June 12th, 2010 at 4:08 pm
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.
June 12th, 2010 at 4:14 pm
I was pointing out that the value was redundant.
June 12th, 2010 at 4:23 pm
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.
June 12th, 2010 at 4:29 pm
The New Boston- you rock!
Thanks for the tutorial- it has proved to be very helpful
June 12th, 2010 at 4:36 pm
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…..
June 12th, 2010 at 5:23 pm
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 !
June 12th, 2010 at 6:10 pm
Sorry, 100.
June 12th, 2010 at 6:31 pm
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.