2. E – Commerce Website PHP Tutorial – MySQL Database and its Tables

www.developphp.com In this 2nd video we will create the MySQL database and its tables. We demonstrate a scripted method for database table creation in this example. The E – Commerce Web Site we will be assembling is one in which all of the inventory is in a MySQL database and we offer a custom PHP cart for a unique shopping experience. It is a site that handles sales, customers, and inventory.


  • Thanks for the great video! If you need help installing, configuring, or setting up zen cart, check out our channel for lots of Easy Help Zen Cart Tutorials:

  • I am running on:
    Mac os X 10.6.8
    Dreamweaver CS5
    go_daddy is hosting

    This is where I am getting confused….

    On part 2
    After I ftp:
    I click on Live View in Dreamweaver and I get the message of “CRITICAL ERROR…” but when I go to Manage viaphpMyAdmin the tables are there…I don’t get it. Thanks!!!!

  • I went to the effort of resetting my youtube password (i forgot it) and going through the whole shabang just to tell you that I love you and want to have 3 children with you. 2 girls and one boy. And we’ll have a red setter and a house with a white pickett fence.
    Thank you for these tutorials.

  • I have a plain text file, how do I make a mysql database out of this file. It is very large over 275,000 bits of data.

  • will you check this out. I did and their program really worked Its one platform like amazon where the prices are not hyper inflated and I don’t have to supply any products but still get 50% of the profit way cool I thought the site is stratusmallcom

  • thx alot m8, this is very helpfull, keep doing this, you make it so easy, and you make me understand it easy. :o) thx from Denmark

  • how do i fix this problem mate? i am having problem fixing it.

    #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘<?php
    // Connect to the file above here
    require "connect_to_mysql.php"' at line 1



  • Hey Adam, I have pasted your code into dreamweaver on those pages and i have setup a MySQL database as well…..i did the sql quick test page and it worked but when i created the tables, I got the critical error……what am i doing wrong

  • hi i have written the code for create the tabe, but when i test it all i get back is: Warning: mysql_query() [function.mysql-query]: Access denied for user ‘jeetkune’@’localhost’ (using password: NO) in /home/jeetkune/public_html/storescripts/create_admin_table.php on line 13

    Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/jeetkune/public_html/storescripts/create_admin_table.php on line 13
    CRITICAL ERROR admin table has not been created

  • I follow the instructions for creating an admin table exactly but still get an error message – I dont get it – the connecting is fine though – Can anyone assist please?

    I’m even using the code for the admin table from the downloaded source code…..

  • Adam if i want to put more than 1 picture to product? what script i use?
    please help me, i want to put 6 picture to 1 product. can you help me?

  • I am following this tutorial on WAMP and its has not given me any error so far regarding anything. Good luck for those cannot figure it out. You should really be checking your info in connect_to_mysql.php !!! Just in case.

Leave a Reply

Your email address will not be published. Required fields are marked *