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

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

detail
{'title': '2. E - Commerce Website PHP Tutorial - MySQL Database and its Tables', 'heatmap': [{'end': 389.899, 'start': 354.02, 'weight': 0.988}], 'summary': 'Series covers the creation of a mysql database and tables for an e-commerce website, aiming to deliver six tutorials by christmas day and extend to cover an admin system for adding products. it discusses setting up a mysql database on a live server, creating tables using php scripts, and executing sql commands for admin tables and product transactions. the series also details the setup of an inventory table and paypal transactions, emphasizing the importance of the transactions table for tracking purchases and customer data.', 'chapters': [{'end': 116.531, 'segs': [{'end': 79.277, 'src': 'embed', 'start': 47.636, 'weight': 0, 'content': [{'end': 54.516, 'text': 'I was reading the comments and Matthiasv91 said will this tutorial include an admin system where we can add products?', 'start': 47.636, 'duration': 6.88}, {'end': 65.869, 'text': "and so i thought about it and i said you know that would be a handy thing to add to the system in case people wouldn't know how to make an admin panel for this sort of thing to where people who don't know html,", 'start': 55.563, 'duration': 10.306}, {'end': 69.531, 'text': 'css and php and all this crap can add inventory products.', 'start': 65.869, 'duration': 3.662}, {'end': 79.277, 'text': 'so say somebody in your office that works in the office that you want to give privileges to to get in there and add inventory and deal with the managing the store online.', 'start': 69.531, 'duration': 9.746}], 'summary': 'Matthiasv91 requested an admin system to add products. the system aims to help non-technical users manage online store inventory.', 'duration': 31.641, 'max_score': 47.636, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH047636.jpg'}, {'end': 120.454, 'src': 'embed', 'start': 94.788, 'weight': 2, 'content': [{'end': 99.37, 'text': "But I'm going to stick to my guns and make sure you guys have six tutorials for this series by Christmas Day.", 'start': 94.788, 'duration': 4.582}, {'end': 106.712, 'text': "I've decided to use AdamCorey.com as the place where all I have right now is this one page.", 'start': 100.15, 'duration': 6.562}, {'end': 108.433, 'text': "And there's really not much even on it.", 'start': 106.992, 'duration': 1.441}, {'end': 112.328, 'text': "So I'm just going to strip this page down and use this as my store example.", 'start': 108.905, 'duration': 3.423}, {'end': 116.531, 'text': 'So adamcorey.com is where you can see this progress live online.', 'start': 112.448, 'duration': 4.083}, {'end': 118.252, 'text': "And that's how I'm going to build.", 'start': 117.051, 'duration': 1.201}, {'end': 120.454, 'text': "Live online, that's how I'm even going to test.", 'start': 118.572, 'duration': 1.882}], 'summary': 'Commitment to deliver six tutorials by christmas on adamcorey.com for live online progress and testing.', 'duration': 25.666, 'max_score': 94.788, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH094788.jpg'}], 'start': 10.899, 'title': 'E-commerce website database creation', 'summary': 'Focuses on creating a mysql database and tables for an e-commerce website. it aims to deliver six tutorials by christmas day and extend to cover an admin system for adding products.', 'chapters': [{'end': 116.531, 'start': 10.899, 'title': 'E-commerce website database creation', 'summary': 'Focuses on creating a mysql database and tables for an e-commerce website, with a commitment to deliver six tutorials by christmas day and an extension to cover an admin system for adding products.', 'duration': 105.632, 'highlights': ['The commitment to provide six tutorials by Christmas Day and the extension to cover an admin system for adding products, as per feedback from Matthiasv91.', 'The plan to use AdamCorey.com as the live online example for the store.', 'The intention to create an admin panel for managing the store, allowing users without expertise in HTML, CSS, and PHP to add inventory products.']}], 'duration': 105.632, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH010899.jpg', 'highlights': ['The commitment to provide six tutorials by Christmas Day and the extension to cover an admin system for adding products, as per feedback from Matthiasv91.', 'The intention to create an admin panel for managing the store, allowing users without expertise in HTML, CSS, and PHP to add inventory products.', 'The plan to use AdamCorey.com as the live online example for the store.']}, {'end': 427.627, 'segs': [{'end': 219.677, 'src': 'embed', 'start': 140.377, 'weight': 0, 'content': [{'end': 143.34, 'text': "Now, maybe you're hosting with GoDaddy or something like that,", 'start': 140.377, 'duration': 2.963}, {'end': 150.486, 'text': "and GoDaddy uses a custom cPanel to where it's not the regular cPanel that you see on most hosting providers.", 'start': 143.34, 'duration': 7.146}, {'end': 156.571, 'text': 'So what you have to do is go into your GoDaddy cPanel and look for MySQL databases.', 'start': 151.547, 'duration': 5.024}, {'end': 159.893, 'text': "If you're in cPanel like I am, finding it is very easy.", 'start': 156.651, 'duration': 3.242}, {'end': 161.915, 'text': "It's right down here in the database section.", 'start': 159.933, 'duration': 1.982}, {'end': 164.277, 'text': 'You just click MySQL Databases.', 'start': 162.475, 'duration': 1.802}, {'end': 169.665, 'text': "and, like I said, if you're on something like GoDaddy,", 'start': 166.164, 'duration': 3.501}, {'end': 176.228, 'text': "you might want to ask for assistance from the people at GoDaddy if you're having any trouble finding any of these things to click on,", 'start': 169.665, 'duration': 6.563}, {'end': 187.832, 'text': 'or any of the connection information for your MySQL database once you create it so you get to the page for MySQL databases and just take the time to read all the information on this page.', 'start': 176.228, 'duration': 11.604}, {'end': 196.923, 'text': 'now, right here it says create new database and mine is going to have a prefix of Adam KHOU underscore.', 'start': 187.832, 'duration': 9.091}, {'end': 205.248, 'text': "so I'm gonna put my store all one word, all lowercase letters, and this will have a prefix.", 'start': 196.923, 'duration': 8.325}, {'end': 210.952, 'text': 'my store will have a prefix of Adam Kuhl underscore there.', 'start': 205.248, 'duration': 5.704}, {'end': 219.677, 'text': 'so on, some hosting providers in the MySQL creation, MySQL database creation section they might automatically add a prefix to yours.', 'start': 210.952, 'duration': 8.725}], 'summary': "In godaddy's custom cpanel, creating a mysql database involves finding the mysql databases section, asking for assistance if needed, and adding a prefix to the database name.", 'duration': 79.3, 'max_score': 140.377, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH0140377.jpg'}, {'end': 400.692, 'src': 'heatmap', 'start': 342.213, 'weight': 4, 'content': [{'end': 348.997, 'text': "You can create tables manually within phpMyAdmin, but what we're going to do is set up our tables through script.", 'start': 342.213, 'duration': 6.784}, {'end': 353.42, 'text': "Okay, now we're going to get the MySQL connection script going.", 'start': 350.298, 'duration': 3.122}, {'end': 357.943, 'text': 'Make sure we have the proper data inside of it so we can open our store files again in Dreamweaver.', 'start': 354.02, 'duration': 3.923}, {'end': 363.046, 'text': "I'm going to go to File, Open, Store Scripts, Connect to MySQL.", 'start': 357.963, 'duration': 5.083}, {'end': 370.551, 'text': "I'm going to go to developphp.com, the learn MySQL section, and here there's connecting to your database.", 'start': 364.189, 'duration': 6.362}, {'end': 376.174, 'text': "I'm going to grab this little scripty poo right there back at Dreamweaver.", 'start': 370.571, 'duration': 5.603}, {'end': 377.734, 'text': "make sure I'm in code view.", 'start': 376.174, 'duration': 1.56}, {'end': 381.876, 'text': 'get rid of all that and pop in the script I grabbed from developphp.', 'start': 377.734, 'duration': 4.142}, {'end': 389.899, 'text': "And for me, my database host I know is localhost, because that's the type of server I have.", 'start': 382.996, 'duration': 6.903}, {'end': 400.692, 'text': 'If you were on GoDaddy, you might have a host string that looks something like this, but most people using cPanel localhost.', 'start': 390.559, 'duration': 10.133}], 'summary': 'Setting up mysql connection script to access database via phpmyadmin and dreamweaver.', 'duration': 58.479, 'max_score': 342.213, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH0342213.jpg'}], 'start': 117.051, 'title': 'Setting up mysql database', 'summary': 'Discusses setting up a mysql database on a live server, emphasizing the process of accessing cpanel, locating mysql databases, and seeking assistance if necessary. it also outlines the process of creating a mysql database, adding a user, setting up tables through script, and configuring mysql connection script, emphasizing the importance of having the database, user, and password for the connection file.', 'chapters': [{'end': 187.832, 'start': 117.051, 'title': 'Setting up mysql database on live server', 'summary': 'Discusses setting up a mysql database on a live server, emphasizing the process of accessing cpanel, locating mysql databases, and seeking assistance if necessary for platforms like godaddy.', 'duration': 70.781, 'highlights': ['Accessing cPanel and locating MySQL databases is essential for setting up a MySQL database on a live server.', 'Seeking assistance from the hosting provider, especially for platforms like GoDaddy, can aid in finding connection information for the MySQL database.', 'Reading all the information on the MySQL databases page is crucial for a comprehensive understanding of the setup process.']}, {'end': 427.627, 'start': 187.832, 'title': 'Setting up mysql database and user', 'summary': 'Outlines the process of creating a mysql database, adding a user, setting up tables through script, and configuring mysql connection script, emphasizing the importance of having the database, user, and password for the connection file.', 'duration': 239.795, 'highlights': ["The chapter emphasizes the process of creating a MySQL database and adding a user with a specific prefix, such as 'Adam KHOU underscore', and highlights the importance of having the database and user set up for the MySQL connection file.", 'It explains the significance of having the proper data in the MySQL connection script, including the database host, username, and password for configuring the store files.', 'It mentions the option to manually create tables within phpMyAdmin, but focuses on setting up tables through script for the MySQL database, and emphasizes the readiness of the database for programming.']}], 'duration': 310.576, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH0117051.jpg', 'highlights': ['Accessing cPanel and locating MySQL databases is essential for setting up a MySQL database on a live server.', 'Seeking assistance from the hosting provider, especially for platforms like GoDaddy, can aid in finding connection information for the MySQL database.', 'Reading all the information on the MySQL databases page is crucial for a comprehensive understanding of the setup process.', "The chapter emphasizes the process of creating a MySQL database and adding a user with a specific prefix, such as 'Adam KHOU underscore', and highlights the importance of having the database and user set up for the MySQL connection file.", 'It explains the significance of having the proper data in the MySQL connection script, including the database host, username, and password for configuring the store files.', 'It mentions the option to manually create tables within phpMyAdmin, but focuses on setting up tables through script for the MySQL database, and emphasizes the readiness of the database for programming.']}, {'end': 854.045, 'segs': [{'end': 511.941, 'src': 'embed', 'start': 428.528, 'weight': 0, 'content': [{'end': 430.029, 'text': 'And you should have wrote all yours down, too.', 'start': 428.528, 'duration': 1.501}, {'end': 442.938, 'text': 'Yes So now once I put my password in here, this script will connect to my MySQL database.', 'start': 434.212, 'duration': 8.726}, {'end': 452.986, 'text': 'Okay, now that my MySQL file is all set up, the proper data inside of it needed to allow me to connect to my MySQL database online.', 'start': 445.52, 'duration': 7.466}, {'end': 456.227, 'text': "I'm going to have to test that real fast.", 'start': 453.905, 'duration': 2.322}, {'end': 465.754, 'text': "So under the example at DevelopPHP where it shows you how to connect, there's a test file so you can make sure that you're connected.", 'start': 456.267, 'duration': 9.487}, {'end': 480.325, 'text': "I'm going to grab the code press Control-C, go back to Dreamweaver, File New PHP, go into Code View, remove all of that and replace it with Control-V,", 'start': 466.434, 'duration': 13.891}, {'end': 482.286, 'text': 'with the code that you grabbed from the site.', 'start': 480.325, 'duration': 1.961}, {'end': 492.164, 'text': "So what this is going to do is require ConnectToMySQL.php, and if there's any problems, the script will not process past that point.", 'start': 483.598, 'duration': 8.566}, {'end': 497.627, 'text': "If it does, it's going to echo out to you, success in database connection, happy coding.", 'start': 493.184, 'duration': 4.443}, {'end': 501.17, 'text': 'So, once it brings in ConnectToMySQL,', 'start': 498.348, 'duration': 2.822}, {'end': 511.941, 'text': "this file is going to let you know if there's a connection error by the data because of the die functions within connect to mysql.php.", 'start': 501.17, 'duration': 10.771}], 'summary': 'Connecting to mysql database and testing connection using php script.', 'duration': 83.413, 'max_score': 428.528, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH0428528.jpg'}, {'end': 780.886, 'src': 'embed', 'start': 752.462, 'weight': 2, 'content': [{'end': 755.963, 'text': "So what we're doing is feeding it certain syntax to create table.", 'start': 752.462, 'duration': 3.501}, {'end': 758.004, 'text': 'Table name is admin.', 'start': 756.683, 'duration': 1.321}, {'end': 762.646, 'text': "And inside of that admin table, there's going to be certain columns or fields.", 'start': 758.864, 'duration': 3.782}, {'end': 764.446, 'text': 'First one is going to be ID.', 'start': 763.206, 'duration': 1.24}, {'end': 766.547, 'text': "It's an integer type field.", 'start': 764.746, 'duration': 1.801}, {'end': 773.444, 'text': 'The value of 11, not null, means it cannot ever be empty, and it auto increments.', 'start': 767.182, 'duration': 6.262}, {'end': 780.886, 'text': "That means each time one is added, it'll auto increment a unique ID for each admin.", 'start': 774.004, 'duration': 6.882}], 'summary': 'Creating a table named admin with an id column that auto-increments and cannot be empty.', 'duration': 28.424, 'max_score': 752.462, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH0752462.jpg'}], 'start': 428.528, 'title': 'Connecting and setting up mysql database', 'summary': 'Covers setting up and testing the mysql database connection for a website using code from developphp, as well as creating tables using php scripts. it includes details of setting up the connection, testing the connection, creating an admin table, and explaining the sql syntax for creating the table with specific field details and keys.', 'chapters': [{'end': 482.286, 'start': 428.528, 'title': 'Connecting to mysql database', 'summary': 'Discusses setting up and testing the mysql database connection for a website using code from developphp, ensuring successful connection and data transfer.', 'duration': 53.758, 'highlights': ['The script connects to my MySQL database, containing the necessary data for online connection.', 'The chapter demonstrates testing the connection using a test file from DevelopPHP to ensure successful connectivity.', 'The process involves obtaining code from DevelopPHP and replacing existing code in Dreamweaver to establish the connection and perform testing.']}, {'end': 854.045, 'start': 483.598, 'title': 'Setting up mysql connection and creating tables', 'summary': 'Explains setting up a mysql connection and creating tables using php scripts. it includes details of setting up the connection, testing the connection, creating an admin table, and explaining the sql syntax for creating the table with specific field details and keys.', 'duration': 370.447, 'highlights': ['Setting up MySQL connection and testing the connection Explains the process of requiring ConnectToMySQL.php, testing the connection, and ensuring successful database connection.', 'Creating admin table with specific field details Details the process of creating an admin table with specific field details such as ID, username, password, and last log date using SQL syntax.', 'Explaining the SQL syntax for creating the admin table Provides a detailed explanation of the SQL syntax for creating the admin table, including field types, not null constraints, auto-increment, primary key, and unique key.']}], 'duration': 425.517, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH0428528.jpg', 'highlights': ['The chapter demonstrates testing the connection using a test file from DevelopPHP to ensure successful connectivity.', 'The process involves obtaining code from DevelopPHP and replacing existing code in Dreamweaver to establish the connection and perform testing.', 'Explaining the SQL syntax for creating the admin table Provides a detailed explanation of the SQL syntax for creating the admin table, including field types, not null constraints, auto-increment, primary key, and unique key.', 'Creating admin table with specific field details Details the process of creating an admin table with specific field details such as ID, username, password, and last log date using SQL syntax.', 'Setting up MySQL connection and testing the connection Explains the process of requiring ConnectToMySQL.php, testing the connection, and ensuring successful database connection.', 'The script connects to my MySQL database, containing the necessary data for online connection.']}, {'end': 1140.992, 'segs': [{'end': 885.054, 'src': 'embed', 'start': 855.967, 'weight': 4, 'content': [{'end': 863.232, 'text': 'So after you set up your SQL command, you can set up an if and else condition statement that will actually execute the command for you.', 'start': 855.967, 'duration': 7.265}, {'end': 873.6, 'text': 'And inside of the if condition, you just write in the MySQL query function, and you feed it your MySQL command, or you feed it your SQL command.', 'start': 863.933, 'duration': 9.667}, {'end': 885.054, 'text': "So what'll happen is if it's successful in the SQL command and the query, it'll echo your admin table has been created successfully.", 'start': 875.629, 'duration': 9.425}], 'summary': 'Set up an if-else condition to execute sql command, echoing success if admin table is created.', 'duration': 29.087, 'max_score': 855.967, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH0855967.jpg'}, {'end': 992.288, 'src': 'embed', 'start': 966.192, 'weight': 5, 'content': [{'end': 973.795, 'text': 'So if you prefer working in PHP in my admin manually, I sometimes do, even though I know how to write scripts that interact with my database.', 'start': 966.192, 'duration': 7.603}, {'end': 976.356, 'text': 'I like to go in manually a lot and do things.', 'start': 973.936, 'duration': 2.42}, {'end': 977.117, 'text': "I don't know why.", 'start': 976.557, 'duration': 0.56}, {'end': 977.817, 'text': 'I just like to.', 'start': 977.217, 'duration': 0.6}, {'end': 979.798, 'text': "Maybe I'm more of a visual person.", 'start': 978.217, 'duration': 1.581}, {'end': 980.278, 'text': "I don't know.", 'start': 979.838, 'duration': 0.44}, {'end': 980.978, 'text': 'All right.', 'start': 980.758, 'duration': 0.22}, {'end': 982.019, 'text': "Let's close out of that.", 'start': 981.098, 'duration': 0.921}, {'end': 983.919, 'text': "And let's close out of that.", 'start': 982.859, 'duration': 1.06}, {'end': 987.741, 'text': "And so what I'm going to do is make a few more scripts.", 'start': 984.92, 'duration': 2.821}, {'end': 992.288, 'text': 'Okay, now we have two more scripts to create two more tables.', 'start': 989.386, 'duration': 2.902}], 'summary': 'Preference for manual php admin, creation of two more scripts to create tables', 'duration': 26.096, 'max_score': 966.192, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH0966192.jpg'}, {'end': 1046.509, 'src': 'embed', 'start': 1015.833, 'weight': 0, 'content': [{'end': 1020.236, 'text': 'The only reason you would need a customer database is to know who bought things from you when.', 'start': 1015.833, 'duration': 4.403}, {'end': 1024.098, 'text': "And that's all going to be within the transactions table.", 'start': 1021.357, 'duration': 2.741}, {'end': 1026.501, 'text': "And I'm going to explain that script in just a second.", 'start': 1024.7, 'duration': 1.801}, {'end': 1028.762, 'text': "First, let's talk about the products table.", 'start': 1027.281, 'duration': 1.481}, {'end': 1035.627, 'text': "This one's going to be created when we run it through our browser, and it's going to create a table called products into the database on our server.", 'start': 1028.823, 'duration': 6.804}, {'end': 1040.527, 'text': "It's going to have the first field is going to be ID, int, not null, auto increment.", 'start': 1036.305, 'duration': 4.222}, {'end': 1046.509, 'text': "The next field in that table is product name, and that's going to be the unique name that you give the product.", 'start': 1041.227, 'duration': 5.282}], 'summary': 'Customer database tracks purchases, products table includes unique product names.', 'duration': 30.676, 'max_score': 1015.833, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH01015833.jpg'}, {'end': 1081.852, 'src': 'embed', 'start': 1046.549, 'weight': 1, 'content': [{'end': 1049.571, 'text': 'You can see down here I have unique key product name.', 'start': 1046.549, 'duration': 3.022}, {'end': 1059.198, 'text': "That's going to make that field in this table require that each addition or each item within the table have a unique product name.", 'start': 1050.451, 'duration': 8.747}, {'end': 1061.12, 'text': 'No two can be exactly the same.', 'start': 1059.418, 'duration': 1.702}, {'end': 1063.823, 'text': 'The next field is price.', 'start': 1061.881, 'duration': 1.942}, {'end': 1065.966, 'text': "That's going to be bar chart 16.", 'start': 1063.843, 'duration': 2.123}, {'end': 1068.489, 'text': 'The next field is details.', 'start': 1065.966, 'duration': 2.523}, {'end': 1070.231, 'text': 'Anything you want to have.', 'start': 1068.749, 'duration': 1.482}, {'end': 1073.134, 'text': 'if you want to write paragraphs about a certain product,', 'start': 1070.231, 'duration': 2.903}, {'end': 1081.852, 'text': 'However much information that you want to put on the product page when the person goes to view that product, you can put into this text field here,', 'start': 1073.646, 'duration': 8.206}], 'summary': 'The table requires unique product names and allows for detailed information to be added.', 'duration': 35.303, 'max_score': 1046.549, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH01046549.jpg'}, {'end': 1122.241, 'src': 'embed', 'start': 1099.468, 'weight': 3, 'content': [{'end': 1108.417, 'text': "and then within that, when they click clothing, they'll see subcategories like pants, socks, shoes, shirts, whatever, and you can.", 'start': 1099.468, 'duration': 8.949}, {'end': 1115.838, 'text': 'you can be as flexible as you need to with breaking down subcategories into subcategories of subcategories.', 'start': 1108.417, 'duration': 7.421}, {'end': 1117.839, 'text': 'however, your catalog needs to be set up.', 'start': 1115.838, 'duration': 2.001}, {'end': 1122.241, 'text': "you're gonna have to set up your table customized for your needs.", 'start': 1117.839, 'duration': 4.402}], 'summary': 'E-commerce site offers flexible subcategorization, requires customized catalog setup.', 'duration': 22.773, 'max_score': 1099.468, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH01099468.jpg'}], 'start': 855.967, 'title': 'Creating admin tables and product transactions', 'summary': 'Covers executing sql commands, navigating phpmyadmin, and creating admin tables through script. it also details the creation of products and transactions tables with specific fields and key constraints, emphasizing the importance of the transactions table for tracking purchases and customer data.', 'chapters': [{'end': 987.741, 'start': 855.967, 'title': 'Executing sql commands and navigating phpmyadmin', 'summary': 'Explains executing sql commands using if-else condition statements, phpmyadmin navigation, and manual table creation, emphasizing the process of creating admin tables through script and navigating phpmyadmin for manual adjustments.', 'duration': 131.774, 'highlights': ['The chapter explains the process of executing SQL commands by using if and else condition statements to handle success and errors, providing insights on creating admin tables through script and navigating PHPMyAdmin for manual adjustments.', 'It demonstrates the process of accessing phpMyAdmin, logging in, and navigating the database section, highlighting the ability to manually adjust and create tables within phpMyAdmin.', 'The chapter mentions the preference for manual interaction in PHPMyAdmin, despite knowing how to write scripts, indicating the personal inclination towards visual interaction and manual adjustments.']}, {'end': 1140.992, 'start': 989.386, 'title': 'Creating products and transactions tables', 'summary': 'Describes the creation of two tables - products and transactions, with specific fields and key constraints, where the products table has fields for id, product name, price, details, category, and subcategory, while emphasizing the importance of the transactions table for tracking purchases and customer data.', 'duration': 151.606, 'highlights': ['The products table will have fields for ID, product name, price, details, category, and subcategory, with specific data types and key constraints, such as unique key for product name and text field for details with up to 10,000 characters.', 'The transactions table is emphasized as the primary source for tracking customer purchases, with the exclusion of a dedicated customer database, and the importance of gathering customer data within the transactions table is highlighted.', 'The flexibility in setting up categories and subcategories in the products table is emphasized, with the mention of creating a customized table structure based on individual catalog needs and the need for intuitive customization by the users.', 'The explanation of the scripts for creating the products and transactions tables is briefly mentioned, with a focus on the products table creation through a browser and its specific fields and constraints.', 'The importance of unique product names within the products table is highlighted, with the requirement for each item to have a unique product name and the use of the unique key constraint to enforce this uniqueness.']}], 'duration': 285.025, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH0855967.jpg', 'highlights': ['The transactions table is emphasized as the primary source for tracking customer purchases, with the exclusion of a dedicated customer database, and the importance of gathering customer data within the transactions table is highlighted.', 'The products table will have fields for ID, product name, price, details, category, and subcategory, with specific data types and key constraints, such as unique key for product name and text field for details with up to 10,000 characters.', 'The importance of unique product names within the products table is highlighted, with the requirement for each item to have a unique product name and the use of the unique key constraint to enforce this uniqueness.', 'The flexibility in setting up categories and subcategories in the products table is emphasized, with the mention of creating a customized table structure based on individual catalog needs and the need for intuitive customization by the users.', 'The chapter explains the process of executing SQL commands by using if and else condition statements to handle success and errors, providing insights on creating admin tables through script and navigating PHPMyAdmin for manual adjustments.', 'The chapter mentions the preference for manual interaction in PHPMyAdmin, despite knowing how to write scripts, indicating the personal inclination towards visual interaction and manual adjustments.']}, {'end': 1471.47, 'segs': [{'end': 1212.319, 'src': 'embed', 'start': 1140.992, 'weight': 0, 'content': [{'end': 1146.495, 'text': "set up my items, you'll understand what I'm doing and you can expand upon yours.", 'start': 1140.992, 'duration': 5.503}, {'end': 1152.64, 'text': 'date added will be the date that this inventory item was added to the store.', 'start': 1146.495, 'duration': 6.145}, {'end': 1156.322, 'text': 'so primary key is ID, unique keys, product name.', 'start': 1152.64, 'duration': 3.682}, {'end': 1162.487, 'text': "that's all there is to the products table for now, and I'm flexible to where I can keep this.", 'start': 1156.322, 'duration': 6.165}, {'end': 1165.232, 'text': 'I can have to add two more things.', 'start': 1162.487, 'duration': 2.745}, {'end': 1172.336, 'text': "you know maybe I'll realize a few hours into production that I need another field in this table, I can go back in and put it in.", 'start': 1165.232, 'duration': 7.104}, {'end': 1177.039, 'text': "it's no problem, and if I do anything like that, I'll show you guys.", 'start': 1172.336, 'duration': 4.703}, {'end': 1184.183, 'text': "now, the create transactions table is the one that talks to the PayPal IPN script that we're going to set up,", 'start': 1177.039, 'duration': 7.144}, {'end': 1192.127, 'text': 'and this is going to be gathering data behind the scenes when people actually purchase things through your site using PayPal,', 'start': 1184.183, 'duration': 7.944}, {'end': 1196.752, 'text': "And I'm going to discuss all of these variables.", 'start': 1193.911, 'duration': 2.841}, {'end': 1197.993, 'text': "You can see what's here.", 'start': 1197.032, 'duration': 0.961}, {'end': 1202.555, 'text': 'Pay or email, first name, last name, payment amount.', 'start': 1198.653, 'duration': 3.902}, {'end': 1212.319, 'text': 'Down here, MC fee shows you how much PayPal took out for their percentage for doing the online transaction, which is a very reasonable rate.', 'start': 1203.275, 'duration': 9.044}], 'summary': 'Setting up inventory items with date added and creating transactions table for paypal payments.', 'duration': 71.327, 'max_score': 1140.992, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH01140992.jpg'}, {'end': 1288.545, 'src': 'embed', 'start': 1258.277, 'weight': 3, 'content': [{'end': 1262.7, 'text': "I'm going to use my browser to execute them and they'll create the tables when I do.", 'start': 1258.277, 'duration': 4.423}, {'end': 1264.621, 'text': "So let's go to your site.", 'start': 1263.58, 'duration': 1.041}, {'end': 1267.477, 'text': 'Make sure you FTP those files.', 'start': 1265.916, 'duration': 1.561}, {'end': 1269.898, 'text': 'Store scripts.', 'start': 1268.757, 'duration': 1.141}, {'end': 1273.819, 'text': 'Navigate to create products table.', 'start': 1272.058, 'duration': 1.761}, {'end': 1277.661, 'text': 'Your products table has been created successfully.', 'start': 1275.46, 'duration': 2.201}, {'end': 1279.822, 'text': 'Put that file name here.', 'start': 1278.741, 'duration': 1.081}, {'end': 1281.782, 'text': 'Create transactions table now.', 'start': 1280.402, 'duration': 1.38}, {'end': 1283.063, 'text': 'Press enter.', 'start': 1282.483, 'duration': 0.58}, {'end': 1288.545, 'text': 'Your transactions table has been created successfully.', 'start': 1285.664, 'duration': 2.881}], 'summary': 'Tables for products and transactions created successfully via browser execution.', 'duration': 30.268, 'max_score': 1258.277, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH01258277.jpg'}, {'end': 1382.445, 'src': 'embed', 'start': 1351.407, 'weight': 4, 'content': [{'end': 1355.892, 'text': "That way we can access the back end page that's going to allow us to add inventory items.", 'start': 1351.407, 'duration': 4.485}, {'end': 1359.617, 'text': 'Upload the picture for the inventory item and put in the details.', 'start': 1356.473, 'duration': 3.144}, {'end': 1361.679, 'text': 'Price, all that junk.', 'start': 1360.378, 'duration': 1.301}, {'end': 1367.166, 'text': "And each time we press submit on that, it'll put it into that products database.", 'start': 1362.741, 'duration': 4.425}, {'end': 1372.558, 'text': "So for some of you guys who are, I'll show you those scripts once again.", 'start': 1368.655, 'duration': 3.903}, {'end': 1382.445, 'text': "If you happen to be in a hurry or you want to produce your system as I'm producing mine in real time, I'll show you the scripts here.", 'start': 1372.578, 'duration': 9.867}], 'summary': 'Access back end page to add inventory items, upload picture, input details, and submit to products database.', 'duration': 31.038, 'max_score': 1351.407, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH01351407.jpg'}, {'end': 1471.47, 'src': 'embed', 'start': 1441.872, 'weight': 5, 'content': [{'end': 1443.993, 'text': 'So these are the three scripts that create the tables.', 'start': 1441.872, 'duration': 2.121}, {'end': 1448.495, 'text': "And once they're created, you remove those from the server.", 'start': 1444.413, 'duration': 4.082}, {'end': 1450.561, 'text': 'the live server.', 'start': 1449.841, 'duration': 0.72}, {'end': 1455.603, 'text': "you don't want those three there, so delete them and there you go.", 'start': 1450.561, 'duration': 5.042}, {'end': 1460.465, 'text': 'we can close that out.', 'start': 1455.603, 'duration': 4.862}, {'end': 1468.349, 'text': "so in part three we'll create the admin area for the person or people who are going to manage the store,", 'start': 1460.465, 'duration': 7.884}, {'end': 1471.47, 'text': 'items and various things to do with the store.', 'start': 1468.349, 'duration': 3.121}], 'summary': '3 scripts create tables, remove from live server, create admin area in part three.', 'duration': 29.598, 'max_score': 1441.872, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH01441872.jpg'}], 'start': 1140.992, 'title': 'Inventory and paypal transactions setup', 'summary': 'Details the setup of an inventory table with primary key as id and unique key as product name, and the creation of a transactions table for gathering paypal transaction data, including variables like payor email, payment amount, and mc fee. it also covers the creation of a mysql database and three tables for a system, including the successful creation of the products and transactions tables and the upcoming development of an admin page for adding inventory items.', 'chapters': [{'end': 1238.626, 'start': 1140.992, 'title': 'Setting up inventory and paypal transactions', 'summary': 'Discusses setting up an inventory table with primary key as id and unique key as product name, and creating a transactions table for gathering data from paypal transactions, including variables like payor email, payment amount, and mc fee.', 'duration': 97.634, 'highlights': ['The create transactions table is the one that talks to the PayPal IPN script and gathers data behind the scenes when people purchase things through the site using PayPal.', 'The inventory table includes primary key as ID, unique key as product name, and date added as the date the inventory item was added to the store.', 'The PayPal transactions table includes variables such as Payor email, first name, last name, payment amount, and MC fee, which shows how much PayPal took out for their percentage for doing the online transaction.']}, {'end': 1471.47, 'start': 1239.407, 'title': 'Creating mysql database and tables', 'summary': 'Covers the process of creating a mysql database and three tables for a system, including the successful creation of the products and transactions tables and the upcoming development of an admin page for adding inventory items.', 'duration': 232.063, 'highlights': ['The chapter details the successful creation of the products table via FTP and execution through the browser, followed by the successful creation of the transactions table, providing a comprehensive overview of the initial database setup and structure.', 'The upcoming development of an admin page to manage store items and the process of adding inventory items, including the upload of pictures and input of details such as price, is highlighted, indicating the future focus of the system development.', 'The availability of scripts for creating the tables and the reminder to remove them from the live server after their successful execution is emphasized, providing a practical and preparatory approach for system development.']}], 'duration': 330.478, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/YaII5QhNCH0/pics/YaII5QhNCH01140992.jpg', 'highlights': ['The create transactions table is the one that talks to the PayPal IPN script and gathers data behind the scenes when people purchase things through the site using PayPal.', 'The inventory table includes primary key as ID, unique key as product name, and date added as the date the inventory item was added to the store.', 'The PayPal transactions table includes variables such as Payor email, first name, last name, payment amount, and MC fee, which shows how much PayPal took out for their percentage for doing the online transaction.', 'The chapter details the successful creation of the products table via FTP and execution through the browser, followed by the successful creation of the transactions table, providing a comprehensive overview of the initial database setup and structure.', 'The upcoming development of an admin page to manage store items and the process of adding inventory items, including the upload of pictures and input of details such as price, is highlighted, indicating the future focus of the system development.', 'The availability of scripts for creating the tables and the reminder to remove them from the live server after their successful execution is emphasized, providing a practical and preparatory approach for system development.']}], 'highlights': ['The commitment to provide six tutorials by Christmas Day and the extension to cover an admin system for adding products, as per feedback from Matthiasv91.', 'The intention to create an admin panel for managing the store, allowing users without expertise in HTML, CSS, and PHP to add inventory products.', 'The plan to use AdamCorey.com as the live online example for the store.', 'Accessing cPanel and locating MySQL databases is essential for setting up a MySQL database on a live server.', 'Seeking assistance from the hosting provider, especially for platforms like GoDaddy, can aid in finding connection information for the MySQL database.', 'Reading all the information on the MySQL databases page is crucial for a comprehensive understanding of the setup process.', "The chapter emphasizes the process of creating a MySQL database and adding a user with a specific prefix, such as 'Adam KHOU underscore', and highlights the importance of having the database and user set up for the MySQL connection file.", 'It explains the significance of having the proper data in the MySQL connection script, including the database host, username, and password for configuring the store files.', 'The chapter demonstrates testing the connection using a test file from DevelopPHP to ensure successful connectivity.', 'The process involves obtaining code from DevelopPHP and replacing existing code in Dreamweaver to establish the connection and perform testing.', 'Explaining the SQL syntax for creating the admin table Provides a detailed explanation of the SQL syntax for creating the admin table, including field types, not null constraints, auto-increment, primary key, and unique key.', 'Creating admin table with specific field details Details the process of creating an admin table with specific field details such as ID, username, password, and last log date using SQL syntax.', 'Setting up MySQL connection and testing the connection Explains the process of requiring ConnectToMySQL.php, testing the connection, and ensuring successful database connection.', 'The transactions table is emphasized as the primary source for tracking customer purchases, with the exclusion of a dedicated customer database, and the importance of gathering customer data within the transactions table is highlighted.', 'The products table will have fields for ID, product name, price, details, category, and subcategory, with specific data types and key constraints, such as unique key for product name and text field for details with up to 10,000 characters.', 'The importance of unique product names within the products table is highlighted, with the requirement for each item to have a unique product name and the use of the unique key constraint to enforce this uniqueness.', 'The flexibility in setting up categories and subcategories in the products table is emphasized, with the mention of creating a customized table structure based on individual catalog needs and the need for intuitive customization by the users.', 'The create transactions table is the one that talks to the PayPal IPN script and gathers data behind the scenes when people purchase things through the site using PayPal.', 'The inventory table includes primary key as ID, unique key as product name, and date added as the date the inventory item was added to the store.', 'The PayPal transactions table includes variables such as Payor email, first name, last name, payment amount, and MC fee, which shows how much PayPal took out for their percentage for doing the online transaction.', 'The chapter details the successful creation of the products table via FTP and execution through the browser, followed by the successful creation of the transactions table, providing a comprehensive overview of the initial database setup and structure.', 'The upcoming development of an admin page to manage store items and the process of adding inventory items, including the upload of pictures and input of details such as price, is highlighted, indicating the future focus of the system development.', 'The availability of scripts for creating the tables and the reminder to remove them from the live server after their successful execution is emphasized, providing a practical and preparatory approach for system development.']}