Cazpa.com PHP Developer & Website Designer

26Jan/1025

PHP Tutorial – 23 – Adding Tables to MySQL Database

www.youtube.com click that link if u wanna watch this video in high def! subscribe to my channel!

No related posts.

About Daniel Smith

I am the boss around here, if you need anything then send me a message :))

Popular Content & Keywords

add update delete in php,depositfiles hack,warning: mail() [function mail]: smtp server response: 554 the message was rejected because it contains prohibited virus or spam content in,rails vs php performance,add update delete records from sql server using php,php define variable,php add update delete,php tutorial deutsch,warning: mail() [function mail]: smtp server response: 554 the message was rejected because it contains prohibited virus or spam content,tutorial create contact form in dreamweaver php,ruby on rails vs php 2010,php tutorial // user registration w/ sql,,send emails with a web form: php scripting,php tutorial - register form insert into database
Comments (25) Trackbacks (0)
  1. Already solved it.

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

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

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

  5. 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.

  6. 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.

  7. 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.

  8. Sorry, 100.

  9. 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 !

  10. 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…..

  11. The New Boston- you rock!

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

  12. 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.

  13. I was pointing out that the value was redundant.

  14. 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.

  15. 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.

  16. 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.

  17. 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.

  18. get ulmb so much better

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

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

  21. 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

  22. 1 to 23… hmmm………
    so far…
    the best php tutorial on youtube
    only my opinion
    Much oblidge.

  23. 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

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

  25. xampp also has phpmyadmin


Leave a comment

You must be logged in to post a comment.

No trackbacks yet.

Powered by WordPress Lab