title
PHP Full Course | PHP Tutorial For Beginners | PHP Tutorial | PHP Course | PHP | Simplilearn

description
🔥 IITM Pravartak Professional Certificate Program In Full Stack Development - MERN (India Only): https://www.simplilearn.com/full-stack-developer-course-and-certification-iitm-pravartak?utm_campaign=SCE-FullstackIITM&utm_medium=DescriptionFF&utm_source=youtube 🔥Post Graduate Program In Full Stack Web Development: https://www.simplilearn.com/pgp-full-stack-web-development-certification-training-course?utm_campaign=PHPFCAug24-6EukZDFE_Zg&utm_medium=DescriptionFirstFold&utm_source=youtube 🔥Caltech Coding Bootcamp (US Only): https://www.simplilearn.com/coding-bootcamp?utm_campaign=PHPFCAug24-6EukZDFE_Zg&utm_medium=DescriptionFirstFold&utm_source=youtube This PHP full course or php tutorial for beginners video covers all the key concepts of PHP including an introduction to PHP, hello world in PHP, OOP in PHP, PHP with MySQL, PHP form validation, PHP get and post methods, PHP crud operations, PHP form login, PHP vs Python, PHP rest API, PHP registration for VSCode, PHP programming, along with most important PHP interview questions. 00:00:00 PHP full course 00:10:18 PHP Using Xampp 00:13:39 Hello World in PHP 00:17:43 PHP Programming Concepts 00:59:38 OOPs in PHP 01:25:06 PHP Extenssion for VSCode 01:32:44 PHP GET and POST Method 01:47:16 PHP with MySQL tutorial 02:09:22 PHP Form Validation 02:39:22 PHP CRUD Operations 03:15:13 PHP Registration Form 03:44:01 PHP Login Form 03:56:12 PHP REST API 04:11:46 PHP Web Development Tutorial 05:05:57 PHP E-commerce Website 05:46:54 PHP Interview Questions ✅Subscribe to our Channel to learn more about the top Technologies: https://bit.ly/2VT4WtH ⏩ Check out our PHP training videos playlist: https://www.youtube.com/watch?v=KBT2gmAfav4&list=PLEiEAq2VkUUIjP-QLfvICa1TvqTLFvn1b #PHPFullCourse #PHPForBeginners #PHPTutorialForBeginnersFull #PHPFullTutorial #LearnPHP #PHP #PHPForBeginners #PHPForBeginners #PHPTutorial #PHPTutorialForBeginners #PHPProjectWithSourceCode #PHPTutorials #Simplilearn Introduction to PHP: Despite being an old language, PHP still comprises 79.8% of all web applications that nearly translates to 20 million websites and 2 million web servers. According to zdnet.com, the demand for PHP developers has also massively increased to 834% since January 2020. PHP stands for Hypertext Preprocessor. It is an open-source server-side scripting language used for dynamic web development and can be embedded into HTML codes. ➡️ About Post Graduate Program In Full Stack Web Development This program will give you the foundation for building full-stack web apps using the Java programming language. You'll begin with the basics of JavaScript, and then venture into some of the more advanced concepts like Angular, Spring Boot, Hibernate, JSPs, and MVC. Now is the perfect time to get started on your career as a full-stack web developer! ✅ Key Features - Caltech CTME Post Graduate Certificate - Enrolment in Simplilearn’s JobAssist - Receive up to 25 CEUs from Caltech CTME - Simplilearn's JobAssist helps you get noticed by top hiring companies - Attend Masterclasses from Caltech CTME instructors - Live virtual classes led by industry experts, hands-on projects and integrated labs - Online Convocation by Caltech CTME Program Director - 20 lesson-end and 5 phase-end projects - Capstone Project in 4 domains - Caltech CTME Circle Membership - Build your own portfolio on GitHub ✅ Skills Covered - Agile - JAVA - Hibernate and JPA - Spring Core 50 - DevOps - HTML5 and CSS3 - AWS - JavaScript ES6 - Servlets - SOAP and REST - JSP 👉 Learn More At: https://www.simplilearn.com/pgp-full-stack-web-development-certification-training-course?utm_campaign=PHPFCAug24-6EukZDFE_Zg&utm_medium=Description&utm_source=youtube 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688

detail
{'title': 'PHP Full Course | PHP Tutorial For Beginners | PHP Tutorial | PHP Course | PHP | Simplilearn', 'heatmap': [{'end': 1161.213, 'start': 682.833, 'weight': 1}, {'end': 2072.347, 'start': 1830.195, 'weight': 0.739}, {'end': 4132.051, 'start': 3754.818, 'weight': 0.78}, {'end': 6213.887, 'start': 5859.927, 'weight': 0.995}, {'end': 7130.833, 'start': 6884.936, 'weight': 0.978}], 'summary': 'The php full course tutorial for beginners covers php programming, xampp setup, basics, oops concepts, form validation, crud operations, registration and login system, web development, e-commerce websites, php functions, and advanced concepts, with 79.2% of the web powered by php, translating to 20 million websites and 1 million web servers, and nearly 22 billion visits per month.', 'chapters': [{'end': 140.978, 'segs': [{'end': 60.296, 'src': 'embed', 'start': 38.84, 'weight': 2, 'content': [{'end': 48.487, 'text': "First, we'll start by a proper introduction to PHP, followed by learning how to use XAMPP software to build our first Hello World PHP program.", 'start': 38.84, 'duration': 9.647}, {'end': 55.932, 'text': "Then, we'll learn all the basic PHP programming concepts right from the very beginning till loops and arrays.", 'start': 49.528, 'duration': 6.404}, {'end': 60.296, 'text': 'We will then move on to learning about object-oriented programming in PHP.', 'start': 56.693, 'duration': 3.603}], 'summary': 'Introduction to php, xampp for hello world, basics, loops, arrays, and object-oriented programming covered.', 'duration': 21.456, 'max_score': 38.84, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg38840.jpg'}, {'end': 140.978, 'src': 'embed', 'start': 88.078, 'weight': 0, 'content': [{'end': 96.701, 'text': 'we will also discuss rest apis in php, followed by an extensive web development tutorial by creating a website.', 'start': 88.078, 'duration': 8.623}, {'end': 108.326, 'text': 'next, we will also work on an e-commerce website tutorial and finally, we will have a look at the most frequently asked php interview questions.', 'start': 96.701, 'duration': 11.625}, {'end': 113.428, 'text': "so, without any further ado, let's get started.", 'start': 108.326, 'duration': 5.102}, {'end': 115.529, 'text': 'let us first meet rob.', 'start': 113.428, 'duration': 2.101}, {'end': 117.77, 'text': 'rob is the owner of an e-commerce business.', 'start': 115.529, 'duration': 2.241}, {'end': 126.109, 'text': 'earlier, his customers were very happy with the products they purchased from his website, but with more traffic and user base,', 'start': 118.564, 'duration': 7.545}, {'end': 133.173, 'text': 'rob started receiving complaints from his customers, not related to the products, but the website itself.', 'start': 126.109, 'duration': 7.064}, {'end': 140.978, 'text': 'now the customers were facing challenges like slow website speed, bad user experience and poor security features.', 'start': 133.173, 'duration': 7.805}], 'summary': 'Php web development tutorial including rest apis, e-commerce, and php interview questions.', 'duration': 52.9, 'max_score': 88.078, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg88078.jpg'}], 'start': 16.857, 'title': 'Php programming full course tutorial', 'summary': 'Covers a comprehensive tutorial on php programming, including an introduction to php, using xampp software to build the first program, learning basic concepts, object-oriented programming, integrating php extensions into visual studio code, implementing mysql with php, rest apis in php, web development tutorial, e-commerce website tutorial, and frequently asked php interview questions.', 'chapters': [{'end': 140.978, 'start': 16.857, 'title': 'Php programming full course tutorial', 'summary': 'Covers a comprehensive tutorial on php programming, including an introduction to php, using xampp software to build the first program, learning basic concepts, object-oriented programming, integrating php extensions into visual studio code, implementing mysql with php, rest apis in php, web development tutorial, e-commerce website tutorial, and frequently asked php interview questions.', 'duration': 124.121, 'highlights': ['E-commerce business challenges Rob, the e-commerce business owner, faced challenges like slow website speed, bad user experience, and poor security features with the increase in traffic and user base.', 'Tutorial on frequently asked PHP interview questions The chapter includes a tutorial on the most frequently asked PHP interview questions, providing valuable insight for PHP job seekers.', 'Web development tutorial There is an extensive web development tutorial included in the chapter, offering practical guidance for building websites using PHP.', "E-commerce website tutorial The chapter covers a tutorial on creating an e-commerce website, catering to the practical needs of businesses like Rob's.", 'Introduction to PHP and basic concepts The chapter provides a comprehensive introduction to PHP, covering basic programming concepts, loops, arrays, and object-oriented programming.']}], 'duration': 124.121, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg16857.jpg', 'highlights': ['Tutorial on frequently asked PHP interview questions The chapter includes a tutorial on the most frequently asked PHP interview questions, providing valuable insight for PHP job seekers.', 'Web development tutorial There is an extensive web development tutorial included in the chapter, offering practical guidance for building websites using PHP.', "E-commerce website tutorial The chapter covers a tutorial on creating an e-commerce website, catering to the practical needs of businesses like Rob's.", 'Introduction to PHP and basic concepts The chapter provides a comprehensive introduction to PHP, covering basic programming concepts, loops, arrays, and object-oriented programming.', 'E-commerce business challenges Rob, the e-commerce business owner, faced challenges like slow website speed, bad user experience, and poor security features with the increase in traffic and user base.']}, {'end': 615.631, 'segs': [{'end': 219.47, 'src': 'embed', 'start': 195.183, 'weight': 0, 'content': [{'end': 203.008, 'text': 'Now, before moving into the details, did you know that 79.2% web is still powered by PHP,', 'start': 195.183, 'duration': 7.825}, {'end': 207.451, 'text': 'which nearly translates to 20 million websites and 1 million web servers?', 'start': 203.008, 'duration': 4.443}, {'end': 219.47, 'text': "Now in this presentation, you'll learn about what is PHP, how does it work differently from a conventional webpage, what are its features,", 'start': 209.025, 'duration': 10.445}], 'summary': '79.2% of the web is powered by php, equivalent to 20 million websites and 1 million web servers.', 'duration': 24.287, 'max_score': 195.183, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg195183.jpg'}], 'start': 140.978, 'title': 'Php benefits and usage', 'summary': 'Explores the benefits of using php for web development including speed, security, and compatibility, highlighting that 79.2% of the web is powered by php, translating to 20 million websites and 1 million web servers. it also explains php features and workflow, emphasizing its simplicity, flexibility, speed, and large community support, with php visited by users for nearly 22 billion times per month.', 'chapters': [{'end': 271.079, 'start': 140.978, 'title': 'Benefits of php for web development', 'summary': 'Explores how php can solve various problems for web developers, including its speed, ability to create dynamic web pages, security features, and compatibility with different databases and programming languages. it also highlights that 79.2% of the web is powered by php, translating to 20 million websites and 1 million web servers.', 'duration': 130.101, 'highlights': ['PHP powers 79.2% of the web, equating to 20 million websites and 1 million web servers, showcasing its widespread usage and importance in the industry.', "PHP's ability to make websites function faster and create dynamic web pages enhances user interaction and experience, increasing the efficiency and effectiveness of web development.", 'The language provides security encryption, ensuring the safety of websites and the protection of sensitive data, a crucial aspect for web developers and businesses.', "PHP's cost-efficiency, compatibility with different databases and programming languages, and platform independence make it a versatile and practical choice for web development, appealing to businesses seeking effective solutions.", 'PHP is an open source server-side scripting language, freely available and embedded into HTML, simplifying the web development process and making it accessible to everyone.']}, {'end': 615.631, 'start': 271.079, 'title': 'Understanding php features and workflow', 'summary': 'Explains the syntax and features of php, its workflow, and its usage by major companies like facebook and wikipedia, emphasizing its simplicity, flexibility, speed, and large community support, with php visited by users for nearly 22 billion times per month.', 'duration': 344.552, 'highlights': ['PHP is visited by users for nearly 22 billion times per month, making it crucial for handling huge traffic volumes on websites like Facebook. According to the website, SimilarWeb, PHP is visited by users for nearly 22 billion times per month, indicating its significance in handling massive traffic volumes on websites like Facebook.', 'Facebook, Wikipedia, WordPress, Tumblr, and Yahoo are some major companies using PHP, demonstrating its widespread usage in creating dynamic and interactive websites and handling large data traffic. Major companies like Facebook, Wikipedia, WordPress, Tumblr, and Yahoo utilize PHP, showcasing its widespread usage in creating dynamic and interactive websites and managing substantial data traffic.', 'PHP is simple and easy to learn, providing good news to new learners, and it offers flexibility in making small changes without developer intervention, making it a favorable language for web development. PHP is simple and easy to learn, offering good news to new learners, and it provides flexibility in making small changes without developer intervention, making it a favorable language for web development.', "Websites developed in PHP are faster and considered the best option for developing dynamic websites, emphasizing the language's speed and efficiency for web development. Websites developed in PHP are faster and considered the best option for creating dynamic websites, highlighting the language's speed and efficiency for web development.", 'PHP has a large community that is very helpful and makes the language more stable, emphasizing its strong community support and stability. PHP has a large community that is very helpful and makes the language more stable, underlining its strong community support and stability.']}], 'duration': 474.653, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg140978.jpg', 'highlights': ['PHP powers 79.2% of the web, equating to 20 million websites and 1 million web servers, showcasing its widespread usage and importance in the industry.', 'PHP is visited by users for nearly 22 billion times per month, making it crucial for handling huge traffic volumes on websites like Facebook.', "Websites developed in PHP are faster and considered the best option for developing dynamic websites, emphasizing the language's speed and efficiency for web development.", "PHP's ability to make websites function faster and create dynamic web pages enhances user interaction and experience, increasing the efficiency and effectiveness of web development.", 'PHP has a large community that is very helpful and makes the language more stable, emphasizing its strong community support and stability.']}, {'end': 1263.332, 'segs': [{'end': 641.312, 'src': 'embed', 'start': 616.092, 'weight': 4, 'content': [{'end': 624.799, 'text': 'Now, this is not necessarily a prerequisite, but if you have basic knowledge of programming fundamentals such as oops concept functions and arrays,', 'start': 616.092, 'duration': 8.707}, {'end': 627.141, 'text': 'etc. it would really help you along the way.', 'start': 624.799, 'duration': 2.342}, {'end': 630.864, 'text': "Let's get started and learn what exactly is XAMPP.", 'start': 627.721, 'duration': 3.143}, {'end': 641.312, 'text': 'Now, XAMPP stands for Cross Platform, Apache Server, Maria Database, PHP, and then finally, Perl.', 'start': 631.75, 'duration': 9.562}], 'summary': 'Xampp stands for cross platform, apache server, maria database, php, and perl.', 'duration': 25.22, 'max_score': 616.092, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg616092.jpg'}, {'end': 1161.213, 'src': 'heatmap', 'start': 682.833, 'weight': 1, 'content': [{'end': 690.096, 'text': 'So, as you can see here, ApacheFriends.org is the official website from where you can download the XAMPP software.', 'start': 682.833, 'duration': 7.263}, {'end': 700.121, 'text': "Since we are using the Windows version, we'll download it for Windows, although it is available for Linux and macOS as well.", 'start': 691.597, 'duration': 8.524}, {'end': 709.485, 'text': "Now, let's wait for the download to get finished.", 'start': 707.184, 'duration': 2.301}, {'end': 720.752, 'text': 'it almost is.', 'start': 717.549, 'duration': 3.203}, {'end': 729.219, 'text': "now let's open the setup and install our software right away.", 'start': 720.752, 'duration': 8.467}, {'end': 732.121, 'text': 'continue installation.', 'start': 729.219, 'duration': 2.902}, {'end': 743.178, 'text': "next. now, from here, you can select all the extra files that you want to install along with the xampp setup or you don't want to install now.", 'start': 732.121, 'duration': 11.057}, {'end': 752.105, 'text': 'this is the default folder for xampp installation, that is c drive xampp, and i would recommend you keep it that way.', 'start': 743.178, 'duration': 8.927}, {'end': 756.828, 'text': "i think there's some issue here.", 'start': 752.105, 'duration': 4.723}, {'end': 764.454, 'text': 'yeah, well, this is the folder for my old xampp.', 'start': 756.828, 'duration': 7.626}, {'end': 778.319, 'text': "yeah, now We wait for the installation to get finished and then we'll run a quick PHP script, a welcome or hello world kind of script,", 'start': 764.454, 'duration': 13.865}, {'end': 781.881, 'text': 'to see how this XAMPP software functions along with PHP.', 'start': 778.319, 'duration': 3.562}, {'end': 785.923, 'text': 'Now the installation is almost done.', 'start': 783.682, 'duration': 2.241}, {'end': 788.845, 'text': "We'll just wait for a few.", 'start': 787.184, 'duration': 1.661}, {'end': 813.2, 'text': "now the installation is complete and now let us open the control panel to check if it's done correctly.", 'start': 802.017, 'duration': 11.183}, {'end': 816.061, 'text': 'yes, everything seems fine now.', 'start': 813.2, 'duration': 2.861}, {'end': 822.803, 'text': 'so this is the control panel for the XAMPP software, which includes all the services provided by it,', 'start': 816.061, 'duration': 6.742}, {'end': 828.184, 'text': "and in our PHP tutorials we'll be mainly using the Apache server and the MySQL one.", 'start': 822.803, 'duration': 5.381}, {'end': 834.234, 'text': 'so you need to click on Apache server started and MySQL.', 'start': 828.184, 'duration': 6.05}, {'end': 838.576, 'text': 'Now Apache server will show you the default port on which it is running.', 'start': 834.874, 'duration': 3.702}, {'end': 847.321, 'text': "Now to check if XAMPP is correctly installed on your system, let's open the browser again and type localhost.", 'start': 839.136, 'duration': 8.185}, {'end': 852.123, 'text': 'Now this will open up the dashboard for the XAMPP application.', 'start': 848.721, 'duration': 3.402}, {'end': 862.008, 'text': "Let's click on phpMyAdmin and the information is available here so the installation is complete.", 'start': 853.164, 'duration': 8.844}, {'end': 866.241, 'text': "Similarly, we'll install the Visual Studio Code.", 'start': 862.958, 'duration': 3.283}, {'end': 870.364, 'text': "Since I've already installed the software in my system, I'll not be doing that.", 'start': 866.541, 'duration': 3.823}, {'end': 873.126, 'text': 'Now, let us come to the important part.', 'start': 870.925, 'duration': 2.201}, {'end': 879.972, 'text': 'Let us redirect to C drive and there we have a XAMPP installed.', 'start': 874.367, 'duration': 5.605}, {'end': 884.275, 'text': 'Open the XAMPP folder and locate htdocs.', 'start': 880.632, 'duration': 3.643}, {'end': 890.961, 'text': 'Now, this is the folder where all your PHP files, codes and website related data will be stored.', 'start': 885.076, 'duration': 5.885}, {'end': 897.58, 'text': "Now we'll open the htdocs and let us create a new folder here.", 'start': 892.998, 'duration': 4.582}, {'end': 904.384, 'text': 'Since it will be a first program, let us name it firstphp.', 'start': 898.701, 'duration': 5.683}, {'end': 910.967, 'text': "Now let's open our code editor that is Visual Studio Code.", 'start': 907.105, 'duration': 3.862}, {'end': 914.909, 'text': 'Click on open folder.', 'start': 913.488, 'duration': 1.421}, {'end': 919.591, 'text': 'Locate to XAMPP.', 'start': 917.49, 'duration': 2.101}, {'end': 930.546, 'text': 'htdocs and the folder we created first.php.', 'start': 922.093, 'duration': 8.453}, {'end': 933.349, 'text': 'as you can see, let me close this first.', 'start': 930.546, 'duration': 2.803}, {'end': 936.712, 'text': 'as you can see, first.php folder is visible here.', 'start': 933.349, 'duration': 3.363}, {'end': 940.336, 'text': 'let us create our first.php file.', 'start': 936.712, 'duration': 3.624}, {'end': 944.153, 'text': "let's name it hello.php.", 'start': 940.336, 'duration': 3.817}, {'end': 948.795, 'text': "now. don't forget the php extension, otherwise the code will not run now.", 'start': 944.153, 'duration': 4.642}, {'end': 956.379, 'text': 'since a browser only understands html code, we will have to embed the php script into the html code itself.', 'start': 948.795, 'duration': 7.584}, {'end': 958.04, 'text': "so let's begin.", 'start': 956.379, 'duration': 1.661}, {'end': 970.066, 'text': 'let me zoom it a little bit so you can see clearly.', 'start': 958.04, 'duration': 12.026}, {'end': 975.353, 'text': 'let me add a heading, so h1 will be too big.', 'start': 970.066, 'duration': 5.287}, {'end': 989.359, 'text': "let's keep it to h2, my first php web page.", 'start': 975.353, 'duration': 14.006}, {'end': 991.16, 'text': "let's write a first php script.", 'start': 989.359, 'duration': 1.801}, {'end': 999.423, 'text': 'so a php script begins with an opening angular bracket question mark php.', 'start': 991.16, 'duration': 8.263}, {'end': 1006.898, 'text': "now We'll write the PHP script that is echo hello world.", 'start': 999.423, 'duration': 7.475}, {'end': 1011.92, 'text': 'Now echo acts as a print function, which prints any string that is in front of it.', 'start': 1007.318, 'duration': 4.602}, {'end': 1015.681, 'text': 'In this case, it will display hello world onto the webpage.', 'start': 1012.32, 'duration': 3.361}, {'end': 1023.464, 'text': "Let's close the script with a question mark and a closing angular bracket and also close our HTML code.", 'start': 1016.862, 'duration': 6.602}, {'end': 1035.229, 'text': 'Now before running a web page, let us first check if the web server is still active.', 'start': 1030.345, 'duration': 4.884}, {'end': 1040.353, 'text': 'Yes, the web server is still running.', 'start': 1038.251, 'duration': 2.102}, {'end': 1043.555, 'text': "So let's open the browser.", 'start': 1042.174, 'duration': 1.381}, {'end': 1045.637, 'text': 'Type localhost.', 'start': 1044.536, 'duration': 1.101}, {'end': 1050.2, 'text': 'Now type the name of the folder that you have created.', 'start': 1046.257, 'duration': 3.943}, {'end': 1053.403, 'text': 'That is first.php.', 'start': 1050.541, 'duration': 2.862}, {'end': 1059.88, 'text': 'Now as you can see, our hello.php file is presented.', 'start': 1055.731, 'duration': 4.149}, {'end': 1060.982, 'text': "Let's click on it.", 'start': 1060.241, 'duration': 0.741}, {'end': 1065.773, 'text': 'And as you can see, our first webpage is visible.', 'start': 1062.345, 'duration': 3.428}, {'end': 1072.691, 'text': 'which shows the heading, my first PHP web page and the hello world from a PHP script.', 'start': 1066.647, 'duration': 6.044}, {'end': 1078.915, 'text': "in this video on PHP programming, we're going to discuss different PHP concepts, from the very basics,", 'start': 1072.691, 'duration': 6.224}, {'end': 1088.802, 'text': 'such as syntax hello world program up until learning how to collect form data using PHP scripts, and also cover a lot more concepts in between.', 'start': 1078.915, 'duration': 9.887}, {'end': 1092.084, 'text': 'now what we need to do is to use Visual Studio code.', 'start': 1088.802, 'duration': 3.282}, {'end': 1102.257, 'text': 'what we do is we go to c drive, xampp folder or wherever you have installed your xampp software, we go to that folder,', 'start': 1093.351, 'duration': 8.906}, {'end': 1112.384, 'text': 'locate htdocs and let us now create another folder and you can name it anything that you want to based on your project.', 'start': 1102.257, 'duration': 10.127}, {'end': 1124.771, 'text': 'since we are discussing the concepts, let us name it concepts now, right click on it and Here, as you can see, it shows open with code.', 'start': 1112.384, 'duration': 12.387}, {'end': 1136.658, 'text': 'When you click on it, you can see that it opens Visual Studio Code for you along with the concepts folder that we just created.', 'start': 1125.592, 'duration': 11.066}, {'end': 1144.422, 'text': 'Now this is where you will create all your files for your project and will be writing all of your PHP scripts.', 'start': 1137.158, 'duration': 7.264}, {'end': 1161.213, 'text': "Now let's create the first PHP file from here, new file, Let us name it tutorial.php and see how a PHP syntax looks like.", 'start': 1146.383, 'duration': 14.83}], 'summary': 'Installing xampp on windows, creating first php script, and opening in browser.', 'duration': 478.38, 'max_score': 682.833, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg682833.jpg'}, {'end': 828.184, 'src': 'embed', 'start': 783.682, 'weight': 1, 'content': [{'end': 785.923, 'text': 'Now the installation is almost done.', 'start': 783.682, 'duration': 2.241}, {'end': 788.845, 'text': "We'll just wait for a few.", 'start': 787.184, 'duration': 1.661}, {'end': 813.2, 'text': "now the installation is complete and now let us open the control panel to check if it's done correctly.", 'start': 802.017, 'duration': 11.183}, {'end': 816.061, 'text': 'yes, everything seems fine now.', 'start': 813.2, 'duration': 2.861}, {'end': 822.803, 'text': 'so this is the control panel for the XAMPP software, which includes all the services provided by it,', 'start': 816.061, 'duration': 6.742}, {'end': 828.184, 'text': "and in our PHP tutorials we'll be mainly using the Apache server and the MySQL one.", 'start': 822.803, 'duration': 5.381}], 'summary': 'Xampp installation complete, control panel includes apache server and mysql for php tutorials.', 'duration': 44.502, 'max_score': 783.682, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg783682.jpg'}, {'end': 930.546, 'src': 'embed', 'start': 885.076, 'weight': 0, 'content': [{'end': 890.961, 'text': 'Now, this is the folder where all your PHP files, codes and website related data will be stored.', 'start': 885.076, 'duration': 5.885}, {'end': 897.58, 'text': "Now we'll open the htdocs and let us create a new folder here.", 'start': 892.998, 'duration': 4.582}, {'end': 904.384, 'text': 'Since it will be a first program, let us name it firstphp.', 'start': 898.701, 'duration': 5.683}, {'end': 910.967, 'text': "Now let's open our code editor that is Visual Studio Code.", 'start': 907.105, 'duration': 3.862}, {'end': 914.909, 'text': 'Click on open folder.', 'start': 913.488, 'duration': 1.421}, {'end': 919.591, 'text': 'Locate to XAMPP.', 'start': 917.49, 'duration': 2.101}, {'end': 930.546, 'text': 'htdocs and the folder we created first.php.', 'start': 922.093, 'duration': 8.453}], 'summary': 'Instructions for setting up a php program in visual studio code to work with xampp and htdocs folder.', 'duration': 45.47, 'max_score': 885.076, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg885076.jpg'}, {'end': 1011.92, 'src': 'embed', 'start': 958.04, 'weight': 5, 'content': [{'end': 970.066, 'text': 'let me zoom it a little bit so you can see clearly.', 'start': 958.04, 'duration': 12.026}, {'end': 975.353, 'text': 'let me add a heading, so h1 will be too big.', 'start': 970.066, 'duration': 5.287}, {'end': 989.359, 'text': "let's keep it to h2, my first php web page.", 'start': 975.353, 'duration': 14.006}, {'end': 991.16, 'text': "let's write a first php script.", 'start': 989.359, 'duration': 1.801}, {'end': 999.423, 'text': 'so a php script begins with an opening angular bracket question mark php.', 'start': 991.16, 'duration': 8.263}, {'end': 1006.898, 'text': "now We'll write the PHP script that is echo hello world.", 'start': 999.423, 'duration': 7.475}, {'end': 1011.92, 'text': 'Now echo acts as a print function, which prints any string that is in front of it.', 'start': 1007.318, 'duration': 4.602}], 'summary': "Creating a php web page with an echo function to print 'hello world'.", 'duration': 53.88, 'max_score': 958.04, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg958040.jpg'}], 'start': 616.092, 'title': 'Setting up xampp and creating first php script', 'summary': 'Introduces xampp for hosting a local web server with access to mysql database, php, and perl, and provides guidance on setting it up on a windows system and running a php script. it also covers the installation of xampp, creating a folder for php files, and creating and running a basic php script using visual studio code, as well as the importance of xampp in running php scripts and the basics of php syntax and echo function.', 'chapters': [{'end': 781.881, 'start': 616.092, 'title': 'Setting up xampp for local web server', 'summary': 'Introduces xampp, an open source application for hosting a local web server with access to mysql database, php, and perl, and provides guidance on setting it up on a windows system and running a php script.', 'duration': 165.789, 'highlights': ['XAMPP is an all-in-one package for hosting a local web server with access to MySQL Database, PHP, and Perl, providing an easy way to set up a web server.', 'The official website for downloading XAMPP is ApacheFriends.org, and it is available for Windows, Linux, and macOS.', 'Basic knowledge of programming fundamentals, such as OOPs concepts, functions, and arrays, can be helpful for understanding XAMPP and its setup process.']}, {'end': 1263.332, 'start': 783.682, 'title': 'Setting up xampp and creating first php script', 'summary': 'Covers the installation of xampp, creating a folder for php files, and creating and running a basic php script using visual studio code, as well as the importance of xampp in running php scripts and the basics of php syntax and echo function.', 'duration': 479.65, 'highlights': ['The chapter covers the installation of XAMPP, creating a folder for PHP files, and creating and running a basic PHP script using Visual Studio Code, as well as the importance of XAMPP in running PHP scripts and the basics of PHP syntax and echo function.', 'The XAMPP control panel includes all the services provided by it, and in PHP tutorials, the Apache server and the MySQL one are mainly used.', "To check if XAMPP is correctly installed, opening the browser and typing 'localhost' will open up the dashboard for the XAMPP application.", "The 'htdocs' folder is where all PHP files, codes, and website related data are stored.", 'A PHP script begins with an opening angular bracket question mark php and ends with a closing angular bracket and also close the HTML code, and echo function is used to display strings onto the webpage.', 'Starting the Apache service from the XAMPP control panel will start a local web server on the system.', "To print something in PHP, the 'echo' function is used, where the string to be printed is written in front of it and saved as a program.", "The XAMPP software starts a local web server on the system, and the 'localhost' is used to run PHP scripts."]}], 'duration': 647.24, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg616092.jpg', 'highlights': ['XAMPP is an all-in-one package for hosting a local web server with access to MySQL Database, PHP, and Perl, providing an easy way to set up a web server.', 'The official website for downloading XAMPP is ApacheFriends.org, and it is available for Windows, Linux, and macOS.', 'The chapter covers the installation of XAMPP, creating a folder for PHP files, and creating and running a basic PHP script using Visual Studio Code, as well as the importance of XAMPP in running PHP scripts and the basics of PHP syntax and echo function.', 'The XAMPP control panel includes all the services provided by it, and in PHP tutorials, the Apache server and the MySQL one are mainly used.', "To check if XAMPP is correctly installed, opening the browser and typing 'localhost' will open up the dashboard for the XAMPP application.", "The 'htdocs' folder is where all PHP files, codes, and website related data are stored.", 'Starting the Apache service from the XAMPP control panel will start a local web server on the system.', "To print something in PHP, the 'echo' function is used, where the string to be printed is written in front of it and saved as a program."]}, {'end': 2055.156, 'segs': [{'end': 1444.525, 'src': 'embed', 'start': 1403.121, 'weight': 5, 'content': [{'end': 1414.111, 'text': 'now, to print this, we can use echo, but when you want to print a variable in echo, you need to do things a little differently.', 'start': 1403.121, 'duration': 10.99}, {'end': 1418.83, 'text': 'so Let us start with H1 heading.', 'start': 1414.111, 'duration': 4.719}, {'end': 1426.254, 'text': 'Now to print a variable.', 'start': 1424.433, 'duration': 1.821}, {'end': 1444.525, 'text': 'what you need to do is you need to use dot followed by the name of the variable that would be str and another dot followed by if you want to type something along with the variable.', 'start': 1426.254, 'duration': 18.271}], 'summary': 'Using echo to print a variable, incorporating dot notation.', 'duration': 41.404, 'max_score': 1403.121, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg1403121.jpg'}, {'end': 1893.812, 'src': 'embed', 'start': 1864.849, 'weight': 1, 'content': [{'end': 1874.039, 'text': 'And save the code, go back to the browser and only the second array is.', 'start': 1864.849, 'duration': 9.19}, {'end': 1879.743, 'text': 'the second variable in the array is visible.', 'start': 1874.039, 'duration': 5.704}, {'end': 1889.409, 'text': "now suppose, instead of a variable, you want to create a value that you don't want to be changed throughout your entire program.", 'start': 1879.743, 'duration': 9.666}, {'end': 1893.812, 'text': 'so consonants are used for the same purpose.', 'start': 1889.409, 'duration': 4.403}], 'summary': 'Using constants to create unchangeable values in programming.', 'duration': 28.963, 'max_score': 1864.849, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg1864849.jpg'}, {'end': 1978.54, 'src': 'embed', 'start': 1931.281, 'weight': 0, 'content': [{'end': 1938.546, 'text': 'what you need to do is you need to write the name of the consonant.', 'start': 1931.281, 'duration': 7.265}, {'end': 1964.287, 'text': 'and okay, first let us write the name of the consonant, suppose laptops, followed by the value of the HP Consonant, Lenovo and Asus.', 'start': 1938.546, 'duration': 25.741}, {'end': 1967.37, 'text': "And that's it.", 'start': 1966.669, 'duration': 0.701}, {'end': 1973.896, 'text': 'And you close the define function and there you have defined your consonant in your PHP script.', 'start': 1967.75, 'duration': 6.146}, {'end': 1978.54, 'text': 'Now this cannot be changed or undefined throughout your program.', 'start': 1974.436, 'duration': 4.104}], 'summary': 'Write the names of consonants like hp, lenovo, and asus in a php script to define them as constants.', 'duration': 47.259, 'max_score': 1931.281, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg1931281.jpg'}], 'start': 1263.332, 'title': 'Php basics', 'summary': 'Covers php basics including variables, arrays, comments, and constants. it explains creating, printing variables, array usage, comments types, array access, and constant creation with define function.', 'chapters': [{'end': 1661.837, 'start': 1263.332, 'title': 'Php variables and arrays', 'summary': 'Introduces php variables and arrays, explaining the concept of variables, creating and printing variables, and demonstrating the use of arrays to store multiple values under a single variable.', 'duration': 398.505, 'highlights': ["The chapter explains the concept of variables, demonstrating the creation of a variable 'str' to store a string value and the flexibility of naming variables in PHP.", 'It introduces the use of echo and dot to print variables, showcasing the printing of different variables without the need to write them again and again.', "The concept of arrays is introduced, demonstrating the creation of an array 'laptop brand' to store multiple laptop brand names and the use of var_dump to display the contents of the array."]}, {'end': 2055.156, 'start': 1665.982, 'title': 'Comments, arrays, and constants in php', 'summary': 'Covers the concept of comments in code, the use of single-line and multi-line comments, working with arrays including accessing specific elements and understanding array positions, and the creation and usage of constants in php, demonstrating the use of define function and echoing constant values.', 'duration': 389.174, 'highlights': ['The chapter explains the concept of comments in code, including the use of single-line comments starting with two slashes and multi-line comments using slash star and star slash, emphasizing their role in improving code readability and understanding.', 'It demonstrates the working of arrays in PHP, including accessing specific elements by their positions, highlighting that array positions start from zero, and showcases the practical use of arrays with an example of printing specific elements.', 'The chapter introduces the concept of constants in PHP, highlighting that once defined, they cannot be changed or undefined throughout the program, and demonstrates the creation of constants using the define function and their usage by echoing their values.', 'It also illustrates the creation of constant arrays, showcasing the syntax and emphasizing that constant arrays, like normal constants, cannot be changed or undefined throughout the code.']}], 'duration': 791.824, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg1263332.jpg', 'highlights': ['The chapter introduces the concept of constants in PHP, highlighting that once defined, they cannot be changed or undefined throughout the program, and demonstrates the creation of constants using the define function and their usage by echoing their values.', 'It demonstrates the working of arrays in PHP, including accessing specific elements by their positions, highlighting that array positions start from zero, and showcases the practical use of arrays with an example of printing specific elements.', 'The chapter explains the concept of comments in code, including the use of single-line comments starting with two slashes and multi-line comments using slash star and star slash, emphasizing their role in improving code readability and understanding.', "The concept of arrays is introduced, demonstrating the creation of an array 'laptop brand' to store multiple laptop brand names and the use of var_dump to display the contents of the array.", 'It introduces the use of echo and dot to print variables, showcasing the printing of different variables without the need to write them again and again.', "The chapter explains the concept of variables, demonstrating the creation of a variable 'str' to store a string value and the flexibility of naming variables in PHP."]}, {'end': 3418.856, 'segs': [{'end': 2174.503, 'src': 'embed', 'start': 2140.911, 'weight': 0, 'content': [{'end': 2144.134, 'text': 'now, the example that we just discussed.', 'start': 2140.911, 'duration': 3.223}, {'end': 2155.338, 'text': 'if we want to check if this variable is greater than 7, and only and only then print the variable on the screen.', 'start': 2144.134, 'duration': 11.204}, {'end': 2166.909, 'text': "now. to do that, what we need to do is type in if and in the bracket we need to type the condition that we're going to check, that is,", 'start': 2155.338, 'duration': 11.571}, {'end': 2174.503, 'text': 'if variable greater than 7.', 'start': 2166.909, 'duration': 7.594}], 'summary': "Using an 'if' statement to check if a variable is greater than 7 before printing it.", 'duration': 33.592, 'max_score': 2140.911, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg2140911.jpg'}, {'end': 2616.862, 'src': 'embed', 'start': 2581.66, 'weight': 1, 'content': [{'end': 2586.283, 'text': 'switch statement makes it a lot, lot simpler and more readable.', 'start': 2581.66, 'duration': 4.623}, {'end': 2593.228, 'text': 'so what we need to do is we need to type in switch.', 'start': 2586.283, 'duration': 6.945}, {'end': 2596.971, 'text': 'okay, first, what we need to do is first we need to create a variable.', 'start': 2593.228, 'duration': 3.743}, {'end': 2602.755, 'text': 'so a variable, suppose.', 'start': 2596.971, 'duration': 5.784}, {'end': 2614.982, 'text': 'let us name it level, and level is 3..', 'start': 2602.755, 'duration': 12.227}, {'end': 2616.862, 'text': 'To create a switch statement,', 'start': 2614.982, 'duration': 1.88}], 'summary': 'Using switch statement for readability, simplifying code', 'duration': 35.202, 'max_score': 2581.66, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg2581660.jpg'}], 'start': 2056.775, 'title': 'Php conditional statements, loops, and functions', 'summary': 'Covers php conditional statements including if, if else, else if, and switch statements, along with conditional loops like while, do while, and for loops, and introduces php functions.', 'chapters': [{'end': 2296.17, 'start': 2056.775, 'title': 'Php conditional statements', 'summary': 'Introduces php conditional statements, including if, if else, and else, and discusses their usage to execute code based on different conditions, such as checking if a variable is greater than 7 and printing it, and using else to handle cases where the condition is not met.', 'duration': 239.395, 'highlights': ['PHP conditional statements include if, if else, and else, and are used to execute code based on different conditions. The chapter introduces PHP conditional statements, such as if, if else, and else, for executing code based on different conditions.', 'Demonstrates using if statement to check if a variable is greater than 7 and printing it. The example illustrates using the if statement to check if a variable is greater than 7 and printing it on the screen.', 'Illustrates using else statement to handle cases where the condition is not met. The chapter demonstrates using the else statement to handle cases where the condition specified in the if statement is not met.']}, {'end': 2727.875, 'start': 2296.87, 'title': 'Using if, else if, and switch statements', 'summary': 'Explains how to use if, else if, and switch statements for checking divisibility by 2, 3, or both, and performing different actions based on different conditions, demonstrating with examples of code execution and output.', 'duration': 431.005, 'highlights': ['The chapter demonstrates using if, else if, and else statements to check divisibility by 2, 3, or both, showing examples of code execution with values like 6, 4, 9, and 13 and their corresponding output.', 'It explains the switch statement and its advantage in simplifying and making the code more readable for performing different actions based on different conditions, illustrating with an example of a game with four different levels and the code execution for the switch statement.']}, {'end': 3418.856, 'start': 2727.875, 'title': 'Php conditional statements, loops, and functions', 'summary': 'Covers the usage of conditional statements in php, including the switch statement and conditional loops such as while, do while, and for loops, along with an introduction to php functions.', 'duration': 690.981, 'highlights': ["PHP functions are of two types: built-in functions and user-defined functions. Functions in PHP are categorized into built-in functions and user-defined functions, where built-in functions, such as 'echo', are already present in the framework, while user-defined functions are created by the programmer for repeated code usage.", 'Explanation of different types of PHP loops: while, do while, and for loops. The chapter elaborates on the functionality of different types of PHP loops, including while, do while, and for loops, providing examples and usage scenarios for each type of loop.', 'Demonstration of using the switch statement in PHP for conditional checks. The usage of the switch statement in PHP for evaluating different conditions and providing default error messages is demonstrated, emphasizing the syntax and its application in handling conditional checks.']}], 'duration': 1362.081, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg2056775.jpg', 'highlights': ['The chapter introduces PHP conditional statements, such as if, if else, and else, for executing code based on different conditions.', 'The chapter demonstrates using if, else if, and else statements to check divisibility by 2, 3, or both, showing examples of code execution with values like 6, 4, 9, and 13 and their corresponding output.', 'The chapter elaborates on the functionality of different types of PHP loops, including while, do while, and for loops, providing examples and usage scenarios for each type of loop.', "Functions in PHP are categorized into built-in functions and user-defined functions, where built-in functions, such as 'echo', are already present in the framework, while user-defined functions are created by the programmer for repeated code usage."]}, {'end': 5565.217, 'segs': [{'end': 3510.225, 'src': 'embed', 'start': 3419.497, 'weight': 7, 'content': [{'end': 3426.421, 'text': 'Or do you just want to use this piece of code from here, from anywhere in your program?', 'start': 3419.497, 'duration': 6.924}, {'end': 3433.86, 'text': 'Now, to do that, we need to put this piece of code inside a user defined function.', 'start': 3427.395, 'duration': 6.465}, {'end': 3435.682, 'text': 'So how do we do that?', 'start': 3434.561, 'duration': 1.121}, {'end': 3465.002, 'text': 'We do that by writing function, followed by, suppose you want to call this function a name name and start with curly braces.', 'start': 3437.183, 'duration': 27.819}, {'end': 3469.305, 'text': 'now this is a user defined function, named name.', 'start': 3465.002, 'duration': 4.303}, {'end': 3474.448, 'text': 'now, inside this name function is a piece of code.', 'start': 3469.305, 'duration': 5.143}, {'end': 3479.03, 'text': 'this for now.', 'start': 3474.448, 'duration': 4.582}, {'end': 3481.672, 'text': 'how do we reuse it?', 'start': 3479.03, 'duration': 2.642}, {'end': 3484.674, 'text': "I'll show you in a second.", 'start': 3481.672, 'duration': 3.002}, {'end': 3491.838, 'text': 'so suppose you are a long way from your code, from this code.', 'start': 3484.674, 'duration': 7.164}, {'end': 3494.46, 'text': "you don't even know where it is.", 'start': 3491.838, 'duration': 2.622}, {'end': 3500.005, 'text': 'you want to use this code again after writing hundreds of lines of code.', 'start': 3494.46, 'duration': 5.545}, {'end': 3502.026, 'text': 'so how do you do it?', 'start': 3500.005, 'duration': 2.021}, {'end': 3509.264, 'text': 'you just type the name of the function, that is, name, And close it.', 'start': 3502.026, 'duration': 7.238}, {'end': 3510.225, 'text': "That's about it.", 'start': 3509.544, 'duration': 0.681}], 'summary': 'Create a user-defined function to reuse code throughout the program.', 'duration': 90.728, 'max_score': 3419.497, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg3419497.jpg'}, {'end': 3617.931, 'src': 'embed', 'start': 3561.662, 'weight': 12, 'content': [{'end': 3568.752, 'text': 'save it and, as you can see, Once the function is called,', 'start': 3561.662, 'duration': 7.09}, {'end': 3581.263, 'text': "the output is printed and I'm going to run it again later and then again the function is called and it uses the same piece of code again and again and again.", 'start': 3568.752, 'duration': 12.511}, {'end': 3587.008, 'text': 'See how simple coding can be when you know what to use when.', 'start': 3582.124, 'duration': 4.884}, {'end': 3591.913, 'text': "Now let's move ahead and understand the concepts of oops in PHP.", 'start': 3588.049, 'duration': 3.864}, {'end': 3599.246, 'text': 'So as you can see on the screen, I have listed down the eight concepts of OOPS that we will be discussing today.', 'start': 3593.004, 'duration': 6.242}, {'end': 3606.368, 'text': 'First is class, next comes objects, then its member functions and member variables,', 'start': 3600.326, 'duration': 6.042}, {'end': 3612.229, 'text': 'then constructor and destructor inheritance and finally it is polymorphism.', 'start': 3606.368, 'duration': 5.861}, {'end': 3615.67, 'text': "Now let's walk through each of the concepts one by one.", 'start': 3613.09, 'duration': 2.58}, {'end': 3617.931, 'text': 'First is class.', 'start': 3616.991, 'duration': 0.94}], 'summary': 'The function is called repeatedly, and 8 oops concepts in php are explained.', 'duration': 56.269, 'max_score': 3561.662, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg3561662.jpg'}, {'end': 4132.051, 'src': 'heatmap', 'start': 3754.818, 'weight': 0.78, 'content': [{'end': 3760.783, 'text': 'Here I have defined a class by using the class keyword followed by fruit which is the class name.', 'start': 3754.818, 'duration': 5.965}, {'end': 3768.609, 'text': 'Next I have added a pair of curly braces and added the entire properties and methods within the braces.', 'start': 3761.984, 'duration': 6.625}, {'end': 3777.255, 'text': 'So as you can see on the screen we have declared a class named fruit that contains two properties called name and color.', 'start': 3769.229, 'duration': 8.026}, {'end': 3782.96, 'text': 'Along with that I have also added two methods setName and getName.', 'start': 3778.316, 'duration': 4.644}, {'end': 3789.891, 'text': 'Now, the purpose of these methods is for setting and getting the name property.', 'start': 3784.928, 'duration': 4.963}, {'end': 3793.193, 'text': 'So, let me give you some important information.', 'start': 3790.791, 'duration': 2.402}, {'end': 3800.737, 'text': 'When you define a class, a variable in it is called property while a function is known as method.', 'start': 3793.733, 'duration': 7.004}, {'end': 3804.659, 'text': 'Now, let us execute the code and see the output.', 'start': 3802.097, 'duration': 2.562}, {'end': 3813.043, 'text': "Let's go to the browser and type localhost slash followed by the file name.", 'start': 3808.1, 'duration': 4.943}, {'end': 3827.234, 'text': 'here is a file class.php, and, as you can see on the screen, the code is running perfectly.', 'start': 3819.349, 'duration': 7.885}, {'end': 3829.915, 'text': 'now. that was about the class.', 'start': 3827.234, 'duration': 2.681}, {'end': 3831.757, 'text': 'next comes objects.', 'start': 3829.915, 'duration': 1.842}, {'end': 3834.318, 'text': 'so it is an instance of a class.', 'start': 3831.757, 'duration': 2.561}, {'end': 3838.421, 'text': 'basically, a variable holds the data of a class.', 'start': 3834.318, 'duration': 4.103}, {'end': 3844.964, 'text': 'now we define a class once and create as many objects in it.', 'start': 3838.421, 'duration': 6.543}, {'end': 3847.306, 'text': 'so for a better understanding, let me give you an example.', 'start': 3844.964, 'duration': 2.342}, {'end': 3849.688, 'text': 'Suppose a car is a class.', 'start': 3847.927, 'duration': 1.761}, {'end': 3853.35, 'text': 'So Mercedes Benz and BMW would be objects.', 'start': 3850.368, 'duration': 2.982}, {'end': 3855.271, 'text': "Now let's see objects.", 'start': 3854.25, 'duration': 1.021}, {'end': 3858.572, 'text': 'Classes are incomplete without objects.', 'start': 3856.171, 'duration': 2.401}, {'end': 3862.554, 'text': 'So we can add as many objects as we want from a class.', 'start': 3859.133, 'duration': 3.421}, {'end': 3868.217, 'text': 'And every single object has the properties and methods defined in the class.', 'start': 3863.435, 'duration': 4.782}, {'end': 3871.139, 'text': 'But those objects will have different property values.', 'start': 3868.837, 'duration': 2.302}, {'end': 3875.941, 'text': 'So objects of a class are created using the new keyword.', 'start': 3872.279, 'duration': 3.662}, {'end': 3886.609, 'text': "Now let me open the code editor and let's create another file called obj.php.", 'start': 3877.082, 'duration': 9.527}, {'end': 3890.932, 'text': 'So this code will be the same.', 'start': 3889.091, 'duration': 1.841}, {'end': 3895.015, 'text': "Let's copy and paste it here.", 'start': 3892.073, 'duration': 2.942}, {'end': 3901.22, 'text': 'Now let me type the code for object.', 'start': 3898.798, 'duration': 2.422}, {'end': 3917.193, 'text': 'As you can see, I have used the new keyword to create object of the class fruit.', 'start': 3911.528, 'duration': 5.665}, {'end': 3929.644, 'text': 'Similarly, banana would be another object.', 'start': 3922.338, 'duration': 7.306}, {'end': 3953.55, 'text': "And now we'll use the set name function to set the name to apple on this object on the apple object that we have created.", 'start': 3942.299, 'duration': 11.251}, {'end': 3963.5, 'text': 'Similarly, we will set the name for the banana object.', 'start': 3954.591, 'duration': 8.909}, {'end': 3977.353, 'text': "There is an extra bracket here, let's remove it.", 'start': 3975.171, 'duration': 2.182}, {'end': 3991.883, 'text': 'Now moving forward, let us type the code to display what we have added into the objects.', 'start': 3981.916, 'duration': 9.967}, {'end': 3996.166, 'text': 'For this.', 'start': 3995.225, 'duration': 0.941}, {'end': 3998.027, 'text': 'can you guess which method we will be using?', 'start': 3996.166, 'duration': 1.861}, {'end': 4008.913, 'text': 'Yes, the getName method will be used to display the name saved onto the object using the setName method.', 'start': 3999.528, 'duration': 9.385}, {'end': 4038.474, 'text': "Now that our code is complete, Let us run and check if it's working correctly.", 'start': 4030.439, 'duration': 8.035}, {'end': 4043.478, 'text': 'Let me go back and refresh.', 'start': 4040.796, 'duration': 2.682}, {'end': 4048.722, 'text': 'Now here we have our object.php file.', 'start': 4046.28, 'duration': 2.442}, {'end': 4052.065, 'text': 'Yes, the code runs perfectly.', 'start': 4050.624, 'duration': 1.441}, {'end': 4057.269, 'text': 'The fruit program and it is displaying apple and banana from the two objects that we created.', 'start': 4052.125, 'duration': 5.144}, {'end': 4060.932, 'text': 'I hope now you have clearly understood the concept.', 'start': 4058.69, 'duration': 2.242}, {'end': 4066.312, 'text': "Moving on to the next one, let's talk about the member variable and member function.", 'start': 4061.528, 'duration': 4.784}, {'end': 4069.394, 'text': 'A member variable is defined within a class.', 'start': 4067.053, 'duration': 2.341}, {'end': 4073.678, 'text': 'The data can be accessed by the member functions alone.', 'start': 4070.535, 'duration': 3.143}, {'end': 4076.14, 'text': 'Now, once the object is built.', 'start': 4074.298, 'duration': 1.842}, {'end': 4084.206, 'text': 'these variables are called attributes of the object, whereas member function is defined within a class and is used to access object data.', 'start': 4076.14, 'duration': 8.066}, {'end': 4086.228, 'text': 'So next comes constructor.', 'start': 4084.647, 'duration': 1.581}, {'end': 4095.641, 'text': "so it allows an individual to allot an object's properties while the object creation, while a destructor,", 'start': 4087.313, 'duration': 8.328}, {'end': 4099.184, 'text': 'is a function that is called when the object stops working.', 'start': 4095.641, 'duration': 3.543}, {'end': 4102.867, 'text': 'we will have a look at the constructor program.', 'start': 4099.184, 'duration': 3.683}, {'end': 4109.792, 'text': "so constructor allows an individual to allot an object's properties while the object creation.", 'start': 4102.867, 'duration': 6.925}, {'end': 4112.576, 'text': 'now, suppose you build a program using constructor function.', 'start': 4109.792, 'duration': 2.784}, {'end': 4118.604, 'text': 'PHP will automatically call the construct function while creating an object from a class.', 'start': 4113.522, 'duration': 5.082}, {'end': 4125.287, 'text': 'Also, remember that when you write the construct function always prefix it with two underscores.', 'start': 4119.205, 'duration': 6.082}, {'end': 4132.051, 'text': "Now let's have a look at the example where we will be using a constructor function with calling the setName method.", 'start': 4126.089, 'duration': 5.962}], 'summary': 'The transcript covers class, objects, member variables, member functions, constructor, and destructor in php.', 'duration': 377.233, 'max_score': 3754.818, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg3754818.jpg'}, {'end': 3789.891, 'src': 'embed', 'start': 3761.984, 'weight': 0, 'content': [{'end': 3768.609, 'text': 'Next I have added a pair of curly braces and added the entire properties and methods within the braces.', 'start': 3761.984, 'duration': 6.625}, {'end': 3777.255, 'text': 'So as you can see on the screen we have declared a class named fruit that contains two properties called name and color.', 'start': 3769.229, 'duration': 8.026}, {'end': 3782.96, 'text': 'Along with that I have also added two methods setName and getName.', 'start': 3778.316, 'duration': 4.644}, {'end': 3789.891, 'text': 'Now, the purpose of these methods is for setting and getting the name property.', 'start': 3784.928, 'duration': 4.963}], 'summary': 'Created a fruit class with 2 properties and 2 methods.', 'duration': 27.907, 'max_score': 3761.984, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg3761984.jpg'}, {'end': 3895.015, 'src': 'embed', 'start': 3829.915, 'weight': 1, 'content': [{'end': 3831.757, 'text': 'next comes objects.', 'start': 3829.915, 'duration': 1.842}, {'end': 3834.318, 'text': 'so it is an instance of a class.', 'start': 3831.757, 'duration': 2.561}, {'end': 3838.421, 'text': 'basically, a variable holds the data of a class.', 'start': 3834.318, 'duration': 4.103}, {'end': 3844.964, 'text': 'now we define a class once and create as many objects in it.', 'start': 3838.421, 'duration': 6.543}, {'end': 3847.306, 'text': 'so for a better understanding, let me give you an example.', 'start': 3844.964, 'duration': 2.342}, {'end': 3849.688, 'text': 'Suppose a car is a class.', 'start': 3847.927, 'duration': 1.761}, {'end': 3853.35, 'text': 'So Mercedes Benz and BMW would be objects.', 'start': 3850.368, 'duration': 2.982}, {'end': 3855.271, 'text': "Now let's see objects.", 'start': 3854.25, 'duration': 1.021}, {'end': 3858.572, 'text': 'Classes are incomplete without objects.', 'start': 3856.171, 'duration': 2.401}, {'end': 3862.554, 'text': 'So we can add as many objects as we want from a class.', 'start': 3859.133, 'duration': 3.421}, {'end': 3868.217, 'text': 'And every single object has the properties and methods defined in the class.', 'start': 3863.435, 'duration': 4.782}, {'end': 3871.139, 'text': 'But those objects will have different property values.', 'start': 3868.837, 'duration': 2.302}, {'end': 3875.941, 'text': 'So objects of a class are created using the new keyword.', 'start': 3872.279, 'duration': 3.662}, {'end': 3886.609, 'text': "Now let me open the code editor and let's create another file called obj.php.", 'start': 3877.082, 'duration': 9.527}, {'end': 3890.932, 'text': 'So this code will be the same.', 'start': 3889.091, 'duration': 1.841}, {'end': 3895.015, 'text': "Let's copy and paste it here.", 'start': 3892.073, 'duration': 2.942}], 'summary': 'Classes are templates, objects are instances. multiple objects can be created from a class, each having different property values.', 'duration': 65.1, 'max_score': 3829.915, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg3829915.jpg'}, {'end': 4351.535, 'src': 'embed', 'start': 4261.383, 'weight': 5, 'content': [{'end': 4264.865, 'text': "Now let's create an object to invoke the constructor.", 'start': 4261.383, 'duration': 3.482}, {'end': 4279.851, 'text': 'Now since the constructor has attributes, we will have to give the values for the attributes as well.', 'start': 4274.429, 'duration': 5.422}, {'end': 4288.615, 'text': 'So the fruit would be strawberry and the color would be pink.', 'start': 4280.872, 'duration': 7.743}, {'end': 4297.598, 'text': 'So this creates a new object and it gives the values to the constructor.', 'start': 4291.348, 'duration': 6.25}, {'end': 4349.053, 'text': 'in the PHP script and our HTML code as well.', 'start': 4338.702, 'duration': 10.351}, {'end': 4351.535, 'text': "let us save the code and check if it's working.", 'start': 4349.053, 'duration': 2.482}], 'summary': "Creating a new object with attributes 'fruit' as strawberry and 'color' as pink in php and html script.", 'duration': 90.152, 'max_score': 4261.383, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg4261383.jpg'}, {'end': 5346.513, 'src': 'embed', 'start': 5269.651, 'weight': 3, 'content': [{'end': 5282.796, 'text': "Now what PHP mess detector does is it analyzes your PHP code on every save and now there's no additional setup required if php is already installed on your system,", 'start': 5269.651, 'duration': 13.145}, {'end': 5284.837, 'text': 'which already is.', 'start': 5282.796, 'duration': 2.041}, {'end': 5290.479, 'text': 'so to see what it does, let us install it now.', 'start': 5284.837, 'duration': 5.642}, {'end': 5302.081, 'text': 'before that, let us go back to test.php, and let me just open this now.', 'start': 5290.479, 'duration': 11.602}, {'end': 5304.343, 'text': 'here you can see the output of your code.', 'start': 5302.081, 'duration': 2.262}, {'end': 5313.909, 'text': 'so if you go back to php mess detector, install it and go back to your code, you can see php mess detector is visible here and,', 'start': 5304.343, 'duration': 9.566}, {'end': 5336.008, 'text': 'after everything that you write, it analyzes your code after every save and it is pretty useful while writing big and complex php codes.', 'start': 5313.909, 'duration': 22.099}, {'end': 5346.513, 'text': "now let's move on to the next extension, which would be php auto close tag.", 'start': 5336.008, 'duration': 10.505}], 'summary': 'Php mess detector analyzes code on save, useful for complex codes.', 'duration': 76.862, 'max_score': 5269.651, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg5269651.jpg'}], 'start': 3419.497, 'title': 'Php oops concepts', 'summary': 'Covers user-defined functions and oops concepts in php, including classes, objects, methods, constructors, destructors, inheritance, polymorphism, and essential php extensions for visual studio code.', 'chapters': [{'end': 3789.891, 'start': 3419.497, 'title': 'Functions, oops concepts in php', 'summary': 'Explains the concept of user-defined functions and demonstrates the use of functions to call code repeatedly, followed by an introduction to the eight concepts of oops in php, including class, objects, member functions, member variables, constructor, destructor, inheritance, and polymorphism.', 'duration': 370.394, 'highlights': ['Introduction to user-defined functions and their reusability The chapter explains the concept of user-defined functions and demonstrates the use of functions to call code repeatedly, making coding simpler and more efficient.', 'Overview of the eight concepts of OOPS in PHP The chapter introduces the eight concepts of OOPS in PHP, including class, objects, member functions, member variables, constructor, destructor, inheritance, and polymorphism, providing a comprehensive understanding of OOPS concepts in PHP.']}, {'end': 4048.722, 'start': 3790.791, 'title': 'Understanding classes, objects, and methods in php', 'summary': 'Covers the concept of classes and objects in php, explaining the distinction between properties and methods within a class, the instantiation of objects, and the utilization of methods to manipulate object properties and display data.', 'duration': 257.931, 'highlights': ['A class consists of properties and methods, where properties are variables and methods are functions.', 'Objects are instances of a class, allowing for the creation of multiple objects based on a single class.', 'Objects of a class share the properties and methods defined in the class, but have different property values.', "The 'new' keyword is used to create objects of a class, and methods are utilized to manipulate object properties and display data."]}, {'end': 4500.69, 'start': 4050.624, 'title': 'Constructor and destructor in php', 'summary': 'Explains the concept of member variable, member function, constructor, and destructor in php, including how to use them and their functionalities, with an example of creating a fruit object and invoking the constructor and destructor functions.', 'duration': 450.066, 'highlights': ['The chapter explains the concept of member variable, member function, constructor, and destructor in PHP. It covers the fundamental concepts in PHP OOP and sets the stage for the subsequent examples.', 'It explains the concept of a constructor and its functionality, including the automatic call of the construct function while creating an object from a class in PHP. It elaborates on the purpose and usage of a constructor function in PHP, emphasizing the automatic invocation and the naming convention for the construct function.', 'It provides an example of using a constructor function to set the names and colors of a fruit during object creation and demonstrates the process in a PHP script and HTML code. It illustrates the practical implementation of a constructor function by setting the attributes of a fruit object during its creation and verifying its functionality in both PHP and HTML.', 'It demonstrates an example of a destructor function and its usage, including how to write and use a destructor function in PHP. It showcases the purpose and utilization of a destructor function in PHP, highlighting the similarity to the constructor function and the absence of attributes.']}, {'end': 5087.451, 'start': 4502.336, 'title': 'Oop concepts: inheritance, polymorphism', 'summary': 'Explains inheritance, with a child class derived from a parent class, and polymorphism, where the same function is utilized for different purposes. it also demonstrates the creation of classes and objects, with examples and code snippets.', 'duration': 585.115, 'highlights': ['Inheritance involves creating child classes derived from parent classes, each having its own properties and methods. Inheritance allows the creation of child classes from a parent class, with each class having its own properties and methods. The transcript provides examples of creating classes and objects, with a specific focus on the inheritance aspect.', 'Polymorphism allows the same function to be utilized for different purposes and involves overriding inherited methods in derived classes. Polymorphism is explained as the ability to use the same function for different purposes, and the process of overriding inherited methods in derived classes. The transcript also includes a demonstration of creating and invoking objects to showcase polymorphism in action.', 'Demonstrates the creation of classes and objects, with specific examples and code snippets. The transcript provides clear examples and code snippets to illustrate the creation of classes and objects, enhancing the understanding of OOP concepts such as inheritance and polymorphism.']}, {'end': 5565.217, 'start': 5087.451, 'title': 'Essential php extensions for visual studio code', 'summary': 'Discusses essential php extensions for visual studio code, including php intellifence for intelligent code suggestions, php mess detector for code analysis, php auto close tag for automatic tag closure, php formatter for code formatting, and php debug for debugging purposes.', 'duration': 477.766, 'highlights': ['PHP IntelliFence intelligently suggests and auto fills parts of your code, making programming simpler and easier.', 'PHP Mess detector analyzes PHP code on every save, aiding in writing big and complex PHP codes.', 'php auto close tag automatically closes tags, saving time and preventing coding errors.', 'PHP formatter formats code with proper indentation, improving code readability.', 'php debug is helpful for debugging code and acts as a debug adapter between Visual Studio Code and Xdebug website.']}], 'duration': 2145.72, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg3419497.jpg', 'highlights': ['Introduction to user-defined functions and their reusability.', 'Overview of the eight concepts of OOPS in PHP.', 'A class consists of properties and methods, where properties are variables and methods are functions.', 'Objects are instances of a class, allowing for the creation of multiple objects based on a single class.', "The 'new' keyword is used to create objects of a class, and methods are utilized to manipulate object properties and display data.", 'The chapter explains the concept of member variable, member function, constructor, and destructor in PHP.', 'It provides an example of using a constructor function to set the names and colors of a fruit during object creation and demonstrates the process in a PHP script and HTML code.', 'It demonstrates an example of a destructor function and its usage, including how to write and use a destructor function in PHP.', 'Inheritance involves creating child classes derived from parent classes, each having its own properties and methods.', 'Polymorphism allows the same function to be utilized for different purposes and involves overriding inherited methods in derived classes.', 'PHP IntelliFence intelligently suggests and auto fills parts of your code, making programming simpler and easier.', 'PHP Mess detector analyzes PHP code on every save, aiding in writing big and complex PHP codes.', 'php auto close tag automatically closes tags, saving time and preventing coding errors.', 'PHP formatter formats code with proper indentation, improving code readability.', 'php debug is helpful for debugging code and acts as a debug adapter between Visual Studio Code and Xdebug website.']}, {'end': 7726.962, 'segs': [{'end': 6213.887, 'src': 'heatmap', 'start': 5859.927, 'weight': 0.995, 'content': [{'end': 5869.21, 'text': 'so, as you can see, we have got the output, but if you look at the link, it has an ampersand symbol along with the username and age.', 'start': 5859.927, 'duration': 9.283}, {'end': 5870.751, 'text': 'we entered now.', 'start': 5869.21, 'duration': 1.541}, {'end': 5876.993, 'text': 'before the browser sends the information, it encodes it using a scheme called url encoding.', 'start': 5870.751, 'duration': 6.242}, {'end': 5885.116, 'text': 'in this scheme, name value pairs are joined with equal sign and different pairs are separated by the ampersand.', 'start': 5876.993, 'duration': 8.123}, {'end': 5893.513, 'text': 'also, as we discussed earlier, the page request And the encoded information is separated by a question mark sign.', 'start': 5885.116, 'duration': 8.397}, {'end': 5898.477, 'text': 'So that was all about the get method moving on to the next one.', 'start': 5894.634, 'duration': 3.843}, {'end': 5900.759, 'text': "Let's have a look at the post method.", 'start': 5898.937, 'duration': 1.822}, {'end': 5907.625, 'text': 'Now the post method transfers information via HTTP headers.', 'start': 5902.62, 'duration': 5.005}, {'end': 5914.851, 'text': 'The information is encoded at described in the get method and put into a header called query string.', 'start': 5908.285, 'duration': 6.566}, {'end': 5919.705, 'text': 'The POST method does not have any restrictions on data size to be sent.', 'start': 5915.723, 'duration': 3.982}, {'end': 5929.871, 'text': 'The POST method can be used to send ASCII as well as binary data and the data sent by POST method goes through HTTP header.', 'start': 5920.446, 'duration': 9.425}, {'end': 5933.193, 'text': 'So security depends on HTTP protocol used.', 'start': 5930.311, 'duration': 2.882}, {'end': 5938.496, 'text': 'By using secure HTTP, you can make sure that your information is secure.', 'start': 5933.653, 'duration': 4.843}, {'end': 5941.538, 'text': "Now let's have a look at the code now.", 'start': 5939.297, 'duration': 2.241}, {'end': 6212.186, 'text': 'Now you must be wondering if both the methods give the same output.', 'start': 6208.462, 'duration': 3.724}, {'end': 6213.887, 'text': 'so what is the difference between them?', 'start': 6212.186, 'duration': 1.701}], 'summary': 'Comparison of get and post methods for transferring data via http, including encoding and security considerations.', 'duration': 353.96, 'max_score': 5859.927, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg5859927.jpg'}, {'end': 5929.871, 'src': 'embed', 'start': 5898.937, 'weight': 0, 'content': [{'end': 5900.759, 'text': "Let's have a look at the post method.", 'start': 5898.937, 'duration': 1.822}, {'end': 5907.625, 'text': 'Now the post method transfers information via HTTP headers.', 'start': 5902.62, 'duration': 5.005}, {'end': 5914.851, 'text': 'The information is encoded at described in the get method and put into a header called query string.', 'start': 5908.285, 'duration': 6.566}, {'end': 5919.705, 'text': 'The POST method does not have any restrictions on data size to be sent.', 'start': 5915.723, 'duration': 3.982}, {'end': 5929.871, 'text': 'The POST method can be used to send ASCII as well as binary data and the data sent by POST method goes through HTTP header.', 'start': 5920.446, 'duration': 9.425}], 'summary': 'Post method transfers information via http headers without size restrictions.', 'duration': 30.934, 'max_score': 5898.937, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg5898937.jpg'}, {'end': 6452.371, 'src': 'embed', 'start': 6248.947, 'weight': 4, 'content': [{'end': 6257.109, 'text': 'so let me tell you the request variable can be used to get the result from form data sent with both the get and post methods.', 'start': 6248.947, 'duration': 8.162}, {'end': 6260.308, 'text': 'Let us try out a code for the request method too.', 'start': 6257.839, 'duration': 2.469}, {'end': 6445.689, 'text': 'As you can see we have got the output.', 'start': 6443.308, 'duration': 2.381}, {'end': 6452.371, 'text': 'Today we will learn how to link MySQL database to your HTML code with the help of PHP.', 'start': 6445.849, 'duration': 6.522}], 'summary': 'Learn to link mysql database to html using php.', 'duration': 203.424, 'max_score': 6248.947, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg6248947.jpg'}, {'end': 7130.833, 'src': 'heatmap', 'start': 6884.936, 'weight': 0.978, 'content': [{'end': 6891.538, 'text': 'as you can notice, i have given necessary type for different fields.', 'start': 6884.936, 'duration': 6.602}, {'end': 6906.171, 'text': "so for email i've given the type as email for blood group text and phone as text in case someone wants to enter the entire phone number with the country code.", 'start': 6891.538, 'duration': 14.633}, {'end': 6920.277, 'text': 'so now let us create an input button that would be submit and name.', 'start': 6906.171, 'duration': 14.106}, {'end': 6921.097, 'text': 'let us keep it.', 'start': 6920.277, 'duration': 0.82}, {'end': 6935.034, 'text': 'submit. id would be submit.', 'start': 6921.097, 'duration': 13.937}, {'end': 6945.184, 'text': "let's close the form and close the webpage too.", 'start': 6935.034, 'duration': 10.15}, {'end': 6950.389, 'text': "now let's save it and check if it's working correctly.", 'start': 6945.184, 'duration': 5.205}, {'end': 6952.653, 'text': "Now let's open the browser.", 'start': 6951.232, 'duration': 1.421}, {'end': 6961.058, 'text': 'Before that, first we need to open the SAM control panel and start our Apache server and MySQL server.', 'start': 6953.313, 'duration': 7.745}, {'end': 6969.703, 'text': 'And now let us go to the localhost, type a folder name that is tutorial and open the form.', 'start': 6962.099, 'duration': 7.604}, {'end': 6973.406, 'text': 'Well, there seems to be a problem.', 'start': 6971.144, 'duration': 2.262}, {'end': 6975.347, 'text': 'The other fields are not visible.', 'start': 6973.806, 'duration': 1.541}, {'end': 6980.19, 'text': "Let's open a code and see what did we do wrong.", 'start': 6976.167, 'duration': 4.023}, {'end': 6985.735, 'text': "Yeah, well, there's a spelling mistake here.", 'start': 6983.154, 'duration': 2.581}, {'end': 6992.179, 'text': 'And since I copy pasted the code, the mistake got copy pasted too.', 'start': 6986.796, 'duration': 5.383}, {'end': 6999.783, 'text': "Well, let's save it again and check if it's working correctly.", 'start': 6994.78, 'duration': 5.003}, {'end': 7002.264, 'text': 'Yes, perfect.', 'start': 7001.544, 'duration': 0.72}, {'end': 7011.729, 'text': 'Now, before moving on to creating our connect.php file, we first need to create our database itself.', 'start': 7003.465, 'duration': 8.264}, {'end': 7017.065, 'text': 'So first we need to go to XAMPP control panel and click on admin.', 'start': 7012.563, 'duration': 4.502}, {'end': 7030.01, 'text': 'Now this will open the phpMyAdmin section where we will go to new and create our database.', 'start': 7017.665, 'duration': 12.345}, {'end': 7034.812, 'text': 'Let us name our database as test1.', 'start': 7030.05, 'duration': 4.762}, {'end': 7044.257, 'text': 'Let us give it five fields and name it users.', 'start': 7039.574, 'duration': 4.683}, {'end': 7052.182, 'text': 'First field would be ID and it would be auto-implemented.', 'start': 7047.799, 'duration': 4.383}, {'end': 7060.068, 'text': 'Second, we will name it as name.', 'start': 7053.463, 'duration': 6.605}, {'end': 7063.77, 'text': '250 email.', 'start': 7060.088, 'duration': 3.682}, {'end': 7066.472, 'text': 'This will also be backer.', 'start': 7065.151, 'duration': 1.321}, {'end': 7071.085, 'text': 'Third one would be phone.', 'start': 7069.284, 'duration': 1.801}, {'end': 7080.791, 'text': 'Variable characters since people can enter the plus sign to enter the country codes.', 'start': 7073.406, 'duration': 7.385}, {'end': 7085.954, 'text': 'And finally we will have our blood group.', 'start': 7082.051, 'duration': 3.903}, {'end': 7094.939, 'text': "And let's create our table here.", 'start': 7091.177, 'duration': 3.762}, {'end': 7106.757, 'text': 'As you can see, this is the structure of the table and the table is created.', 'start': 7103.215, 'duration': 3.542}, {'end': 7113.742, 'text': 'Now when you click on browse, it will show you the data in this table itself.', 'start': 7107.418, 'duration': 6.324}, {'end': 7117.364, 'text': "Since we haven't entered any data yet, it is blank.", 'start': 7114.242, 'duration': 3.122}, {'end': 7130.833, 'text': "Now let's open a code editor and create a file connect.php and let's get started.", 'start': 7118.805, 'duration': 12.028}], 'summary': 'Creating a form with input fields for email, blood group, and phone, encountering and resolving issues, and creating a database with five fields named id, name, email, phone, and blood group.', 'duration': 245.897, 'max_score': 6884.936, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg6884936.jpg'}, {'end': 7248.228, 'src': 'embed', 'start': 7214.483, 'weight': 2, 'content': [{'end': 7216.324, 'text': 'So we will have to type localhost.', 'start': 7214.483, 'duration': 1.841}, {'end': 7221.808, 'text': 'Now the type of user, that would be root.', 'start': 7218.286, 'duration': 3.522}, {'end': 7225.671, 'text': 'Now the third part is for the password.', 'start': 7223.209, 'duration': 2.462}, {'end': 7228.653, 'text': "Since we don't have a password for our database, it would be blank.", 'start': 7225.711, 'duration': 2.942}, {'end': 7231.916, 'text': 'And the fourth would be the name of our database.', 'start': 7229.534, 'duration': 2.382}, {'end': 7232.916, 'text': 'That is test1.', 'start': 7232.016, 'duration': 0.9}, {'end': 7243.164, 'text': 'Now we will also check if connection is not complete.', 'start': 7236.579, 'duration': 6.585}, {'end': 7248.228, 'text': 'We will have to display an error connection failed.', 'start': 7245.066, 'duration': 3.162}], 'summary': 'Configuring localhost connection with root user and test1 database.', 'duration': 33.745, 'max_score': 7214.483, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg7214483.jpg'}, {'end': 7665.843, 'src': 'embed', 'start': 7613.23, 'weight': 3, 'content': [{'end': 7619.293, 'text': "well, there's some error that we've experienced on line four.", 'start': 7613.23, 'duration': 6.063}, {'end': 7620.794, 'text': "okay, let's see.", 'start': 7619.293, 'duration': 1.501}, {'end': 7626.217, 'text': 'yeah, we did not close this.', 'start': 7620.794, 'duration': 5.423}, {'end': 7637.67, 'text': "okay, let's save it and try again.", 'start': 7626.217, 'duration': 11.453}, {'end': 7639.812, 'text': 'another error on line 12.', 'start': 7637.67, 'duration': 2.142}, {'end': 7646.478, 'text': 'what do we have here now?', 'start': 7639.812, 'duration': 6.666}, {'end': 7652.363, 'text': 'okay, so this is my sql, i not my sql.', 'start': 7646.478, 'duration': 5.885}, {'end': 7658.628, 'text': 'save, resend the form and entry successful.', 'start': 7652.363, 'duration': 6.265}, {'end': 7660.589, 'text': 'now the entry is successful.', 'start': 7658.628, 'duration': 1.961}, {'end': 7665.843, 'text': "you need to go to your database, which I've shown to you earlier.", 'start': 7660.589, 'duration': 5.254}], 'summary': 'Encountered errors on lines 4 and 12, resolved them, form entry successful.', 'duration': 52.613, 'max_score': 7613.23, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg7613230.jpg'}], 'start': 5566.057, 'title': 'Php methods, http, mysql, and apache setup', 'summary': 'Covers php get and post methods, highlighting their differences, http get and post methods emphasizing data transfer, encoding, and security, linking mysql database to html using php with a registration form, and setting up apache server and mysql database with xampp. it also explains database registration, data entry, and error handling.', 'chapters': [{'end': 5635.786, 'start': 5566.057, 'title': 'Php get and post methods', 'summary': 'Explains the php get and post methods, highlighting that the get method sends encoded user information appended to the page request, is limited to 1024 characters, and should not be used for sensitive information.', 'duration': 69.729, 'highlights': ['The get method sends the encoded user information appended to the page request, and it is restricted to sending up to 1024 characters.', "Never use the get method if you have a password or other sensitive information to be sent to the server, since it will show in the browser's location box.", "The get method can't be used to send binary data like images or word documents to the server."]}, {'end': 6248.947, 'start': 5636.747, 'title': 'Http methods: get and post', 'summary': 'Covers the usage of get and post methods in http, highlighting the differences in data transfer, encoding, and security, with emphasis on the secure nature of the post method due to its transmission of data via message body and not url string.', 'duration': 612.2, 'highlights': ['The POST method does not have any restrictions on data size to be sent, allowing for the transmission of ASCII as well as binary data through HTTP headers.', 'The major difference between POST and GET method is that GET method carries request parameters appended in the URL string, while POST carries request parameters in the message body, making it a more secure way of transferring data from the client to the destination.', 'By using secure HTTP, you can ensure that your information is secure, as security depends on the HTTP protocol used.']}, {'end': 6950.389, 'start': 6248.947, 'title': 'Linking mysql database to html with php', 'summary': 'Demonstrates how to link a mysql database to an html page using php, creating a registration form with fields for name, email, phone number, and blood group, making the name and email fields compulsory, and specifying input types for each field. it also mentions the tools used for the tutorial (xampp and visual studio code).', 'duration': 701.442, 'highlights': ['The chapter demonstrates how to link a MySQL database to an HTML page using PHP, creating a registration form with fields for name, email, phone number, and blood group, making the name and email fields compulsory, and specifying input types for each field.', 'The tutorial mentions the tools used for the demonstration, specifically XAMPP and Visual Studio Code.', 'The tutorial assumes a basic understanding of HTML, PHP, and MySQL for the audience.', 'The speaker mentions the use of request variables to retrieve form data sent via both get and post methods, and also hints at trying out a code for the request method.']}, {'end': 7248.228, 'start': 6951.232, 'title': 'Setting up apache server and mysql database', 'summary': 'Covers setting up apache server and mysql server using xampp control panel, creating a database named test1 with a table named users, and creating a connection to the database using mysqli_connect function with server name, user type, password, and database name.', 'duration': 296.996, 'highlights': ['Setting up Apache server and MySQL server using XAMPP control panel to create a database named test1 with a table named users', 'Creating a connection to the database using mysqli_connect function with server name, user type, password, and database name', 'Creating a file connect.php to establish the connection and displaying an error message if the connection fails']}, {'end': 7726.962, 'start': 7267.375, 'title': 'Database registration and data entry', 'summary': 'Explains how to create a database, link it to an html form, and enter and delete data, with examples of php and sql code, as well as error handling.', 'duration': 459.587, 'highlights': ['Creating variables to pick data from the registration fields in a registration page, including name, email, phone, and blood group.', 'Inserting data into a database table using an SQL command and sending the respective values using PHP.', 'Demonstrating error handling by identifying and resolving errors in the code, ensuring successful data entry into the database.', 'Explaining the process of deleting entries from the database, including deleting fields, users, and the entire database using phpMyAdmin.', 'Showing a practical example of entering data into the registration form and verifying its successful entry into the database.']}], 'duration': 2160.905, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg5566057.jpg', 'highlights': ['The major difference between POST and GET method is that GET method carries request parameters appended in the URL string, while POST carries request parameters in the message body, making it a more secure way of transferring data from the client to the destination.', 'The POST method does not have any restrictions on data size to be sent, allowing for the transmission of ASCII as well as binary data through HTTP headers.', 'Creating a connection to the database using mysqli_connect function with server name, user type, password, and database name', 'The chapter demonstrates how to link a MySQL database to an HTML page using PHP, creating a registration form with fields for name, email, phone number, and blood group, making the name and email fields compulsory, and specifying input types for each field.', 'Demonstrating error handling by identifying and resolving errors in the code, ensuring successful data entry into the database.']}, {'end': 9559.715, 'segs': [{'end': 7796.645, 'src': 'embed', 'start': 7767.155, 'weight': 2, 'content': [{'end': 7771.477, 'text': 'Math, MacAdherit, mail.com and the rest of the details.', 'start': 7767.155, 'duration': 4.322}, {'end': 7776.458, 'text': 'Today, we are going to have a video session on PHP form validation.', 'start': 7772.117, 'duration': 4.341}, {'end': 7782.074, 'text': 'So what does this actually mean? Okay, well, let me give you an example here.', 'start': 7777.31, 'duration': 4.764}, {'end': 7786.677, 'text': 'So when you try to create an account on Facebook or Instagram,', 'start': 7782.714, 'duration': 3.963}, {'end': 7792.522, 'text': 'you submit a form and then that form is cross verified with the code written in the backend.', 'start': 7786.677, 'duration': 5.845}, {'end': 7796.645, 'text': 'So today we are going to do the same process in this video.', 'start': 7793.442, 'duration': 3.203}], 'summary': 'Video session on php form validation for account creation.', 'duration': 29.49, 'max_score': 7767.155, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg7767155.jpg'}, {'end': 8499.667, 'src': 'embed', 'start': 8426.986, 'weight': 0, 'content': [{'end': 8431.368, 'text': 'that is cross-site referencing scripting attacks in forms.', 'start': 8426.986, 'duration': 4.382}, {'end': 8437.51, 'text': 'so now that we know what these functions do, let us jump and see if our webpage works.', 'start': 8431.368, 'duration': 6.142}, {'end': 8451.878, 'text': "okay. for that, first open xampp control panel and start the Apache server and now let's open the browser and type localhost, followed by the folder name.", 'start': 8437.51, 'duration': 14.368}, {'end': 8459.34, 'text': 'that would be validation and then a file name form.php.', 'start': 8451.878, 'duration': 7.462}, {'end': 8461.78, 'text': 'so yes, the form looks good.', 'start': 8459.34, 'duration': 2.44}, {'end': 8465.681, 'text': "let's add some name to it.", 'start': 8461.78, 'duration': 3.901}, {'end': 8467.982, 'text': 'email. xyz.com.', 'start': 8465.681, 'duration': 2.301}, {'end': 8474.45, 'text': "number is optional, but let's add some number to it.", 'start': 8470.347, 'duration': 4.103}, {'end': 8476.751, 'text': 'it would be 20.', 'start': 8474.45, 'duration': 2.301}, {'end': 8481.415, 'text': 'comment would be hello.', 'start': 8476.751, 'duration': 4.664}, {'end': 8486.278, 'text': 'welcome to simply learn.', 'start': 8481.415, 'duration': 4.863}, {'end': 8489.24, 'text': "gender would be male and let's click here.", 'start': 8486.278, 'duration': 2.962}, {'end': 8495.204, 'text': 'yes, so our input is visible and the form works perfectly.', 'start': 8489.24, 'duration': 5.964}, {'end': 8499.667, 'text': "now let's move on ahead with our second demo, that is, validating a form.", 'start': 8495.204, 'duration': 4.463}], 'summary': 'Demonstrating successful form validation on localhost with xampp and cross-site scripting attacks in forms.', 'duration': 72.681, 'max_score': 8426.986, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg8426986.jpg'}, {'end': 8621.125, 'src': 'embed', 'start': 8521.252, 'weight': 1, 'content': [{'end': 8535.362, 'text': "Let's go to the code editor and create another file and let's name it, validate.php and write another code for it.", 'start': 8521.252, 'duration': 14.11}, {'end': 8590.753, 'text': 'now added some color for the error that will be shown into the form again.', 'start': 8575.069, 'duration': 15.684}, {'end': 8606.034, 'text': 'let us write comment for it, define variables and set to empty, and variables would be named err.', 'start': 8590.753, 'duration': 15.281}, {'end': 8608.936, 'text': 'that is error.', 'start': 8606.034, 'duration': 2.902}, {'end': 8621.125, 'text': 'similarly, email err, gender, err and the rest of fields.', 'start': 8608.936, 'duration': 12.189}], 'summary': 'Created validate.php file, added error color, defined variables for form fields.', 'duration': 99.873, 'max_score': 8521.252, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg8521252.jpg'}, {'end': 9280.443, 'src': 'embed', 'start': 9005.73, 'weight': 6, 'content': [{'end': 9055.101, 'text': "let's write another code for another variable, that is website, and do the same thing again now.", 'start': 9005.73, 'duration': 49.371}, {'end': 9059.782, 'text': 'we will check if the url address syntax is valid or not.', 'start': 9055.101, 'duration': 4.681}, {'end': 9079.348, 'text': 'so which is the single?', 'start': 9059.782, 'duration': 19.566}, {'end': 9115.077, 'text': 'Thank you.', 'start': 9114.684, 'duration': 0.393}, {'end': 9244.063, 'text': 'Now we will write the test input function as we did in the form section.', 'start': 9237.577, 'duration': 6.486}, {'end': 9248.888, 'text': "So let's just copy it from there since it's going to be the same.", 'start': 9244.103, 'duration': 4.785}, {'end': 9280.443, 'text': "Now let's write the PHP script for the form validation section.", 'start': 9271.472, 'duration': 8.971}], 'summary': 'Writing code to validate website url syntax and creating test input function for form validation in php.', 'duration': 274.713, 'max_score': 9005.73, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg9005730.jpg'}, {'end': 9517.669, 'src': 'embed', 'start': 9472.648, 'weight': 4, 'content': [{'end': 9476.489, 'text': 'Open a browser and check if our web page is working correctly.', 'start': 9472.648, 'duration': 3.841}, {'end': 9488.046, 'text': 'type localhost, the name of the folder and the name of your file.', 'start': 9477.443, 'duration': 10.603}, {'end': 9501.45, 'text': "okay, so let's write something mac, mac xyz, add now, let's not write something after it, so that the email address would be wrong.", 'start': 9488.046, 'duration': 13.404}, {'end': 9511.547, 'text': 'just to check one, two, three, dot, see comment.', 'start': 9501.45, 'duration': 10.097}, {'end': 9517.669, 'text': "anything would do gender, male, and let's click on submit.", 'start': 9511.547, 'duration': 6.122}], 'summary': 'Checking web page functionality by entering data and submitting.', 'duration': 45.021, 'max_score': 9472.648, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg9472648.jpg'}], 'start': 7726.962, 'title': 'Php form validation', 'summary': 'Covers a video session on php form validation, creation of a registration form, displaying form details using php script, form validation demo, implementing validation for name and email fields, and form validation with php scripting, demonstrating examples and techniques. it includes setting up a folder in c drive xampp, different input elements such as full name, email, number, comment, gender, and age, usage of post function, server section, html special characters function, and url address syntax validation.', 'chapters': [{'end': 7825.034, 'start': 7726.962, 'title': 'Php form validation video session', 'summary': 'Covers a video session on php form validation, including examples of creating and validating forms, and setting up a folder in c drive xampp.', 'duration': 98.072, 'highlights': ['The video session focuses on PHP form validation and includes two demos for creating and validating forms. PHP form validation, two demos', 'The speaker emphasizes the process of cross-verifying submitted forms with backend code, using examples of account creation on Facebook and Instagram. Cross-verification process, examples from Facebook and Instagram', "Instructions are given to open C drive XAMPP folder htdocs, create a folder named 'validation', and open the code editor for setting up the environment. Setting up folder in C drive XAMPP, creating 'validation' folder, opening code editor"]}, {'end': 8306.775, 'start': 7826.375, 'title': 'Creating a registration form in php', 'summary': 'Details the creation of a registration form in php, including the different input elements and their associated fields, such as full name, email, number, comment, gender, and age, with the comment field being a text area.', 'duration': 480.4, 'highlights': ['The form will contain full name, email number, comment, gender, and age, with the comment field being a text area.', 'The chapter details the creation of input elements such as username, email, mobile number, age, and gender, along with the use of text input and text area for different fields.', 'The details required in the form include full name, email, number, age, and comment, with the comment field being a text area instead of a simple input type.']}, {'end': 8461.78, 'start': 8306.775, 'title': 'Php form validation', 'summary': "Explains the process of displaying form details using a php script, including the usage of post function, server section, and html special characters function to prevent security attacks, and concludes with verifying the webpage's functionality using xampp control panel.", 'duration': 155.005, 'highlights': ["The form data is sent using the method 'post', and the server section utilizes the global variable 'php self' to return the file name of the code.", 'The html special characters function is used to convert special characters to html entities, preventing attackers from injecting HTML or JavaScript codes, particularly defending against cross-site referencing scripting attacks in forms.', "Verifying the webpage's functionality involves opening the XAMPP control panel, starting the Apache server, and accessing the form via 'localhost' and the designated folder and file name."]}, {'end': 8621.125, 'start': 8461.78, 'title': 'Form validation demo', 'summary': 'Demonstrates filling and validating a form with sample inputs and then writing code to validate the form against incorrect inputs, with an addition of error handling for the form fields. the form includes fields for name, email, number, comment, and gender, and the validation code includes error messages for incorrect inputs.', 'duration': 159.345, 'highlights': ['The form includes fields for name, email, number, comment, and gender. This highlights the different input fields in the form.', 'The form works perfectly with the provided inputs. This shows the successful submission of the form with the given inputs.', 'The code is validated against the input and returns an alert message if incorrect data is entered. This highlights the functionality of the code to validate inputs and provide error messages.', 'Error handling for the form fields is added to the code. This emphasizes the addition of error handling for the form fields in the validation code.']}, {'end': 9005.73, 'start': 8710.273, 'title': 'Php form validation', 'summary': 'Discusses implementing validation for name and email fields in a php form, ensuring the name contains only letters and white spaces and checking the correct formation of the email address.', 'duration': 295.457, 'highlights': ['The chapter focuses on implementing validation for the name and email fields in a PHP form.', 'The validation includes checking if the name only contains letters and white spaces.', 'The implementation involves ensuring the correct formation of the email address using if statements.', 'The code is debugged to correct errors, such as misplaced else statements and variable names.', 'The validation process aims to prevent errors and ensure data integrity.']}, {'end': 9559.715, 'start': 9005.73, 'title': 'Form validation and php scripting', 'summary': 'Involves writing code for form validation and php scripting, including checking the validity of url address syntax, and testing input functions, with examples of incorrect and correct input data.', 'duration': 553.985, 'highlights': ['Writing code for form validation and PHP scripting, including checking URL address syntax and testing input functions with examples of incorrect and correct input data', 'Demonstrating the process of writing test input functions for the form section and the PHP script for form validation', 'Showing examples of incorrect input data, such as an incorrect email address and name, and the resulting error messages', 'Providing an example of correct input data, including a valid website and email address']}], 'duration': 1832.753, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg7726962.jpg', 'highlights': ['The video session focuses on PHP form validation and includes two demos for creating and validating forms. PHP form validation, two demos', 'The speaker emphasizes the process of cross-verifying submitted forms with backend code, using examples of account creation on Facebook and Instagram. Cross-verification process, examples from Facebook and Instagram', 'The form will contain full name, email number, comment, gender, and age, with the comment field being a text area.', "The form data is sent using the method 'post', and the server section utilizes the global variable 'php self' to return the file name of the code.", 'The html special characters function is used to convert special characters to html entities, preventing attackers from injecting HTML or JavaScript codes, particularly defending against cross-site referencing scripting attacks in forms.', 'The chapter focuses on implementing validation for the name and email fields in a PHP form.', 'Writing code for form validation and PHP scripting, including checking URL address syntax and testing input functions with examples of incorrect and correct input data']}, {'end': 11691.287, 'segs': [{'end': 9736.407, 'src': 'embed', 'start': 9620.41, 'weight': 1, 'content': [{'end': 9625.753, 'text': 'To do that, open XAMPP Control Panel and start Apache and MySQL.', 'start': 9620.41, 'duration': 5.343}, {'end': 9629.515, 'text': "Now let's quickly open our web browser.", 'start': 9627.494, 'duration': 2.021}, {'end': 9636.919, 'text': 'Open the localhost and go to phpMyAdmin section.', 'start': 9633.077, 'duration': 3.842}, {'end': 9648.545, 'text': "Now let's create a new database and name it MyDB.", 'start': 9640.6, 'duration': 7.945}, {'end': 9662.309, 'text': "let's name the table users and we will have six fields in it.", 'start': 9654.227, 'duration': 8.082}, {'end': 9664.35, 'text': 'the first would be id.', 'start': 9662.309, 'duration': 2.041}, {'end': 9669.712, 'text': 'it would be integer and auto incremented, since it would be the primary key.', 'start': 9664.35, 'duration': 5.362}, {'end': 9679.775, 'text': "the second would be first name, type, where care, let's give it 250.", 'start': 9669.712, 'duration': 10.063}, {'end': 9689.72, 'text': 'the third would be last name, variable character.', 'start': 9679.775, 'duration': 9.945}, {'end': 9711.544, 'text': 'similarly, next would be an email password and finally gender.', 'start': 9689.72, 'duration': 21.824}, {'end': 9724.983, 'text': "So now that our table has been created, let's move on to the coding part.", 'start': 9719.761, 'duration': 5.222}, {'end': 9736.407, 'text': 'Now first we are going to create a file named config.php to configure the database.', 'start': 9725.843, 'duration': 10.564}], 'summary': 'Using xampp, create mydb database with users table having 6 fields, then configure the database by creating config.php file.', 'duration': 115.997, 'max_score': 9620.41, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg9620410.jpg'}, {'end': 9888.463, 'src': 'embed', 'start': 9808.743, 'weight': 2, 'content': [{'end': 9820.631, 'text': 'server name, username, password and the database name.', 'start': 9808.743, 'duration': 11.888}, {'end': 9835.221, 'text': "now this will create a connection for our database and now let's also check for errors while creating the database.", 'start': 9820.631, 'duration': 14.59}, {'end': 9859.443, 'text': 'Now, if an error is found while connecting to the database, it will show a message as connection failed.', 'start': 9850.157, 'duration': 9.286}, {'end': 9879.755, 'text': "Let's end the file.", 'start': 9878.534, 'duration': 1.221}, {'end': 9886.121, 'text': 'and move on to understanding the different CRUD operations.', 'start': 9882.438, 'duration': 3.683}, {'end': 9888.463, 'text': 'Now first comes create.', 'start': 9886.942, 'duration': 1.521}], 'summary': 'Creating database connection and checking for errors. moving on to crud operations.', 'duration': 79.72, 'max_score': 9808.743, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg9808743.jpg'}, {'end': 10286.427, 'src': 'embed', 'start': 10168.174, 'weight': 3, 'content': [{'end': 10195.407, 'text': 'to do that, we will send the query using the connect and put the attribute as sql fields.', 'start': 10168.174, 'duration': 27.233}, {'end': 10204.903, 'text': 'now, If the records are created, it will display a successful message.', 'start': 10195.407, 'duration': 9.496}, {'end': 10215.033, 'text': 'Else, in case of an error, it will show an error message.', 'start': 10206.985, 'duration': 8.048}, {'end': 10259.499, 'text': "Now let's close the connection using the close function and move on to creating our HTML form.", 'start': 10239.147, 'duration': 20.352}, {'end': 10286.427, 'text': "Let's give a heading here.", 'start': 10282.465, 'duration': 3.962}], 'summary': 'Sending query using connect, displaying success/error messages, closing connection, and creating html form with heading.', 'duration': 118.253, 'max_score': 10168.174, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg10168174.jpg'}, {'end': 11029.78, 'src': 'embed', 'start': 10895.443, 'weight': 0, 'content': [{'end': 10899.241, 'text': 'These are the codes for the edit and delete commands.', 'start': 10895.443, 'duration': 3.798}, {'end': 10942.993, 'text': 'finally, let us close the page now.', 'start': 10934.271, 'duration': 8.722}, {'end': 10969.811, 'text': "let's quickly move on to the third part update file and write its code Now, when the update button for the form is clicked.", 'start': 10942.993, 'duration': 26.818}, {'end': 10972.637, 'text': 'we need this code to process it.', 'start': 10969.811, 'duration': 2.826}, {'end': 11004.251, 'text': 'And similarly for the rest of the fields.', 'start': 10999.247, 'duration': 5.004}, {'end': 11013.678, 'text': "Let's quickly change the user ID.", 'start': 11008.975, 'duration': 4.703}, {'end': 11019.303, 'text': 'This would be ID.', 'start': 11017.902, 'duration': 1.401}, {'end': 11024.487, 'text': 'Last name.', 'start': 11023.646, 'duration': 0.841}, {'end': 11029.78, 'text': 'In Jesus name.', 'start': 11028.918, 'duration': 0.862}], 'summary': 'Coding update and delete commands for form fields.', 'duration': 134.337, 'max_score': 10895.443, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg10895443.jpg'}, {'end': 11506.834, 'src': 'embed', 'start': 11467.133, 'weight': 4, 'content': [{'end': 11473.538, 'text': "so, As you guess, I'm going to be skipping ahead with some part, some part of the code.", 'start': 11467.133, 'duration': 6.405}, {'end': 11478.341, 'text': 'now this is the code for our delete or PHP file.', 'start': 11473.538, 'duration': 4.803}, {'end': 11487.027, 'text': 'and now we will save all these files and Go to a browser and try to run.', 'start': 11478.341, 'duration': 8.686}, {'end': 11489.108, 'text': 'check if the run correct.', 'start': 11487.027, 'duration': 2.081}, {'end': 11503.072, 'text': 'now lips, open the localhost first and go to phpmyadmin and open our users field here.', 'start': 11489.108, 'duration': 13.964}, {'end': 11506.834, 'text': "so, as you can see, i've already created a record here.", 'start': 11503.072, 'duration': 3.762}], 'summary': 'Skipping ahead to the delete php file, testing in localhost, and creating a record in phpmyadmin.', 'duration': 39.701, 'max_score': 11467.133, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg11467133.jpg'}], 'start': 9562.056, 'title': 'Php crud and database operations', 'summary': 'Delves into php crud operators, database configuration with xampp and phpmyadmin, database entry for registration form, and php web page operations, covering the creation, reading, updating, and deleting records in a php application.', 'chapters': [{'end': 9619.521, 'start': 9562.056, 'title': 'Php crud operators demystified', 'summary': 'Delves into the fundamentals of php crud operators, discussing the purpose of create, read, update, and delete operations and their usage in building user interface conventions for data manipulation.', 'duration': 57.465, 'highlights': ['The chapter discusses the fundamentals of PHP CRUD operators, which stands for create, read, update, and delete, used in persistent storage functions.', 'The purpose of CRUD operations is to create user interface conventions for viewing, searching, and modifying data via computer-based forms and reports.', 'The operators are used to read, build, update, and delete data, and are essential in database management and user interface design.']}, {'end': 9949.366, 'start': 9620.41, 'title': 'Database configuration and crud operations', 'summary': 'Explains the process of configuring a database using xampp and phpmyadmin, creating a table with six fields, and setting up a connection to the database using php. it also covers the creation of a file for database configuration and understanding the crud operations in php.', 'duration': 328.956, 'highlights': ['Setting up database configuration using XAMPP and phpMyAdmin, creating a table with six fields (id, first name, last name, email, password, gender). The process involves starting Apache and MySQL in XAMPP Control Panel, opening phpMyAdmin to create a new database named MyDB and a table named users with six fields: id (integer, auto-incremented), first name (varchar, 250), last name (varchar), email (varchar), password (varchar), and gender.', 'Configuring the database connection using PHP and handling errors during the connection. Creating a file named config.php to configure the database connection by defining variables for server name, username, password, and database name, establishing a connection using mysqli command, and checking for errors while connecting to the database.', "Understanding the CRUD operations in PHP and creating a file for 'create' operation. Explaining the 'create' operation in PHP by creating a new file named create.php, which adds an insert statement to create a new record in the database and checks if the submit button on the form is pressed."]}, {'end': 10350.62, 'start': 9949.366, 'title': 'Database entry for registration form', 'summary': 'Explains the process of creating variables, writing sql queries, executing the query to enter values into the database, and creating an html form for a registration page, including the fields first name, last name, email, password, and gender.', 'duration': 401.254, 'highlights': ['The process of creating variables and writing SQL queries to enter values into the database is explained. Creation of variables, writing SQL query', 'The explanation of executing the query to enter values into the database is provided. Execution of query, insertion of values into the database', 'The creation of an HTML form for a registration page is detailed. Creation of HTML form, fields for first name, last name, password, and gender']}, {'end': 11311.78, 'start': 10350.62, 'title': 'Php web page operations', 'summary': 'Details the creation of a view page, including fetching and displaying data from a table, linking to a css file, and creating edit and delete commands in php, emphasizing the sql queries and execution.', 'duration': 961.16, 'highlights': ['The chapter discusses creating a view page in PHP to display data from a table, including fetching all data from the users table and executing the query, with a focus on linking to a bootstrap CSS file for visual enhancement.', 'It details the process of displaying specific fields like ID, email, and gender, and creating edit and delete commands for the displayed data to complete the view page.', 'The update file and its code are explained, including the processing of the update button for the form, writing SQL update queries, and executing the queries with success and error message handling.']}, {'end': 11691.287, 'start': 11360.181, 'title': 'Crud operations in php', 'summary': 'Covers the process of creating, reading, updating, and deleting records in a php application, with specific insights into creating, updating, and deleting records and their corresponding outcomes.', 'duration': 331.106, 'highlights': ['The chapter covers the process of creating, reading, updating, and deleting records in a PHP application, with a specific focus on creating, updating, and deleting records (6 instances).', "Demonstrates the creation of a new record 'map X' with the email 'mapx@simplylearnb.com' and password 'simplylearnB' (1 instance).", "Illustrates the successful update of a record with the new email 'xxxxx@xyz.com' and the successful deletion of a record with the name 'macx' and email 'simplylearnb@macx' (2 instances).", 'Describes the process of opening and editing a record, including the reference to the ID in the URL and the successful update of the record (2 instances).', "Provides insight into the display of records and the existence of a URL 'delete.php' for the deletion process (2 instances)."]}], 'duration': 2129.231, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg9562056.jpg', 'highlights': ['The chapter delves into PHP CRUD operators, covering create, read, update, and delete functions.', 'Database configuration using XAMPP and phpMyAdmin involves creating a table with six fields.', 'Configuring the database connection using PHP and handling errors during the connection.', 'The process of creating variables, writing SQL queries, and executing the query to enter values into the database is explained.', 'Creating a view page in PHP to display data from a table, including fetching all data and executing queries.', 'The chapter covers the process of creating, reading, updating, and deleting records in a PHP application.']}, {'end': 14141.585, 'segs': [{'end': 12206.517, 'src': 'embed', 'start': 12157.338, 'weight': 3, 'content': [{'end': 12158.238, 'text': 'Well, wait a second.', 'start': 12157.338, 'duration': 0.9}, {'end': 12164.96, 'text': 'I left off of a pretty important section of the registration form that is the register button itself.', 'start': 12158.578, 'duration': 6.382}, {'end': 12168.081, 'text': 'So let me just.', 'start': 12166.081, 'duration': 2}, {'end': 12170.602, 'text': 'Not form.', 'start': 12169.622, 'duration': 0.98}, {'end': 12172.563, 'text': 'Let me just create.', 'start': 12171.422, 'duration': 1.141}, {'end': 12177.684, 'text': 'The Registration.', 'start': 12173.983, 'duration': 3.701}, {'end': 12185.907, 'text': 'For Registration button and will be of type submit.', 'start': 12179.885, 'duration': 6.022}, {'end': 12198.814, 'text': 'and value displayed would be register.', 'start': 12187.609, 'duration': 11.205}, {'end': 12206.517, 'text': 'now we will move on to creating the CSS file and let us create a new file and name it style.css.', 'start': 12198.814, 'duration': 7.703}], 'summary': 'Transcript involves creating registration button and css file.', 'duration': 49.179, 'max_score': 12157.338, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg12157338.jpg'}, {'end': 13498.957, 'src': 'embed', 'start': 13470.856, 'weight': 0, 'content': [{'end': 13476.122, 'text': "Now for this tutorial, we'll be creating a set of files for different functions.", 'start': 13470.856, 'duration': 5.266}, {'end': 13478.986, 'text': 'Now there will be six in total.', 'start': 13476.663, 'duration': 2.323}, {'end': 13482.69, 'text': "Let us first create these files and we'll write the code later.", 'start': 13479.446, 'duration': 3.244}, {'end': 13486.752, 'text': 'now the first file would be index.php.', 'start': 13483.13, 'duration': 3.622}, {'end': 13494.755, 'text': "now this is the file that will be responsible for the login page where we'll enter a username and password to login.", 'start': 13486.752, 'duration': 8.003}, {'end': 13498.957, 'text': 'now the second file would be login.php.', 'start': 13494.755, 'duration': 4.202}], 'summary': 'Creating 6 files for different functions, including login page and code writing.', 'duration': 28.101, 'max_score': 13470.856, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg13470856.jpg'}, {'end': 13756.209, 'src': 'embed', 'start': 13720.641, 'weight': 2, 'content': [{'end': 13724.923, 'text': "now what i'm going to do is i'm going to name my table as users.", 'start': 13720.641, 'duration': 4.282}, {'end': 13745.887, 'text': "so here i'm writing select star from users, where username would be the value be passed and similarly password could also be the value that be passed.", 'start': 13724.923, 'duration': 20.964}, {'end': 13756.209, 'text': 'now this is where, if the password and username match with what we have in a database, it will display a message as logged in.', 'start': 13745.887, 'duration': 10.322}], 'summary': "Creating a table 'users' and querying for username and password match to display login message.", 'duration': 35.568, 'max_score': 13720.641, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg13720641.jpg'}], 'start': 11691.287, 'title': 'Creating registration and login system with php and mysql', 'summary': 'Covers creating a registration page and form using php, html, css, and mysql, implementing error handling, database connection, and login function, and adding credentials for a secure and user-friendly system.', 'chapters': [{'end': 12290.27, 'start': 11691.287, 'title': 'Creating a registration page with php and mysql', 'summary': 'Covers the process of creating a registration page using php, html, css, and xampp software, with a focus on username, password, and email fields, and the registration form styling using a css file.', 'duration': 598.983, 'highlights': ['The chapter covers the process of creating a registration page using PHP, HTML, CSS, and XAMPP software It includes the creation of a registration page with a focus on username, password, and email fields, along with the usage of XAMPP software for database operations.', 'The registration form includes fields for username, password, and email The form is designed to include simple categories - username, password, and email - with corresponding labels and input types.', 'Styling of the registration form is achieved using a CSS file The CSS file is utilized to enhance the visual appearance of the registration form, with specific code sections for different form elements.']}, {'end': 12596.334, 'start': 12309.13, 'title': 'Creating registration form and database', 'summary': 'Discusses creating a registration form structure, linking the pages, creating a database with phpmyadmin, and connecting the php code with the database for a complete structure.', 'duration': 287.204, 'highlights': ['Creating a database with phpMyAdmin by opening XAMPP, starting Apache and MySQL server, opening localhost phpMyAdmin, and creating a new database named form. Database named form, four columns created', 'Creating a registration form structure and linking the pages to each other, completing the structure of the registration form. Registration form structure completed', 'Connecting the PHP code with the database by creating a variable con to establish the connection. Connection between PHP code and the database created']}, {'end': 13370.19, 'start': 12600.748, 'title': 'Php database error handling', 'summary': 'Outlines the process of handling database connectivity, input validation, and data insertion in php, including checking for database connection, input field validation, and username existence, as well as displaying error messages and closing the database connection.', 'duration': 769.442, 'highlights': ['The chapter explains adding error messages to check database connectivity and field validation, ensuring proper data handling.', 'It details the process of checking if the username entered already exists in the database and displaying an error message if it does.', 'It highlights the insertion of data into the database and the display of corresponding error messages, emphasizing proper data handling.', 'It emphasizes the importance of closing the database connection and concludes by suggesting running the code for verification, ensuring smooth execution.']}, {'end': 13654.975, 'start': 13370.19, 'title': 'Create registration form with html, php, xampp and mysql', 'summary': 'Explains the process of creating a registration form using html, php, xampp, and mysql, allowing users to register with their email and password, while ensuring password security by using hash protection, and also outlines the structure and purpose of various files to be created for implementing a simple login system in php and mysql.', 'duration': 284.785, 'highlights': ['The process of creating a registration form using HTML, PHP, XAMPP, and MySQL is explained, allowing users to register with their email and password. The tutorial explains the process of creating a registration form using HTML, PHP, XAMPP, and MySQL, enabling users to register with their email and password.', 'Security measure of using hash protection for passwords is highlighted, ensuring that passwords are not visible to the database admins. The tutorial emphasizes the use of hash protection for passwords, ensuring that passwords are not visible to the database admins.', 'The structure and purpose of various files to be created for implementing a simple login system in PHP and MySQL are outlined. The tutorial outlines the structure and purpose of various files to be created for implementing a simple login system in PHP and MySQL.']}, {'end': 13988.676, 'start': 13657.957, 'title': 'Php login function', 'summary': 'Details the process of creating a php login function, including error handling, database connection, and session management, with a focus on creating a secure and user-friendly login system.', 'duration': 330.719, 'highlights': ['The code checks for empty username and password fields and displays appropriate error messages if they are empty. The code includes error handling for empty username and password fields, ensuring a user-friendly experience and preventing potential errors.', "The process involves writing an SQL query to retrieve data from a database and setting up a table named 'users' to store usernames and passwords. The chapter describes the creation of a table named 'users' and the retrieval of data from a database using SQL queries, laying the foundation for secure user authentication.", "Creation of a session for login, including the auto-incremented 'id' field as the primary key in the database. The process involves setting up a login session and utilizing an auto-incremented 'id' field as the primary key in the database, ensuring a secure and efficient login system.", 'The chapter emphasizes the importance of error handling, including displaying an error message for incorrect username or password entries. The chapter underscores the significance of error handling by displaying a specific error message for incorrect username or password entries, enhancing the user experience and security of the login system.', 'Describes the process of linking the home page to a CSS file for styling and displaying the logged-in username. The process involves linking the home page to a CSS file for styling and implementing a feature to display the username of the logged-in user, enhancing the visual appeal and personalization of the user experience.']}, {'end': 14141.585, 'start': 13988.676, 'title': 'Creating database and adding credentials', 'summary': 'Covers the process of creating a database and adding credentials, including creating a table with 3 columns, adding records to the database, and testing login with the added credentials.', 'duration': 152.909, 'highlights': ["The table users has been created with id, username, and password. Confirmation of successful creation of the 'users' table with specified columns.", "Two records 'mac' with password '12345' and 'simply learn' with password 'abcde' have been added to the database. Adding two records to the database, with specific usernames and passwords.", 'Error message correctly displayed for incorrect password and empty username during login attempt. Verification of error message functionality for incorrect credentials during login.']}], 'duration': 2450.298, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg11691287.jpg', 'highlights': ['The chapter covers creating a registration page using PHP, HTML, CSS, and XAMPP software, including the usage of XAMPP for database operations.', 'Creating a database with phpMyAdmin by opening XAMPP, starting Apache and MySQL server, and creating a new database named form.', 'Explaining the process of adding error messages for database connectivity and field validation, ensuring proper data handling.', 'Emphasizing the use of hash protection for passwords, ensuring that passwords are not visible to the database admins.', "Describing the creation of a table named 'users' and the retrieval of data from a database using SQL queries, laying the foundation for secure user authentication.", "Setting up a login session and utilizing an auto-incremented 'id' field as the primary key in the database, ensuring a secure and efficient login system."]}, {'end': 17360.422, 'segs': [{'end': 14416.228, 'src': 'embed', 'start': 14393.334, 'weight': 2, 'content': [{'end': 14402.52, 'text': 'According to this principle, there should be a uniform interface across all devices and platforms for the interaction between application and server.', 'start': 14393.334, 'duration': 9.186}, {'end': 14405.341, 'text': 'Layered systems.', 'start': 14404.581, 'duration': 0.76}, {'end': 14416.228, 'text': "Now, REST API's architecture includes several layers that operate together to construct a hierarchy that helps generate a more scalable and flexible application.", 'start': 14405.922, 'duration': 10.306}], 'summary': "Rest api's architecture incorporates layered systems for scalability and flexibility.", 'duration': 22.894, 'max_score': 14393.334, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg14393334.jpg'}, {'end': 14952.805, 'src': 'embed', 'start': 14851.932, 'weight': 4, 'content': [{'end': 14881.986, 'text': "again we're going to need the curly braces what I'm doing here is I'm creating a variable as a counter and I'm going to give it a value of zero.", 'start': 14851.932, 'duration': 30.054}, {'end': 14902.002, 'text': 'Now let us create a while loop and in this while loop I am going to fetch the data and display it in JSON format.', 'start': 14882.767, 'duration': 19.235}, {'end': 14952.805, 'text': 'Now we are going to write the names of all the rows that we created in a table.', 'start': 14946.181, 'duration': 6.624}], 'summary': 'Creating a loop to fetch and display data in json format.', 'duration': 100.873, 'max_score': 14851.932, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg14851932.jpg'}, {'end': 15964.949, 'src': 'embed', 'start': 15934.717, 'weight': 1, 'content': [{'end': 15937.218, 'text': "so it's now visible.", 'start': 15934.717, 'duration': 2.501}, {'end': 15946.222, 'text': 'twice reload home categories, contact and above looks perfect.', 'start': 15937.218, 'duration': 9.004}, {'end': 15952.267, 'text': "So you see, now that's the beauty of building a website.", 'start': 15949.406, 'duration': 2.861}, {'end': 15956.327, 'text': "You don't have to write the entire code by yourself.", 'start': 15952.287, 'duration': 4.04}, {'end': 15960.748, 'text': 'There are codes already written for all these kinds of stuff.', 'start': 15956.988, 'duration': 3.76}, {'end': 15964.949, 'text': "There's navigation bar, the carousel that I'm going to be using in the website,", 'start': 15960.768, 'duration': 4.181}], 'summary': 'Building a website saves time with pre-written codes for navigation and carousel.', 'duration': 30.232, 'max_score': 15934.717, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg15934717.jpg'}, {'end': 16331.533, 'src': 'embed', 'start': 16304.768, 'weight': 3, 'content': [{'end': 16309.029, 'text': "okay, let's reload and voila.", 'start': 16304.768, 'duration': 4.261}, {'end': 16316.41, 'text': 'so our images are visible here with this beautiful carousel and you can forward them.', 'start': 16309.029, 'duration': 7.381}, {'end': 16321.631, 'text': 'and well, does this not look beautiful to you?', 'start': 16316.41, 'duration': 5.221}, {'end': 16327.85, 'text': 'architecture, nature and travel.', 'start': 16322.666, 'duration': 5.184}, {'end': 16331.533, 'text': 'but as you can see, we have some problems.', 'start': 16327.85, 'duration': 3.683}], 'summary': 'A carousel displays images of architecture, nature, and travel, but there are issues.', 'duration': 26.765, 'max_score': 16304.768, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg16304768.jpg'}, {'end': 16933.71, 'src': 'embed', 'start': 16875.183, 'weight': 0, 'content': [{'end': 16888.632, 'text': 'yeah, refresh, nature, architecture and well nature again, because we did not edit the third part of the code.', 'start': 16875.183, 'duration': 13.449}, {'end': 16896.317, 'text': 'so the third part of the code will be for travel.', 'start': 16888.632, 'duration': 7.685}, {'end': 16901.601, 'text': 'let us quickly add the images.', 'start': 16896.317, 'duration': 5.284}, {'end': 16907.245, 'text': 'so travel2, travel4.', 'start': 16901.601, 'duration': 5.644}, {'end': 16914.811, 'text': 'think we use travel 5 already.', 'start': 16911.448, 'duration': 3.363}, {'end': 16929.686, 'text': 'so travel 6 and go back refresh and travel, images, architecture and nature.', 'start': 16914.811, 'duration': 14.875}, {'end': 16933.71, 'text': 'so half of our website is already done.', 'start': 16929.686, 'duration': 4.024}], 'summary': 'Half of the website is completed with images for travel, architecture, and nature.', 'duration': 58.527, 'max_score': 16875.183, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg16875183.jpg'}], 'start': 14141.585, 'title': 'Building websites with php and rest api', 'summary': 'Delves into creating a weather app for weather forecast, setting up xampp, connecting to the database, resolving css issues, optimizing website layout, and adding website navigation and carousel.', 'chapters': [{'end': 14502.267, 'start': 14141.585, 'title': 'Understanding rest api principles with php', 'summary': 'Explains the functionality of a program showing the login page and home page, followed by a detailed insight into rest api, including its definition, principles, and usage of http methods, to create a weather app for weather forecast using rest api with php.', 'duration': 360.682, 'highlights': ['The chapter explains the functionality of a program showing the login page and home page. The program demonstrates the login functionality and home page display with the username, providing a practical example of application communication.', 'REST API principles are explained, including client server, stateless, cacheable, uniform interface, layered systems, and code on demand. The principles of REST API are detailed, such as client-server isolation, stateless communication, cacheable data, uniform interface across platforms, layered systems architecture, and optional code on demand.', 'The usage of HTTP methods in REST API, such as POST to create, GET to read, PUT to update, and DELETE to delete data, is elucidated. The chapter provides a clear understanding of how HTTP methods are utilized within REST API, using CRUD operations to perform tasks on the server.']}, {'end': 15175.483, 'start': 14503.923, 'title': 'Setting up api and creating website', 'summary': 'Covers setting up xampp, creating a database and table for api with two entries, writing php code to connect to the database, fetching and displaying data in json format, and previewing a website built with php, html, css, and mysql for a photo gallery.', 'duration': 671.56, 'highlights': ["Creating a database for API with a table for users and adding two entries The speaker creates a database named API with a table for users, including columns for ID, name, age, and email. Two entries are added with the names 'Mac' and 'Simply Learn', with ages 21 and 30, respectively.", "Writing PHP code to connect to the database, fetch data, and display it in JSON format The speaker demonstrates writing PHP code to connect to the locally hosted database, fetch data from the 'users' table, and display it in JSON format, enabling the extraction of data from the database with the help of the API.", 'Previewing a website built with PHP, HTML, CSS, and MySQL for a photo gallery The speaker provides a preview of a photo gallery website built using PHP, HTML, CSS, and MySQL, encouraging viewers to create similar websites to showcase their talent or personal interests.']}, {'end': 15696.598, 'start': 15175.483, 'title': 'Setting up visual studio code and xampp', 'summary': 'Covers the process of setting up visual studio code and xampp, creating project folders, adding files, linking to external resources, and encountering and resolving issues with css design in a webpage.', 'duration': 521.115, 'highlights': ['The chapter covers the process of setting up Visual Studio Code and XAMPP, emphasizing the creation of project folders and adding files, with a focus on linking to external resources, such as CSS and scripts, and encountering and resolving issues with CSS design in a webpage.', 'XAMPP is a web server solution package used to manage databases and create a local web server, serving as a key software requirement for the process.', 'The importance of creating separate folders for CSS and images within the project folder is highlighted as a good practice for website development.']}, {'end': 16304.768, 'start': 15696.598, 'title': 'Building website navigation and carousel', 'summary': 'Covers making changes to the navigation bar including color theme, adding drop-down menu with categories, removing unnecessary parts of the navigation bar, and adding a carousel with images, emphasizing the ease of using pre-written codes and templates.', 'duration': 608.17, 'highlights': ['Adding a drop-down menu with categories like nature photographs, architecture, and travel. The speaker adds a drop-down menu with categories including nature photographs, architecture, and travel.', 'Removing unnecessary parts of the navigation bar to optimize its appearance. The unnecessary parts of the navigation bar are removed to enhance its appearance and functionality.', 'Emphasizing the ease of using pre-written codes and templates for building a website. The speaker emphasizes the convenience of using pre-written codes and templates for building a website, saving time and effort.', 'Adding a carousel with images for the website using pre-written code from Bootstrap. The speaker demonstrates adding a carousel with images to the website using pre-written code from Bootstrap.']}, {'end': 17360.422, 'start': 16304.768, 'title': 'Optimizing website layout and creating sections', 'summary': 'Discusses optimizing the website layout by adjusting image size and visibility, creating responsive sections for nature, architecture, and travel categories, and adding a contact form and about section.', 'duration': 1055.654, 'highlights': ['Adjusting image size and visibility by defining width and height in CSS to fit the main page, ensuring a responsive display on all devices. Width: 100%, Height: 95bh', 'Creating responsive sections for nature, architecture, and travel categories with three images displayed in a row on large and middle screens and a single image on mobile phones. Displaying three images on large and middle screens, single image on mobile', 'Adding a contact form with fields for name, email, and number, along with a submit button, and creating an about section with a text and image using container fluid class. Contact form fields: name, email, number, About section: text and image']}], 'duration': 3218.837, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg14141585.jpg', 'highlights': ['The chapter covers the process of setting up Visual Studio Code and XAMPP, emphasizing the creation of project folders and adding files, with a focus on linking to external resources, such as CSS and scripts, and encountering and resolving issues with CSS design in a webpage.', "Creating a database for API with a table for users and adding two entries The speaker creates a database named API with a table for users, including columns for ID, name, age, and email. Two entries are added with the names 'Mac' and 'Simply Learn', with ages 21 and 30, respectively.", 'Adding a carousel with images for the website using pre-written code from Bootstrap. The speaker demonstrates adding a carousel with images to the website using pre-written code from Bootstrap.', 'The chapter explains the functionality of a program showing the login page and home page. The program demonstrates the login functionality and home page display with the username, providing a practical example of application communication.', 'Adjusting image size and visibility by defining width and height in CSS to fit the main page, ensuring a responsive display on all devices. Width: 100%, Height: 95bh']}, {'end': 18355.838, 'segs': [{'end': 17483.789, 'src': 'embed', 'start': 17360.422, 'weight': 0, 'content': [{'end': 17367.786, 'text': 'otherwise, if the text will start from the extreme left, it would look weird and close it.', 'start': 17360.422, 'duration': 7.364}, {'end': 17411.994, 'text': "let's add some bold and write let's see, i am a passionate photographer, interested in working, architecture, nature and travel photography.", 'start': 17370.385, 'duration': 41.609}, {'end': 17432.635, 'text': 'next would be a full-time freelancer, will then experience of five years.', 'start': 17411.994, 'duration': 20.641}, {'end': 17437.601, 'text': 'well, i think this would do refresh.', 'start': 17432.635, 'duration': 4.966}, {'end': 17445.589, 'text': 'we did not change this.', 'start': 17443.267, 'duration': 2.322}, {'end': 17449.012, 'text': "we'll just get right on to it, contact us.", 'start': 17445.589, 'duration': 3.423}, {'end': 17453.675, 'text': "I'm a passionate photographer, interested in working, architecture, nature, travel, photography,", 'start': 17449.012, 'duration': 4.663}, {'end': 17458.819, 'text': 'freelancer and all of the things that Richard just written about Mac.', 'start': 17453.675, 'duration': 5.144}, {'end': 17468.776, 'text': "we just need to change this to about and i think we're done.", 'start': 17458.819, 'duration': 9.957}, {'end': 17474.119, 'text': 'yes. so our web page is almost complete.', 'start': 17468.776, 'duration': 5.343}, {'end': 17483.789, 'text': 'guys, now we need to do some changes or add some things.', 'start': 17474.119, 'duration': 9.67}], 'summary': 'Passionate photographer with 5 years of freelance experience, interested in architecture, nature, and travel photography.', 'duration': 123.367, 'max_score': 17360.422, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg17360422.jpg'}, {'end': 17688.791, 'src': 'embed', 'start': 17647.136, 'weight': 1, 'content': [{'end': 17660.301, 'text': "so first variable that i'll be creating is con to connect the database.", 'start': 17647.136, 'duration': 13.165}, {'end': 17668.344, 'text': 'since a server is locally hosted, the name of the server would be localhost root.', 'start': 17660.301, 'duration': 8.043}, {'end': 17673.055, 'text': 'that is the default.', 'start': 17670.532, 'duration': 2.523}, {'end': 17676.218, 'text': 'now, if connection.', 'start': 17673.055, 'duration': 3.163}, {'end': 17688.791, 'text': 'so this if condition will check if the connection is successful or not and if successful display connection successful.', 'start': 17676.218, 'duration': 12.573}], 'summary': "Creating 'con' variable to connect to localhost root server and checking successful connection.", 'duration': 41.655, 'max_score': 17647.136, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg17647136.jpg'}, {'end': 17960.776, 'src': 'embed', 'start': 17917.178, 'weight': 5, 'content': [{'end': 17919.098, 'text': "connection successful, we don't need that.", 'start': 17917.178, 'duration': 1.92}, {'end': 17922.519, 'text': 'we need to stay on this page itself.', 'start': 17919.098, 'duration': 3.421}, {'end': 17942.604, 'text': 'so in order to do that, I am writing this header file with the location of index.php enter, and i think we are done here.', 'start': 17922.519, 'duration': 20.085}, {'end': 17947.527, 'text': "now let's go back and add some details.", 'start': 17942.604, 'duration': 4.923}, {'end': 17949.269, 'text': 'mac mac.', 'start': 17947.527, 'duration': 1.742}, {'end': 17955.693, 'text': 'add to it simply learn.com.', 'start': 17949.269, 'duration': 6.424}, {'end': 17960.776, 'text': 'number would be one, two, three, four, five, six, seven, eight, nine, zero.', 'start': 17955.693, 'duration': 5.083}], 'summary': 'Set header file to location of index.php, add details to simplylearn.com, and use numbers 1-9 and 0.', 'duration': 43.598, 'max_score': 17917.178, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg17917178.jpg'}, {'end': 18051.54, 'src': 'embed', 'start': 18003.318, 'weight': 2, 'content': [{'end': 18010.603, 'text': 'so when we click on nature, we need our web page to be redirected to this section.', 'start': 18003.318, 'duration': 7.285}, {'end': 18015.056, 'text': "so let's just go back to our code.", 'start': 18010.603, 'duration': 4.453}, {'end': 18025.482, 'text': "and what we're going to be doing is we will create links just a second for every section of our web page.", 'start': 18015.056, 'duration': 10.426}, {'end': 18027.803, 'text': "so let's go back to the first section.", 'start': 18025.482, 'duration': 2.321}, {'end': 18030.604, 'text': 'that is nature.', 'start': 18027.803, 'duration': 2.801}, {'end': 18039.295, 'text': 'and here write, give it an id.', 'start': 18030.604, 'duration': 8.691}, {'end': 18044.837, 'text': 'so the id for this section would be nature.', 'start': 18039.295, 'duration': 5.542}, {'end': 18051.54, 'text': 'close the tag, cut and paste it here.', 'start': 18044.837, 'duration': 6.703}], 'summary': "Creating links for each section of the web page, starting with 'nature' section.", 'duration': 48.222, 'max_score': 18003.318, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg18003318.jpg'}, {'end': 18272.105, 'src': 'embed', 'start': 18236.924, 'weight': 3, 'content': [{'end': 18238.765, 'text': 'so everything works perfectly now.', 'start': 18236.924, 'duration': 1.841}, {'end': 18243.318, 'text': "So, while we're at it, let me just okay, let me first show you.", 'start': 18239.935, 'duration': 3.383}, {'end': 18251.906, 'text': 'Rob Rob at the rate start.com.', 'start': 18245.48, 'duration': 6.426}, {'end': 18255.544, 'text': '1, 2, 3, 4, 5, 5, 5, 5, 5.', 'start': 18251.926, 'duration': 3.618}, {'end': 18256.65, 'text': 'Click on submit.', 'start': 18255.549, 'duration': 1.101}, {'end': 18264.357, 'text': 'So as you can see, whenever you click on submit, it redirects you to the front of the webpage.', 'start': 18257.551, 'duration': 6.806}, {'end': 18266.959, 'text': "I don't want that.", 'start': 18266.278, 'duration': 0.681}, {'end': 18272.105, 'text': 'yeah, the database is working.', 'start': 18269.983, 'duration': 2.122}], 'summary': 'The website functions well, redirecting on submission and the database is operational.', 'duration': 35.181, 'max_score': 18236.924, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg18236924.jpg'}], 'start': 17360.422, 'title': 'Web page editing, photography description, database connection, and website navigation', 'summary': 'Involves editing a web page, refining a photography description, creating a database and connecting form data, performing database queries, and setting up website navigation, covering bold text addition, language adjustment, phpmyadmin database and table creation, php form connection, query execution, and website section navigation.', 'chapters': [{'end': 17483.789, 'start': 17360.422, 'title': 'Web page editing and photography description', 'summary': 'Involves editing a web page and refining a photography description, with a focus on adding bold text, adjusting language, and finalizing the webpage.', 'duration': 123.367, 'highlights': ['The chapter involves refining a photography description, with a focus on adding bold text, adjusting language, and finalizing the webpage.', 'The speaker is a passionate photographer interested in working, architecture, nature, and travel photography, with five years of experience as a full-time freelancer.', 'The final task involves making changes or additions to the webpage.']}, {'end': 17748.128, 'start': 17483.789, 'title': 'Creating database and connecting form data', 'summary': 'Covers creating a database and table in phpmyadmin, establishing a connection to the database, and writing php code to connect a form to the database, including the process of handling successful and unsuccessful connections.', 'duration': 264.339, 'highlights': ["Creating a table named 'users' with 4 columns in the 'photography' database. The table 'users' is created with 4 columns in the 'photography' database.", "Establishing a connection to the database using the mysqli_connect function and displaying 'Connection successful' if successful. The PHP code successfully establishes a connection to the database using the mysqli_connect function and displays 'Connection successful' upon success.", 'The process of starting the Apache server and MySQL server in XAMPP control panel is mentioned. The XAMPP control panel is used to start the Apache server and MySQL server.']}, {'end': 18355.838, 'start': 17752.225, 'title': 'Database query and website navigation', 'summary': 'Discusses creating variables to fetch data from a form, running a query to insert data into a table, and setting up navigation links for different sections of a web page, demonstrating database interaction and website navigation.', 'duration': 603.613, 'highlights': ['Creating variables to fetch data from a form and running a query to insert data into a table. variables, form data, query, table insertion', 'Setting up navigation links for different sections of a web page. navigation links, web page sections', 'Demonstrating database interaction and website navigation. database interaction, website navigation']}], 'duration': 995.416, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg17360422.jpg', 'highlights': ['The chapter involves refining a photography description, with a focus on adding bold text, adjusting language, and finalizing the webpage.', "Creating a table named 'users' with 4 columns in the 'photography' database.", "Establishing a connection to the database using the mysqli_connect function and displaying 'Connection successful' if successful.", 'Creating variables to fetch data from a form and running a query to insert data into a table.', 'Setting up navigation links for different sections of a web page.', 'The speaker is a passionate photographer interested in working, architecture, nature, and travel photography, with five years of experience as a full-time freelancer.']}, {'end': 19494.118, 'segs': [{'end': 18883.844, 'src': 'embed', 'start': 18847.45, 'weight': 2, 'content': [{'end': 18855.136, 'text': 'on a web page, we need to type in localhost, followed by the name of the folder that you created for your project.', 'start': 18847.45, 'duration': 7.686}, {'end': 18858.879, 'text': "since the name of my folder is website, i've written website here.", 'start': 18855.136, 'duration': 3.743}, {'end': 18860.88, 'text': 'click on enter.', 'start': 18858.879, 'duration': 2.001}, {'end': 18865.703, 'text': 'and well, our navigation bar looks a bit weird.', 'start': 18860.88, 'duration': 4.823}, {'end': 18867.105, 'text': "there's no designing to it.", 'start': 18865.703, 'duration': 1.402}, {'end': 18871.808, 'text': 'now let me go back to the code and see what i did wrong.', 'start': 18867.105, 'duration': 4.703}, {'end': 18883.844, 'text': "well, yeah, we don't need this bootstrap reboot.min.css.", 'start': 18876.181, 'duration': 7.663}], 'summary': 'Troubleshooting web page navigation bar design issue after entering localhost and folder name.', 'duration': 36.394, 'max_score': 18847.45, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg18847450.jpg'}, {'end': 19143.246, 'src': 'embed', 'start': 19073.338, 'weight': 0, 'content': [{'end': 19086.684, 'text': 'this will be for the row and now just a second.', 'start': 19073.338, 'duration': 13.346}, {'end': 19106.468, 'text': 'yes, this will also need a class, since we want our text in the center of the page and top products.', 'start': 19086.684, 'duration': 19.784}, {'end': 19111.23, 'text': 'okay, let me just add some spaces.', 'start': 19106.468, 'duration': 4.762}, {'end': 19136.6, 'text': 'well, before adding those images and the products onto our page, we need to prepare a little bit more.', 'start': 19124.949, 'duration': 11.651}, {'end': 19143.246, 'text': 'so before that, let us just save this piece of code and see how does it look.', 'start': 19136.6, 'duration': 6.646}], 'summary': 'Preparing for adding images and products onto the page by saving the code and checking the appearance.', 'duration': 69.908, 'max_score': 19073.338, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg19073338.jpg'}], 'start': 18355.838, 'title': 'Creating e-commerce website with visual studio code and bootstrap', 'summary': 'Details creating an e-commerce website using visual studio code and xampp, setting up bootstrap, integrating design, and creating a database with a product entry for a google pixel 5.', 'chapters': [{'end': 18406.695, 'start': 18355.838, 'title': 'Creating e-commerce website with visual studio code', 'summary': 'Detailed the process of creating a basic e-commerce website using visual studio code and xampp as the web server solutions package, showcasing top products on the front page and hosting a local server for the website.', 'duration': 50.857, 'highlights': ['The chapter showcased the process of creating a basic e-commerce website using Visual Studio Code and XAMPP as the web server solutions package, with a demonstration of top products on the front page.', 'The chapter emphasized the use of Visual Studio Code as the IDE and XAMPP as the web server solutions package for hosting a local server for the website.', "The chapter demonstrated the website 'techbad.com' as an example for creating a basic e-commerce website."]}, {'end': 18583.275, 'start': 18407.576, 'title': 'Setting up bootstrap and creating a website', 'summary': 'Covers the process of downloading and setting up bootstrap for website development, including extracting the files and creating an index.php file in visual studio code.', 'duration': 175.699, 'highlights': ["Download Bootstrap from the website 'bootstrap download' and extract the files into the project folder in the coding environment The chapter emphasizes the process of downloading Bootstrap and extracting the files for website development.", 'Create an index.php file in Visual Studio code and add a title and links for the website The process of creating an index.php file and adding a title and links is a significant step in website development.', 'Open the coding environment in Visual Studio code and access the project folder to create new files Utilizing Visual Studio code for creating and accessing project files is an essential aspect of the coding environment setup.']}, {'end': 19195.857, 'start': 18592.799, 'title': 'Website design and bootstrap integration', 'summary': 'Covers the process of linking css and javascript files from the bootstrap folder, creating a navigation bar using bootstrap, making modifications to the navigation bar, and preparing the front page layout including database creation for an e-commerce website.', 'duration': 603.058, 'highlights': ['Linking CSS and JavaScript files from Bootstrap folder The process involves linking the CSS file bootstrap.min.css and JavaScript file bootstrap.min.js, essential for styling and functionality.', 'Creating a navigation bar using Bootstrap The chapter demonstrates the use of Bootstrap to easily create a navigation bar, making it accessible and responsive for the website.', 'Modifying the navigation bar The modifications involve changing the color theme, navigation names, and adjusting the width to enhance the appearance of the navigation bar.', 'Preparing the front page layout and database creation The process involves creating a layout for featured content and preparing a database to store product information for fetching and displaying on the website.']}, {'end': 19494.118, 'start': 19195.857, 'title': 'Creating e-commerce database and adding products', 'summary': 'Covers the creation of a new e-commerce database with a products table including columns such as id, title, price, brand, image, description, and featured, and adding an entry for a google pixel 5 product with details.', 'duration': 298.261, 'highlights': ['The chapter covers the creation of a new E-commerce database with a products table including columns such as ID, title, price, brand, image, description, and featured, and adding an entry for a Google Pixel 5 product with details.', 'The database E-commerce is created with a products table containing columns like ID, title, price, brand, image, description, and featured, with the price column set to decimal with values 10,2.', "The process includes adding an entry for a product 'Google Pixel 5' with details like price, brand, image path, and description, providing a practical demonstration of the database creation and entry addition."]}], 'duration': 1138.28, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg18355838.jpg', 'highlights': ['The chapter showcased the process of creating a basic e-commerce website using Visual Studio Code and XAMPP as the web server solutions package, with a demonstration of top products on the front page.', 'The chapter covers the creation of a new E-commerce database with a products table including columns such as ID, title, price, brand, image, description, and featured, and adding an entry for a Google Pixel 5 product with details.', 'Linking CSS and JavaScript files from Bootstrap folder The process involves linking the CSS file bootstrap.min.css and JavaScript file bootstrap.min.js, essential for styling and functionality.', 'Creating a navigation bar using Bootstrap The chapter demonstrates the use of Bootstrap to easily create a navigation bar, making it accessible and responsive for the website.']}, {'end': 20753.394, 'segs': [{'end': 19629.176, 'src': 'embed', 'start': 19532.962, 'weight': 3, 'content': [{'end': 19541.605, 'text': "let's go back to our code and in our code, Let's go back to the top,", 'start': 19532.962, 'duration': 8.643}, {'end': 19556.112, 'text': 'and here we are going to be creating a PHP script and inside that script I will be accessing the database.', 'start': 19541.605, 'duration': 14.507}, {'end': 19574.055, 'text': 'Now let us create a connection to the database using mysqli connect and inside this what we are going to do is we will be writing the name of the server,', 'start': 19556.733, 'duration': 17.322}, {'end': 19582.32, 'text': 'since the server is localhost, and then this next would be root.', 'start': 19574.055, 'duration': 8.265}, {'end': 19587.884, 'text': 'now again mysqli.', 'start': 19582.32, 'duration': 5.564}, {'end': 19601.003, 'text': "now here select db database and inside this we'll be selecting a database from the my admin panel.", 'start': 19587.884, 'duration': 13.119}, {'end': 19611.488, 'text': 'so what we need to do is we need to write the variable name followed by the name of the database that we need information from.', 'start': 19601.003, 'duration': 10.485}, {'end': 19619.012, 'text': 'so our, the name of our database was e-commerce.', 'start': 19611.488, 'duration': 7.524}, {'end': 19622.334, 'text': 'yep, so e-commerce.', 'start': 19619.012, 'duration': 3.322}, {'end': 19629.176, 'text': 'So here we have created a connection with the database.', 'start': 19625.794, 'duration': 3.382}], 'summary': "Creating a php script to access the 'e-commerce' database using mysqli connect.", 'duration': 96.214, 'max_score': 19532.962, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg19532962.jpg'}, {'end': 20406.55, 'src': 'embed', 'start': 20332.148, 'weight': 11, 'content': [{'end': 20334.649, 'text': 'was it brand name?', 'start': 20332.148, 'duration': 2.501}, {'end': 20340.45, 'text': 'yep, brand name description looks good.', 'start': 20334.649, 'duration': 5.801}, {'end': 20342.85, 'text': 'change class name here?', 'start': 20340.45, 'duration': 2.4}, {'end': 20364.069, 'text': "okay. so What we're going to do is we will be refreshing this page and clicking on more.", 'start': 20342.85, 'duration': 21.219}, {'end': 20367.711, 'text': 'And well, yes, good.', 'start': 20365.43, 'duration': 2.281}, {'end': 20370.512, 'text': 'The details of our product are visible here.', 'start': 20368.171, 'duration': 2.341}, {'end': 20376.436, 'text': "Now let's go back and make a little changes.", 'start': 20371.293, 'duration': 5.143}, {'end': 20380.338, 'text': 'So the first change would be this.', 'start': 20377.816, 'duration': 2.522}, {'end': 20399.226, 'text': 'So this would be product details and save click.', 'start': 20380.858, 'duration': 18.368}, {'end': 20406.55, 'text': 'still a big gap.', 'start': 20399.226, 'duration': 7.324}], 'summary': 'Reviewing and updating product details and class name for web page refresh.', 'duration': 74.402, 'max_score': 20332.148, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg20332148.jpg'}, {'end': 20519.201, 'src': 'embed', 'start': 20484.344, 'weight': 0, 'content': [{'end': 20490.94, 'text': 'make your description look better and let us go back to the main page.', 'start': 20484.344, 'duration': 6.596}, {'end': 20499.422, 'text': "and what we're going to do is we are going to create two new files for this laptops and phones,", 'start': 20490.94, 'duration': 8.482}, {'end': 20504.564, 'text': 'to display them separately when we click on any drop down menu.', 'start': 20499.422, 'duration': 5.142}, {'end': 20519.201, 'text': "since they don't work yet, let me show you an example to create a file for this product laptops and you can create the rest yourself.", 'start': 20504.564, 'duration': 14.637}], 'summary': 'Create separate files for laptops and phones to display in dropdown menu.', 'duration': 34.857, 'max_score': 20484.344, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg20484344.jpg'}, {'end': 20614.506, 'src': 'embed', 'start': 20565.7, 'weight': 9, 'content': [{'end': 20574.886, 'text': 'And now the one thing that you need to notice is we are going to be keeping this featured part as two instead of one.', 'start': 20565.7, 'duration': 9.186}, {'end': 20583.857, 'text': 'and go back to browse and you can see the detail that we just created with the feature number 2.', 'start': 20575.954, 'duration': 7.903}, {'end': 20588.758, 'text': 'so now go back to our code and create another file.', 'start': 20583.857, 'duration': 4.901}, {'end': 20600.463, 'text': 'let us name it product laptops.php.', 'start': 20588.758, 'duration': 11.705}, {'end': 20611.564, 'text': 'let me just see yep, I have.', 'start': 20605.902, 'duration': 5.662}, {'end': 20614.506, 'text': 'so, yeah, I may have skipped this part.', 'start': 20611.564, 'duration': 2.942}], 'summary': 'Feature part kept as 2 instead of 1 for product creation.', 'duration': 48.806, 'max_score': 20565.7, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg20565700.jpg'}, {'end': 20753.394, 'src': 'embed', 'start': 20662.995, 'weight': 2, 'content': [{'end': 20666.137, 'text': 'everything looks fine, save it.', 'start': 20662.995, 'duration': 3.142}, {'end': 20681.004, 'text': 'Since the feature number will be 2, let us go back refresh, click on laptops, and here you can see the ASUS ROG laptop visible.', 'start': 20666.954, 'duration': 14.05}, {'end': 20691.351, 'text': 'Now let me add another product on our feature page that is the front page to show you how do we display more than one product with the same code.', 'start': 20681.725, 'duration': 9.626}, {'end': 20700.277, 'text': 'go back to this database and create another entry.', 'start': 20693.274, 'duration': 7.003}, {'end': 20706.06, 'text': "let's say hp laptop price would be 80 000.", 'start': 20700.277, 'duration': 5.783}, {'end': 20713.523, 'text': 'okay, i think i just created an entry.', 'start': 20706.06, 'duration': 7.463}, {'end': 20717.705, 'text': 'let me delete it.', 'start': 20713.523, 'duration': 4.182}, {'end': 20718.165, 'text': 'go back.', 'start': 20717.705, 'duration': 0.46}, {'end': 20724.904, 'text': 'hp laptop price 80,000.', 'start': 20718.165, 'duration': 6.739}, {'end': 20735.113, 'text': 'brand name, HP image website images.', 'start': 20724.905, 'duration': 10.208}, {'end': 20741.177, 'text': 'name of the image, that is hp underscore laptop dot png.', 'start': 20735.113, 'duration': 6.064}, {'end': 20753.394, 'text': "hp underscore laptop dot png and the description which I have copied from the internet, and in this feature we're going to be writing one,", 'start': 20741.177, 'duration': 12.217}], 'summary': 'Added 2 products: asus rog laptop and hp laptop priced at 80,000, with image and description.', 'duration': 90.399, 'max_score': 20662.995, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg20662995.jpg'}], 'start': 19494.118, 'title': 'Creating and displaying e-commerce products', 'summary': 'Covers retrieving and displaying data from a database using php, creating a product display for an e-commerce website, detailing the product details page, and demonstrating the creation and display of laptop products with a focus on functionality and improved display.', 'chapters': [{'end': 19801.929, 'start': 19494.118, 'title': 'Retrieving and displaying data from a database', 'summary': "Explains the process of creating a database connection, accessing information from a database, and displaying it on the screen using php, emphasizing the retrieval of product details for a google pixel 5 phone from the 'e-commerce' database.", 'duration': 307.811, 'highlights': ["The process involves creating a connection to the 'e-commerce' database and accessing information using SQL commands, specifically fetching details from the 'products' table where the 'featured' value is one.", "The chapter emphasizes the need to create a PHP script to establish a connection to the database and retrieve information, demonstrating the use of mysqli_connect and SQL commands to access data from the 'e-commerce' database.", "The transcript details the practical steps of creating a while loop to fetch data from the 'products' table based on the 'featured' category, ensuring the successful retrieval and display of product information on the screen."]}, {'end': 20223.843, 'start': 19801.929, 'title': 'Creating product display for e-commerce website', 'summary': 'Details the process of creating a product display for an e-commerce website, including adding the title, image, price, and a button for more details, with a focus on accessing and displaying data from a database.', 'duration': 421.914, 'highlights': ['Creating a div class for displaying product details The chapter outlines the process of creating a div class to display product details such as title, image, and price, emphasizing accessing and displaying data from a database.', 'Accessing and displaying product title from database The chapter emphasizes the process of accessing and displaying the product title from the database, showcasing the implementation of dynamic data retrieval.', 'Displaying product image sourced from the database The chapter explains the method of displaying product images sourced from the database, highlighting the efficiency of accessing stored images for display.', 'Creating a button for accessing more product details The chapter discusses the creation of a button for accessing more product details, demonstrating the addition of interactive elements for enhanced user experience.']}, {'end': 20484.344, 'start': 20223.843, 'title': 'Creating product details page', 'summary': 'Discusses creating a product details page, including displaying the title, price, description, and brand name, with a focus on making changes to the code for an improved display and functionality.', 'duration': 260.501, 'highlights': ['The chapter discusses creating a product details page and making changes to the code for an improved display and functionality.', 'It includes displaying the title, price, description, and brand name on the page.', 'The process involves copying and pasting parts of the code and making adjustments for a better visual presentation.', 'The code is modified to add bold to the title and make it more visually appealing.']}, {'end': 20753.394, 'start': 20484.344, 'title': 'Creating and displaying laptop products', 'summary': 'Demonstrates the process of creating and displaying laptop products in a drop-down menu, including creating entries in a database, setting prices, and displaying multiple products with the same code.', 'duration': 269.05, 'highlights': ['The process involves creating separate files for laptop and phone products to display them separately when clicking on a drop down menu.', 'Creating entries in the database, such as an ASUS ROG laptop with a price of 1 lakh 20,000 and a HP laptop with a price of 80,000, along with their respective brand names, images, and descriptions, is explained.', 'Demonstrating the display of multiple products using the same code, with the ASUS ROG laptop and HP laptop being visible on the feature page, is illustrated.']}], 'duration': 1259.276, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg19494118.jpg', 'highlights': ["Creating a connection to the 'e-commerce' database and accessing information using SQL commands", "Demonstrating the use of mysqli_connect and SQL commands to access data from the 'e-commerce' database", "Creating a while loop to fetch data from the 'products' table based on the 'featured' category", 'Creating a div class to display product details such as title, image, and price', 'Emphasizing the process of accessing and displaying the product title from the database', 'Explaining the method of displaying product images sourced from the database', 'Discussing the creation of a button for accessing more product details', 'Creating a product details page and making changes to the code for an improved display and functionality', 'Displaying the title, price, description, and brand name on the page', 'Creating separate files for laptop and phone products to display them separately when clicking on a drop down menu', 'Explaining the process of creating entries in the database for laptop products with their respective details', 'Illustrating the display of multiple products using the same code']}, {'end': 21332.309, 'segs': [{'end': 20848.738, 'src': 'embed', 'start': 20818.627, 'weight': 0, 'content': [{'end': 20825.391, 'text': 'now the questions are categorized in two sections beginner and advanced questions.', 'start': 20818.627, 'duration': 6.764}, {'end': 20831.074, 'text': 'so, without any further ado, let us get started with the beginner questions now.', 'start': 20825.391, 'duration': 5.683}, {'end': 20835.674, 'text': 'the most basic question is what is php so?', 'start': 20831.074, 'duration': 4.6}, {'end': 20839.395, 'text': 'php stands for hypertext preprocessor.', 'start': 20835.674, 'duration': 3.721}, {'end': 20848.738, 'text': 'it is a server-side scripting language that is embedded into html and is generally used for dynamic web development.', 'start': 20839.395, 'duration': 9.343}], 'summary': 'Php is a server-side scripting language used for dynamic web development.', 'duration': 30.111, 'max_score': 20818.627, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg20818627.jpg'}, {'end': 20935.282, 'src': 'embed', 'start': 20904.018, 'weight': 2, 'content': [{'end': 20913.02, 'text': 'So PHP is partially case sensitive since variables in PHP are case sensitive while functions and user defined functions are not.', 'start': 20904.018, 'duration': 9.002}, {'end': 20918.678, 'text': 'Next, name different types of data types in PHP.', 'start': 20913.857, 'duration': 4.821}, {'end': 20930.541, 'text': 'So different data types in PHP include integer, float, string, boolean, array, object, null and finally resource.', 'start': 20919.378, 'duration': 11.163}, {'end': 20935.282, 'text': 'So there are total eight different data types that exist in PHP.', 'start': 20930.881, 'duration': 4.401}], 'summary': 'Php has 8 data types; variables case-sensitive; functions not.', 'duration': 31.264, 'max_score': 20904.018, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg20904018.jpg'}, {'end': 21225.649, 'src': 'embed', 'start': 21198.11, 'weight': 4, 'content': [{'end': 21205.236, 'text': 'next question is related to this question, since what is constant function and useful in php, then?', 'start': 21198.11, 'duration': 7.126}, {'end': 21208.999, 'text': 'so constant function returns the value of a constant.', 'start': 21205.236, 'duration': 3.763}, {'end': 21213.422, 'text': 'it is not used to define a constant, but it returns the value of a constant.', 'start': 21208.999, 'duration': 4.423}, {'end': 21221.288, 'text': 'so suppose you define a function, constant using this define function and you want to return this value.', 'start': 21213.422, 'duration': 7.866}, {'end': 21225.649, 'text': 'you can use this constant function for that.', 'start': 21221.946, 'duration': 3.703}], 'summary': 'Constant function in php returns the value of a constant.', 'duration': 27.539, 'max_score': 21198.11, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg21198110.jpg'}, {'end': 21309.095, 'src': 'embed', 'start': 21281.656, 'weight': 3, 'content': [{'end': 21290.603, 'text': 'so to do that, you need to use this dot operator in echo, as you can see this dot operator.', 'start': 21281.656, 'duration': 8.947}, {'end': 21299.649, 'text': "so first you write the name of the first string, then followed by the dot operator I've given this space and then the next dot operator,", 'start': 21290.603, 'duration': 9.046}, {'end': 21309.095, 'text': 'because this is also considered as a string, and then the third string variable, and this is how you concatenate two strings.', 'start': 21299.649, 'duration': 9.446}], 'summary': 'Concatenate strings using the dot operator for php echo.', 'duration': 27.439, 'max_score': 21281.656, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg21281656.jpg'}], 'start': 20753.394, 'title': 'Php basics and e-commerce websites', 'summary': 'Covers the basics of e-commerce websites and php, including adding products to a database, displaying them on a web page, and beginner php interview questions. it further discusses php basics, best practices, data types, variable naming rules, popular frameworks, key functions, and performance differences between echo and print, with a total of eight data types and four types of loops in php.', 'chapters': [{'end': 20903.318, 'start': 20753.394, 'title': 'Basics of e-commerce websites & php interviews', 'summary': "Discusses the basics of an e-commerce website, including adding products to a database and displaying them on a web page using php. it also covers frequently asked beginner php interview questions, such as defining php, sessions, pecl, and php's case sensitivity.", 'duration': 149.924, 'highlights': ['The chapter covers the basics of an e-commerce website, including adding products to a database and displaying them on a web page using PHP.', "It discusses frequently asked beginner PHP interview questions, such as defining PHP, sessions, PECL, and PHP's case sensitivity.", 'PHP is a server-side scripting language embedded into HTML, used for dynamic web development and compatible with almost 20 different databases.', 'Sessions in PHP are used to store data for users under a unique ID, which can be then used across multiple web pages of a website.', 'PECL (PHP Extension and Application Repository) is a framework and repository for reusable components of PHP containing code snippets and libraries.', 'PHP is a case sensitive language, a frequently asked question in interviews.']}, {'end': 21332.309, 'start': 20904.018, 'title': 'Php basics and best practices', 'summary': 'Covers php basics including data types, variable naming rules, popular frameworks, and key functions. it also outlines best practices and performance differences between echo and print, with a total of eight data types and four types of loops in php.', 'duration': 428.291, 'highlights': ['PHP consists of a total of eight different data types including integer, float, string, boolean, array, object, null, and resource. This highlights the different data types in PHP, providing quantifiable data on the total number of data types.', 'Echo can output multiple strings at a time and does not have a return value, making it faster than print, which always returns a value. This highlights the performance differences between echo and print, with quantifiable data on their functionalities and speed.', 'Good coding practices for naming variables in PHP include starting with an underscore or letter, not using special characters at the start, and allowing numbers within the name but not as the starting character. This highlights the rules for naming variables in PHP, providing quantifiable data on the coding practices and naming conventions.', 'Popular PHP frameworks include Symphony, CodeIgniter, CakePHP, and Laravel. This highlights some popular PHP frameworks, providing quantifiable data on the specific frameworks mentioned.', 'PHP consists of a total of four loops including while, do while, for, and for each loops. This highlights the different types of loops in PHP, providing quantifiable data on the total number of loops.']}], 'duration': 578.915, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg20753394.jpg', 'highlights': ['The chapter covers the basics of an e-commerce website using PHP.', 'PHP is a server-side scripting language compatible with almost 20 different databases.', 'Sessions in PHP are used to store data for users under a unique ID.', 'PHP consists of a total of eight different data types including integer, float, string, boolean, array, object, null, and resource.', 'Echo can output multiple strings at a time and does not have a return value, making it faster than print.', 'Good coding practices for naming variables in PHP include starting with an underscore or letter.', 'Popular PHP frameworks include Symphony, CodeIgniter, CakePHP, and Laravel.', 'PHP consists of a total of four loops including while, do while, for, and for each loops.']}, {'end': 21862.138, 'segs': [{'end': 21391.783, 'src': 'embed', 'start': 21363.996, 'weight': 7, 'content': [{'end': 21374.899, 'text': 'Now, some predefined variables in PHP are known as super global variables because they are always accessible from any function, file or class,', 'start': 21363.996, 'duration': 10.903}, {'end': 21375.939, 'text': 'regardless of the scope.', 'start': 21374.899, 'duration': 1.04}, {'end': 21380.2, 'text': 'So in all in all they are globally accessible.', 'start': 21376.379, 'duration': 3.821}, {'end': 21385.601, 'text': 'So suppose you write a piece of code and you declare a variable inside it,', 'start': 21380.66, 'duration': 4.941}, {'end': 21391.783, 'text': 'it would be a local variable and could be accessed only in that part of the code.', 'start': 21385.601, 'duration': 6.182}], 'summary': 'Php super global variables are accessible from any function, file, or class, while local variables are limited to specific parts of the code.', 'duration': 27.787, 'max_score': 21363.996, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg21363996.jpg'}, {'end': 21450.131, 'src': 'embed', 'start': 21419.762, 'weight': 0, 'content': [{'end': 21431.668, 'text': 'While in case of multi-line comments, you can use this hash star and write your comments in multiple lines and enclose it with a star and slash.', 'start': 21419.762, 'duration': 11.906}, {'end': 21440.813, 'text': "What I'm going to do now is I am going to show you the use of these comments in actual VS code.", 'start': 21432.409, 'duration': 8.404}, {'end': 21444.206, 'text': 'Now let us take this block of code for example.', 'start': 21441.463, 'duration': 2.743}, {'end': 21450.131, 'text': 'Now suppose you want to add a single line comment after this variable.', 'start': 21444.746, 'duration': 5.385}], 'summary': 'Demonstrating multi-line comments usage in vs code.', 'duration': 30.369, 'max_score': 21419.762, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg21419762.jpg'}, {'end': 21516.522, 'src': 'embed', 'start': 21486.361, 'weight': 1, 'content': [{'end': 21492.124, 'text': 'so suppose you need to write two, three lines about this line of code.', 'start': 21486.361, 'duration': 5.763}, {'end': 21495.005, 'text': 'what you will do is you will use a slash star.', 'start': 21492.124, 'duration': 2.881}, {'end': 21502.595, 'text': 'now write the comment this is displaying.', 'start': 21495.951, 'duration': 6.644}, {'end': 21504.336, 'text': 'simply learn.', 'start': 21502.595, 'duration': 1.741}, {'end': 21512.18, 'text': 'so this is a three line comment which you can end simply by star and a slash.', 'start': 21504.336, 'duration': 7.844}, {'end': 21516.522, 'text': 'this is how you write single line and multi-line comments.', 'start': 21512.18, 'duration': 4.342}], 'summary': 'The transcript explains how to write single and multi-line comments in code.', 'duration': 30.161, 'max_score': 21486.361, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg21486361.jpg'}, {'end': 21708.49, 'src': 'embed', 'start': 21677.208, 'weight': 4, 'content': [{'end': 21685.19, 'text': 'now, in this echo, as you can notice, what we are doing is we are using this also before.', 'start': 21677.208, 'duration': 7.982}, {'end': 21692.243, 'text': 'that you need to notice is this is the same string as the name of this variable.', 'start': 21685.19, 'duration': 7.053}, {'end': 21700.166, 'text': 'so first we are displaying this variable and then we are referencing this variable here.', 'start': 21692.243, 'duration': 7.923}, {'end': 21705.509, 'text': 'so what it is doing is it is referencing the value to another variable.', 'start': 21700.166, 'duration': 5.343}, {'end': 21708.49, 'text': 'so hello variable is being referenced.', 'start': 21705.509, 'duration': 2.981}], 'summary': 'Demonstrates referencing the value of a variable to another variable.', 'duration': 31.282, 'max_score': 21677.208, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg21677208.jpg'}, {'end': 21862.138, 'src': 'embed', 'start': 21832.434, 'weight': 5, 'content': [{'end': 21833.995, 'text': 'These are the default values.', 'start': 21832.434, 'duration': 1.561}, {'end': 21837.118, 'text': 'Now to check if the connection is connected.', 'start': 21834.396, 'duration': 2.722}, {'end': 21842.984, 'text': 'what we are going to do is we will use an if condition.', 'start': 21837.901, 'duration': 5.083}, {'end': 21851.59, 'text': 'if the con variable gets an connect error, we will display a error message that is, connection failed.', 'start': 21842.984, 'duration': 8.606}, {'end': 21855.072, 'text': 'if not, we will display connected successfully.', 'start': 21851.59, 'duration': 3.482}, {'end': 21862.138, 'text': "now, as you can see here, These names can be the name of the server that you're trying to connect.", 'start': 21855.072, 'duration': 7.066}], 'summary': 'Checking connection status, display error if failed, else success', 'duration': 29.704, 'max_score': 21832.434, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg21832434.jpg'}], 'start': 21332.309, 'title': 'Php functions, applications, and advanced questions', 'summary': 'Covers php functions, super global variables, single and multi-line comments, common php applications such as form handling and crud tasks, and advanced level questions including executing php script from command line and connecting to a database using php script.', 'chapters': [{'end': 21516.522, 'start': 21332.309, 'title': 'Php functions and comments', 'summary': 'Covers php functions, super global variables, and single and multi-line comments, highlighting the use of variable arguments in functions, super global variables in php, and the syntax for single and multi-line comments.', 'duration': 184.213, 'highlights': ['The super global variables in PHP include global, server, request, post, get, files, env, cookie, and session, and are globally accessible from any function, file, or class. Super global variables in PHP are globally accessible, including global, server, request, post, get, files, env, cookie, and session.', 'The function in the sample code has been passed three arguments, and the output of the function would be three. The sample function has been passed three arguments, which results in an output of three.', 'The syntax for single line comments in PHP involves using a hash or double slash followed by the comment, while multi-line comments are enclosed with slash star and star slash. In PHP, single line comments are denoted by a hash or double slash, and multi-line comments are enclosed with slash star and star slash.']}, {'end': 21862.138, 'start': 21516.522, 'title': 'Common php applications and advanced level questions', 'summary': 'Discusses common applications of php including form handling, crud tasks, accessing cookies and variables, data encryption, and then moves on to advanced level questions covering executing php script from command line, differentiating dollar and double dollar variables, get and post method, and connecting to a database using php script.', 'duration': 345.616, 'highlights': ['PHP is commonly used for handling forms on web pages, performing CRUD tasks, accessing cookies and variables, and providing data encryption for security. PHP is commonly used for form handling, CRUD tasks, accessing cookies and variables, and data encryption for security.', 'Executing a PHP script from the command line involves specifying the script or PHP file in the command line to run it. Executing a PHP script from the command line involves specifying the script or PHP file in the command line to run it.', 'Differentiating between dollar and double dollar variables, where a single dollar variable stores data and a double dollar variable is used to reference existing variables. Differentiating between dollar and double dollar variables, where a single dollar variable stores data and a double dollar variable is used to reference existing variables.', 'Explaining the difference between the get and post method, where get method sends data as part of the web page URL and post method sends data through the HTTP header for secure data transfer. Explaining the difference between the get and post method, where get method sends data as part of the web page URL and post method sends data through the HTTP header for secure data transfer.', 'Connecting to a database using a PHP script involves creating variables for server name, username, and password, and using mysqli functions to establish the connection. Connecting to a database using a PHP script involves creating variables for server name, username, and password, and using mysqli functions to establish the connection.']}], 'duration': 529.829, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg21332309.jpg', 'highlights': ['Super global variables in PHP include global, server, request, post, get, files, env, cookie, and session, and are globally accessible from any function, file, or class.', 'PHP is commonly used for form handling, CRUD tasks, accessing cookies and variables, and data encryption for security.', 'Connecting to a database using a PHP script involves creating variables for server name, username, and password, and using mysqli functions to establish the connection.', 'The syntax for single line comments in PHP involves using a hash or double slash followed by the comment, while multi-line comments are enclosed with slash star and star slash.', 'Differentiating between dollar and double dollar variables, where a single dollar variable stores data and a double dollar variable is used to reference existing variables.', 'Executing a PHP script from the command line involves specifying the script or PHP file in the command line to run it.', 'Explaining the difference between the get and post method, where get method sends data as part of the web page URL and post method sends data through the HTTP header for secure data transfer.', 'The function in the sample code has been passed three arguments, and the output of the function would be three.']}, {'end': 22941.341, 'segs': [{'end': 21975.473, 'src': 'embed', 'start': 21862.298, 'weight': 0, 'content': [{'end': 21865.679, 'text': 'I have used localhost username and password for the default values.', 'start': 21862.298, 'duration': 3.381}, {'end': 21869.62, 'text': "You can use the name of the database that you're trying to connect your PHP script to.", 'start': 21865.699, 'duration': 3.921}, {'end': 21875.742, 'text': 'Next up, what does final class and final method mean in PHP?', 'start': 21870.381, 'duration': 5.361}, {'end': 21885.665, 'text': 'Now, a final class in PHP means that the class cannot be extended, while a final method means that it cannot be overridden.', 'start': 21876.482, 'duration': 9.183}, {'end': 21895.898, 'text': 'now, as you can see in this block of code, we have used the final keyword for a class and the final keyword for a function.', 'start': 21886.431, 'duration': 9.467}, {'end': 21902.863, 'text': 'now suppose this final class is being inherited by this child class.', 'start': 21895.898, 'duration': 6.965}, {'end': 21912.309, 'text': 'what the program will return is an error, because once you use this final keyword, this class cannot be inherited.', 'start': 21902.863, 'duration': 9.446}, {'end': 21921.444, 'text': 'and similarly, suppose this function is trying to be overridden by this part of the code.', 'start': 21912.309, 'duration': 9.135}, {'end': 21925.187, 'text': 'it cannot be, because we have used the final function.', 'start': 21921.444, 'duration': 3.743}, {'end': 21931.15, 'text': 'next question differentiate between function overloading and overriding.', 'start': 21925.187, 'duration': 5.963}, {'end': 21933.151, 'text': 'now function overloading.', 'start': 21931.15, 'duration': 2.001}, {'end': 21940.435, 'text': 'the same function is used for different purposes based on the number of arguments inside the function,', 'start': 21933.151, 'duration': 7.284}, {'end': 21946.286, 'text': 'while in case of function overriding the same name and same argument,', 'start': 21940.435, 'duration': 5.851}, {'end': 21953.433, 'text': 'function is used in parent and child class respectively to change the behavior of parent class method.', 'start': 21946.286, 'duration': 7.147}, {'end': 21959.039, 'text': 'now let me show you and demonstrate the difference with an example.', 'start': 21953.433, 'duration': 5.606}, {'end': 21961.841, 'text': 'so let us look at this code.', 'start': 21959.039, 'duration': 2.802}, {'end': 21973.382, 'text': 'so suppose you have a function named show title, which does contain a single parameter and displays, when called upon using this parameter,', 'start': 21961.841, 'duration': 11.541}, {'end': 21975.473, 'text': 'displays function 1..', 'start': 21973.382, 'duration': 2.091}], 'summary': 'Discusses php concepts like final class, final method, overloading, and overriding with code examples.', 'duration': 113.175, 'max_score': 21862.298, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg21862298.jpg'}, {'end': 22083.48, 'src': 'embed', 'start': 22000.725, 'weight': 9, 'content': [{'end': 22005.443, 'text': 'next, From this piece of code we can understand function overriding.', 'start': 22000.725, 'duration': 4.718}, {'end': 22016.051, 'text': 'Suppose you display a function demo in a base class and you want to override this demo function inside the derived class.', 'start': 22005.724, 'duration': 10.327}, {'end': 22024.536, 'text': 'so what you do is you make another function with the same name inside the derived class, with some different properties.', 'start': 22016.051, 'duration': 8.485}, {'end': 22027.878, 'text': 'as you can see, it displays something different.', 'start': 22024.536, 'duration': 3.342}, {'end': 22034.942, 'text': 'now you create an object for the base class and when you use this base class object to call this demo function,', 'start': 22027.878, 'duration': 7.064}, {'end': 22045.567, 'text': 'you can use the properties of this function here, while if you create another object, that is object2 for the derived class,', 'start': 22035.602, 'duration': 9.965}, {'end': 22055.212, 'text': 'and you use this object to call upon the same demo function, you are overriding this base class demo function that was inherited.', 'start': 22045.567, 'duration': 9.645}, {'end': 22061.575, 'text': 'instead, what it will use is it will use the properties of the derived demo function.', 'start': 22055.212, 'duration': 6.363}, {'end': 22067.882, 'text': 'So that is how you overload or override a class function in PHP.', 'start': 22062.156, 'duration': 5.726}, {'end': 22075.529, 'text': "Now let's move on to the next question that is differentiate between equal to equal to and triple equal operator.", 'start': 22068.262, 'duration': 7.267}, {'end': 22083.48, 'text': 'So a double equal operator is generally used to check if the value of two operands are equal or not.', 'start': 22076.314, 'duration': 7.166}], 'summary': 'Explains function overriding and compares double equal to triple equal operator.', 'duration': 82.755, 'max_score': 22000.725, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg22000725.jpg'}, {'end': 22402.323, 'src': 'embed', 'start': 22371.105, 'weight': 8, 'content': [{'end': 22376.888, 'text': 'so this piece of code, as you can notice, is used to create a singleton class.', 'start': 22371.105, 'duration': 5.783}, {'end': 22384.132, 'text': 'Now in, to create a singleton class, you need to have the constructor function private.', 'start': 22376.888, 'duration': 7.244}, {'end': 22386.053, 'text': 'now here, as you can see,', 'start': 22384.132, 'duration': 1.921}, {'end': 22397.259, 'text': "a singleton class is created using this private construct and it then checks if there's only one instance created and if it is,", 'start': 22386.053, 'duration': 11.206}, {'end': 22402.323, 'text': 'it functions properly and displays initialize only once.', 'start': 22397.998, 'duration': 4.325}], 'summary': 'Code creates a singleton class with private constructor, allowing only one instance to be initialized.', 'duration': 31.218, 'max_score': 22371.105, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg22371105.jpg'}, {'end': 22459.734, 'src': 'embed', 'start': 22430.957, 'weight': 11, 'content': [{'end': 22435.779, 'text': 'So what it will generate is we are echoing this generated hash.', 'start': 22430.957, 'duration': 4.822}, {'end': 22439.321, 'text': 'So what it will generate is this.', 'start': 22436.44, 'duration': 2.881}, {'end': 22442.383, 'text': 'So this is the this is random.', 'start': 22439.841, 'duration': 2.542}, {'end': 22453.391, 'text': 'It changes every time you generate the password, since it is encrypted, and same when you pass This password to the database using hashing algorithm.', 'start': 22442.443, 'duration': 10.948}, {'end': 22456.372, 'text': 'even in the database, the password will not be visible.', 'start': 22453.391, 'duration': 2.981}, {'end': 22458.333, 'text': 'So your data is secure.', 'start': 22456.652, 'duration': 1.681}, {'end': 22459.734, 'text': 'Next question.', 'start': 22459.153, 'duration': 0.581}], 'summary': 'Generated hash ensures secure and encrypted passwords stored in the database.', 'duration': 28.777, 'max_score': 22430.957, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg22430957.jpg'}, {'end': 22518.362, 'src': 'embed', 'start': 22486.842, 'weight': 4, 'content': [{'end': 22491.706, 'text': 'Now if you want to sort it in descending order, use rsort, that is reverse sort.', 'start': 22486.842, 'duration': 4.864}, {'end': 22501.973, 'text': 'Similarly, suppose you want to sort an array in terms of value in ascending order, so you need to use a sort function.', 'start': 22492.446, 'duration': 9.527}, {'end': 22503.314, 'text': 'that is this.', 'start': 22501.973, 'duration': 1.341}, {'end': 22511.738, 'text': 'so, in terms of value, what in terms of value means is suppose, in a given array there are keys and values.', 'start': 22503.314, 'duration': 8.424}, {'end': 22518.362, 'text': 'so it will sort the array based on the values, that is this 22, 27 and 37.', 'start': 22511.738, 'duration': 6.624}], 'summary': 'Use rsort for descending order, and sort for ascending order based on array values.', 'duration': 31.52, 'max_score': 22486.842, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg22486842.jpg'}, {'end': 22581.888, 'src': 'embed', 'start': 22553.032, 'weight': 7, 'content': [{'end': 22565.519, 'text': 'now, if you want to sort this array in descending order in terms of value, you use, instead of a sort, you use a reverse sort.', 'start': 22553.032, 'duration': 12.487}, {'end': 22576.925, 'text': 'similarly, if you want to sort an array in terms of key in descending, you use k instead of k sort, kr sort, that is k reverse sort.', 'start': 22565.519, 'duration': 11.406}, {'end': 22581.888, 'text': 'so these are the different sorting functions that are inbuilt into php.', 'start': 22576.925, 'duration': 4.963}], 'summary': 'Php has inbuilt functions for sorting arrays in ascending and descending order based on value and key.', 'duration': 28.856, 'max_score': 22553.032, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg22553032.jpg'}], 'start': 21862.298, 'title': 'Php programming concepts', 'summary': 'Covers php programming concepts including class and operator comparison, basics like exception handling and file inclusion, array sorting functions, and type hinting and class implementation. it provides insights into final class and method, function overloading and overriding, double equal and triple equal operators, error types, function reference, singleton class creation, password encryption, array sorting functions, type hinting, and class implementation, accompanied by code examples and explanations.', 'chapters': [{'end': 22145.218, 'start': 21862.298, 'title': 'Php class and operator comparison', 'summary': 'Discusses the concepts of final class and method, function overloading and overriding, and the difference between double equal and triple equal operators in php, providing code examples and explanations.', 'duration': 282.92, 'highlights': ['The final class in PHP means that the class cannot be extended, while a final method means that it cannot be overridden, leading to errors if attempted.', 'Function overloading in PHP involves using the same function for different purposes based on the number of arguments, while function overriding changes the behavior of the parent class method in the child class.', 'The explanation and demonstration of function overloading and overriding are provided with code examples, showcasing the impact of parameter changes and property overrides.', 'The triple equals to operator in PHP performs a type-safe comparison, returning true only if both operands have the same type and value, illustrated with code examples highlighting the difference from the double equal operator.']}, {'end': 22459.734, 'start': 22145.218, 'title': 'Php basics: exception handling, file inclusion, error types, function reference, singleton class, password encryption', 'summary': 'Covers php basics including exception handling, file inclusion, error types, function reference, singleton class creation, and password encryption.', 'duration': 314.516, 'highlights': ['PHP consists of mainly three errors: Notice, Warning, and Fatal Error. Notice is a non-critical error, Warning is a critical error, and Fatal Error results in termination of the code.', 'Password_hash function in PHP creates a hashed password using a hashing algorithm. The function generates a random hash which changes every time it is executed, ensuring password security.', 'Exception handling in PHP involves using try and catch blocks to manage errors and prevent fatal errors. When an exception is thrown, PHP attempts to find the first matching catch block, and without a catch function, it results in a fatal error.', 'Differentiate between require and include: require throws a fatal error if the file is not found, whereas include produces a warning and continues script execution. Require stops code execution if the file is not found, while include continues script execution but produces a warning.', 'A singleton class in PHP allows only one object and provides a single point of access. A singleton class restricts the creation of multiple objects, allowing only one instance to be created, ensuring a single point of access.']}, {'end': 22753.177, 'start': 22460.574, 'title': 'Php array sorting functions', 'summary': 'Explains different sorting functions for arrays in php, including sorting in ascending and descending order, sorting based on values and keys, and the behavior of constructor and destructor functions, as well as the interaction between php and javascript.', 'duration': 292.603, 'highlights': ['PHP has different sorting functions for arrays, such as sort, rsort, ksort, and krsort, to sort arrays in ascending, descending, value-based, and key-based orders. PHP consists of different sorting functions like sort, rsort, ksort, and krsort to sort arrays in various orders, providing flexibility and ease of use.', "The output of a given code will be '21, 21' due to the reference-based assignment of variable values. The output of the given code will be '21, 21' due to the reference-based assignment of variable values, demonstrating the behavior of reference assignment in PHP.", 'Constructor (construct) function in PHP is automatically invoked when a new object of a class is created, while the destructor (destruct) function is automatically invoked when an object of a class is destructed. The constructor function in PHP is automatically invoked when a new object of a class is created, and the destructor function is automatically invoked when an object of a class is destructed, providing insight into these essential object-oriented programming concepts in PHP.', 'PHP and JavaScript can interact by PHP producing JavaScript code to be implemented by the browser, enabling the exchange of variables and allowing PHP to influence client-side behavior. PHP and JavaScript can interact by PHP producing JavaScript code to be implemented by the browser, enabling the exchange of variables and allowing PHP to influence client-side behavior, showcasing the potential interaction between these server-side and client-side languages.']}, {'end': 22941.341, 'start': 22753.177, 'title': 'Php type hinting and class implementation', 'summary': 'Covers the concept of type hinting in php, where specifying expected data types for function arguments helps avoid fatal errors, and also provides an example of implementing a class named basketball with an attribute named baskets that increases with the score method. the tutorial concludes with a call to action for the audience.', 'duration': 188.164, 'highlights': ['Type hinting in PHP specifies the expected data type for function arguments, such as array, object, or interface, and mismatching types result in fatal errors. Type hinting in PHP helps ensure the correct data types for function arguments, preventing fatal errors.', 'Implementing a class named basketball with an attribute named baskets and a method named score that increases the baskets by one upon invocation. The tutorial provides an example of creating a class in PHP, named basketball, with a method to increase the baskets attribute upon scoring.', 'The tutorial concludes with a call to action for the audience to like and subscribe for more content. The tutorial ends with an encouragement for the audience to engage with the content by liking and subscribing for more.']}], 'duration': 1079.043, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/6EukZDFE_Zg/pics/6EukZDFE_Zg21862298.jpg', 'highlights': ['The final class in PHP means that the class cannot be extended, while a final method means that it cannot be overridden, leading to errors if attempted.', 'Function overloading in PHP involves using the same function for different purposes based on the number of arguments, while function overriding changes the behavior of the parent class method in the child class.', 'The triple equals to operator in PHP performs a type-safe comparison, returning true only if both operands have the same type and value, illustrated with code examples highlighting the difference from the double equal operator.', 'PHP consists of mainly three errors: Notice, Warning, and Fatal Error. Notice is a non-critical error, Warning is a critical error, and Fatal Error results in termination of the code.', 'Password_hash function in PHP creates a hashed password using a hashing algorithm. The function generates a random hash which changes every time it is executed, ensuring password security.', 'Exception handling in PHP involves using try and catch blocks to manage errors and prevent fatal errors. When an exception is thrown, PHP attempts to find the first matching catch block, and without a catch function, it results in a fatal error.', 'Differentiate between require and include: require throws a fatal error if the file is not found, whereas include produces a warning and continues script execution. Require stops code execution if the file is not found, while include continues script execution but produces a warning.', 'A singleton class in PHP allows only one object and provides a single point of access. A singleton class restricts the creation of multiple objects, allowing only one instance to be created, ensuring a single point of access.', 'PHP has different sorting functions for arrays, such as sort, rsort, ksort, and krsort, to sort arrays in ascending, descending, value-based, and key-based orders.', "The output of a given code will be '21, 21' due to the reference-based assignment of variable values, demonstrating the behavior of reference assignment in PHP.", 'Constructor (construct) function in PHP is automatically invoked when a new object of a class is created, while the destructor (destruct) function is automatically invoked when an object of a class is destructed.', 'PHP and JavaScript can interact by PHP producing JavaScript code to be implemented by the browser, enabling the exchange of variables and allowing PHP to influence client-side behavior.', 'Type hinting in PHP specifies the expected data type for function arguments, such as array, object, or interface, and mismatching types result in fatal errors.', 'Implementing a class named basketball with an attribute named baskets and a method named score that increases the baskets by one upon invocation.', 'The tutorial concludes with a call to action for the audience to like and subscribe for more content.']}], 'highlights': ['PHP powers 79.2% of the web, equating to 20 million websites and 1 million web servers, showcasing its widespread usage and importance in the industry.', 'PHP is visited by users for nearly 22 billion times per month, making it crucial for handling huge traffic volumes on websites like Facebook.', 'The chapter covers the process of creating, reading, updating, and deleting records in a PHP application.', 'The major difference between POST and GET method is that GET method carries request parameters appended in the URL string, while POST carries request parameters in the message body, making it a more secure way of transferring data from the client to the destination.', 'The chapter covers the process of setting up Visual Studio Code and XAMPP, emphasizing the creation of project folders and adding files, with a focus on linking to external resources, such as CSS and scripts, and encountering and resolving issues with CSS design in a webpage.', 'The chapter showcased the process of creating a basic e-commerce website using Visual Studio Code and XAMPP as the web server solutions package, with a demonstration of top products on the front page.', 'The final class in PHP means that the class cannot be extended, while a final method means that it cannot be overridden, leading to errors if attempted.', 'PHP consists of mainly three errors: Notice, Warning, and Fatal Error. Notice is a non-critical error, Warning is a critical error, and Fatal Error results in termination of the code.', 'PHP has different sorting functions for arrays, such as sort, rsort, ksort, and krsort, to sort arrays in ascending, descending, value-based, and key-based orders.', 'PHP and JavaScript can interact by PHP producing JavaScript code to be implemented by the browser, enabling the exchange of variables and allowing PHP to influence client-side behavior.']}