title
How to Build a Community Website Part 1 Social Network Production Tutorials

description
This series is deprecated and replaced by: https://www.youtube.com/playlist?list=PLlkGN-8wjPHV41Y12LFD8uttbAd1d_ohe

detail
{'title': 'How to Build a Community Website Part 1 Social Network Production Tutorials', 'heatmap': [{'end': 465.535, 'start': 437.595, 'weight': 0.921}, {'end': 618.403, 'start': 552.806, 'weight': 0.744}, {'value': 0.8332956049243934, 'end_time': 610.9770000000001, 'start_time': 585.702}], 'summary': 'Tutorial series covers creating a robust member system with mp3 and flv uploads, flash-based gallery, linux and php hosting, and free mysql databases. it emphasizes building a live website on the hosting environment, setting up php and mysql, adding website and youtube fields, mysql connection, database table constraints, and creating a script and website for a community website.', 'chapters': [{'end': 223.37, 'segs': [{'end': 73.221, 'src': 'embed', 'start': 45.914, 'weight': 0, 'content': [{'end': 55.701, 'text': "we we're gonna use some of those first few steps to start our new one and but we're gonna branch off into other other structures to create a more robust system.", 'start': 45.914, 'duration': 9.787}, {'end': 64.928, 'text': "like I said, we're gonna allow them members to upload mp3s, FLV files, to play videos on their profile.", 'start': 55.701, 'duration': 9.227}, {'end': 73.221, 'text': "we're gonna allow them to upload pictures and then make a flash based gallery to display those pictures.", 'start': 64.928, 'duration': 8.293}], 'summary': 'Creating a more robust system to allow members to upload mp3s, flv files, and pictures for display.', 'duration': 27.307, 'max_score': 45.914, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz845914.jpg'}, {'end': 196.686, 'src': 'embed', 'start': 97.669, 'weight': 1, 'content': [{'end': 102.573, 'text': 'so the first thing you want to do is, once you get your domain name and hosting account,', 'start': 97.669, 'duration': 4.904}, {'end': 106.295, 'text': 'you want to make sure you set your hosting account as linux and php.', 'start': 102.573, 'duration': 3.722}, {'end': 114.199, 'text': 'Maybe, when you buy it, if you get the choice between Windows and ASP or Linux and PHP, choose Linux and PHP,', 'start': 107.136, 'duration': 7.063}, {'end': 116.06, 'text': "because that's what we'll be using in the system.", 'start': 114.199, 'duration': 1.861}, {'end': 121.562, 'text': "And if you're on Windows and ASP server, it might not work for you.", 'start': 117.14, 'duration': 4.422}, {'end': 130.262, 'text': 'uh, you want to make sure the hosting accounts to purchase will have will offer free mysql databases.', 'start': 123.016, 'duration': 7.246}, {'end': 132.403, 'text': "you don't want to pay for those because they're free.", 'start': 130.262, 'duration': 2.141}, {'end': 138.708, 'text': "we're going to use mysql to start the system because it's free and it's powerful.", 'start': 132.403, 'duration': 6.305}, {'end': 143.972, 'text': 'i mean he, he can get you up into the millions of members with, uh.', 'start': 138.708, 'duration': 5.264}, {'end': 145.453, 'text': 'but not too many problems.', 'start': 143.972, 'duration': 1.481}, {'end': 155.942, 'text': 'if you ever see you get way up in numbers with your members and if you see any performance decreases or decrease in performance in your system,', 'start': 145.453, 'duration': 10.489}, {'end': 162.568, 'text': 'then you can look into getting a more powerful database system set up for your website.', 'start': 155.942, 'duration': 6.626}, {'end': 167.512, 'text': "But I don't think you'd ever need to unless you got wildly popular.", 'start': 163.088, 'duration': 4.424}, {'end': 174.578, 'text': "So, yeah, I'm going to go nice and slow in this tutorial series.", 'start': 168.333, 'duration': 6.245}, {'end': 179.843, 'text': 'Maybe a little bit too slow for some of you veteran coders out there, and I apologize for that.', 'start': 174.979, 'duration': 4.864}, {'end': 190.141, 'text': 'But I want to make sure that I get the most insight in so I can avoid people coming at me with questions later.', 'start': 180.575, 'duration': 9.566}, {'end': 196.686, 'text': "Because I'm just going to offer all this source code free and people can get what they can from it.", 'start': 190.802, 'duration': 5.884}], 'summary': 'Choose linux and php hosting, ensure free mysql databases, scalable for millions of members.', 'duration': 99.017, 'max_score': 97.669, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz897669.jpg'}], 'start': 0.069, 'title': 'Creating a robust member system', 'summary': 'Outlines a plan for creating a robust member system, enabling mp3 and flv uploads, flash-based gallery for picture uploads, emphasizing linux and php hosting, free mysql databases, and promises a detailed tutorial series.', 'chapters': [{'end': 223.37, 'start': 0.069, 'title': 'Creating a robust member system', 'summary': 'Outlines the plan to create a robust member system allowing mp3 and flv uploads, picture uploads with a flash-based gallery, emphasizing the importance of linux and php hosting and free mysql databases, and promising a detailed tutorial series.', 'duration': 223.301, 'highlights': ['Emphasizing the importance of using Linux and PHP hosting for the system and the need for free MySQL databases.', 'Promising a detailed tutorial series to avoid potential questions later and offering all source code free to viewers.', 'Outlining the plan to create a robust member system allowing mp3 and FLV uploads, picture uploads with a flash-based gallery.', "Stressing the need to start with Linux and PHP hosting for the system's setup and mentioning the option to upgrade the database system if the performance decreases with increased membership.", 'Mentioning the need to go slow to ensure clarity and thoroughness in the tutorial series.']}], 'duration': 223.301, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz869.jpg', 'highlights': ['Outlining a plan for creating a robust member system allowing mp3 and FLV uploads, picture uploads with a flash-based gallery.', 'Emphasizing the importance of using Linux and PHP hosting for the system and the need for free MySQL databases.', 'Promising a detailed tutorial series to avoid potential questions later and offering all source code free to viewers.', "Stressing the need to start with Linux and PHP hosting for the system's setup and mentioning the option to upgrade the database system if the performance decreases with increased membership.", 'Mentioning the need to go slow to ensure clarity and thoroughness in the tutorial series.']}, {'end': 573.193, 'segs': [{'end': 294.314, 'src': 'embed', 'start': 224.249, 'weight': 0, 'content': [{'end': 230.531, 'text': 'so the first step after the first step in getting a hosting account set up,', 'start': 224.249, 'duration': 6.282}, {'end': 240.334, 'text': "and the reason why I'm gonna build live and I recommend you build it live is because years building on the actual environment is going to be running on,", 'start': 230.531, 'duration': 9.803}, {'end': 246.335, 'text': "so you won't run into any snags when it comes to switching over to your actual server.", 'start': 240.334, 'duration': 6.001}, {'end': 254.728, 'text': "it's very important and if you, if you're good like me, it'll be up and done in three and four days your whole website,", 'start': 246.335, 'duration': 8.393}, {'end': 261.993, 'text': "so search engines won't even have a chance to spider your website or even notice it before you're launched in and done.", 'start': 254.728, 'duration': 7.265}, {'end': 265.315, 'text': "so. that's that.", 'start': 261.993, 'duration': 3.322}, {'end': 266.336, 'text': 'and so what to do?', 'start': 265.315, 'duration': 1.021}, {'end': 276.263, 'text': 'is you run a quick php test file to make sure that your system is parsing php correctly and i have that at develop php here.', 'start': 266.336, 'duration': 9.927}, {'end': 276.944, 'text': 'which one is it?', 'start': 276.263, 'duration': 0.681}, {'end': 285.029, 'text': "If you go to the PHP and MySQL tutorials, I'm going to reference a lot of stuff here actually, as we go.", 'start': 279.045, 'duration': 5.984}, {'end': 294.314, 'text': 'And this one is the second link in the introductions of the basics to PHP is how to check if PHP is enabled on your server.', 'start': 285.049, 'duration': 9.265}], 'summary': 'Recommend building website live to avoid snags, check php setup.', 'duration': 70.065, 'max_score': 224.249, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz8224249.jpg'}, {'end': 413.555, 'src': 'embed', 'start': 381.626, 'weight': 2, 'content': [{'end': 391.816, 'text': "nothing like that goes into the database and i say text string data, because that's all i use a database for is text string data exclusively,", 'start': 381.626, 'duration': 10.19}, {'end': 393.097, 'text': 'nothing else.', 'start': 391.816, 'duration': 1.281}, {'end': 397.781, 'text': 'any type of other kind of files go on the server in the members folder.', 'start': 393.097, 'duration': 4.684}, {'end': 405.25, 'text': 'This way your database runs really quick, clean and smooth.', 'start': 398.726, 'duration': 6.524}, {'end': 413.555, 'text': 'So in creating the database, you can go to develop PHP and get some insight into that.', 'start': 406.711, 'duration': 6.844}], 'summary': 'Database exclusively for text string data, other files on server. database runs quick, clean, and smooth. php insight available.', 'duration': 31.929, 'max_score': 381.626, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz8381626.jpg'}, {'end': 465.535, 'src': 'heatmap', 'start': 437.595, 'weight': 0.921, 'content': [{'end': 440.861, 'text': "Once you get to step seven, there's a little script there that you run.", 'start': 437.595, 'duration': 3.266}, {'end': 449.529, 'text': 'you grab this, you make this script and this is a very important little script to the whole system,', 'start': 442.506, 'duration': 7.023}, {'end': 455.812, 'text': 'because this script is for connecting to the database anytime we have to connect to it in the code.', 'start': 449.529, 'duration': 6.283}, {'end': 462.254, 'text': 'so say, we have some PHP script that needs to, uh.', 'start': 455.812, 'duration': 6.442}, {'end': 465.535, 'text': 'register the member when they first come and sign up.', 'start': 462.254, 'duration': 3.281}], 'summary': 'At step seven, a crucial script for connecting to the database is utilized in php to register new members.', 'duration': 27.94, 'max_score': 437.595, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz8437595.jpg'}, {'end': 543.643, 'src': 'embed', 'start': 515.563, 'weight': 4, 'content': [{'end': 523.568, 'text': "So we're going to create the member table inside of the database that's already set and add the appropriate fields inside of it.", 'start': 515.563, 'duration': 8.005}, {'end': 529.153, 'text': "That's also a developed PHP under the member system tutorial.", 'start': 524.389, 'duration': 4.764}, {'end': 530.634, 'text': "Let's close that one out.", 'start': 529.413, 'duration': 1.221}, {'end': 533.075, 'text': "And let's go to step two.", 'start': 531.755, 'duration': 1.32}, {'end': 540.781, 'text': "And that's where I have a script that shows you how this actually creates the table on the database.", 'start': 534.136, 'duration': 6.645}, {'end': 543.643, 'text': 'All you have to do is run it in your browser.', 'start': 541.281, 'duration': 2.362}], 'summary': 'Creating a member table in the database and running a script to populate it.', 'duration': 28.08, 'max_score': 515.563, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz8515563.jpg'}], 'start': 224.249, 'title': 'Building and launching a website and setting up php and mysql', 'summary': 'Emphasizes the importance of building a website live on the hosting environment to avoid snags when switching servers, highlighting the efficiency of completing the process in three to four days. it also discusses setting up php and mysql by checking php enablement, creating a database for text string data, and adding a member table with appropriate fields, emphasizing not storing media files in the database.', 'chapters': [{'end': 266.336, 'start': 224.249, 'title': 'Building and launching a website', 'summary': 'Emphasizes the importance of building a website live on the actual hosting environment to avoid snags when switching servers, and highlights the efficiency of completing the process in three to four days, preventing search engines from indexing the website before launch.', 'duration': 42.087, 'highlights': ["It's crucial to build the website live on the actual hosting environment to avoid snags when switching servers.", 'Completing the website in three to four days can prevent search engines from indexing the site before launch.']}, {'end': 573.193, 'start': 266.336, 'title': 'Setting up php and mysql', 'summary': 'Discusses setting up php and mysql by checking php enablement, creating a database for text string data, and adding a member table with appropriate fields, emphasizing not storing media files in the database.', 'duration': 306.857, 'highlights': ['Creating a database for text string data exclusively, emphasizing not storing media files in the database. The speaker advises against storing media files in the database and highlights the exclusive use of the database for text string data, advocating for storing media files in a separate folder.', 'Checking PHP enablement and ensuring proper output before system setup. The chapter stresses the importance of running a phpcheck.php file to verify PHP enablement on the server before proceeding with system setup.', 'Adding a member table with appropriate fields inside the database. The speaker explains the process of adding a member table with the relevant fields inside the database and emphasizes the importance of this step in the setup process.']}], 'duration': 348.944, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz8224249.jpg', 'highlights': ['Completing the website in three to four days can prevent search engines from indexing the site before launch.', "It's crucial to build the website live on the actual hosting environment to avoid snags when switching servers.", 'Creating a database for text string data exclusively, emphasizing not storing media files in the database.', 'Checking PHP enablement and ensuring proper output before system setup.', 'Adding a member table with appropriate fields inside the database.']}, {'end': 802.903, 'segs': [{'end': 648.657, 'src': 'embed', 'start': 574.696, 'weight': 0, 'content': [{'end': 580.759, 'text': "okay, now i'm going to do just a couple of tweaks to this and then i'm going to explain this line by line.", 'start': 574.696, 'duration': 6.063}, {'end': 585.702, 'text': 'okay, okay, i went ahead and changed a few things that i wanted to change.', 'start': 580.759, 'duration': 4.943}, {'end': 595.467, 'text': 'i added a website field and youtube field, so i want to be able to allow the members to embed their youtube channel directly on their profile,', 'start': 585.702, 'duration': 9.765}, {'end': 605.753, 'text': "and i'll show you how i do that later on in in later parts of this tutorial, which there will be many parts.", 'start': 595.467, 'duration': 10.286}, {'end': 610.977, 'text': 'that way, people can jump in and out of sections they want to jump in and out of, to go back to,', 'start': 605.753, 'duration': 5.224}, {'end': 618.403, 'text': "or if you're an advanced developer already and you just want to see one little part of something I'm doing, you can just head to that section.", 'start': 610.977, 'duration': 7.426}, {'end': 623.152, 'text': "Let's see, so let's go ahead and explain this here.", 'start': 620.271, 'duration': 2.881}, {'end': 629.613, 'text': "We have include once, connect to mysql.php, and that's the file we made.", 'start': 623.212, 'duration': 6.401}, {'end': 634.874, 'text': "Let me show you my directory structure so you guys know where I'm starting here.", 'start': 630.413, 'duration': 4.461}, {'end': 639.595, 'text': 'Okay, so say you have the route to your website.', 'start': 636.074, 'duration': 3.521}, {'end': 642.296, 'text': 'Here, let me just close that and show you from here.', 'start': 640.435, 'duration': 1.861}, {'end': 648.657, 'text': "On my desktop, here's my website, WebIntersect is the one I'm building, my new project.", 'start': 643.436, 'duration': 5.221}], 'summary': 'Added website and youtube fields for member profiles, with plans for multiple tutorial parts.', 'duration': 73.961, 'max_score': 574.696, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz8574696.jpg'}, {'end': 756.384, 'src': 'embed', 'start': 701.403, 'weight': 4, 'content': [{'end': 707.848, 'text': "We're going to make sure we save this new create member table file into the scripts folder.", 'start': 701.403, 'duration': 6.445}, {'end': 717.212, 'text': "That way it'll connect to the MySQL, it'll execute correctly for us, and then we can delete it from the server after we get it up.", 'start': 709.045, 'duration': 8.167}, {'end': 722.417, 'text': 'So that line includes that connect to MySQL file.', 'start': 717.312, 'duration': 5.105}, {'end': 728.662, 'text': 'That way we connect with this to MySQL, the newly created database.', 'start': 722.757, 'duration': 5.905}, {'end': 734.947, 'text': 'Then we print ourselves a message after it connects successfully.', 'start': 728.842, 'duration': 6.105}, {'end': 739.288, 'text': "because if it doesn't, it won't print this message here.", 'start': 734.947, 'duration': 4.341}, {'end': 744.654, 'text': "it'll print out a different message and you'll see what the error message is.", 'start': 739.288, 'duration': 5.366}, {'end': 751.722, 'text': "but you print success in database connection, you'll see that line.", 'start': 744.654, 'duration': 7.068}, {'end': 756.384, 'text': 'and then, if you see at the bottom success in table creation,', 'start': 751.722, 'duration': 4.662}], 'summary': 'Creating and connecting a new member table to mysql, including successful database and table creation.', 'duration': 54.981, 'max_score': 701.403, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz8701403.jpg'}], 'start': 574.696, 'title': 'Adding website and youtube fields and setting up mysql connection', 'summary': "Involves making tweaks to add website and youtube fields for members to embed their youtube channel on their profile, with plans for multiple tutorial parts. it also explains setting up a mysql connection and creating a table in a website's directory structure, including the inclusion of connect to mysql file and the successful execution of database connection and table creation.", 'chapters': [{'end': 618.403, 'start': 574.696, 'title': 'Adding website and youtube fields', 'summary': 'Involves making tweaks to add website and youtube fields for members to embed their youtube channel on their profile, with plans for multiple tutorial parts.', 'duration': 43.707, 'highlights': ['Explaining the addition of website and YouTube fields for members to embed their YouTube channel on their profile, planning multiple parts of the tutorial', 'Allowing members to jump in and out of sections and go back to specific parts as needed', 'Adding a website field and YouTube field to enable members to embed their YouTube channel directly on their profile']}, {'end': 802.903, 'start': 620.271, 'title': 'Setting up mysql connection and creating table', 'summary': "Explains setting up a mysql connection and creating a table in a website's directory structure, including the inclusion of connect to mysql file and the successful execution of database connection and table creation.", 'duration': 182.632, 'highlights': ["The chapter explains setting up a MySQL connection and creating a table in a website's directory structure. The chapter provides instructions on setting up a MySQL connection and creating a table within the website's directory structure.", 'Inclusion of connect to MySQL file and successful execution of database connection and table creation. The chapter includes connecting to the MySQL database using the connect to MySQL file and ensuring successful execution of database connection and table creation.', 'Printing success message for successful database connection and table creation. Instructions are given for printing a success message upon successful database connection and table creation, with different messages for error scenarios.']}], 'duration': 228.207, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz8574696.jpg', 'highlights': ['Explaining the addition of website and YouTube fields for members to embed their YouTube channel on their profile, planning multiple parts of the tutorial', 'Adding a website field and YouTube field to enable members to embed their YouTube channel directly on their profile', 'Allowing members to jump in and out of sections and go back to specific parts as needed', "The chapter explains setting up a MySQL connection and creating a table in a website's directory structure", 'Inclusion of connect to MySQL file and successful execution of database connection and table creation', 'Printing success message for successful database connection and table creation']}, {'end': 1057.886, 'segs': [{'end': 924.201, 'src': 'embed', 'start': 855.314, 'weight': 0, 'content': [{'end': 859.157, 'text': "And so they're set to bar chart 255, most of them.", 'start': 855.314, 'duration': 3.843}, {'end': 862.879, 'text': "And this one's set to a date.", 'start': 860.578, 'duration': 2.301}, {'end': 863.86, 'text': 'This is a date field.', 'start': 862.959, 'duration': 0.901}, {'end': 867.822, 'text': 'And the first one, the ID field, is set to an integer field.', 'start': 864.941, 'duration': 2.881}, {'end': 875.227, 'text': 'And it has a value of 11, or a length of 11.', 'start': 868.303, 'duration': 6.924}, {'end': 878.69, 'text': "And that's also set to not null and it auto increments itself.", 'start': 875.227, 'duration': 3.463}, {'end': 884.914, 'text': 'So when each member joins, say I join, I get member ID one.', 'start': 879.21, 'duration': 5.704}, {'end': 887.817, 'text': "Next member joins, he's ID two.", 'start': 886.055, 'duration': 1.762}, {'end': 889.878, 'text': 'And so on and so forth.', 'start': 888.837, 'duration': 1.041}, {'end': 891.279, 'text': "And you don't have to code that in.", 'start': 889.938, 'duration': 1.341}, {'end': 893.22, 'text': 'It does it auto incrementing.', 'start': 891.299, 'duration': 1.921}, {'end': 899.245, 'text': 'Okay, so what else we have here? We have the account type.', 'start': 894.181, 'duration': 5.064}, {'end': 901.365, 'text': 'going to be.', 'start': 899.905, 'duration': 1.46}, {'end': 913.409, 'text': 'well, here we have a text type field which will hold a whole bunch of a whole lot of text string data.', 'start': 901.365, 'duration': 12.044}, {'end': 920.771, 'text': "most of these are just set to hold 255, and that's as many characters as you can put into that field.", 'start': 913.409, 'duration': 7.362}, {'end': 924.201, 'text': "it won't hold any more than 255.", 'start': 920.771, 'duration': 3.43}], 'summary': 'Setting fields in a database table with specific data types and constraints, where the id field auto-increments.', 'duration': 68.887, 'max_score': 855.314, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz8855314.jpg'}, {'end': 983.736, 'src': 'embed', 'start': 955.268, 'weight': 2, 'content': [{'end': 961.493, 'text': 'yours can be one, two and three, whatever you want, and that has a default value of a.', 'start': 955.268, 'duration': 6.225}, {'end': 966.045, 'text': 'so when somebody joins my site, they are a default member type A.', 'start': 961.493, 'duration': 4.552}, {'end': 972.669, 'text': 'If I want to change it later on in the system I just change it to B or C and then they can have special privileges on the site.', 'start': 966.045, 'duration': 6.624}, {'end': 974.23, 'text': "That's what that's for.", 'start': 973.51, 'duration': 0.72}, {'end': 977.412, 'text': 'And email activated.', 'start': 975.191, 'duration': 2.221}, {'end': 983.736, 'text': "that's whether or not the person has successfully activated through email,", 'start': 977.412, 'duration': 6.324}], 'summary': 'Users start as type a with default value of a. can change to b or c for special privileges. email activation status tracked.', 'duration': 28.468, 'max_score': 955.268, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz8955268.jpg'}, {'end': 1027.54, 'src': 'embed', 'start': 996.838, 'weight': 3, 'content': [{'end': 1006.36, 'text': "you know that that's the correct person and they're a human and they are the owner of that email address that joined your site recently.", 'start': 996.838, 'duration': 9.522}, {'end': 1016.702, 'text': 'Okay, so that switches from zero, which is created by default.', 'start': 1006.86, 'duration': 9.842}, {'end': 1021.723, 'text': "when their account's created by default and their row goes into the database, it's zero.", 'start': 1016.702, 'duration': 5.021}, {'end': 1027.54, 'text': 'And then when they get that email later and they hit the activation link, it swaps to one.', 'start': 1022.557, 'duration': 4.983}], 'summary': 'Email activation changes account status from 0 to 1.', 'duration': 30.702, 'max_score': 996.838, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz8996838.jpg'}], 'start': 803.163, 'title': 'Database table constraints and schema', 'summary': "Discusses creating a database table 'my members' with fields including id, first name, middle name, last name, country, and state. it also covers constraints where certain fields must not be empty, and types such as auto-incrementing id, text field capacity, and enumerated field for account type.", 'chapters': [{'end': 854.373, 'start': 803.163, 'title': 'Database table and field constraints', 'summary': "Discusses creating a database table 'my members' with fields including id, first name, middle name, last name, country, and state, where some fields must not be empty and others can be empty.", 'duration': 51.21, 'highlights': ["The chapter explains creating a database table 'my members' with fields including ID, first name, middle name, last name, country, and state, where some fields must not be empty and others can be empty.", "It adds constraints such as 'not null' for fields like ID, first name, last name, country, and state, indicating that these fields cannot be empty.", "Fields like middle name, YouTube, and website are allowed to be empty, as they have the 'null' constraint."]}, {'end': 1057.886, 'start': 855.314, 'title': 'Database table schema and field types', 'summary': 'Discusses the database table schema and field types, including the auto-incrementing id field, text field capacity, enumerated field for account type, and email activation security measure.', 'duration': 202.572, 'highlights': ['The ID field is set as an integer field with a length of 11 and auto-increments, ensuring unique member IDs and currently holds a value of 11.', 'The text type field can hold up to 255 characters, while another text field can hold significantly more data, designed for the bio or about me section.', "The account type is an enumerated field with default values of 'a', 'b', and 'c', allowing for different member types and special privileges.", 'The email activation serves as a security measure, with a value of 0 indicating account creation and 1 indicating successful email activation, preventing spam bots.']}], 'duration': 254.723, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz8803163.jpg', 'highlights': ['The ID field is an integer with a length of 11 and auto-increments, currently holding a value of 11.', 'The text type field can hold up to 255 characters, while another text field can hold significantly more data.', "The account type is an enumerated field with default values of 'a', 'b', and 'c', allowing for different member types and special privileges.", 'The email activation serves as a security measure, with a value of 0 indicating account creation and 1 indicating successful email activation.']}, {'end': 1291.755, 'segs': [{'end': 1124.704, 'src': 'embed', 'start': 1058.966, 'weight': 0, 'content': [{'end': 1060.367, 'text': "So let's go ahead and run this bad boy.", 'start': 1058.966, 'duration': 1.401}, {'end': 1062.487, 'text': 'Stop talking and do it.', 'start': 1061.207, 'duration': 1.28}, {'end': 1065.489, 'text': 'Okay, so save this file.', 'start': 1063.508, 'duration': 1.981}, {'end': 1066.309, 'text': 'Save as.', 'start': 1065.589, 'duration': 0.72}, {'end': 1069.53, 'text': "Make sure we're in the scripts folder.", 'start': 1067.949, 'duration': 1.581}, {'end': 1088.041, 'text': 'save it as create table, create underscore capital, T, A, B, L, E, press save as or press save, and then we can FTP them.', 'start': 1072.512, 'duration': 15.529}, {'end': 1095.166, 'text': 'I use filezilla to FTP files to my servers and you can use whatever you want.', 'start': 1088.041, 'duration': 7.125}, {'end': 1098.948, 'text': "now let's see here's web intersects root directory.", 'start': 1095.166, 'duration': 3.782}, {'end': 1102.77, 'text': 'you can see my images folder, my favicon.', 'start': 1098.948, 'duration': 3.822}, {'end': 1107.633, 'text': "favicon is that little file that shows up here in people's browser.", 'start': 1102.77, 'duration': 4.863}, {'end': 1111.315, 'text': "it's really cool to have those and uh.", 'start': 1107.633, 'duration': 3.682}, {'end': 1112.556, 'text': 'or have one of those.', 'start': 1111.315, 'duration': 1.241}, {'end': 1119.401, 'text': "and then the index file you see there, which is what we're looking at here in the web, and this is just temporary.", 'start': 1112.556, 'duration': 6.845}, {'end': 1123.943, 'text': "i'm going to be changing it real soon when we go deeper into the system.", 'start': 1119.401, 'duration': 4.542}, {'end': 1124.704, 'text': 'so uh,', 'start': 1123.943, 'duration': 0.761}], 'summary': 'Demonstrating file saving and ftping in web development using filezilla.', 'duration': 65.738, 'max_score': 1058.966, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz81058966.jpg'}, {'end': 1183.829, 'src': 'embed', 'start': 1158.055, 'weight': 2, 'content': [{'end': 1162.538, 'text': "so let's go ahead and grab the whole name of that.", 'start': 1158.055, 'duration': 4.483}, {'end': 1163.318, 'text': 'copy it.', 'start': 1162.538, 'duration': 0.78}, {'end': 1165.219, 'text': "so we're going to paste it in the browser right now.", 'start': 1163.318, 'duration': 1.901}, {'end': 1168.641, 'text': "now we're going to run it in the browser to create the table.", 'start': 1165.219, 'duration': 3.422}, {'end': 1171.002, 'text': "so we're at web intersect, dot com or whatever.", 'start': 1168.641, 'duration': 2.361}, {'end': 1173.804, 'text': 'your website is dot com.', 'start': 1171.002, 'duration': 2.802}, {'end': 1183.829, 'text': "slash scripts, because there's a scripts folder we have to dig into and then press control v to paste that file name right there.", 'start': 1173.804, 'duration': 10.025}], 'summary': 'Pasting the file name in the browser at webintersect.com/scripts to create a table.', 'duration': 25.774, 'max_score': 1158.055, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz81158055.jpg'}, {'end': 1291.755, 'src': 'embed', 'start': 1218.296, 'weight': 3, 'content': [{'end': 1219.416, 'text': "That one's always going to stay.", 'start': 1218.296, 'duration': 1.12}, {'end': 1222.717, 'text': 'The connect to MySQL file is always going to stay in that scripts folder.', 'start': 1219.456, 'duration': 3.261}, {'end': 1227.438, 'text': "We're going to access that file many times within our system.", 'start': 1223.497, 'duration': 3.941}, {'end': 1231.799, 'text': 'Okay, so create table is done.', 'start': 1229.638, 'duration': 2.161}, {'end': 1236.5, 'text': 'Create some more tables later on in later tutorials for this series.', 'start': 1232.399, 'duration': 4.101}, {'end': 1241.141, 'text': "But for now, that's going to be the main one.", 'start': 1237.42, 'duration': 3.721}, {'end': 1245.582, 'text': "That'll be the main table for the foundation of the system.", 'start': 1241.181, 'duration': 4.401}, {'end': 1251.624, 'text': 'Once you have the foundation, we have the foundation set up, then we can play around with different things.', 'start': 1246.621, 'duration': 5.003}, {'end': 1257.987, 'text': "But we'll go ahead and continue on in a part two for this series.", 'start': 1253.485, 'duration': 4.502}, {'end': 1271.214, 'text': "Now that we have the table created, we'll make our home page here look a little bit more like a home page would for a community website.", 'start': 1258.447, 'duration': 12.767}, {'end': 1277.308, 'text': 'will make the registration form uh..', 'start': 1272.585, 'duration': 4.723}, {'end': 1280.789, 'text': 'to let the users register to the site.', 'start': 1277.308, 'duration': 3.481}, {'end': 1290.435, 'text': "add all of that data from the form to our mysql database and that'll be part two and then we'll go maybe into a few other things in part two.", 'start': 1280.789, 'duration': 9.646}, {'end': 1291.755, 'text': "okay, we'll see you next lesson.", 'start': 1290.435, 'duration': 1.32}], 'summary': 'Creating main table for system foundation, adding registration form to mysql database in part two.', 'duration': 73.459, 'max_score': 1218.296, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz81218296.jpg'}], 'start': 1058.966, 'title': 'Creating a script and website', 'summary': 'Involves running a script to create a table and transfer files using filezilla, setting up a database and creating a main table in php, and creating a foundation for a community website with a registration form and mysql database storage for future lessons.', 'chapters': [{'end': 1183.829, 'start': 1058.966, 'title': 'Creating and running a script for file transfer and table creation', 'summary': 'Involves running a script to create a table and transfer files using filezilla, with emphasis on creating a favicon and transferring files to a server, followed by running the script in a browser.', 'duration': 124.863, 'highlights': ['Running a script to create a table and transfer files using FileZilla.', 'Creating a favicon and transferring files to a server.', 'Running the script in a browser to create the table.']}, {'end': 1245.582, 'start': 1183.829, 'title': 'Setting up database and creating main table', 'summary': 'Details the successful creation of a table in php, emphasizes the importance of a specific file for future use, and mentions plans for creating additional tables in later tutorials.', 'duration': 61.753, 'highlights': ['The main table for the foundation of the system has been successfully created in PHP.', "The file 'connect to MySQL' is crucial and will be accessed multiple times within the system.", 'Plans to create additional tables are mentioned for later tutorials in the series.']}, {'end': 1291.755, 'start': 1246.621, 'title': 'Creating a community website', 'summary': 'Covers setting up the foundation for a community website, creating a registration form for users, and storing the form data in a mysql database for future lessons.', 'duration': 45.134, 'highlights': ['Creating a registration form for users to register to the site.', 'Storing all form data in a MySQL database for future lessons.', "Continuing with 'part two' to explore additional features for the community website.", 'Setting up the foundation for the community website.']}], 'duration': 232.789, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/aj2ugj0Tzz8/pics/aj2ugj0Tzz81058966.jpg', 'highlights': ['Running a script to create a table and transfer files using FileZilla.', 'Creating a favicon and transferring files to a server.', 'Running the script in a browser to create the table.', 'The main table for the foundation of the system has been successfully created in PHP.', "The file 'connect to MySQL' is crucial and will be accessed multiple times within the system.", 'Creating a registration form for users to register to the site.', 'Storing all form data in a MySQL database for future lessons.', 'Setting up the foundation for the community website.', 'Plans to create additional tables are mentioned for later tutorials in the series.', "Continuing with 'part two' to explore additional features for the community website."]}], 'highlights': ['Outlining a plan for creating a robust member system allowing mp3 and FLV uploads, picture uploads with a flash-based gallery.', 'Emphasizing the importance of using Linux and PHP hosting for the system and the need for free MySQL databases.', 'Promising a detailed tutorial series to avoid potential questions later and offering all source code free to viewers.', "Stressing the need to start with Linux and PHP hosting for the system's setup and mentioning the option to upgrade the database system if the performance decreases with increased membership.", 'Mentioning the need to go slow to ensure clarity and thoroughness in the tutorial series.', 'Completing the website in three to four days can prevent search engines from indexing the site before launch.', "It's crucial to build the website live on the actual hosting environment to avoid snags when switching servers.", 'Creating a database for text string data exclusively, emphasizing not storing media files in the database.', 'Checking PHP enablement and ensuring proper output before system setup.', 'Adding a member table with appropriate fields inside the database.', 'Explaining the addition of website and YouTube fields for members to embed their YouTube channel on their profile, planning multiple parts of the tutorial', 'Adding a website field and YouTube field to enable members to embed their YouTube channel directly on their profile', 'Allowing members to jump in and out of sections and go back to specific parts as needed', "The chapter explains setting up a MySQL connection and creating a table in a website's directory structure", 'Inclusion of connect to MySQL file and successful execution of database connection and table creation', 'Printing success message for successful database connection and table creation', 'The ID field is an integer with a length of 11 and auto-increments, currently holding a value of 11.', 'The text type field can hold up to 255 characters, while another text field can hold significantly more data.', "The account type is an enumerated field with default values of 'a', 'b', and 'c', allowing for different member types and special privileges.", 'The email activation serves as a security measure, with a value of 0 indicating account creation and 1 indicating successful email activation.', 'Running a script to create a table and transfer files using FileZilla.', 'Creating a favicon and transferring files to a server.', 'Running the script in a browser to create the table.', 'The main table for the foundation of the system has been successfully created in PHP.', "The file 'connect to MySQL' is crucial and will be accessed multiple times within the system.", 'Creating a registration form for users to register to the site.', 'Storing all form data in a MySQL database for future lessons.', 'Setting up the foundation for the community website.', 'Plans to create additional tables are mentioned for later tutorials in the series.', "Continuing with 'part two' to explore additional features for the community website."]}