title
Android MySQL Database Tutorial 1 - Creating Database And Writing PHP Script

description
Hi welcome to this short series on Android MySQL Database Tutorial for beginners. In Android PHP/MySQL Tutorial I will use PHP to create a back-end rest server. In this first video I will show How to Create your MySQL Database And Writing PHP Script. It is the Best tutorial for android PHP and MySQL. This tutorial series will cover How to connect Android app to MySQL database?, Android Tutorial - Connect Android to MySQL Database, Android Login and Registration with PHP, MySQL , Android Login Form Tutorial with MySQL and PHP ★★★Top Online Courses From ProgrammingKnowledge ★★★ Python Programming Course ➡️ http://bit.ly/2vsuMaS ⚫️ http://bit.ly/2GOaeQB Java Programming Course ➡️ http://bit.ly/2GEfQMf ⚫️ http://bit.ly/2Vvjy4a Bash Shell Scripting Course ➡️ http://bit.ly/2DBVF0C ⚫️ http://bit.ly/2UM06vF Linux Command Line Tutorials ➡️ http://bit.ly/2IXuil0 ⚫️ http://bit.ly/2IXukt8 C Programming Course ➡️ http://bit.ly/2GQCiD1 ⚫️ http://bit.ly/2ZGN6ej C++ Programming Course ➡️ http://bit.ly/2V4oEVJ ⚫️ http://bit.ly/2XMvqMs PHP Programming Course ➡️ http://bit.ly/2XP71WH ⚫️ http://bit.ly/2vs3od6 Android Development Course ➡️ http://bit.ly/2UHih5H ⚫️ http://bit.ly/2IMhVci C# Programming Course ➡️ http://bit.ly/2Vr7HEl ⚫️ http://bit.ly/2W6RXTU JavaFx Programming Course ➡️ http://bit.ly/2XMvZWA ⚫️ http://bit.ly/2V2CoAi NodeJs Programming Course ➡️ http://bit.ly/2GPg7gA ⚫️ http://bit.ly/2GQYTQ2 Jenkins Course For Developers and DevOps ➡️ http://bit.ly/2Wd4l4W ⚫️ http://bit.ly/2J1B1ug Scala Programming Tutorial Course ➡️ http://bit.ly/2PysyA4 ⚫️ http://bit.ly/2PCaVj2 Bootstrap Responsive Web Design Tutorial ➡️ http://bit.ly/2DFQ2yC ⚫️ http://bit.ly/2VoJWwH MongoDB Tutorial Course ➡️ http://bit.ly/2LaCJfP ⚫️ http://bit.ly/2WaI7Ap QT C++ GUI Tutorial For Beginners ➡️ http://bit.ly/2vwqHSZ ★★★ Online Courses to learn ★★★ Get 2 FREE Months of Unlimited Classes from skillshare - https://skillshare.eqcm.net/r1KEj Data Science - http://bit.ly/2lD9h5L | http://bit.ly/2lI8wIl Machine Learning - http://bit.ly/2WGGQpb | http://bit.ly/2GghLXX Artificial Intelligence - http://bit.ly/2lYqaYx | http://bit.ly/2NmaPya MERN Stack E-Degree Program - http://bit.ly/2kx2NFe | http://bit.ly/2lWj4no DevOps E-degree - http://bit.ly/2k1PwUQ | http://bit.ly/2k8Ypfy Data Analytics with R - http://bit.ly/2lBKqz8 | http://bit.ly/2lAjos3 AWS Certification Training - http://bit.ly/2kmLtTu | http://bit.ly/2lAkQL1 Projects in Java - http://bit.ly/2kzn25d | http://bit.ly/2lBMffs Machine Learning With TensorFlow - http://bit.ly/2m1z3AF | http://bit.ly/2lBMhnA Angular 8 - Complete Essential Guide - http://bit.ly/2lYvYRP Kotlin Android Development Masterclass - http://bit.ly/2GcblsI Learn iOS Programming Building Advance Projects - http://bit.ly/2kyX7ue ★★★ Follow ★★★ My Website - http://www.codebind.com DISCLAIMER: This video and description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This help support the channel and allows us to continue to make videos like this. Thank you for the support!

detail
{'title': 'Android MySQL Database Tutorial 1 - Creating Database And Writing PHP Script', 'heatmap': [{'end': 605.217, 'start': 584.864, 'weight': 0.821}, {'end': 1043.133, 'start': 1018.143, 'weight': 0.855}, {'end': 1216.827, 'start': 1149.288, 'weight': 1}, {'value': 0.7042869570466413, 'end_time': 1211.1450000000002, 'start_time': 1178.607}, {'end': 1694.101, 'start': 1656.325, 'weight': 0.753}], 'summary': "This tutorial provides a beginner's guide on creating an android app with mysql database, requiring a web server, php for server-side scripting, and android studio for development, including setting up web servers, mysql databases using wamp, installing wampserver, creating database tables, setting up php script for database connection and data manipulation, and preparing mysql query for user authentication.", 'chapters': [{'end': 160.885, 'segs': [{'end': 26.713, 'src': 'embed', 'start': 1.018, 'weight': 0, 'content': [{'end': 6.041, 'text': 'hello, guys, welcome to the first video on android mysql database tutorial for beginners.', 'start': 1.018, 'duration': 5.023}, {'end': 15.466, 'text': 'in this video series, we are going to learn how we can create an android app using mysql database which is running on some web server.', 'start': 6.041, 'duration': 9.425}, {'end': 18.008, 'text': "so let's see what are the requirement.", 'start': 15.466, 'duration': 2.542}, {'end': 26.713, 'text': 'first of all, we are going to need mysql database and then we want to use a web server.', 'start': 18.008, 'duration': 8.705}], 'summary': 'Android mysql tutorial for beginners to create app using mysql database on a web server.', 'duration': 25.695, 'max_score': 1.018, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w1018.jpg'}, {'end': 160.885, 'src': 'embed', 'start': 87.955, 'weight': 1, 'content': [{'end': 101.706, 'text': 'web server is a windows web development environment and it allows you to create a web application with apache, php and mysql database alongside.', 'start': 87.955, 'duration': 13.751}, {'end': 108.832, 'text': "it's also going to give you php myadmin, which allows you to manage your database easily.", 'start': 101.706, 'duration': 7.126}, {'end': 121.157, 'text': 'ok, so this is the first option which we can use for creating our first android application and for testing our application.', 'start': 109.312, 'duration': 11.845}, {'end': 131.621, 'text': 'now, for practical uses, we can use web hosting and a server which is running on some web hosting website,', 'start': 121.157, 'duration': 10.464}, {'end': 138.144, 'text': 'like godaddy or hostgator or google hosting or any other hosting website.', 'start': 131.621, 'duration': 6.523}, {'end': 142.067, 'text': 'So what is web hosting?', 'start': 139.485, 'duration': 2.582}, {'end': 157.882, 'text': 'Web hosting is a service which you can use to host your website and it generally comes with file system and database integrated.', 'start': 142.127, 'duration': 15.755}, {'end': 160.885, 'text': 'So we can use this web hosting also.', 'start': 158.102, 'duration': 2.783}], 'summary': 'Windows web server provides apache, php, and mysql for web application development and hosting. it includes php myadmin for database management and can be used for creating android applications and practical hosting on platforms like godaddy, hostgator, and google hosting.', 'duration': 72.93, 'max_score': 87.955, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w87955.jpg'}], 'start': 1.018, 'title': 'Android mysql database tutorial', 'summary': "Provides a beginner's tutorial on creating an android app using mysql database, requiring a web server, php for server-side scripting, and android studio for development, with options to use a local web server or web hosting for practical use.", 'chapters': [{'end': 160.885, 'start': 1.018, 'title': 'Android mysql database tutorial', 'summary': "Provides a beginner's tutorial on creating an android app using mysql database, requiring a web server, php for server-side scripting, and android studio for development, with options to use a local web server or web hosting for practical use.", 'duration': 159.867, 'highlights': ['The chapter covers the requirements for creating an Android app using MySQL database, including the need for a web server, PHP for server-side scripting, and Android Studio for development.', 'It explains the option of using a local web server, such as a Windows web development environment, for testing purposes, which includes Apache, PHP, and MySQL database.', 'The tutorial also discusses the practical use of web hosting services like Godaddy, HostGator, or Google Hosting for hosting the web application and database integrated with the file system.']}], 'duration': 159.867, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w1018.jpg', 'highlights': ['The chapter covers the requirements for creating an Android app using MySQL database, including the need for a web server, PHP for server-side scripting, and Android Studio for development.', 'The tutorial also discusses the practical use of web hosting services like Godaddy, HostGator, or Google Hosting for hosting the web application and database integrated with the file system.', 'It explains the option of using a local web server, such as a Windows web development environment, for testing purposes, which includes Apache, PHP, and MySQL database.']}, {'end': 360.8, 'segs': [{'end': 254.153, 'src': 'embed', 'start': 161.585, 'weight': 0, 'content': [{'end': 170.512, 'text': "so i'm going to give you both examples using web server also and this web hosting also,", 'start': 161.585, 'duration': 8.927}, {'end': 178.738, 'text': 'so you can create online mysql database using android application.', 'start': 170.512, 'duration': 8.226}, {'end': 183.941, 'text': 'so first of all, we are going to create an application using web server.', 'start': 178.738, 'duration': 5.203}, {'end': 188.445, 'text': 'it comes with mysql apache and php myadmin.', 'start': 183.941, 'duration': 4.504}, {'end': 202.248, 'text': "So let's download and install WAMP web server and then we are going to write some PHP scripts to query our database and then we are going to create our Android application.", 'start': 189.145, 'duration': 13.103}, {'end': 207.87, 'text': 'So, first of all open your favorite browser and search for WAMP server.', 'start': 202.949, 'duration': 4.921}, {'end': 215.012, 'text': 'and the first result, most probably, which will appear here, will be from web server.com.', 'start': 208.81, 'duration': 6.202}, {'end': 217.413, 'text': 'slash en for english.', 'start': 215.012, 'duration': 2.401}, {'end': 226.116, 'text': 'just click this link here and this is the website from which you can install web web server.', 'start': 217.413, 'duration': 8.703}, {'end': 233.58, 'text': 'so you can read more about web server in here and how you can install it.', 'start': 226.876, 'duration': 6.704}, {'end': 237.321, 'text': 'so to download web server executable file,', 'start': 233.58, 'duration': 3.741}, {'end': 254.153, 'text': 'you just need to click download section here and in here you have two options one is web server for 32-bit operating system and and second is the web server for 64-bit operating system.', 'start': 237.321, 'duration': 16.832}], 'summary': 'Demonstration of creating an online mysql database using wamp web server to develop an android application.', 'duration': 92.568, 'max_score': 161.585, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w161585.jpg'}, {'end': 335.299, 'src': 'embed', 'start': 282.09, 'weight': 3, 'content': [{'end': 288.291, 'text': 'the second warning here it says that this web server requires visual studio 2012 vc 11 executable file.', 'start': 282.09, 'duration': 6.201}, {'end': 303.255, 'text': 'so to install This web server you need to have Visual Studio 2012 VC 11 and to download and install it you can just click this link.', 'start': 288.291, 'duration': 14.964}, {'end': 308.437, 'text': 'So first of all I am going to click this link to install this executable.', 'start': 303.295, 'duration': 5.142}, {'end': 311.179, 'text': 'And then we are going to install web server.', 'start': 308.957, 'duration': 2.222}, {'end': 324.97, 'text': 'So just click this Microsoft website link and in here you can see we are going to install Visual C++ redistributable for Visual Studio 2012 update 4.', 'start': 311.239, 'duration': 13.731}, {'end': 335.299, 'text': 'ok, select your language and click download, and in here we are going to check this first option, which is for 64-bit operating system.', 'start': 324.97, 'duration': 10.329}], 'summary': 'To install the web server, download visual studio 2012 vc 11 from the provided link and select the 64-bit option for installation.', 'duration': 53.209, 'max_score': 282.09, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w282090.jpg'}], 'start': 161.585, 'title': 'Setting up web servers and mysql databases', 'summary': 'Covers creating an online mysql database with wamp web server, including mysql, apache, and php myadmin, and installing a web server on a 64-bit operating system with visual studio 2012 vc 11 executable file for installation.', 'chapters': [{'end': 217.413, 'start': 161.585, 'title': 'Creating online mysql database with wamp web server', 'summary': 'Demonstrates how to create an online mysql database using the wamp web server, which includes mysql, apache, and php myadmin, and then proceed to create an android application.', 'duration': 55.828, 'highlights': ['The chapter illustrates the process of creating an online MySQL database using the WAMP web server, which consists of MySQL, Apache, and PHP MyAdmin.', 'The process involves downloading and installing the WAMP web server, writing PHP scripts to query the database, and creating an Android application.', 'The first step is to download and install the WAMP web server, followed by writing PHP scripts to query the database, and finally creating the Android application.']}, {'end': 360.8, 'start': 217.413, 'title': 'Installing web server and visual studio 2012 vc 11', 'summary': 'Explains the process of installing a web server on a 64-bit operating system, including the prerequisites and the requirement of visual studio 2012 vc 11 executable file for installation.', 'duration': 143.387, 'highlights': ['To install the web server, the user is required to download the executable file from the website, with options available for both 32-bit and 64-bit operating systems.', 'The installation process includes prerequisites such as not having any previous web server extension or add-ons and the requirement of Visual Studio 2012 VC 11 executable file.', 'The user is directed to download and install the Visual C++ redistributable for Visual Studio 2012 update 4, with specific instructions provided for choosing the appropriate option based on the operating system type.', 'The chapter provides detailed steps for downloading and installing the necessary executable file for Visual Studio 2012 VC 11, including language selection and choosing the appropriate option for the operating system.']}], 'duration': 199.215, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w161585.jpg', 'highlights': ['The chapter illustrates the process of creating an online MySQL database using the WAMP web server, which consists of MySQL, Apache, and PHP MyAdmin.', 'The process involves downloading and installing the WAMP web server, writing PHP scripts to query the database, and creating an Android application.', 'To install the web server, the user is required to download the executable file from the website, with options available for both 32-bit and 64-bit operating systems.', 'The installation process includes prerequisites such as not having any previous web server extension or add-ons and the requirement of Visual Studio 2012 VC 11 executable file.', 'The user is directed to download and install the Visual C++ redistributable for Visual Studio 2012 update 4, with specific instructions provided for choosing the appropriate option based on the operating system type.']}, {'end': 561.287, 'segs': [{'end': 492.355, 'src': 'embed', 'start': 360.8, 'weight': 0, 'content': [{'end': 379.908, 'text': 'so just click this executable file here and then click run and then just check this checkbox to agree with license terms and condition and click install and click yes,', 'start': 360.8, 'duration': 19.108}, {'end': 387.566, 'text': 'And once Visual C++ Distributable installation is complete, you can just close it.', 'start': 381.818, 'duration': 5.748}, {'end': 399.461, 'text': 'And once again, you can open your favorite web browser and then search for WampServer and then go to the same website, wampserver.com,', 'start': 388.046, 'duration': 11.415}, {'end': 406.519, 'text': 'and then once again go to downloads here and then once again click the web server option.', 'start': 400.376, 'duration': 6.143}, {'end': 411.181, 'text': 'and then this time you need to just click download directly.', 'start': 406.519, 'duration': 4.662}, {'end': 417.324, 'text': "okay, so it's going to download this web server executable, right.", 'start': 411.181, 'duration': 6.143}, {'end': 424.04, 'text': 'so we will wait for this web server executable to download.', 'start': 418.917, 'duration': 5.123}, {'end': 429.463, 'text': "it's not a big file, it's just a 41.5 mb file.", 'start': 424.04, 'duration': 5.423}, {'end': 433.825, 'text': "so it's going to download in a few seconds.", 'start': 429.463, 'duration': 4.362}, {'end': 444.171, 'text': 'now, once the download is complete, you can click this executable file for the web server and you will be able to see this kind of web server setup.', 'start': 433.825, 'duration': 10.346}, {'end': 454.016, 'text': 'so just click next and in here, just click i accept the agreement and click next, and this is the location where web server will be installed.', 'start': 444.171, 'duration': 9.845}, {'end': 460.199, 'text': 'so c colon slash web will be the folder in which this web server will be installed.', 'start': 454.016, 'duration': 6.183}, {'end': 467.923, 'text': 'so just click next and then you can create a desktop icon and quick launch icon also.', 'start': 460.199, 'duration': 7.724}, {'end': 473.125, 'text': "so i'm going to create only desktop icon for that and click next and click install.", 'start': 467.923, 'duration': 5.202}, {'end': 487.213, 'text': "now in here it's going to tell you or ask you please choose your default web browser and if you are not sure, just click open,", 'start': 477.15, 'duration': 10.063}, {'end': 492.355, 'text': 'or if you have some browser preferences, you can choose your browser from here.', 'start': 487.213, 'duration': 5.142}], 'summary': 'Install visual c++ distributable and wampserver web server, total file size 41.5 mb', 'duration': 131.555, 'max_score': 360.8, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w360800.jpg'}, {'end': 561.287, 'src': 'embed', 'start': 525.277, 'weight': 4, 'content': [{'end': 536.717, 'text': 'so just click allow access here and these are the php mail parameter which we are not going to use right now.', 'start': 525.277, 'duration': 11.44}, {'end': 549.061, 'text': 'so we will leave them as default and click next and then just click finish and please make sure that this option is checked to launch the web server right.', 'start': 536.717, 'duration': 12.344}, {'end': 561.287, 'text': "so just click finish and click yes, and it's going to launch your web server and when your web server is ready,", 'start': 549.061, 'duration': 12.226}], 'summary': 'Setting up web server with default php mail parameters.', 'duration': 36.01, 'max_score': 525.277, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w525277.jpg'}], 'start': 360.8, 'title': 'Installing web server and wampserver', 'summary': 'Provides a detailed guide on installing wampserver and a web server, including the download and installation process, file sizes, installation location, choosing a default web browser, and launching the web server, with specific steps for creating a desktop icon and selecting browsers like chrome.', 'chapters': [{'end': 460.199, 'start': 360.8, 'title': 'Installing wampserver for web development', 'summary': "Details the step-by-step process of installing wampserver, including instructions to download and install visual c++ distributable and wampserver, with the web server executable being a 41.5 mb file, and the installation location being in the 'c:\\", 'duration': 99.399, 'highlights': ['The web server executable is a 41.5 mb file, which will download in a few seconds.', "The installation location for the web server is in the folder 'c:\\", 'The process involves installing Visual C++ Distributable and WampServer, with specific instructions for each step.']}, {'end': 561.287, 'start': 460.199, 'title': 'Installing web server and choosing default browser', 'summary': 'Covers the process of installing a web server, choosing a default web browser, and launching the web server, including steps to create a desktop icon and select a specific browser like chrome, with a reminder to allow access and launch the web server.', 'duration': 101.088, 'highlights': ["The installation process involves creating a desktop icon and choosing a default web browser, such as Chrome, by navigating through specific folders and selecting the browser's executable file.", 'After finishing the installation, allowing access and launching the web server is essential, with a reminder to ensure the option to launch the web server is checked.', 'The chapter also mentions the option to choose a quick launch icon and the PHP mail parameters, which are not utilized in this context.']}], 'duration': 200.487, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w360800.jpg', 'highlights': ['The web server executable is a 41.5 mb file, which will download in a few seconds.', "The installation location for the web server is in the folder 'c:\\", 'The process involves installing Visual C++ Distributable and WampServer, with specific instructions for each step.', "The installation process involves creating a desktop icon and choosing a default web browser, such as Chrome, by navigating through specific folders and selecting the browser's executable file.", 'After finishing the installation, allowing access and launching the web server is essential, with a reminder to ensure the option to launch the web server is checked.', 'The chapter also mentions the option to choose a quick launch icon and the PHP mail parameters, which are not utilized in this context.']}, {'end': 757.599, 'segs': [{'end': 626.702, 'src': 'heatmap', 'start': 584.864, 'weight': 0, 'content': [{'end': 592.65, 'text': 'So, first of all, what we are going to do is we are going to use phpMyAdmin to create our database.', 'start': 584.864, 'duration': 7.786}, {'end': 594.932, 'text': "So let's create our database.", 'start': 592.85, 'duration': 2.082}, {'end': 599.836, 'text': 'Now you can see our phpMyAdmin is open here.', 'start': 595.512, 'duration': 4.324}, {'end': 605.217, 'text': 'and by default it has some databases right.', 'start': 600.636, 'duration': 4.581}, {'end': 606.978, 'text': 'so to create a database.', 'start': 605.217, 'duration': 1.761}, {'end': 613.039, 'text': 'what we can do here is we can click database and give the database name.', 'start': 606.978, 'duration': 6.061}, {'end': 616.32, 'text': 'so, for example, we are creating a database for employees,', 'start': 613.039, 'duration': 3.281}, {'end': 625.162, 'text': 'so we can just write employee 101 and then just click create here and you can see our database is created.', 'start': 616.32, 'duration': 8.842}, {'end': 626.702, 'text': 'so expand your database.', 'start': 625.162, 'duration': 1.54}], 'summary': "Using phpmyadmin to create a database named 'employee 101' for employees.", 'duration': 31.19, 'max_score': 584.864, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w584864.jpg'}, {'end': 757.599, 'src': 'embed', 'start': 651.89, 'weight': 2, 'content': [{'end': 659.316, 'text': "For example, it's going to contain employee ID, name, surname, age and username and password.", 'start': 651.89, 'duration': 7.426}, {'end': 662.518, 'text': "So it's going to contain six columns.", 'start': 659.376, 'duration': 3.142}, {'end': 666.421, 'text': 'Just select six from here and then click go.', 'start': 662.878, 'duration': 3.543}, {'end': 670.744, 'text': "and then it's going to give you this kind of wizard.", 'start': 668.021, 'duration': 2.723}, {'end': 672.485, 'text': 'first is our id.', 'start': 670.744, 'duration': 1.741}, {'end': 674.748, 'text': 'second is the name.', 'start': 672.485, 'duration': 2.263}, {'end': 676.97, 'text': 'third is the surname.', 'start': 674.748, 'duration': 2.222}, {'end': 679.012, 'text': 'fourth column is the age.', 'start': 676.97, 'duration': 2.042}, {'end': 683.716, 'text': 'fifth column is the user name and sixth column is the password.', 'start': 679.012, 'duration': 4.704}, {'end': 691.603, 'text': 'ok, now, id is integer, name is text, surname data type is text.', 'start': 683.716, 'duration': 7.887}, {'end': 700.528, 'text': 'also, age data type is int itself, username data type is text and password data type is text.', 'start': 691.603, 'duration': 8.925}, {'end': 708.533, 'text': 'okay, now we can also choose the primary key of this table.', 'start': 700.528, 'duration': 8.005}, {'end': 710.394, 'text': 'so id is our primary key.', 'start': 708.533, 'duration': 1.861}, {'end': 720.344, 'text': 'so go to index here and then choose the primary for ID, and this ID is also going to be auto incremented.', 'start': 710.394, 'duration': 9.95}, {'end': 731.637, 'text': 'so choose this option which says A underscore I, which is auto increment, and then, once this is done, we can just save our table.', 'start': 720.344, 'duration': 11.293}, {'end': 747.195, 'text': 'So now our table contains six columns which you can just click on this employee table, and then you can see all the columns inside the table,', 'start': 733.289, 'duration': 13.906}, {'end': 752.097, 'text': 'which is ID, name, surname, age and username and password columns.', 'start': 747.195, 'duration': 4.902}, {'end': 757.599, 'text': 'So our database and database table is ready to use.', 'start': 752.637, 'duration': 4.962}], 'summary': 'A database table with 6 columns is created, including employee data and data types, with the id set as primary key and auto-incremented.', 'duration': 105.709, 'max_score': 651.89, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w651890.jpg'}], 'start': 561.287, 'title': 'Setting up a database and creating database table', 'summary': "Guides through setting up a database using phpmyadmin for 'employee 101' and creating a table with 6 columns. it explains the process of creating a database table with 6 columns including id, name, surname, age, username, and password, setting id as the primary key with auto-increment feature.", 'chapters': [{'end': 683.716, 'start': 561.287, 'title': 'Setting up a database with phpmyadmin', 'summary': "Guides through setting up a database using phpmyadmin, creating a database for employees named 'employee 101', and creating a table with six columns for employee data.", 'duration': 122.429, 'highlights': ["The chapter demonstrates using phpMyAdmin to create a database for employees named 'employee 101', and a table with six columns for employee data.", 'It shows how to create a database using phpMyAdmin and the process of creating a table with six columns for employee data.']}, {'end': 757.599, 'start': 683.716, 'title': 'Creating database table', 'summary': 'Explains the process of creating a database table with 6 columns including id, name, surname, age, username, and password, setting id as the primary key with auto-increment feature.', 'duration': 73.883, 'highlights': ['The database table consists of 6 columns: ID, name, surname, age, username, and password.', 'ID is set as the primary key for the table.', 'The ID column is configured to auto-increment.']}], 'duration': 196.312, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w561287.jpg', 'highlights': ["The chapter demonstrates using phpMyAdmin to create a database for employees named 'employee 101', and a table with six columns for employee data.", 'It shows how to create a database using phpMyAdmin and the process of creating a table with six columns for employee data.', 'The database table consists of 6 columns: ID, name, surname, age, username, and password.', 'ID is set as the primary key for the table.', 'The ID column is configured to auto-increment.']}, {'end': 1315.313, 'segs': [{'end': 1043.133, 'src': 'heatmap', 'start': 1018.143, 'weight': 0.855, 'content': [{'end': 1023.484, 'text': 'so, for example, we are going to use this localhost as a server name.', 'start': 1018.143, 'duration': 5.341}, {'end': 1032.828, 'text': 'so we are going to just write localhost and in here we can just go to edit privileges and go down a little.', 'start': 1023.484, 'duration': 9.344}, {'end': 1034.969, 'text': 'and right now there is no password.', 'start': 1032.828, 'duration': 2.141}, {'end': 1043.133, 'text': "or you can just select this option, which is no password, and then click, go and it's going to.", 'start': 1034.969, 'duration': 8.164}], 'summary': 'Using localhost as server name, setting no password for privileges.', 'duration': 24.99, 'max_score': 1018.143, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w1018143.jpg'}, {'end': 1139.1, 'src': 'embed', 'start': 1066.76, 'weight': 1, 'content': [{'end': 1081.119, 'text': 'so just write mysqli underscore connect and then, inside the brackets, just pass the four arguments.', 'start': 1066.76, 'duration': 14.359}, {'end': 1083.28, 'text': 'it takes four arguments.', 'start': 1081.119, 'duration': 2.161}, {'end': 1089.863, 'text': 'first is your server name, so just pass the first argument as server name.', 'start': 1083.28, 'duration': 6.583}, {'end': 1093.204, 'text': 'second, is the mysql username.', 'start': 1089.863, 'duration': 3.341}, {'end': 1094.565, 'text': 'second, is this one?', 'start': 1093.204, 'duration': 1.361}, {'end': 1097.886, 'text': 'Third is MySQL password.', 'start': 1095.265, 'duration': 2.621}, {'end': 1100.727, 'text': 'so just copy this variable and paste it here', 'start': 1097.886, 'duration': 2.841}, {'end': 1107.931, 'text': 'And the fourth is the database name, so database name is this one.', 'start': 1101.308, 'duration': 6.623}, {'end': 1110.872, 'text': 'So these are the four arguments.', 'start': 1109.011, 'duration': 1.861}, {'end': 1115.012, 'text': 'right now to check if the connection is successful or not.', 'start': 1111.331, 'duration': 3.681}, {'end': 1128.736, 'text': 'you can just give this condition if, and inside the if statement you can just write this variable con, which gives you the boolean result,', 'start': 1115.012, 'duration': 13.724}, {'end': 1134.558, 'text': 'and then inside these brackets, if the connection is successful, you can echo something.', 'start': 1128.736, 'duration': 5.822}, {'end': 1139.1, 'text': 'so you can just write echo connection success.', 'start': 1134.558, 'duration': 4.542}], 'summary': "Using mysqli_connect with four arguments to establish a successful connection and echo 'connection success.'", 'duration': 72.34, 'max_score': 1066.76, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w1066760.jpg'}, {'end': 1216.827, 'src': 'heatmap', 'start': 1149.288, 'weight': 1, 'content': [{'end': 1162.493, 'text': 'okay, so just write echo connection not success, okay, and then save everything and then open your web browser.', 'start': 1149.288, 'duration': 13.205}, {'end': 1172.055, 'text': 'and in here you just need to first of all write localhost, which is going to give you this kind of web server options like this right.', 'start': 1162.493, 'duration': 9.562}, {'end': 1178.607, 'text': 'and then, whenever you give localhost slash in your browser,', 'start': 1172.055, 'duration': 6.552}, {'end': 1199.441, 'text': 'you just need to write localhost and then slash con dot php right and when you click enter,', 'start': 1178.607, 'duration': 20.834}, {'end': 1204.262, 'text': "it's going to give you connection success if your connection is successful.", 'start': 1199.441, 'duration': 4.821}, {'end': 1208.784, 'text': "otherwise it's going to give you connection not success.", 'start': 1204.262, 'duration': 4.522}, {'end': 1211.145, 'text': "so let's edit our.", 'start': 1208.784, 'duration': 2.361}, {'end': 1216.827, 'text': 'you know these values so we can know that it gives the right result.', 'start': 1211.145, 'duration': 5.682}], 'summary': 'Testing connection to localhost using con.php to check for success or failure.', 'duration': 67.539, 'max_score': 1149.288, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w1149288.jpg'}, {'end': 1315.313, 'src': 'embed', 'start': 1249.472, 'weight': 0, 'content': [{'end': 1257.474, 'text': 'okay. so in this way we know that our PHP is able to connect to the MySQL database.', 'start': 1249.472, 'duration': 8.002}, {'end': 1261.495, 'text': 'right now we are going to create one more PHP script.', 'start': 1257.474, 'duration': 4.021}, {'end': 1270.739, 'text': "so I'm going to just write create a new PHP script and I'm going to save it as, for example, login.php.", 'start': 1261.495, 'duration': 9.244}, {'end': 1276.903, 'text': 'so just write login.php and click save here.', 'start': 1270.739, 'duration': 6.164}, {'end': 1283.668, 'text': "and once again I'm going to just give the php initialization tag.", 'start': 1276.903, 'duration': 6.765}, {'end': 1292.975, 'text': 'and in here, first of all, we are going to import this con.php, which gives us the connection right.', 'start': 1283.668, 'duration': 9.307}, {'end': 1307.544, 'text': 'so we are going to require first of all so just write require, and then inside the double code con.php, right.', 'start': 1292.975, 'duration': 14.569}, {'end': 1311.509, 'text': 'so this is going to import this connection.', 'start': 1307.544, 'duration': 3.965}, {'end': 1315.313, 'text': 'and then we are going to create two variables.', 'start': 1311.509, 'duration': 3.804}], 'summary': 'Creating a new php script to import connection from con.php and create two variables.', 'duration': 65.841, 'max_score': 1249.472, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w1249472.jpg'}], 'start': 760.123, 'title': 'Php script and mysql connection setup', 'summary': 'Details creating a php script for database connection and data manipulation, emphasizing the use of php elements and variables. it also covers setting up mysql connection in php with mysqli_connect method and verifying connection status through examples.', 'chapters': [{'end': 915.082, 'start': 760.123, 'title': 'Php script for database connection and data manipulation', 'summary': 'Outlines the process of creating a php script to connect to a database, navigate to the www directory, and create a new php file for database connection, emphasizing the use of php elements and variables for database interaction.', 'duration': 154.959, 'highlights': ['The process involves creating a PHP script for database connection, navigating to the www directory, and creating a new PHP file for database connection.', 'Emphasizes the use of PHP elements and variables for defining the database name and other parameters.']}, {'end': 1315.313, 'start': 915.082, 'title': 'Setting up mysql connection in php', 'summary': "Covers setting up a mysql connection in php, including specifying the database name, username, password, and server name, using mysqli_connect method with four arguments, and checking the connection status by echoing 'connection success' or 'connection not success' in the browser, with an example demonstrating a successful connection and a failed connection.", 'duration': 400.231, 'highlights': ['The chapter explains how to set up a MySQL connection in PHP, including specifying the database name, username, password, and server name, and using the mysqli_connect method with four arguments: server name, MySQL username, MySQL password, and database name.', "It demonstrates checking the connection status by using an if statement to echo 'connection success' if the connection is successful, and 'connection not success' if it's not, and provides an example of a successful connection and a failed connection when incorrect parameters are used.", 'It also covers importing the connection from con.php using the require statement and creating variables in the login.php script.']}], 'duration': 555.19, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w760123.jpg', 'highlights': ['The process involves creating a PHP script for database connection and defining parameters.', 'Explains setting up a MySQL connection in PHP with mysqli_connect method and parameters.', 'Demonstrates checking connection status using if statement and provides successful and failed connection examples.', 'Covers importing connection from con.php using require statement and creating variables in the login.php script.']}, {'end': 1725.369, 'segs': [{'end': 1427.722, 'src': 'embed', 'start': 1349.766, 'weight': 1, 'content': [{'end': 1355.247, 'text': 'so just write mysql, for example, query.', 'start': 1349.766, 'duration': 5.481}, {'end': 1363.689, 'text': 'ok, query for qry, and in here we want to check if the username and password is correct.', 'start': 1355.247, 'duration': 8.442}, {'end': 1371.45, 'text': 'so we can just write select some element, or you can just write select asterisk,', 'start': 1363.689, 'duration': 7.761}, {'end': 1377.073, 'text': 'which is a wild card for selecting everything from your database name.', 'start': 1371.45, 'duration': 5.623}, {'end': 1381.815, 'text': 'so our database table name is employee data.', 'start': 1377.073, 'duration': 4.742}, {'end': 1386.138, 'text': 'if you remember, this one is our database table name.', 'start': 1381.815, 'duration': 4.323}, {'end': 1400.651, 'text': 'so just copy the same name and paste it here and then just write where clause and in here we are going to check username and password right.', 'start': 1386.138, 'duration': 14.513}, {'end': 1407.078, 'text': 'so we want to check the column name, username and password right.', 'start': 1400.651, 'duration': 6.427}, {'end': 1414.69, 'text': 'so where username, like your username variable.', 'start': 1407.078, 'duration': 7.612}, {'end': 1427.722, 'text': 'so in the single quotes you just need to copy this variable and paste it here and then just give a space here and in here.', 'start': 1414.69, 'duration': 13.032}], 'summary': "Writing a mysql query to check username and password in the 'employee data' table.", 'duration': 77.956, 'max_score': 1349.766, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w1349766.jpg'}, {'end': 1580.201, 'src': 'embed', 'start': 1526.632, 'weight': 2, 'content': [{'end': 1540.862, 'text': 'so just write mysqli and then, inside these bracket, just pass this result variable.', 'start': 1526.632, 'duration': 14.23}, {'end': 1551.352, 'text': "so just pass result and we will evaluate if it's greater than zero.", 'start': 1540.862, 'duration': 10.49}, {'end': 1558.416, 'text': 'then we will say that our username and password is correct, right.', 'start': 1551.352, 'duration': 7.064}, {'end': 1566.301, 'text': 'so in the echo we can just echo login success right.', 'start': 1558.416, 'duration': 7.885}, {'end': 1571.264, 'text': 'so just write login success.', 'start': 1566.301, 'duration': 4.963}, {'end': 1580.201, 'text': 'Otherwise, if there is no result, we are going to echo that login is not successful.', 'start': 1573.034, 'duration': 7.167}], 'summary': 'Using mysqli to evaluate if result > 0 for successful login, otherwise echo login failure.', 'duration': 53.569, 'max_score': 1526.632, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w1526632.jpg'}, {'end': 1725.369, 'src': 'heatmap', 'start': 1656.325, 'weight': 0, 'content': [{'end': 1670.072, 'text': 'so when we write here 123, 123 and password is also 123, and save it and in here i think this should be mysqli query.', 'start': 1656.325, 'duration': 13.747}, {'end': 1679.856, 'text': 'so instead of mysqli query you need to write mysqli underscore query right and save your php file,', 'start': 1670.072, 'duration': 9.784}, {'end': 1694.101, 'text': "go to your web browser and just write localhost and then this time you just need to login.php and now it's going to give you connection success and login success.", 'start': 1679.856, 'duration': 14.245}, {'end': 1701.204, 'text': 'that means your login is success using the php script.', 'start': 1694.101, 'duration': 7.103}, {'end': 1708.466, 'text': 'so right now we are done installing our web server and we are done writing our php scripts.', 'start': 1701.204, 'duration': 7.262}, {'end': 1710.188, 'text': 'so, in the next video,', 'start': 1708.926, 'duration': 1.262}, {'end': 1722.104, 'text': 'what we are going to do is we are going to create our android app and we are going to connect it to our mysql database using this php script.', 'start': 1710.188, 'duration': 11.916}, {'end': 1725.369, 'text': 'so stay tuned and please rate comment, subscribe and bye for now.', 'start': 1722.104, 'duration': 3.265}], 'summary': 'Successfully connected to mysql database using php script.', 'duration': 69.044, 'max_score': 1656.325, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w1656325.jpg'}], 'start': 1315.313, 'title': 'Mysql database query and php login', 'summary': 'Covers preparing a mysql query for user authentication and creating a php script to connect to a mysql database, insert data, and perform a login process, resulting in a successful login with provided credentials.', 'chapters': [{'end': 1456.425, 'start': 1315.313, 'title': 'Mysql database query for user authentication', 'summary': "Focuses on preparing a mysql query to check the correctness of a username and password against the 'employee data' table in the database, using a 'select' statement and 'where' clause.", 'duration': 141.112, 'highlights': ["The chapter emphasizes the importance of preparing a MySQL query to check the correctness of a username and password against the 'employee data' table in the database.", "It instructs to use a 'select' statement with a wild card to select everything from the 'employee data' table.", "The chapter explains the use of a 'where' clause to check the username and password columns for correctness."]}, {'end': 1725.369, 'start': 1456.425, 'title': 'Php mysql login and data insertion', 'summary': 'Explains the process of creating a php script to connect to a mysql database, insert data, and perform a login process, resulting in a successful login with the provided credentials.', 'duration': 268.944, 'highlights': ['The php script is used to connect to a MySQL database, insert data, and perform a login process, which resulted in a successful login using the provided credentials.', "The process involves creating a variable 'result' and using the 'mysqli_query' method to execute the MySQL query, evaluating the result to determine the correctness of the username and password.", "The tutorial also demonstrates the insertion of data into the database using the 'mysqli_query' method and verifies the successful addition of data.", 'The next steps involve creating an Android app and connecting it to the MySQL database using the PHP script.']}], 'duration': 410.056, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/HK515-8-Q_w/pics/HK515-8-Q_w1315313.jpg', 'highlights': ['The php script connects to a MySQL database, inserts data, and performs a login process resulting in a successful login.', "The chapter emphasizes preparing a MySQL query to check the correctness of a username and password against the 'employee data' table.", "The process involves creating a variable 'result' and using the 'mysqli_query' method to execute the MySQL query.", "The tutorial demonstrates the insertion of data into the database using the 'mysqli_query' method and verifies the successful addition of data.", "The chapter explains the use of a 'where' clause to check the username and password columns for correctness."]}], 'highlights': ['The chapter covers the requirements for creating an Android app using MySQL database, including the need for a web server, PHP for server-side scripting, and Android Studio for development.', 'The chapter illustrates the process of creating an online MySQL database using the WAMP web server, which consists of MySQL, Apache, and PHP MyAdmin.', 'The process involves creating a PHP script for database connection and defining parameters.', "The chapter demonstrates using phpMyAdmin to create a database for employees named 'employee 101', and a table with six columns for employee data.", 'The php script connects to a MySQL database, inserts data, and performs a login process resulting in a successful login.', 'The web server executable is a 41.5 mb file, which will download in a few seconds.']}