title
10. Build a Web App - Step 1 - MySQL/PHP

description
http://goo.gl/BBse40 - Design + Code a Professional Android App from Scratch http://www.designcourse.com/videos/how-to-make-a-web-app-step-1-mysql-php-part-10/86 - Now let's get things working a bit with PHP/MySQL. Follow us: Facebook: http://www.facebook.com/designcourses Twitter: http://twitter.com/designcoursecom Google+: http://plus.google.com/+DesignCourse Dribbble: http://dribbble.com/designcourse - - - - - - - - - - - - - - - - - - - - - - Subscribe for NEW VIDEOS weekly! My site: https://designcourse.com My personal FB account: http://fb.com/logodesigner Coursetro FB: http://fb.com/coursetro Coursetro's Twitter: http://twitter.com/designcoursecom Join my Discord! https://discord.gg/a27CKAF ^-Chat with me and others - - - - - - - - - - - - - - - - - - - - - - Who is Gary Simon? Well, I'm a full stack developer with 2+ decades experience and I teach people how to design and code. I've created around 100+ courses for big brands like LinkedIn, Lynda.com, Pluralsight and Envato Network. Now, I focus all of my time and energy on this channel and my website Coursetro.com. Come to my discord server or add me on social media and say Hi!

detail
{'title': '10. Build a Web App - Step 1 - MySQL/PHP', 'heatmap': [{'end': 123.713, 'start': 49.983, 'weight': 0.708}, {'end': 170.785, 'start': 131.777, 'weight': 0.718}, {'end': 210.058, 'start': 185.495, 'weight': 0.885}, {'end': 1415.915, 'start': 1373.319, 'weight': 0.768}], 'summary': "Tutorial series 'build a web app' covers creating mysql tables and database, setting up user table, integrating php and form validation, and css styling with focus on user input validation and alert box styling.", 'chapters': [{'end': 54.346, 'segs': [{'end': 54.346, 'src': 'embed', 'start': 12.5, 'weight': 0, 'content': [{'end': 14.663, 'text': 'Hello, Gary Simon here of designcourse.com.', 'start': 12.5, 'duration': 2.163}, {'end': 22.092, 'text': "today we're going to create our actual MySQL tables and the table structures, and so, basically,", 'start': 14.663, 'duration': 7.429}, {'end': 27.979, 'text': "this is a step that we're going to need to have done before we actually mess around with any type of PHP.", 'start': 22.092, 'duration': 5.887}, {'end': 30.362, 'text': 'alright so, in making the site basically active.', 'start': 27.979, 'duration': 2.383}, {'end': 35.287, 'text': "So if you've never messed around with MySQL, well, basically you do need to have a host.", 'start': 30.842, 'duration': 4.445}, {'end': 36.989, 'text': 'You can set it up locally.', 'start': 35.708, 'duration': 1.281}, {'end': 39.612, 'text': "I've never done it, but I've always just used a host.", 'start': 37.47, 'duration': 2.142}, {'end': 44.958, 'text': 'And usually, basically every host out there, they offer MySQL databases.', 'start': 39.852, 'duration': 5.106}, {'end': 49.983, 'text': "So you'll have to log into your host control panel to kind of figure out how to do that,", 'start': 45.399, 'duration': 4.584}, {'end': 54.346, 'text': "and I'm going to be using PHPMyAdmin to basically set up those tables.", 'start': 49.983, 'duration': 4.363}], 'summary': 'Creating mysql tables and structures for website, using phpmyadmin.', 'duration': 41.846, 'max_score': 12.5, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM12500.jpg'}], 'start': 12.5, 'title': 'Mysql table creation', 'summary': 'Covers the process of creating mysql tables and their structures for site functionality, emphasizing the need for a host and the use of phpmyadmin to set up tables.', 'chapters': [{'end': 54.346, 'start': 12.5, 'title': 'Mysql table creation', 'summary': 'Covers the process of creating mysql tables and their structures for site functionality, emphasizing the need for a host and the use of phpmyadmin to set up tables.', 'duration': 41.846, 'highlights': ['Creating MySQL tables and their structures is essential before working with PHP to make the site active.', 'Having a host with MySQL databases is necessary for this process.', 'PHPMyAdmin is used to set up the tables.']}], 'duration': 41.846, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM12500.jpg', 'highlights': ['Creating MySQL tables and their structures is essential before working with PHP to make the site active.', 'Having a host with MySQL databases is necessary for this process.', 'PHPMyAdmin is used to set up the tables.']}, {'end': 254.606, 'segs': [{'end': 102.732, 'src': 'embed', 'start': 54.806, 'weight': 0, 'content': [{'end': 60.129, 'text': "Alright, so yeah, check out designcourse.com if you haven't yet and subscribe here on YouTube.", 'start': 54.806, 'duration': 5.323}, {'end': 60.81, 'text': "Alright, let's get started.", 'start': 60.15, 'duration': 0.66}, {'end': 64.779, 'text': "All right, so I'm going to be jumping all over the place on this,", 'start': 61.775, 'duration': 3.004}, {'end': 74.17, 'text': 'but my goal is to basically get the first and second step done today in terms of making it actually work and saving it to a database and all that stuff.', 'start': 64.779, 'duration': 9.391}, {'end': 78.596, 'text': "So I'm going to get out a browser here.", 'start': 75.372, 'duration': 3.224}, {'end': 84.162, 'text': "Alright, so basically, let's go back to the index.", 'start': 80.12, 'duration': 4.042}, {'end': 94.465, 'text': 'The first step, you know, they enter their needs, they can offer, you know, whatever, put in here, separated by comma, and click on find matches.', 'start': 84.202, 'duration': 10.263}, {'end': 98.287, 'text': "So there's a few things that have to take place after they click that.", 'start': 94.525, 'duration': 3.762}, {'end': 102.732, 'text': "So first, I'm going to switch over here.", 'start': 98.847, 'duration': 3.885}], 'summary': 'The goal is to complete the first and second steps of a project, including saving to a database and implementing a matching feature.', 'duration': 47.926, 'max_score': 54.806, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM54806.jpg'}, {'end': 172.907, 'src': 'heatmap', 'start': 131.777, 'weight': 2, 'content': [{'end': 137.14, 'text': 'So you will need basically also the MySQL address.', 'start': 131.777, 'duration': 5.363}, {'end': 149.908, 'text': "So, if you real quickly download the project files and trying to get out the right window here, there's a new folder that I've included in it,", 'start': 137.741, 'duration': 12.167}, {'end': 155.773, 'text': 'so this is called include and it has two files, basically.', 'start': 149.908, 'duration': 5.865}, {'end': 161.638, 'text': "so this DB, as in database, this is something that we're going to be including on the top of every page.", 'start': 155.773, 'duration': 5.865}, {'end': 165, 'text': 'so index.php will include it up here.', 'start': 161.638, 'duration': 3.362}, {'end': 168.583, 'text': 'what this does is it connects to the MySQL server.', 'start': 165, 'duration': 3.583}, {'end': 170.785, 'text': "so you're going to need four pieces of information.", 'start': 168.583, 'duration': 2.202}, {'end': 172.907, 'text': "you're going to need your host name and your.", 'start': 170.785, 'duration': 2.122}], 'summary': "The project includes an 'include' folder with two files to connect to the mysql server, requiring four pieces of information.", 'duration': 48.874, 'max_score': 131.777, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM131777.jpg'}, {'end': 213.324, 'src': 'heatmap', 'start': 185.495, 'weight': 0.885, 'content': [{'end': 190.078, 'text': "So the second file is just this class I've used for years upon years upon years.", 'start': 185.495, 'duration': 4.583}, {'end': 199.744, 'text': 'And it just makes basically taking PHP and querying the database make it a little bit easier.', 'start': 190.879, 'duration': 8.865}, {'end': 201.766, 'text': "So that's something I've used forever.", 'start': 200.365, 'duration': 1.401}, {'end': 203.087, 'text': 'So, yeah.', 'start': 202.506, 'duration': 0.581}, {'end': 210.058, 'text': 'Basically, this stuff down here will actually do the connecting stuff from up here.', 'start': 203.988, 'duration': 6.07}, {'end': 213.324, 'text': "Real quickly, what I'll do is..", 'start': 210.078, 'duration': 3.246}], 'summary': 'A class used for years to simplify php database querying.', 'duration': 27.829, 'max_score': 185.495, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM185495.jpg'}], 'start': 54.806, 'title': 'Building database and setting up mysql', 'summary': 'Covers building website functionality to save data to a database and setting up a mysql database including specifying name, attaching user, and obtaining connection details.', 'chapters': [{'end': 102.732, 'start': 54.806, 'title': 'Building database functionality', 'summary': 'Focuses on building the first and second steps of a website, aiming to make it work and save data to a database, following a process of entering needs and offers, then finding matches.', 'duration': 47.926, 'highlights': ['The goal is to get the first and second step done today to make it work and save it to a database.', "The process involves users entering their needs and offers, separated by comma, and clicking on 'find matches'."]}, {'end': 254.606, 'start': 103.973, 'title': 'Setting up mysql database for website', 'summary': 'Explains how to create a mysql database, including specifying the name, attaching a mysql user, and obtaining the necessary information for connection, such as the host name, username, password, and database name.', 'duration': 150.633, 'highlights': ['Explaining the process of creating a MySQL database and connecting it to the website. The chapter explains the process of creating a MySQL database, specifying the name, attaching a MySQL user, and obtaining the necessary connection information such as the host name, username, password, and database name.', 'Describing the necessity of four pieces of information for connecting to the MySQL server. The necessity of four pieces of information for connecting to the MySQL server is emphasized, including the host name, username, password, and database name.', 'Including a file for connecting to the MySQL server and a class for querying the database. The inclusion of a file for connecting to the MySQL server and a class for querying the database is mentioned, which facilitates the process of connecting and querying the database.']}], 'duration': 199.8, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM54806.jpg', 'highlights': ["The process involves users entering their needs and offers, separated by comma, and clicking on 'find matches'.", 'The goal is to get the first and second step done today to make it work and save it to a database.', 'Describing the necessity of four pieces of information for connecting to the MySQL server.', 'Explaining the process of creating a MySQL database and connecting it to the website.', 'Including a file for connecting to the MySQL server and a class for querying the database.']}, {'end': 553.887, 'segs': [{'end': 363.03, 'src': 'embed', 'start': 332.367, 'weight': 0, 'content': [{'end': 336.89, 'text': 'So these three things, they enter on the second step and then just date added.', 'start': 332.367, 'duration': 4.523}, {'end': 339.872, 'text': 'This is just a field that we can specify.', 'start': 337.19, 'duration': 2.682}, {'end': 342.316, 'text': 'about when they actually joined.', 'start': 340.753, 'duration': 1.563}, {'end': 349.329, 'text': 'So what we want to do is create the table name right here, and that is going to be users.', 'start': 342.456, 'duration': 6.873}, {'end': 351.633, 'text': 'Number of fields is five.', 'start': 350.03, 'duration': 1.603}, {'end': 355.967, 'text': 'All right, so the first field is ID.', 'start': 354.226, 'duration': 1.741}, {'end': 357.807, 'text': 'And then you have the type.', 'start': 356.867, 'duration': 0.94}, {'end': 363.03, 'text': "Now, if you never mess with MySQL, there's a lot of different data or basically row types.", 'start': 357.868, 'duration': 5.162}], 'summary': "Creating a table named 'users' with five fields including 'id' using mysql.", 'duration': 30.663, 'max_score': 332.367, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM332367.jpg'}, {'end': 528.118, 'src': 'embed', 'start': 497.363, 'weight': 1, 'content': [{'end': 502.548, 'text': 'So what you have to do in that case is look for when that form is submitted.', 'start': 497.363, 'duration': 5.185}, {'end': 503.749, 'text': 'All right.', 'start': 502.568, 'duration': 1.181}, {'end': 505.831, 'text': "So there's a few ways you could do it.", 'start': 503.869, 'duration': 1.962}, {'end': 511.717, 'text': 'I usually I just get out like, for example, I need I offer this name.', 'start': 505.851, 'duration': 5.866}, {'end': 518.404, 'text': 'What you could do is if is set.', 'start': 512.258, 'duration': 6.146}, {'end': 524.709, 'text': 'and then post because our we have the method is post right here.', 'start': 520.077, 'duration': 4.632}, {'end': 528.118, 'text': 'And then inside you could put the name of the field.', 'start': 524.729, 'duration': 3.389}], 'summary': "To detect form submission, use 'if is set' and 'post' method with the field name.", 'duration': 30.755, 'max_score': 497.363, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM497363.jpg'}], 'start': 255.487, 'title': 'Creating a users table in mysql', 'summary': 'Covers the process of creating a users table in mysql, including defining fields such as id, email, city, state, and date added, and explains the form submission process in php.', 'chapters': [{'end': 553.887, 'start': 255.487, 'title': 'Creating users table in mysql', 'summary': 'Covers the process of creating a users table in mysql, including defining the fields and their types, such as id, email, city, state, and date added, and explains the form submission process in php.', 'duration': 298.4, 'highlights': ['Creating the users table in MySQL The chapter demonstrates the process of creating a users table in MySQL, including defining the fields and their types.', 'Defining the fields and their types The chapter explains the fields and their types, such as ID, email, city, state, and date added.', "Explaining the form submission process in PHP The chapter provides an explanation of the form submission process in PHP, including the use of 'form action' and 'if isset' for form submission handling."]}], 'duration': 298.4, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM255487.jpg', 'highlights': ['Creating the users table in MySQL The chapter demonstrates the process of creating a users table in MySQL, including defining the fields and their types.', "Explaining the form submission process in PHP The chapter provides an explanation of the form submission process in PHP, including the use of 'form action' and 'if isset' for form submission handling.", 'Defining the fields and their types The chapter explains the fields and their types, such as ID, email, city, state, and date added.']}, {'end': 928.897, 'segs': [{'end': 608.3, 'src': 'embed', 'start': 553.947, 'weight': 0, 'content': [{'end': 559.79, 'text': "So, Basically, if is set, that means if it's a, if it exists and it will exist.", 'start': 553.947, 'duration': 5.843}, {'end': 567.293, 'text': 'if they click the fine matches button, Then whatever we specify in here will occur alright.', 'start': 559.79, 'duration': 7.503}, {'end': 577.059, 'text': "so just a quick example I We put echo and we'll put yay, submitted and All right, just like that.", 'start': 567.293, 'duration': 9.766}, {'end': 582.486, 'text': "And if we save this, I'm going to bring, I'm going to pause real quick so I can get those files.", 'start': 577.78, 'duration': 4.706}, {'end': 589.015, 'text': "Okay So I've transferred all these new files over to butterfly.com and we bring up the browser.", 'start': 583.187, 'duration': 5.828}, {'end': 598.116, 'text': "Basically, as you can see, we don't have that yay submitted thing here because it hasn't actually been submitted.", 'start': 591.394, 'duration': 6.722}, {'end': 602.358, 'text': 'But if we hit find matches, we see that it says yay submitted.', 'start': 598.536, 'duration': 3.822}, {'end': 604.738, 'text': "So that's roughly how that works.", 'start': 602.478, 'duration': 2.26}, {'end': 608.3, 'text': "If you never mess with PHP and MySQL, then yeah, that's very handy.", 'start': 604.778, 'duration': 3.522}], 'summary': "A demonstration of conditional behavior in php and mysql, showing how 'yay submitted' is displayed upon clicking 'find matches'.", 'duration': 54.353, 'max_score': 553.947, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM553947.jpg'}, {'end': 663.206, 'src': 'embed', 'start': 629.703, 'weight': 3, 'content': [{'end': 635.165, 'text': 'We want to display some type of message that lets them know, hey, both fields are required.', 'start': 629.703, 'duration': 5.462}, {'end': 639.826, 'text': 'So the field names are I need and I offer.', 'start': 635.505, 'duration': 4.321}, {'end': 643.468, 'text': "So what we want to make sure of is they're not empty.", 'start': 639.906, 'duration': 3.562}, {'end': 659.245, 'text': 'So, instead of just checking to see if it was submitted at all, the first thing we want to do is, instead of is set, We can put uh,', 'start': 643.688, 'duration': 15.557}, {'end': 663.206, 'text': "if post I need doesn't equal, and that's the sign for that.", 'start': 659.245, 'duration': 3.961}], 'summary': "Ensure both 'i need' and 'i offer' fields are not empty.", 'duration': 33.503, 'max_score': 629.703, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM629703.jpg'}, {'end': 865.999, 'src': 'embed', 'start': 829.979, 'weight': 5, 'content': [{'end': 831.5, 'text': 'Yeah The div class alert.', 'start': 829.979, 'duration': 1.521}, {'end': 835.704, 'text': 'So basically inside here we can put PHP.', 'start': 832.221, 'duration': 3.483}, {'end': 848.964, 'text': 'If is set error MSG, echo error msg, all right.', 'start': 835.924, 'duration': 13.04}, {'end': 852.667, 'text': "so actually, you know, i think i'm going to change how that works one second.", 'start': 848.964, 'duration': 3.703}, {'end': 855.289, 'text': "i'm going to copy this portion.", 'start': 852.667, 'duration': 2.622}, {'end': 865.999, 'text': "i'm just going to put echo error msg and then outside of this, just above the div, we're going to put php and then paste that area right here.", 'start': 855.289, 'duration': 10.71}], 'summary': 'The transcript discusses php code changes for error messages placement.', 'duration': 36.02, 'max_score': 829.979, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM829979.jpg'}], 'start': 553.947, 'title': 'Php integration and form validation', 'summary': "Explains the 'fine matches' button functionality in a php and mysql program, demonstrating specified actions upon clicking the button. it also discusses form field validation to ensure completion of 'i need' and 'i offer' fields, with error message implementation using php and html.", 'chapters': [{'end': 608.3, 'start': 553.947, 'title': 'Php and mysql integration', 'summary': "Explains the functionality of a 'fine matches' button in a php and mysql program, demonstrating the occurrence of specified actions upon clicking the button and the practicality of the integration for those unfamiliar with php and mysql.", 'duration': 54.353, 'highlights': ["The 'fine matches' button triggers specified actions upon clicking, demonstrating practical functionality. If clicked, it displays 'yay submitted'.", "Transferring new files to butterfly.com and bringing up the browser, the absence of 'yay submitted' is observed until the 'fine matches' button is clicked, showcasing the dynamic behavior of the program.", 'Demonstrates the practicality of PHP and MySQL integration for individuals not experienced with these technologies.']}, {'end': 928.897, 'start': 609.773, 'title': 'Form field validation and error handling', 'summary': "Discusses the validation of form fields to ensure both 'i need' and 'i offer' fields are filled out, and the implementation of error messages to prompt users when the fields are left blank, using php and html.", 'duration': 319.124, 'highlights': ["Implementing form field validation to ensure both 'I need' and 'I offer' fields are filled out is crucial to prevent saving incomplete data. Ensuring that both 'I need' and 'I offer' fields are required to be filled out to prevent saving incomplete data.", "Utilizing error messages to prompt users when the fields are left blank is essential for providing a clear indication of missing information. Implementing error messages to prompt users when 'I need' and 'I offer' fields are left blank to provide a clear indication of missing information.", 'Demonstrating the use of PHP and HTML to create error messages and alert users about the incomplete fields. Demonstrating the use of PHP and HTML to create error messages and alert users about the incomplete fields, ensuring a clear indication of missing information.']}], 'duration': 374.95, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM553947.jpg', 'highlights': ["The 'fine matches' button triggers specified actions upon clicking, demonstrating practical functionality. If clicked, it displays 'yay submitted'.", "Transferring new files to butterfly.com and bringing up the browser, the absence of 'yay submitted' is observed until the 'fine matches' button is clicked, showcasing the dynamic behavior of the program.", 'Demonstrates the practicality of PHP and MySQL integration for individuals not experienced with these technologies.', "Implementing form field validation to ensure both 'I need' and 'I offer' fields are filled out is crucial to prevent saving incomplete data. Ensuring that both 'I need' and 'I offer' fields are required to be filled out to prevent saving incomplete data.", "Utilizing error messages to prompt users when the fields are left blank is essential for providing a clear indication of missing information. Implementing error messages to prompt users when 'I need' and 'I offer' fields are left blank to provide a clear indication of missing information.", 'Demonstrating the use of PHP and HTML to create error messages and alert users about the incomplete fields, ensuring a clear indication of missing information.']}, {'end': 1675.423, 'segs': [{'end': 956.427, 'src': 'embed', 'start': 928.957, 'weight': 4, 'content': [{'end': 934.402, 'text': "Now it's going to work if they're either both left blank or just one is left blank.", 'start': 928.957, 'duration': 5.445}, {'end': 937.865, 'text': 'You can also style this a little bit better.', 'start': 935.163, 'duration': 2.702}, {'end': 939.807, 'text': 'Obviously, that looks terrible.', 'start': 938.386, 'duration': 1.421}, {'end': 942.489, 'text': "I'll go ahead and do that real quick.", 'start': 940.488, 'duration': 2.001}, {'end': 943.871, 'text': "Let's see here.", 'start': 943.23, 'duration': 0.641}, {'end': 948.376, 'text': "Let's go to that was called alert.", 'start': 944.551, 'duration': 3.825}, {'end': 950.84, 'text': "All right, so let's get out our CSS.", 'start': 949.077, 'duration': 1.763}, {'end': 953.383, 'text': 'Come down here.', 'start': 952.602, 'duration': 0.781}, {'end': 956.427, 'text': "I'll put this over here.", 'start': 955.586, 'duration': 0.841}], 'summary': 'Improving styling and functionality for handling empty fields.', 'duration': 27.47, 'max_score': 928.957, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM928957.jpg'}, {'end': 1146.643, 'src': 'embed', 'start': 1108.719, 'weight': 3, 'content': [{'end': 1113.501, 'text': "So if, let me just copy that real quick so I'm not typing out all these.", 'start': 1108.719, 'duration': 4.782}, {'end': 1127.986, 'text': "If character count I need is greater than, we'll say three, and then the same thing basically with the different variable name.", 'start': 1114.921, 'duration': 13.065}, {'end': 1132.928, 'text': 'I offer.', 'start': 1132.387, 'duration': 0.541}, {'end': 1141.797, 'text': 'And then inside here is where they will proceed to the next step.', 'start': 1137.733, 'duration': 4.064}, {'end': 1146.643, 'text': 'And then we can put an else right here and put another error message.', 'start': 1142.358, 'duration': 4.285}], 'summary': 'Creating a condition for character count with a threshold of three, followed by error handling.', 'duration': 37.924, 'max_score': 1108.719, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM1108719.jpg'}, {'end': 1303.654, 'src': 'embed', 'start': 1230.562, 'weight': 1, 'content': [{'end': 1237.306, 'text': "And the reason we're going to save it in a session is because they haven't yet entered their email or anything.", 'start': 1230.562, 'duration': 6.744}, {'end': 1243.13, 'text': 'So this session variable will get sent off to the second step basically.', 'start': 1237.426, 'duration': 5.704}, {'end': 1246.692, 'text': 'So first we have to create those session variables.', 'start': 1243.33, 'duration': 3.362}, {'end': 1272.098, 'text': "So what we want to do is put session and we'll just call this I need equals And what we can do is put post I need, I offer, all right, right there.", 'start': 1246.792, 'duration': 25.306}, {'end': 1279.153, 'text': "And then once we've saved that, then what we can do is redirect them to that second step.", 'start': 1273.089, 'duration': 6.064}, {'end': 1280.234, 'text': 'All right.', 'start': 1279.954, 'duration': 0.28}, {'end': 1293.884, 'text': "So what we'll do is header location, and this is also where we're going to put in, uh, an HT access file.", 'start': 1280.334, 'duration': 13.55}, {'end': 1297.527, 'text': "So let's go to file new file.", 'start': 1295.506, 'duration': 2.021}, {'end': 1301.43, 'text': "We'll save this as dot HT access.", 'start': 1298.107, 'duration': 3.323}, {'end': 1303.654, 'text': 'All right.', 'start': 1303.294, 'duration': 0.36}], 'summary': 'Creating session variables for user input and redirecting to second step.', 'duration': 73.092, 'max_score': 1230.562, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM1230562.jpg'}, {'end': 1415.915, 'src': 'heatmap', 'start': 1373.319, 'weight': 0.768, 'content': [{'end': 1377.883, 'text': "And then we'll put in the actual file name step dash two dot PHP.", 'start': 1373.319, 'duration': 4.564}, {'end': 1380.806, 'text': 'And then just put L right here.', 'start': 1378.704, 'duration': 2.102}, {'end': 1383.328, 'text': "I can't describe everything or explain everything.", 'start': 1380.926, 'duration': 2.402}, {'end': 1384.769, 'text': "It's just how I've done it.", 'start': 1383.568, 'duration': 1.201}, {'end': 1385.429, 'text': 'I know it works.', 'start': 1384.789, 'duration': 0.64}, {'end': 1387.951, 'text': "So I yeah, we'll save that.", 'start': 1385.469, 'duration': 2.482}, {'end': 1390.093, 'text': "And we'll see if this works.", 'start': 1388.872, 'duration': 1.221}, {'end': 1396.939, 'text': 'So let me go ahead to here, just drag the htaccess file in to the root.', 'start': 1391.494, 'duration': 5.445}, {'end': 1407.228, 'text': "And if we go to and just type in, what was it final step? All right, we'll see that it works.", 'start': 1397.98, 'duration': 9.248}, {'end': 1412.552, 'text': "Oh, and that's showing up because I don't have that if step, step, whatever.", 'start': 1408.409, 'duration': 4.143}, {'end': 1415.915, 'text': 'Alright, so now what we can do is come over here.', 'start': 1412.992, 'duration': 2.923}], 'summary': 'Setting up file naming and testing for functionality.', 'duration': 42.596, 'max_score': 1373.319, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM1373319.jpg'}, {'end': 1623.339, 'src': 'embed', 'start': 1577.768, 'weight': 0, 'content': [{'end': 1590.448, 'text': "we're going to call it session session dot inc, dot php and inside of here we're going to put, uh, opening a php tag.", 'start': 1577.768, 'duration': 12.68}, {'end': 1605.062, 'text': "we're going to put at session start because you have to start the session in order for it to be carried on through the different pages and we'll just save that and then include.", 'start': 1590.448, 'duration': 14.614}, {'end': 1623.339, 'text': "we'll require once that and save that and also same thing here as well,", 'start': 1614.795, 'duration': 8.544}], 'summary': 'Creating a session in php for carrying data across pages.', 'duration': 45.571, 'max_score': 1577.768, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM1577768.jpg'}], 'start': 928.957, 'title': 'Css styling and user input validation', 'summary': 'Covers the styling of an alert box in css, including font weight, alignment, color, and padding, and demonstrates creating user input validation with a focus on entries with more than three characters, session variable handling, url rewriting, and session management across pages.', 'chapters': [{'end': 1040.089, 'start': 928.957, 'title': 'Styling alert box in css', 'summary': 'Demonstrates styling an alert box in css, adjusting its font weight, text alignment, background color, and padding, with a particular focus on making it visually appealing.', 'duration': 111.132, 'highlights': ['The chapter demonstrates styling an alert box in CSS, adjusting its font weight, text alignment, background color, and padding, with a particular focus on making it visually appealing.', 'The alert box is styled using CSS with properties such as text-align, font-weight, background color, and padding, with specific values mentioned including 700 for font weight and 10 pixels for padding.', 'The CSS is saved and applied to index.php, resulting in a visually appealing alert box with noticeable changes.']}, {'end': 1675.423, 'start': 1040.43, 'title': 'Creating user input validation and session management', 'summary': 'Discusses creating input validation to allow only entries with more than three characters, saving input in session variables, and using ht access file for url rewriting. it also covers checking session variables and implementing session management to carry them across different pages.', 'duration': 634.993, 'highlights': ['Creating input validation to allow only entries with more than three characters The speaker discusses using a function to count the characters entered by a person, and implementing an if statement to allow proceeding only if the character count is greater than three.', "Saving input in session variables for sending to the next step The chapter explains the process of saving input in session variables to send them to the second step, ensuring that the session variable will get sent off to the next step, and creating session variables 'I need' and 'I offer'.", 'Using HT access file for URL rewriting The speaker demonstrates the use of an HT access file for URL rewriting, discussing the process of creating a rewrite rule to make the URL appear more user-friendly and redirecting to the second step using the HT access file.', 'Checking session variables and implementing session management The chapter covers the process of checking the presence of session variables and implementing session management to carry them across different pages, including the creation of a session include file and starting the session to carry it through different pages.']}], 'duration': 746.466, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/JPFrxV1TVfM/pics/JPFrxV1TVfM928957.jpg', 'highlights': ['The chapter covers the process of checking the presence of session variables and implementing session management to carry them across different pages, including the creation of a session include file and starting the session to carry it through different pages.', 'Using HT access file for URL rewriting, creating a rewrite rule to make the URL appear more user-friendly and redirecting to the second step using the HT access file.', "Saving input in session variables to send them to the second step, ensuring that the session variable will get sent off to the next step, and creating session variables 'I need' and 'I offer'.", 'Creating input validation to allow only entries with more than three characters, using a function to count the characters entered by a person, and implementing an if statement to allow proceeding only if the character count is greater than three.', 'The chapter demonstrates styling an alert box in CSS, adjusting its font weight, text alignment, background color, and padding, with a particular focus on making it visually appealing.']}], 'highlights': ['Creating MySQL tables and their structures is essential before working with PHP to make the site active.', 'Having a host with MySQL databases is necessary for this process.', 'PHPMyAdmin is used to set up the tables.', "The process involves users entering their needs and offers, separated by comma, and clicking on 'find matches'.", 'The goal is to get the first and second step done today to make it work and save it to a database.', 'Describing the necessity of four pieces of information for connecting to the MySQL server.', 'Explaining the process of creating a MySQL database and connecting it to the website.', 'Including a file for connecting to the MySQL server and a class for querying the database.', 'Creating the users table in MySQL The chapter demonstrates the process of creating a users table in MySQL, including defining the fields and their types.', "Explaining the form submission process in PHP The chapter provides an explanation of the form submission process in PHP, including the use of 'form action' and 'if isset' for form submission handling.", 'Defining the fields and their types The chapter explains the fields and their types, such as ID, email, city, state, and date added.', "The 'fine matches' button triggers specified actions upon clicking, demonstrating practical functionality. If clicked, it displays 'yay submitted'.", "Transferring new files to butterfly.com and bringing up the browser, the absence of 'yay submitted' is observed until the 'fine matches' button is clicked, showcasing the dynamic behavior of the program.", 'Demonstrates the practicality of PHP and MySQL integration for individuals not experienced with these technologies.', "Implementing form field validation to ensure both 'I need' and 'I offer' fields are filled out is crucial to prevent saving incomplete data. Ensuring that both 'I need' and 'I offer' fields are required to be filled out to prevent saving incomplete data.", "Utilizing error messages to prompt users when the fields are left blank is essential for providing a clear indication of missing information. Implementing error messages to prompt users when 'I need' and 'I offer' fields are left blank to provide a clear indication of missing information.", 'Demonstrating the use of PHP and HTML to create error messages and alert users about the incomplete fields, ensuring a clear indication of missing information.', 'The chapter covers the process of checking the presence of session variables and implementing session management to carry them across different pages, including the creation of a session include file and starting the session to carry it through different pages.', 'Using HT access file for URL rewriting, creating a rewrite rule to make the URL appear more user-friendly and redirecting to the second step using the HT access file.', "Saving input in session variables to send them to the second step, ensuring that the session variable will get sent off to the next step, and creating session variables 'I need' and 'I offer'.", 'Creating input validation to allow only entries with more than three characters, using a function to count the characters entered by a person, and implementing an if statement to allow proceeding only if the character count is greater than three.', 'The chapter demonstrates styling an alert box in CSS, adjusting its font weight, text alignment, background color, and padding, with a particular focus on making it visually appealing.']}