title
Part 1: How to Build PHP and MySQL CMS Website Software

description
In this part of the lesson we create our MySQL database and quickly set up a default layout in Dreamweaver CS4, and tinker with the looks through CSS.

detail
{'title': 'Part 1: How to Build PHP and MySQL CMS Website Software', 'heatmap': [{'end': 544.088, 'start': 521.815, 'weight': 0.901}], 'summary': "Tutorial series 'how to build php and mysql cms website software' covers creating a mysql database for a custom content management system using php in seven steps, setting up mysql connection, creating a custom cms project, and demonstrating web design using fireworks cs4 and dreamweaver.", 'chapters': [{'end': 271.266, 'segs': [{'end': 128.162, 'src': 'embed', 'start': 84.036, 'weight': 0, 'content': [{'end': 89.279, 'text': "And cPanel, it's simple to create MySQL databases and connect to phpMyAdmin.", 'start': 84.036, 'duration': 5.243}, {'end': 91.34, 'text': "So that's what we're going to be doing.", 'start': 90.22, 'duration': 1.12}, {'end': 93.402, 'text': "We're going to create our database.", 'start': 91.36, 'duration': 2.042}, {'end': 96.163, 'text': "I'm going to follow these seven steps.", 'start': 94.462, 'duration': 1.701}, {'end': 102.047, 'text': "And then once I'm done creating my database, I'm going to click this link in step seven.", 'start': 96.604, 'duration': 5.443}, {'end': 105.236, 'text': 'which is going to show me how to connect to my database.', 'start': 102.895, 'duration': 2.341}, {'end': 114.598, 'text': "And here I put a little message about how we're going to be using the MySQL I family of functions rather than the old MySQL family of functions.", 'start': 106.156, 'duration': 8.442}, {'end': 120.46, 'text': "So here's the page that talks about the difference between the two.", 'start': 115.638, 'duration': 4.822}, {'end': 127.182, 'text': "And it'll explain why we're going to use the MySQL I family of functions.", 'start': 120.48, 'duration': 6.702}, {'end': 128.162, 'text': "It's very similar.", 'start': 127.382, 'duration': 0.78}], 'summary': 'Creating mysql database using cpanel in 7 steps', 'duration': 44.126, 'max_score': 84.036, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UUMq-yBVlrM/pics/UUMq-yBVlrM84036.jpg'}, {'end': 172.266, 'src': 'embed', 'start': 146.906, 'weight': 3, 'content': [{'end': 153.631, 'text': 'you take this little guy and you put your connection data from your server, from your mysql host, uh.', 'start': 146.906, 'duration': 6.725}, {'end': 161.737, 'text': "sorry, you put your mysql database information here from the newly created mysql database and if you don't know how to get connection data,", 'start': 153.631, 'duration': 8.106}, {'end': 172.266, 'text': 'to fill in all these lines with the database, host the username, and I put a little bit of hints here in the code in the comments there.', 'start': 164.144, 'duration': 8.122}], 'summary': 'Instructions for setting up a mysql database with hints provided.', 'duration': 25.36, 'max_score': 146.906, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UUMq-yBVlrM/pics/UUMq-yBVlrM146906.jpg'}, {'end': 271.266, 'src': 'embed', 'start': 242.131, 'weight': 4, 'content': [{'end': 248.217, 'text': "And I'm going to make that connection file by using the page on DevelopPHP.", 'start': 242.131, 'duration': 6.086}, {'end': 249.478, 'text': "I'm just going to grab all that script.", 'start': 248.257, 'duration': 1.221}, {'end': 251.799, 'text': 'Press Control-C.', 'start': 250.759, 'duration': 1.04}, {'end': 252.9, 'text': 'Highlight it all.', 'start': 252.28, 'duration': 0.62}, {'end': 253.801, 'text': 'Press Control-C.', 'start': 252.92, 'duration': 0.881}, {'end': 254.942, 'text': 'Go into Dreamweaver.', 'start': 254.061, 'duration': 0.881}, {'end': 258.345, 'text': 'Create New PHP.', 'start': 256.824, 'duration': 1.521}, {'end': 262.048, 'text': 'And then just get rid of all of that.', 'start': 260.065, 'duration': 1.983}, {'end': 271.266, 'text': "and put the code from the page in now i'm going to put my database host here uh.", 'start': 264.403, 'duration': 6.863}], 'summary': 'Creating a connection file using developphp, copying script, and adding database host.', 'duration': 29.135, 'max_score': 242.131, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UUMq-yBVlrM/pics/UUMq-yBVlrM242131.jpg'}], 'start': 12.466, 'title': 'Creating cms and using mysql i functions', 'summary': 'Covers creating a mysql database for a custom content management system using php, emphasizing seven steps to create the database and connect to phpmyadmin, as well as discussing the usage of the mysql i family of functions for connecting to a mysql database, including guidance on obtaining and using connection data and creating the connection file in dreamweaver.', 'chapters': [{'end': 105.236, 'start': 12.466, 'title': 'Creating cms with php and mysql', 'summary': 'Introduces creating a mysql database for a custom content management system using php, emphasizing the seven steps to create the database and connect to phpmyadmin.', 'duration': 92.77, 'highlights': ['The chapter emphasizes the process of creating a MySQL database for a custom content management system using PHP, which includes following seven steps to get it going.', "It mentions that hosts may use different control panel interfaces such as cPanel or custom control panels like GoDaddy's, but many hosts use cPanel which makes it simple to create MySQL databases and connect to phpMyAdmin.", 'The chapter highlights the importance of following the seven steps to create a MySQL database and provides a link in step seven to guide on connecting to the database.']}, {'end': 271.266, 'start': 106.156, 'title': 'Using mysql i family of functions', 'summary': 'Discusses the usage of the mysql i family of functions for connecting to a mysql database, emphasizing the importance of a connection include file and providing guidance on obtaining and using connection data, along with a demonstration of creating the connection file in dreamweaver.', 'duration': 165.11, 'highlights': ['The importance of using the MySQL I family of functions for connecting to a MySQL database is explained, emphasizing the usage of a connection include file.', 'Guidance is provided on obtaining and using connection data for the MySQL database, including hints on filling in the required information and the recommendation to contact web hosts for assistance.', 'A demonstration of creating the connection file in Dreamweaver is given, highlighting the process of obtaining the script from DevelopPHP and using it to create the connection file.']}], 'duration': 258.8, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UUMq-yBVlrM/pics/UUMq-yBVlrM12466.jpg', 'highlights': ['The chapter emphasizes the process of creating a MySQL database for a custom content management system using PHP, including following seven steps.', 'Many hosts use cPanel, making it simple to create MySQL databases and connect to phpMyAdmin.', 'The importance of using the MySQL I family of functions for connecting to a MySQL database is explained.', 'Guidance is provided on obtaining and using connection data for the MySQL database, including hints on filling in the required information.', 'A demonstration of creating the connection file in Dreamweaver is given, highlighting the process of obtaining the script from DevelopPHP and using it.']}, {'end': 539.286, 'segs': [{'end': 309.543, 'src': 'embed', 'start': 271.266, 'weight': 0, 'content': [{'end': 280.051, 'text': "which is a lot of the times it's a string that looks like mysql dot, some server dot net, and then a lot of the times it's localhost.", 'start': 271.266, 'duration': 8.785}, {'end': 291.497, 'text': 'some, a lot of servers use or hosting companies just connect to mysql through localhost and then you put your database username here and then the database password and then the database name,', 'start': 280.051, 'duration': 11.446}, {'end': 297.233, 'text': 'which is a lot of the times the same as the username, And then this line will connect it all.', 'start': 291.497, 'duration': 5.736}, {'end': 298.595, 'text': "You don't have to touch this line.", 'start': 297.514, 'duration': 1.081}, {'end': 300.836, 'text': "This line's already set up and ready to go.", 'start': 299.375, 'duration': 1.461}, {'end': 303.078, 'text': "It's going to be using these variables that you place in there.", 'start': 300.876, 'duration': 2.202}, {'end': 305.2, 'text': "So I'm going to do that now.", 'start': 304.199, 'duration': 1.001}, {'end': 305.981, 'text': "I'm going to change mine.", 'start': 305.22, 'duration': 0.761}, {'end': 309.543, 'text': 'Let me just go ahead and save this file to its location where I want it.', 'start': 306.781, 'duration': 2.762}], 'summary': 'Configuring mysql connection settings with localhost and database credentials.', 'duration': 38.277, 'max_score': 271.266, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UUMq-yBVlrM/pics/UUMq-yBVlrM271266.jpg'}, {'end': 372.663, 'src': 'embed', 'start': 344.009, 'weight': 2, 'content': [{'end': 347.671, 'text': "So here, let's go to new folder.", 'start': 344.009, 'duration': 3.662}, {'end': 352.514, 'text': "Let's call it, actually let's call this root.", 'start': 348.412, 'duration': 4.102}, {'end': 354.63, 'text': 'root directory.', 'start': 353.829, 'duration': 0.801}, {'end': 356.451, 'text': 'And this will be my root directory.', 'start': 354.99, 'duration': 1.461}, {'end': 363.396, 'text': 'Well, this will be my version of my root directory on my local machine.', 'start': 359.774, 'duration': 3.622}, {'end': 365.818, 'text': "But I'll be FTPing everything up to the web.", 'start': 364.077, 'duration': 1.741}, {'end': 368.56, 'text': "So let's go ahead and double click inside of that.", 'start': 366.258, 'duration': 2.302}, {'end': 369.701, 'text': "There's the root directory.", 'start': 368.72, 'duration': 0.981}, {'end': 370.782, 'text': "Let's make a new folder.", 'start': 369.741, 'duration': 1.041}, {'end': 372.663, 'text': 'Call it scripts.', 'start': 371.943, 'duration': 0.72}], 'summary': "Creating a root directory and a 'scripts' folder for ftp upload.", 'duration': 28.654, 'max_score': 344.009, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UUMq-yBVlrM/pics/UUMq-yBVlrM344009.jpg'}, {'end': 431.348, 'src': 'embed', 'start': 404.704, 'weight': 4, 'content': [{'end': 410.93, 'text': 'where are you MyCustomCMS root directory in the scripts folder?', 'start': 404.704, 'duration': 6.226}, {'end': 415.334, 'text': "So this connect file isn't going to be in the root directory.", 'start': 411.31, 'duration': 4.024}, {'end': 417.155, 'text': "It's going to be in the folder called scripts.", 'start': 415.354, 'duration': 1.801}, {'end': 418.937, 'text': "And we'll connect to it like that.", 'start': 417.876, 'duration': 1.061}, {'end': 422.56, 'text': 'Make the file name connect to MySQL.', 'start': 420.038, 'duration': 2.522}, {'end': 425.583, 'text': "It's already a PHP file, so we're going to need that extension there.", 'start': 423.02, 'duration': 2.563}, {'end': 431.348, 'text': "And unless you're in Notepad or WordPad, you might want to make sure it has a proper .", 'start': 426.824, 'duration': 4.524}], 'summary': 'The connect file for mycustomcms is located in the scripts folder and is named connect to mysql.php.', 'duration': 26.644, 'max_score': 404.704, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UUMq-yBVlrM/pics/UUMq-yBVlrM404704.jpg'}, {'end': 481.925, 'src': 'embed', 'start': 447.898, 'weight': 3, 'content': [{'end': 455.085, 'text': "Okay my little connect to MySQL file is successfully tested and it's saved to the location it should be saved.", 'start': 447.898, 'duration': 7.187}, {'end': 461.416, 'text': 'on the server and now all we have to do is build an index page.', 'start': 456.474, 'duration': 4.942}, {'end': 475.142, 'text': "let's go to create new php and we'll use the default doc type they have assigned there and let's go to.", 'start': 461.416, 'duration': 13.726}, {'end': 481.925, 'text': "and if you want to add your meta, keyword and description tags, that's up to you.", 'start': 475.142, 'duration': 6.783}], 'summary': 'Mysql file successfully tested, now building index page', 'duration': 34.027, 'max_score': 447.898, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UUMq-yBVlrM/pics/UUMq-yBVlrM447898.jpg'}], 'start': 271.266, 'title': 'Mysql connection and custom cms project', 'summary': "Discusses setting up a mysql connection, emphasizing the use of 'localhost' and the structure of the connection line, as well as creating a custom cms project, including setting up the root directory, creating a 'connect to mysql' file within the 'scripts' folder, and building an index page with basic structure and design.", 'chapters': [{'end': 309.543, 'start': 271.266, 'title': 'Setting up mysql connection', 'summary': "Discusses setting up a mysql connection, emphasizing the use of 'localhost' and the structure of the connection line, which is already set up and ready to go.", 'duration': 38.277, 'highlights': ["The connection string often includes 'localhost' and the database username, password, and name, which are sometimes the same.", 'The connection line is already set up and ready to go, using the variables placed in there.']}, {'end': 539.286, 'start': 310.144, 'title': 'Creating custom cms project', 'summary': "Discusses creating a custom cms project, including setting up the root directory, creating a 'connect to mysql' file within the 'scripts' folder, and building an index page with basic structure and design.", 'duration': 229.142, 'highlights': ["Creating a 'connect to MySQL' file within the 'scripts' folder in the root directory.", 'Setting up the root directory for the main site and FTPing the files to the web.', 'Building an index page with basic structure and design.']}], 'duration': 268.02, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UUMq-yBVlrM/pics/UUMq-yBVlrM271266.jpg', 'highlights': ['The connection line is already set up and ready to go, using the variables placed in there.', "The connection string often includes 'localhost' and the database username, password, and name, which are sometimes the same.", 'Setting up the root directory for the main site and FTPing the files to the web.', 'Building an index page with basic structure and design.', "Creating a 'connect to MySQL' file within the 'scripts' folder in the root directory."]}, {'end': 917.214, 'segs': [{'end': 587.938, 'src': 'embed', 'start': 564.188, 'weight': 0, 'content': [{'end': 573.475, 'text': 'I feel I should show some of you guys this, because you might not understand the relation to where these files are in relation to the site.', 'start': 564.188, 'duration': 9.287}, {'end': 575.216, 'text': "Okay, so I'm going to show you that right now.", 'start': 573.635, 'duration': 1.581}, {'end': 576.932, 'text': 'I made a little graphic here.', 'start': 575.731, 'duration': 1.201}, {'end': 578.292, 'text': "I'm in Fireworks CS4.", 'start': 576.992, 'duration': 1.3}, {'end': 580.814, 'text': 'I made a little logo image.', 'start': 578.613, 'duration': 2.201}, {'end': 583.475, 'text': 'And it has no background color.', 'start': 581.354, 'duration': 2.121}, {'end': 585.476, 'text': 'The canvas is set to no color.', 'start': 583.876, 'duration': 1.6}, {'end': 587.938, 'text': "And I'm going to save it as a PNG32.", 'start': 586.577, 'duration': 1.361}], 'summary': 'Demonstrating file location and saving logo as png32 in fireworks cs4.', 'duration': 23.75, 'max_score': 564.188, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UUMq-yBVlrM/pics/UUMq-yBVlrM564188.jpg'}, {'end': 647.281, 'src': 'embed', 'start': 621.127, 'weight': 1, 'content': [{'end': 627.789, 'text': "with that one in the root directory we're going to name this one style and then the style folder.", 'start': 621.127, 'duration': 6.662}, {'end': 638.618, 'text': "that's where we're going to have our CSS file, if we choose to have one and any images that go along with the template.", 'start': 627.789, 'duration': 10.829}, {'end': 640.639, 'text': "so let's go ahead and put it here.", 'start': 638.618, 'duration': 2.021}, {'end': 647.281, 'text': "logo that's a good name for it, logo.png, and it's a PNG 32 high quality.", 'start': 640.639, 'duration': 6.642}], 'summary': "Create 'style' folder in root directory for css file and images. place 'logo.png' (png 32) in it.", 'duration': 26.154, 'max_score': 621.127, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UUMq-yBVlrM/pics/UUMq-yBVlrM621127.jpg'}, {'end': 779.944, 'src': 'embed', 'start': 738.716, 'weight': 3, 'content': [{'end': 741.216, 'text': "now let's go to the page properties.", 'start': 738.716, 'duration': 2.5}, {'end': 743.317, 'text': 'add that background appearance.', 'start': 741.216, 'duration': 2.101}, {'end': 745.807, 'text': 'background image Strip BG.', 'start': 743.317, 'duration': 2.49}, {'end': 751.711, 'text': "Okay, let's do a couple more CSS design tweaks here in the design view.", 'start': 746.968, 'duration': 4.743}, {'end': 753.012, 'text': "Let's go to page properties.", 'start': 751.731, 'duration': 1.281}, {'end': 757.976, 'text': 'Appearance Text color.', 'start': 754.093, 'duration': 3.883}, {'end': 759.477, 'text': "Let's make that white.", 'start': 757.996, 'duration': 1.481}, {'end': 763.98, 'text': 'Looks good.', 'start': 762.479, 'duration': 1.501}, {'end': 765.021, 'text': 'Background image.', 'start': 764.08, 'duration': 0.941}, {'end': 771.206, 'text': 'Wait a second.', 'start': 770.725, 'duration': 0.481}, {'end': 779.944, 'text': "How's that background image even there? In the code, we have a body background image.", 'start': 771.286, 'duration': 8.658}], 'summary': 'Css design tweaks made to page properties, including setting text color to white.', 'duration': 41.228, 'max_score': 738.716, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UUMq-yBVlrM/pics/UUMq-yBVlrM738716.jpg'}, {'end': 883.136, 'src': 'embed', 'start': 851.483, 'weight': 4, 'content': [{'end': 852.984, 'text': 'Push that down with a rick tag as well.', 'start': 851.483, 'duration': 1.501}, {'end': 855.346, 'text': 'It looks good.', 'start': 854.826, 'duration': 0.52}, {'end': 862.066, 'text': 'You can even make the background of this cell black if you want.', 'start': 857.864, 'duration': 4.202}, {'end': 865.027, 'text': 'That way all your text will show up nice.', 'start': 863.307, 'duration': 1.72}, {'end': 869.089, 'text': 'And even on the menu system as well.', 'start': 867.669, 'duration': 1.42}, {'end': 872.811, 'text': "Let's make that background color like this dark brown.", 'start': 869.87, 'duration': 2.941}, {'end': 874.412, 'text': 'There we go.', 'start': 873.792, 'duration': 0.62}, {'end': 877.133, 'text': "It's ugly, but it works.", 'start': 876.093, 'duration': 1.04}, {'end': 878.774, 'text': "It's a quick design.", 'start': 878.054, 'duration': 0.72}, {'end': 883.136, 'text': 'Okay, so now we have everything in place.', 'start': 879.374, 'duration': 3.762}], 'summary': 'Quickly designed cell with dark brown background for better visibility.', 'duration': 31.653, 'max_score': 851.483, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UUMq-yBVlrM/pics/UUMq-yBVlrM851483.jpg'}], 'start': 539.326, 'title': 'Web design and css tweaks', 'summary': 'Provides a demonstration of web design using fireworks cs4 and dreamweaver, emphasizing the importance of file type and quality. it also discusses making css design tweaks to the webpage, including setting the background image and text color.', 'chapters': [{'end': 738.716, 'start': 539.326, 'title': 'Web design demonstration and file export', 'summary': 'Provides a demonstration of web design, including exporting files and folder organization, using fireworks cs4 and dreamweaver, emphasizing the importance of file type and quality for background images and logos.', 'duration': 199.39, 'highlights': ['The importance of file type and quality for background images and logos is emphasized, with a focus on using PNG32 for the logo to ensure high quality on any background.', 'The process of exporting files to the web using Fireworks CS4, including saving a logo as a PNG32 file with no background color, and exporting a background strip as a JPEG file.', "Demonstration of folder organization for web design, with specific emphasis on creating a 'style' folder for CSS files and images related to the template, and placing the logo and background images in the designated folder structure."]}, {'end': 917.214, 'start': 738.716, 'title': 'Css design tweaks and database population', 'summary': 'Discusses making css design tweaks to the webpage, including setting the background image and text color, and planning to pre-populate data into the mysql database for dynamic rendering in part two.', 'duration': 178.498, 'highlights': ['The chapter explains making CSS design tweaks, such as setting the background image and text color for the webpage, ensuring that the text color becomes white and adding background images through CSS rather than directly in the code.', 'It mentions the quick design process of making the background color of a cell dark brown and discusses pre-populating data into the MySQL database for dynamic rendering of the menu system in part two of the video series.']}], 'duration': 377.888, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/UUMq-yBVlrM/pics/UUMq-yBVlrM539326.jpg', 'highlights': ['The importance of file type and quality for background images and logos is emphasized, with a focus on using PNG32 for the logo to ensure high quality on any background.', "Demonstration of folder organization for web design, with specific emphasis on creating a 'style' folder for CSS files and images related to the template, and placing the logo and background images in the designated folder structure.", 'The process of exporting files to the web using Fireworks CS4, including saving a logo as a PNG32 file with no background color, and exporting a background strip as a JPEG file.', 'The chapter explains making CSS design tweaks, such as setting the background image and text color for the webpage, ensuring that the text color becomes white and adding background images through CSS rather than directly in the code.', 'It mentions the quick design process of making the background color of a cell dark brown and discusses pre-populating data into the MySQL database for dynamic rendering of the menu system in part two of the video series.']}], 'highlights': ['The chapter emphasizes the process of creating a MySQL database for a custom content management system using PHP, including following seven steps.', 'Many hosts use cPanel, making it simple to create MySQL databases and connect to phpMyAdmin.', 'The importance of using the MySQL I family of functions for connecting to a MySQL database is explained.', 'The importance of file type and quality for background images and logos is emphasized, with a focus on using PNG32 for the logo to ensure high quality on any background.', "Demonstration of folder organization for web design, with specific emphasis on creating a 'style' folder for CSS files and images related to the template, and placing the logo and background images in the designated folder structure."]}