title
Intro: How to Build Custom PHP and MySQL CMS Website Software
description
Introduction for new series we are about to launch to show the foundation for systems like Wordpress or Joomla. Dynamic PHP and MySQL Content Management System Websites that use Javascript WYSIWYG rich text editors to populate and edit website pages.
detail
{'title': 'Intro: How to Build Custom PHP and MySQL CMS Website Software', 'heatmap': [{'end': 239.37, 'start': 185.803, 'weight': 0.952}, {'end': 317.107, 'start': 290.467, 'weight': 0.796}], 'summary': 'Learn about raw data management systems like joomla and wordpress, building a mysql database in php, custom dynamic rendering, essential web development tools like html, css, php, and mysql, and effective listening for instructional videos when developing mysql websites.', 'chapters': [{'end': 294.829, 'segs': [{'end': 108.079, 'src': 'embed', 'start': 12.605, 'weight': 0, 'content': [{'end': 17.486, 'text': 'Hello everybody, Adam at FlashBuilding, here with another tutorial series and in this lesson,', 'start': 12.605, 'duration': 4.881}, {'end': 21.824, 'text': "which is going to be very in-depth and I'm going to go really slow,", 'start': 18.163, 'duration': 3.661}, {'end': 28.846, 'text': "that way beginners can hang with us is we're gonna do raw data management systems from scratch,", 'start': 21.824, 'duration': 7.022}, {'end': 34.647, 'text': 'which are the equivalent to content management systems, which a lot of us already know what they are.', 'start': 28.846, 'duration': 5.801}, {'end': 42.149, 'text': 'there are systems that you can create or you can download, template systems and use to give to clients,', 'start': 34.647, 'duration': 7.502}, {'end': 46.552, 'text': 'or use for yourself to have a dynamic PHP MySQL website.', 'start': 42.149, 'duration': 4.403}, {'end': 51.86, 'text': "That's what Joomla and WordPress both are, are dynamic PHP MySQL websites.", 'start': 47.053, 'duration': 4.807}, {'end': 54.463, 'text': 'And what they do is they store data.', 'start': 52.781, 'duration': 1.682}, {'end': 59.831, 'text': 'All the data for the site essentially is stored in a MySQL database,', 'start': 55.385, 'duration': 4.446}, {'end': 65.679, 'text': 'and PHP interacts with that MySQL database to render all the pages and the menus themselves.', 'start': 59.831, 'duration': 5.848}, {'end': 77.361, 'text': 'A lot of those templates have CSS menus or JavaScript based menus that populate on the left and right sides in columns,', 'start': 66.919, 'duration': 10.442}, {'end': 79.042, 'text': 'and those menus are all dynamic.', 'start': 77.361, 'duration': 1.681}, {'end': 83.403, 'text': "They're not statically coded into a template somewhere.", 'start': 79.722, 'duration': 3.681}, {'end': 86.763, 'text': "They're coming out of the database as well according to what data is in it.", 'start': 83.563, 'duration': 3.2}, {'end': 94.14, 'text': "So that's what we're going to show you how to do, and We'll take you all the way through starting the system from scratch,", 'start': 87.303, 'duration': 6.837}, {'end': 101.83, 'text': 'building the MySQL database and going all the way to basically the point to where you can hand it over to a client.', 'start': 94.14, 'duration': 7.69}, {'end': 104.454, 'text': 'I might not show everything.', 'start': 103.032, 'duration': 1.422}, {'end': 108.079, 'text': 'I might change my mind on what to show throughout the series.', 'start': 104.814, 'duration': 3.265}], 'summary': 'Tutorial series on building raw data management systems for dynamic php mysql websites, like joomla and wordpress.', 'duration': 95.474, 'max_score': 12.605, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I12605.jpg'}, {'end': 239.37, 'src': 'heatmap', 'start': 174.913, 'weight': 2, 'content': [{'end': 184.32, 'text': "first thing, is earning potential is much higher, or has the potential to be much higher, if you're keen and clients are much happier with the unique,", 'start': 174.913, 'duration': 9.407}, {'end': 185.803, 'text': 'powerful site.', 'start': 184.32, 'duration': 1.483}, {'end': 188.467, 'text': 'so let me show you an example.', 'start': 185.803, 'duration': 2.664}, {'end': 194.357, 'text': 'this is an all flash website and I just wanted to show this as an example,', 'start': 188.467, 'duration': 5.89}, {'end': 205.459, 'text': 'because the guys who who can hack Joomla and WordPress real well the designs and put in any kind of templates that look like whatever they want,', 'start': 194.357, 'duration': 11.102}, {'end': 206.6, 'text': 'they cannot do this.', 'start': 205.459, 'duration': 1.141}, {'end': 210.883, 'text': 'They cannot do this unless they have custom coding knowledge.', 'start': 207.801, 'duration': 3.082}, {'end': 213.584, 'text': 'My client.', 'start': 212.544, 'duration': 1.04}, {'end': 216.006, 'text': 'he puts in his own journal entries.', 'start': 213.584, 'duration': 2.422}, {'end': 219.528, 'text': 'his gallery is dynamically rendered all his images.', 'start': 216.006, 'duration': 3.522}, {'end': 222.991, 'text': "he's an artist and all of his images are dynamically rendered.", 'start': 219.528, 'duration': 3.463}, {'end': 233.029, 'text': "So, and the gallery is dynamic flash gallery and it's packed into a full flash website.", 'start': 226.273, 'duration': 6.756}, {'end': 239.37, 'text': "you can't guys, guys who modified Joomla and and WordPress templates cannot do this.", 'start': 233.029, 'duration': 6.341}], 'summary': 'Custom coding allows for dynamic flash website, increasing earning potential and client satisfaction.', 'duration': 48.078, 'max_score': 174.913, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I174913.jpg'}, {'end': 299.832, 'src': 'embed', 'start': 273.715, 'weight': 7, 'content': [{'end': 281.822, 'text': 'god knows, joomla and wordpress are magnificent and powerful and a lot of people have made a lot of money using them and benefited a lot.', 'start': 273.715, 'duration': 8.107}, {'end': 286.245, 'text': "but what i'm saying is there's no design boundaries.", 'start': 281.822, 'duration': 4.423}, {'end': 288.506, 'text': "there's no data feed boundaries.", 'start': 286.245, 'duration': 2.261}, {'end': 290.467, 'text': "there's no boundaries whatsoever.", 'start': 288.506, 'duration': 1.961}, {'end': 294.829, 'text': "that's all i'm saying, and that site i just showed you should be proof enough.", 'start': 290.467, 'duration': 4.362}, {'end': 299.832, 'text': "that whole site being dynamically rendered is amazing and mysql driven, that's crazy.", 'start': 294.829, 'duration': 5.003}], 'summary': 'Joomla and wordpress are powerful, but no design or data feed boundaries. dynamic site shown as proof.', 'duration': 26.117, 'max_score': 273.715, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I273715.jpg'}], 'start': 12.605, 'title': 'Website development tools and techniques', 'summary': 'Covers raw data management systems like joomla and wordpress, building a mysql database in php, and the necessity of custom coding knowledge for dynamic website designs. it emphasizes working in php my admin and the potential for higher earning and client satisfaction.', 'chapters': [{'end': 86.763, 'start': 12.605, 'title': 'Raw data management systems tutorial', 'summary': 'Covers the creation and usage of raw data management systems, such as joomla and wordpress, which are dynamic php mysql websites storing data in a mysql database and interacting with php to render dynamic menus.', 'duration': 74.158, 'highlights': ['The tutorial series focuses on creating and using raw data management systems like Joomla and WordPress, which are dynamic PHP MySQL websites, allowing beginners to follow along (quantifiable data: beginner-friendly approach).', "These systems store all the site's data in a MySQL database and use PHP to render pages and dynamic menus, which are not statically coded into a template but are retrieved from the database (quantifiable data: storage of site data, dynamic menu rendering).", 'The lesson emphasizes the equivalence of raw data management systems to content management systems, highlighting their use for creating dynamic PHP MySQL websites (quantifiable data: equivalence to content management systems).']}, {'end': 194.357, 'start': 87.303, 'title': 'Building a mysql database in php', 'summary': 'Demonstrates building a mysql database in php, showcasing the process from scratch to handover, emphasizing a shorter series with a focus on working in php my admin and the potential for higher earning and client satisfaction.', 'duration': 107.054, 'highlights': ['The process of building a MySQL database in PHP will be demonstrated from scratch to handover, with a shorter series and a focus on working in PHP My Admin.', 'Working in PHP My Admin will be emphasized, catering to beginners and providing insight into the programming process.', 'The potential for higher earning and client satisfaction in building unique and powerful websites will be showcased, with an example of an all flash website provided.']}, {'end': 294.829, 'start': 194.357, 'title': 'Custom coding knowledge for dynamic website designs', 'summary': 'Discusses the limitations of modifying joomla and wordpress templates, emphasizing the necessity of custom coding knowledge for creating dynamic and diverse website designs, as demonstrated by the showcased flash website.', 'duration': 100.472, 'highlights': ['The necessity of custom coding knowledge for creating dynamic and diverse website designs is emphasized, highlighting the limitations of modifying Joomla and WordPress templates.', 'The showcased flash website demonstrates the ability to dynamically render journal entries and images, showcasing the diverse design possibilities achievable with custom coding.', 'The chapter mentions the diversity and lack of design boundaries in custom-coded websites, contrasting them with the limitations of systems like Joomla and WordPress.']}], 'duration': 282.224, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I12605.jpg', 'highlights': ['The tutorial series focuses on creating and using raw data management systems like Joomla and WordPress, which are dynamic PHP MySQL websites, allowing beginners to follow along (quantifiable data: beginner-friendly approach).', 'The process of building a MySQL database in PHP will be demonstrated from scratch to handover, with a shorter series and a focus on working in PHP My Admin.', 'The necessity of custom coding knowledge for creating dynamic and diverse website designs is emphasized, highlighting the limitations of modifying Joomla and WordPress templates.', "These systems store all the site's data in a MySQL database and use PHP to render pages and dynamic menus, which are not statically coded into a template but are retrieved from the database (quantifiable data: storage of site data, dynamic menu rendering).", 'The showcased flash website demonstrates the ability to dynamically render journal entries and images, showcasing the diverse design possibilities achievable with custom coding.', 'The lesson emphasizes the equivalence of raw data management systems to content management systems, highlighting their use for creating dynamic PHP MySQL websites (quantifiable data: equivalence to content management systems).', 'The potential for higher earning and client satisfaction in building unique and powerful websites will be showcased, with an example of an all flash website provided.', 'The chapter mentions the diversity and lack of design boundaries in custom-coded websites, contrasting them with the limitations of systems like Joomla and WordPress.']}, {'end': 621.863, 'segs': [{'end': 321.951, 'src': 'embed', 'start': 294.829, 'weight': 4, 'content': [{'end': 299.832, 'text': "that whole site being dynamically rendered is amazing and mysql driven, that's crazy.", 'start': 294.829, 'duration': 5.003}, {'end': 303.934, 'text': "it's all flash and that's scottclarkvision.com.", 'start': 299.832, 'duration': 4.102}, {'end': 307.956, 'text': 'if you want to check that site out, scottclarkvision.com.', 'start': 303.934, 'duration': 4.022}, {'end': 314.725, 'text': 'and this one is my site, flash building, and a lot of people ask me how I built my guestbook.', 'start': 308.82, 'duration': 5.905}, {'end': 317.107, 'text': 'a lot of people want to know how I built this guestbook here.', 'start': 314.725, 'duration': 2.382}, {'end': 321.951, 'text': "that's all dynamic, and it updates without refreshing the page.", 'start': 317.107, 'duration': 4.844}], 'summary': 'Dynamic, mysql-driven site with flash at scottclarkvision.com. my site features flash building and a dynamic guestbook.', 'duration': 27.122, 'max_score': 294.829, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I294829.jpg'}, {'end': 385.961, 'src': 'embed', 'start': 358.341, 'weight': 3, 'content': [{'end': 361.543, 'text': "Actually, this whole system, you don't need any Adobe tools whatsoever.", 'start': 358.341, 'duration': 3.202}, {'end': 365.185, 'text': "It can be done in Notepad, because I'm going to be showing you the code, basically.", 'start': 362.003, 'duration': 3.182}, {'end': 367.027, 'text': "I'll be in Dreamweaver, CS4.", 'start': 365.866, 'duration': 1.161}, {'end': 370.878, 'text': 'And you can just follow along if you have Dreamweaver CS4.', 'start': 368.337, 'duration': 2.541}, {'end': 374.638, 'text': "But if you happen to not have any Adobe software, you'll be just fine.", 'start': 371.178, 'duration': 3.46}, {'end': 376.719, 'text': 'You can use WordPad or Notepad, no problem.', 'start': 374.658, 'duration': 2.061}, {'end': 380.2, 'text': "Because I'm going to show all the code and I'm going to give the code away at the end.", 'start': 376.759, 'duration': 3.441}, {'end': 385.961, 'text': "Okay, so let's move on to adding flash elements we talked about.", 'start': 380.84, 'duration': 5.121}], 'summary': 'The system can be operated without adobe tools, utilizing notepad for code demonstration, and dreamweaver cs4 for following along.', 'duration': 27.62, 'max_score': 358.341, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I358341.jpg'}, {'end': 448.319, 'src': 'embed', 'start': 400.637, 'weight': 1, 'content': [{'end': 402.759, 'text': 'Where I developed PHP we have way over 200 pages.', 'start': 400.637, 'duration': 2.122}, {'end': 411.068, 'text': "So what you do is you use templates, and I'm going to show you how to use templates effectively to make the design,", 'start': 404.361, 'duration': 6.707}, {'end': 415.793, 'text': 'updating and changes in certain things a whole lot easier.', 'start': 411.068, 'duration': 4.725}, {'end': 425.602, 'text': "So on hundreds of pages instead of taking days to update things it just takes minutes to update a couple of template files and then you're done.", 'start': 416.794, 'duration': 8.808}, {'end': 429.457, 'text': 'Now, number five is suited for people.', 'start': 426.733, 'duration': 2.724}, {'end': 433.883, 'text': 'This system is suited for people that enjoy creating their websites from scratch.', 'start': 429.978, 'duration': 3.905}, {'end': 438.129, 'text': 'If you enjoy just going and getting some free software, this is not for you.', 'start': 434.524, 'duration': 3.605}, {'end': 441.074, 'text': 'This is going to be a bare bones kit.', 'start': 438.79, 'duration': 2.284}, {'end': 444.396, 'text': 'You understand me? So you have to want to get your hands dirty.', 'start': 441.954, 'duration': 2.442}, {'end': 445.337, 'text': 'You got to want to learn.', 'start': 444.416, 'duration': 0.921}, {'end': 448.319, 'text': 'You got to want to grow and make it a powerful system.', 'start': 445.357, 'duration': 2.962}], 'summary': 'Developed php for over 200 pages, using templates to make design and updating easier, saving days of work to minutes. suited for people who enjoy creating websites from scratch, not for those seeking free software.', 'duration': 47.682, 'max_score': 400.637, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I400637.jpg'}, {'end': 507.793, 'src': 'embed', 'start': 475.193, 'weight': 2, 'content': [{'end': 476.754, 'text': 'Not many developers can do this yet.', 'start': 475.193, 'duration': 1.561}, {'end': 480.618, 'text': "After this tutorial series, I'm blowing the lid right off of it.", 'start': 477.535, 'duration': 3.083}, {'end': 486.142, 'text': "All kind of developers are going to know how to do this and it's going to be a lot nicer for everybody.", 'start': 480.698, 'duration': 5.444}, {'end': 495.291, 'text': 'Alrighty, number six is this system is ideal for e-commerce or deep data indexing systems on or off the web.', 'start': 487.043, 'duration': 8.248}, {'end': 502.849, 'text': 'I had a buddy of mine who was creating a plant indexing system where they were indexing.', 'start': 497.185, 'duration': 5.664}, {'end': 507.793, 'text': 'him and his company were indexing all of the plant life on earth, I believe.', 'start': 502.849, 'duration': 4.944}], 'summary': 'Tutorial series will enable many developers to use system for e-commerce and data indexing, as demonstrated by a plant indexing system for all plant life on earth.', 'duration': 32.6, 'max_score': 475.193, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I475193.jpg'}, {'end': 603.883, 'src': 'embed', 'start': 575.815, 'weight': 0, 'content': [{'end': 583.858, 'text': 'this type of system makes e-commerce a breeze, because once you learn button programming for whatever gateway, payment gateway you work with,', 'start': 575.815, 'duration': 8.043}, {'end': 585.038, 'text': "then it's a breeze.", 'start': 583.858, 'duration': 1.18}, {'end': 603.883, 'text': 'uh, making all the pages and the putting the cart buttons in add to the buy now buttons in whatever kind of buttons you need and all the pages can be rendered out and all the items can be cataloged rather in a table.', 'start': 585.038, 'duration': 18.845}], 'summary': 'E-commerce system simplifies button programming, making page rendering and cataloging easier.', 'duration': 28.068, 'max_score': 575.815, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I575815.jpg'}], 'start': 294.829, 'title': 'Custom dynamic rendering and building powerful websites', 'summary': 'Covers custom dynamic rendering without adobe tools and building a powerful website system suitable for e-commerce, with dynamic capabilities and deep data indexing.', 'chapters': [{'end': 425.602, 'start': 294.829, 'title': 'Custom dynamic rendering and flash building', 'summary': 'Discusses the creative freedom and ease of updating design using custom-built systems, not requiring adobe tools, and demonstrates creating a dynamic guestbook in flash that updates without refreshing the page, with the capability to easily update hundreds of pages using templates.', 'duration': 130.773, 'highlights': ['The chapter emphasizes the creative freedom and ease of updating design using custom-built systems, not requiring Adobe tools.', 'It demonstrates creating a dynamic guestbook in flash that updates without refreshing the page.', 'The capability to easily update hundreds of pages using templates is showcased, with updates taking minutes instead of days.']}, {'end': 621.863, 'start': 426.733, 'title': 'Building a powerful system for websites', 'summary': 'Outlines a system suited for creating websites from scratch, focusing on providing powerful and dynamic capabilities, as well as its suitability for e-commerce and deep data indexing systems.', 'duration': 195.13, 'highlights': ['The system is suited for people that enjoy creating their websites from scratch, emphasizing the need to want to learn and grow to make it a powerful and dynamic system. Emphasizes the need for individuals to enjoy creating websites from scratch and be willing to learn and grow to make the system powerful and dynamic.', "The system is ideal for e-commerce or deep data indexing systems on or off the web, providing creative freedom and flexibility for such projects. Highlights the system's suitability for e-commerce and deep data indexing systems, offering creative freedom and flexibility for various projects.", 'The system makes e-commerce a breeze by simplifying button programming for payment gateways and facilitating the rendering and cataloging of items, emphasizing the importance of pagination. Explains how the system simplifies e-commerce processes, including button programming, rendering, cataloging of items, and the importance of pagination.']}], 'duration': 327.034, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I294829.jpg', 'highlights': ['The system simplifies e-commerce processes, including button programming, rendering, cataloging of items, and the importance of pagination.', 'The system is suited for people that enjoy creating their websites from scratch, emphasizing the need to want to learn and grow to make it a powerful and dynamic system.', 'The system is ideal for e-commerce or deep data indexing systems on or off the web, providing creative freedom and flexibility for such projects.', 'The chapter emphasizes the creative freedom and ease of updating design using custom-built systems, not requiring Adobe tools.', 'It demonstrates creating a dynamic guestbook in flash that updates without refreshing the page.', 'The capability to easily update hundreds of pages using templates is showcased, with updates taking minutes instead of days.']}, {'end': 922.324, 'segs': [{'end': 647.069, 'src': 'embed', 'start': 622.784, 'weight': 1, 'content': [{'end': 629.232, 'text': 'What we will need is, like I said before, no Adobe tools required, but maybe preferred.', 'start': 622.784, 'duration': 6.448}, {'end': 634.078, 'text': "I'm going to work with Dreamweaver CS4 throughout the series.", 'start': 629.993, 'duration': 4.085}, {'end': 642.787, 'text': 'because I like the, the HTML syntax highlighting code help and all that good junk.', 'start': 636.125, 'duration': 6.662}, {'end': 647.069, 'text': "and if you have just notepad or wordpad, you'll be just fine too,", 'start': 642.787, 'duration': 4.282}], 'summary': 'No adobe tools required, dreamweaver cs4 used for html syntax highlighting code help.', 'duration': 24.285, 'max_score': 622.784, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I622784.jpg'}, {'end': 699.338, 'src': 'embed', 'start': 671.946, 'weight': 0, 'content': [{'end': 680.413, 'text': 'will need at least basic level, all four of those technologies html, css, php and mysql.', 'start': 671.946, 'duration': 8.467}, {'end': 684.835, 'text': "if you don't have any php and mysql knowledge, You can still hang with this, trust me.", 'start': 680.413, 'duration': 4.422}, {'end': 689.696, 'text': 'But having some HTML and CSS knowledge is kind of essential.', 'start': 685.896, 'duration': 3.8}, {'end': 691.317, 'text': 'Not a whole lot, just a little bit.', 'start': 689.936, 'duration': 1.381}, {'end': 699.338, 'text': 'And an HTML text editor, which like was I saying before, which is Dreamweaver for me in my case.', 'start': 692.297, 'duration': 7.041}], 'summary': 'Basic knowledge of html and css is essential, along with some php and mysql knowledge. trust me, you can hang without php and mysql, but html and css knowledge is crucial. a basic html text editor like dreamweaver is recommended.', 'duration': 27.392, 'max_score': 671.946, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I671946.jpg'}, {'end': 772.318, 'src': 'embed', 'start': 727.066, 'weight': 2, 'content': [{'end': 730.068, 'text': 'except for when it comes time to render the data out.', 'start': 727.066, 'duration': 3.002}, {'end': 736.112, 'text': "But feeding the data in, we're going to be using and building the tables and assembling the structure of the database.", 'start': 730.608, 'duration': 5.504}, {'end': 737.733, 'text': "We're going to use PHP MyAdmin.", 'start': 736.132, 'duration': 1.601}, {'end': 741.343, 'text': 'which comes on any host server.', 'start': 738.342, 'duration': 3.001}, {'end': 750.405, 'text': 'really, any professional host that offers MySQL databases, that is, MySQL ready, will have phpMyAdmin already installed.', 'start': 741.343, 'duration': 9.062}, {'end': 759.307, 'text': 'for you ready to go, all you have to do is create your MySQL database and then phpMyAdmin is there in your hosting control panel.', 'start': 750.405, 'duration': 8.902}, {'end': 760.608, 'text': 'you can go right to it.', 'start': 759.307, 'duration': 1.301}, {'end': 771.577, 'text': 'then you just save that page, favorite it and get to it easily that way, And I recommend an online server rather than trying to set up LAMP,', 'start': 760.608, 'duration': 10.969}, {'end': 772.318, 'text': 'WAMP or ZAMP.', 'start': 771.577, 'duration': 0.741}], 'summary': 'Using phpmyadmin for mysql database on any professional host server.', 'duration': 45.252, 'max_score': 727.066, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I727066.jpg'}, {'end': 846.886, 'src': 'embed', 'start': 795.785, 'weight': 4, 'content': [{'end': 803.831, 'text': 'And then you have a year to play around with a PHP enabled server that is MySQL ready, equipped with PHP MyAdmin.', 'start': 795.785, 'duration': 8.046}, {'end': 806.253, 'text': 'Okay? I know GoDaddy does it.', 'start': 804.191, 'duration': 2.062}, {'end': 807.894, 'text': 'You can just buy the .', 'start': 806.973, 'duration': 0.921}, {'end': 814.319, 'text': 'com and then put the free hosting on it, which GoDaddy will offer you.', 'start': 807.894, 'duration': 6.425}, {'end': 817.692, 'text': "You put the free hosting on it, and it's PHP and MySQL ready.", 'start': 814.81, 'duration': 2.882}, {'end': 829.342, 'text': "Okay, number three you'll need good FTP software that has folder creation and file permissions control, which is Chimad,", 'start': 819.614, 'duration': 9.728}, {'end': 831.023, 'text': 'or file permissions same thing.', 'start': 829.342, 'duration': 1.681}, {'end': 838.109, 'text': 'And I recommend FileZilla, because I like the way FileZilla handles FTP.', 'start': 832.744, 'duration': 5.365}, {'end': 840.631, 'text': 'And you can use whatever you want, though.', 'start': 839.09, 'duration': 1.541}, {'end': 846.886, 'text': 'But as long as you can get to manipulate file permissions and things like that, it might not even be necessary.', 'start': 841.144, 'duration': 5.742}], 'summary': 'You need a php enabled server with mysql, free hosting from godaddy, and good ftp software like filezilla.', 'duration': 51.101, 'max_score': 795.785, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I795785.jpg'}, {'end': 931.724, 'src': 'embed', 'start': 899.312, 'weight': 5, 'content': [{'end': 905.895, 'text': "If it's a page you're just creating for the first time, you're going to see the WYSIWYG with a blank canvas.", 'start': 899.312, 'duration': 6.583}, {'end': 907.936, 'text': 'And then you just go to town creating your page.', 'start': 906.095, 'duration': 1.841}, {'end': 908.817, 'text': 'Press Enter.', 'start': 908.357, 'duration': 0.46}, {'end': 909.837, 'text': 'Boom Page is done.', 'start': 909.057, 'duration': 0.78}, {'end': 914.8, 'text': "Okay, so you'll need a free WYSIWYG JavaScript-based text editor.", 'start': 910.578, 'duration': 4.222}, {'end': 919.402, 'text': 'And those are plenty of them all over the Web 3.', 'start': 916.101, 'duration': 3.301}, {'end': 920.043, 'text': "Don't buy one.", 'start': 919.402, 'duration': 0.641}, {'end': 921.103, 'text': "I'll slap you.", 'start': 920.543, 'duration': 0.56}, {'end': 922.324, 'text': 'Okay, so.', 'start': 921.843, 'duration': 0.481}, {'end': 931.724, 'text': "Number five is listen very closely to the instructions on the video series that I'm going to be creating to avoid having to ask many questions later.", 'start': 923.499, 'duration': 8.225}], 'summary': 'Creating a page with a wysiwyg editor, avoid buying one, and follow video instructions closely.', 'duration': 32.412, 'max_score': 899.312, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I899312.jpg'}], 'start': 622.784, 'title': 'Web development essentials', 'summary': 'Covers essential tools and skills for web development, including html, css, php, and mysql, as well as setting up a php server and mysql database, and the use of ftp software and wysiwyg text editor for efficient web development.', 'chapters': [{'end': 699.338, 'start': 622.784, 'title': 'Web development tools and skills', 'summary': 'Highlights the essential tools and skills needed for web development, including basic knowledge of html, css, php, and mysql, and emphasizes the use of dreamweaver for html text editing.', 'duration': 76.554, 'highlights': ['The importance of basic knowledge in HTML, CSS, PHP, and MySQL is emphasized, with HTML and CSS knowledge considered essential.', 'The preference for using Dreamweaver as an HTML text editor is noted, with its HTML syntax highlighting and code help highlighted as beneficial.']}, {'end': 817.692, 'start': 700.018, 'title': 'Setting up php server and mysql database', 'summary': 'Emphasizes the importance of having an online server with php and mysql capability, particularly php myadmin, for database interaction, advising against setting up local servers and recommending affordable online hosting options.', 'duration': 117.674, 'highlights': ['Setting up an online server with PHP and MySQL capability, particularly PHP MyAdmin, is recommended over local server setup, with affordable options available such as purchasing a .com domain and utilizing free hosting offered by providers like GoDaddy.', 'PHP MyAdmin is essential for working with and building MySQL databases, easily accessible through the hosting control panel, and is commonly included in hosting packages offered by professional hosts.', 'Acquiring a .com domain and enabling free hosting provides a cost-effective solution for having a year of access to a PHP-enabled server with MySQL capability, offering a practical environment for learning and experimenting with database management.']}, {'end': 922.324, 'start': 819.614, 'title': 'Essential tools for web development', 'summary': 'Emphasizes the need for ftp software with folder creation and file permissions control, recommending filezilla, and the necessity of a free javascript-based wysiwyg text editor for easy page assembly or editing, as used in joomla and wordpress.', 'duration': 102.71, 'highlights': ["You'll need a free JavaScript-based WYSIWYG text editor for easy page assembly or editing, as used in Joomla and WordPress.", "You'll need good FTP software with folder creation and file permissions control, recommending FileZilla."]}], 'duration': 299.54, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I622784.jpg', 'highlights': ['HTML, CSS, PHP, and MySQL knowledge is essential.', "Dreamweaver's HTML syntax highlighting and code help are beneficial.", 'Setting up an online server with PHP and MySQL capability is recommended.', 'PHP MyAdmin is essential for working with and building MySQL databases.', 'Acquiring a .com domain and enabling free hosting provides a cost-effective solution.', 'A free JavaScript-based WYSIWYG text editor is needed for easy page assembly or editing.', 'Good FTP software with folder creation and file permissions control is recommended.']}, {'end': 1165.329, 'segs': [{'end': 964.204, 'src': 'embed', 'start': 923.499, 'weight': 0, 'content': [{'end': 931.724, 'text': "Number five is listen very closely to the instructions on the video series that I'm going to be creating to avoid having to ask many questions later.", 'start': 923.499, 'duration': 8.225}, {'end': 938.748, 'text': "I mean, if you pay attention, the better you pay attention, the less you'll have to ask because I'm going to cover basically everything.", 'start': 932.824, 'duration': 5.924}, {'end': 939.948, 'text': "I'm not going to leave anything out.", 'start': 938.768, 'duration': 1.18}, {'end': 948.253, 'text': 'And if you have trouble doing certain things that it seems like I am just doing easily,', 'start': 940.809, 'duration': 7.444}, {'end': 956.159, 'text': "then you really have to buckle down and experiment and say why is it so easy for him to just do it and then I'm having trouble?", 'start': 949.414, 'duration': 6.745}, {'end': 958.1, 'text': 'Oh my god, blah blah blah.', 'start': 956.179, 'duration': 1.921}, {'end': 964.204, 'text': "Just pay attention the best you can to avoid many, many questions that you'd have to ask people later.", 'start': 958.861, 'duration': 5.343}], 'summary': 'Pay close attention to video instructions to minimize later questions.', 'duration': 40.705, 'max_score': 923.499, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I923499.jpg'}, {'end': 1020.021, 'src': 'embed', 'start': 990.789, 'weight': 5, 'content': [{'end': 994.091, 'text': "If it's pertaining to what you're talking about, go to that part of the scripts.", 'start': 990.789, 'duration': 3.302}, {'end': 994.852, 'text': 'Study it.', 'start': 994.311, 'duration': 0.541}, {'end': 996.193, 'text': 'Change it around.', 'start': 995.392, 'duration': 0.801}, {'end': 1001.456, 'text': 'Experiment Do things that just seems logical for the functionality you want.', 'start': 996.313, 'duration': 5.143}, {'end': 1002.977, 'text': 'To change it up or whatever.', 'start': 1001.976, 'duration': 1.001}, {'end': 1015.837, 'text': 'Okay, so what if I get stuck? You can try the forums that develop PHP and although no help guarantees in a free forum online anywhere.', 'start': 1004.178, 'duration': 11.659}, {'end': 1020.021, 'text': 'I can tell you right now if you go in there and you ask a question,', 'start': 1017.098, 'duration': 2.923}], 'summary': 'Experiment and modify scripts to achieve desired functionality. seek help from php forums if stuck.', 'duration': 29.232, 'max_score': 990.789, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I990789.jpg'}, {'end': 1099.588, 'src': 'embed', 'start': 1070.402, 'weight': 7, 'content': [{'end': 1074.36, 'text': 'or number two you can hire me if you get really desperate.', 'start': 1070.402, 'duration': 3.958}, {'end': 1076.501, 'text': 'you get to the point where you want to kill yourself.', 'start': 1074.36, 'duration': 2.141}, {'end': 1080.982, 'text': 'you can hire me at six hundred and sixty six dollars per hour to help you produce your system.', 'start': 1076.501, 'duration': 4.481}, {'end': 1082.243, 'text': "I won't ask any questions.", 'start': 1080.982, 'duration': 1.261}, {'end': 1082.963, 'text': 'you command me.', 'start': 1082.243, 'duration': 0.72}, {'end': 1085.324, 'text': "I'll be your little programming robot.", 'start': 1082.963, 'duration': 2.361}, {'end': 1093.046, 'text': 'okay, now try not to ask people to help build your shite for you for free.', 'start': 1085.324, 'duration': 7.722}, {'end': 1095.267, 'text': "you can't come to our forums or some.", 'start': 1093.046, 'duration': 2.221}, {'end': 1099.588, 'text': "any other forms can't go and just be like hey, I got this great idea.", 'start': 1095.267, 'duration': 4.321}], 'summary': 'Offering programming assistance for $666/hr, no questions asked.', 'duration': 29.186, 'max_score': 1070.402, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I1070402.jpg'}, {'end': 1165.329, 'src': 'embed', 'start': 1144.364, 'weight': 4, 'content': [{'end': 1147.366, 'text': "WordPress and Joomla are much more powerful than what we're going to be creating.", 'start': 1144.364, 'duration': 3.002}, {'end': 1153.695, 'text': 'But this will give you insight into how to get started with your own systems,', 'start': 1148.208, 'duration': 5.487}, {'end': 1159.202, 'text': 'like that to offer your clients and have total control over design and programming.', 'start': 1153.695, 'duration': 5.507}, {'end': 1165.329, 'text': "It's going to be a wild ride, so strap on your headgear, sit back and relax.", 'start': 1161.224, 'duration': 4.105}], 'summary': 'Wordpress and joomla are more powerful than our creation, but this will offer insight into starting own systems for clients.', 'duration': 20.965, 'max_score': 1144.364, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I1144364.jpg'}], 'start': 923.499, 'title': 'Listening and developing mysql websites', 'summary': 'Discusses effective listening for instructional videos to minimize questions, and developing mysql websites with free scripts, forum help, and hiring assistance at $666 per hour for total control over design and programming.', 'chapters': [{'end': 964.204, 'start': 923.499, 'title': 'Effective listening for instructional videos', 'summary': 'Emphasizes the importance of paying close attention to the instructional video series to minimize the need for asking questions later, aiming to cover all aspects comprehensively and reduce the number of questions asked by listeners.', 'duration': 40.705, 'highlights': ['Paying close attention to the instructional video series can reduce the need for asking many questions later.', 'The video series aims to cover all aspects comprehensively, minimizing the gaps in information.', 'Encouraging listeners to experiment and analyze to understand the ease of certain tasks, potentially reducing their need to ask questions.', 'Emphasizing the importance of paying attention to minimize the number of questions asked later.']}, {'end': 1165.329, 'start': 964.224, 'title': 'Developing mysql websites: foundations & tips', 'summary': 'Emphasizes the importance of studying free scripts, seeking help from forums, and hiring assistance at $666 per hour, while providing insights into creating mysql websites and having total control over design and programming.', 'duration': 201.105, 'highlights': ['Studying free scripts and experimenting is emphasized for understanding the functionality and making changes.', 'Seeking help from forums like developphp.com is suggested as a source of assistance from members with varying levels of knowledge.', 'Hiring assistance is offered at a rate of $666 per hour for individuals facing extreme difficulties.', 'Insights into creating MySQL websites are provided, offering total control over design and programming, preparing individuals to create systems like WordPress and Joomla.']}], 'duration': 241.83, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/23Q8Ivumj6I/pics/23Q8Ivumj6I923499.jpg', 'highlights': ['The video series aims to cover all aspects comprehensively, minimizing the gaps in information.', 'Paying close attention to the instructional video series can reduce the need for asking many questions later.', 'Emphasizing the importance of paying attention to minimize the number of questions asked later.', 'Encouraging listeners to experiment and analyze to understand the ease of certain tasks, potentially reducing their need to ask questions.', 'Insights into creating MySQL websites are provided, offering total control over design and programming, preparing individuals to create systems like WordPress and Joomla.', 'Studying free scripts and experimenting is emphasized for understanding the functionality and making changes.', 'Seeking help from forums like developphp.com is suggested as a source of assistance from members with varying levels of knowledge.', 'Hiring assistance is offered at a rate of $666 per hour for individuals facing extreme difficulties.']}], 'highlights': ['The tutorial series focuses on creating and using raw data management systems like Joomla and WordPress, which are dynamic PHP MySQL websites, allowing beginners to follow along (quantifiable data: beginner-friendly approach).', 'The process of building a MySQL database in PHP will be demonstrated from scratch to handover, with a shorter series and a focus on working in PHP My Admin.', 'The showcased flash website demonstrates the ability to dynamically render journal entries and images, showcasing the diverse design possibilities achievable with custom coding.', 'The lesson emphasizes the equivalence of raw data management systems to content management systems, highlighting their use for creating dynamic PHP MySQL websites (quantifiable data: equivalence to content management systems).', 'The system simplifies e-commerce processes, including button programming, rendering, cataloging of items, and the importance of pagination.', 'The system is suited for people that enjoy creating their websites from scratch, emphasizing the need to want to learn and grow to make it a powerful and dynamic system.', 'The system is ideal for e-commerce or deep data indexing systems on or off the web, providing creative freedom and flexibility for such projects.', 'The chapter emphasizes the creative freedom and ease of updating design using custom-built systems, not requiring Adobe tools.', 'HTML, CSS, PHP, and MySQL knowledge is essential.', 'The video series aims to cover all aspects comprehensively, minimizing the gaps in information.', 'Paying close attention to the instructional video series can reduce the need for asking many questions later.', 'Insights into creating MySQL websites are provided, offering total control over design and programming, preparing individuals to create systems like WordPress and Joomla.']}