title
Android MySQL Database Tutorial 4 - Insert Data in Mysql Database using Registration Form

description
How to Create MYSQL Database Using cPanel https://youtu.be/0tdFBqDsOqQ 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 Insert Data in Mysql Database using Registration Form. this will be the first step in order to perform CRUD (create, read, update and delete) operations with MySQL database using Android app. 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, How to create Simple Login form using php in android, android studio mysql connection, android php mysql json tutorial, Android Login and Registration with PHP, MySQL. how to connect android app to mysql database. ★★★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 4 - Insert Data in Mysql Database using Registration Form', 'heatmap': [{'end': 521.179, 'start': 473.487, 'weight': 0.865}, {'end': 615.354, 'start': 581.477, 'weight': 1}, {'end': 690.072, 'start': 666.639, 'weight': 0.831}, {'end': 1078.653, 'start': 1037.631, 'weight': 0.745}, {'end': 1210.811, 'start': 1191.858, 'weight': 0.764}, {'end': 1409.415, 'start': 1390.942, 'weight': 0.766}], 'summary': 'This tutorial series on android mysql database covers connecting to a mysql database, creating a login page, inserting data into mysql through registration activity, creating registration.php, developing android app for registration, defining register url for background worker, and parsing type conditions for android app registration.', 'chapters': [{'end': 51.222, 'segs': [{'end': 51.222, 'src': 'embed', 'start': 0.743, 'weight': 0, 'content': [{'end': 4.965, 'text': 'Hello guys welcome to the next video on android mysql database tutorial for beginners.', 'start': 0.743, 'duration': 4.222}, {'end': 6.926, 'text': 'Till now in this series,', 'start': 5.565, 'duration': 1.361}, {'end': 21.432, 'text': 'we have seen how we can connect to our mysql database and how we can create a simple login page and query our mysql database using our android app and php script.', 'start': 6.926, 'duration': 14.506}, {'end': 32.804, 'text': 'Now in this video I am going to show you how you can insert data into mysql database using a registration activity on your android app.', 'start': 22.072, 'duration': 10.732}, {'end': 34.755, 'text': "so let's get started.", 'start': 33.735, 'duration': 1.02}, {'end': 40.298, 'text': 'we are going to create a registration activity in a while, but first of all,', 'start': 34.755, 'duration': 5.543}, {'end': 45.78, 'text': 'what we are going to do is we are going to create a php script for registration.', 'start': 40.298, 'duration': 5.482}, {'end': 51.222, 'text': 'okay, so we are going to create a new php file.', 'start': 45.78, 'duration': 5.442}], 'summary': 'Android mysql tutorial covers connecting, creating login, querying database, and inserting data using registration activity.', 'duration': 50.479, 'max_score': 0.743, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc743.jpg'}], 'start': 0.743, 'title': 'Android mysql database tutorial', 'summary': 'Introduces a tutorial on connecting to a mysql database, creating a login page, and querying the database via an android app and php script. it also demonstrates how to insert data into the mysql database through a registration activity on the android app.', 'chapters': [{'end': 51.222, 'start': 0.743, 'title': 'Android mysql database tutorial', 'summary': 'Introduces a tutorial on connecting to a mysql database, creating a login page, and querying the database via an android app and php script. it then focuses on demonstrating how to insert data into the mysql database through a registration activity on the android app.', 'duration': 50.479, 'highlights': ['The tutorial covers connecting to a MySQL database, creating a login page, and querying the database using an Android app and PHP script.', 'The video focuses on demonstrating how to insert data into the MySQL database through a registration activity on the Android app.', 'The presenter plans to create a registration activity and a new PHP file to facilitate the data insertion process.']}], 'duration': 50.479, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc743.jpg', 'highlights': ['The tutorial covers connecting to a MySQL database, creating a login page, and querying the database using an Android app and PHP script.', 'The video focuses on demonstrating how to insert data into the MySQL database through a registration activity on the Android app.', 'The presenter plans to create a registration activity and a new PHP file to facilitate the data insertion process.']}, {'end': 638.486, 'segs': [{'end': 119.115, 'src': 'embed', 'start': 51.222, 'weight': 2, 'content': [{'end': 53.483, 'text': 'so, first of all, what we are going to do?', 'start': 51.222, 'duration': 2.261}, {'end': 59.345, 'text': 'we are going to, first of all, if your vamp server is not started, just start your vamp server,', 'start': 53.483, 'duration': 5.862}, {'end': 64.793, 'text': 'because I will be using this localhost web server for this demonstration.', 'start': 59.83, 'duration': 4.963}, {'end': 68.716, 'text': "if you want to use online database, it's perfectly fine,", 'start': 64.793, 'duration': 3.923}, {'end': 80.623, 'text': 'and then go to www directory here in web server and in here our con.php and our login.php is already there.', 'start': 68.716, 'duration': 11.907}, {'end': 85.527, 'text': 'ok, so we are going to create a registration.php also.', 'start': 80.623, 'duration': 4.904}, {'end': 102.72, 'text': 'so new file and we are going to save it as register.php and just save it and then you can see in the folder this registration.php is created.', 'start': 85.527, 'duration': 17.193}, {'end': 107.947, 'text': 'now in here, as we have done in login.php.', 'start': 103.464, 'duration': 4.483}, {'end': 119.115, 'text': 'we need to add this connection file first of all and then we need to write a query to insert the data and then run the query using php script.', 'start': 107.947, 'duration': 11.168}], 'summary': 'Setting up localhost web server for demonstration and creating registration.php file.', 'duration': 67.893, 'max_score': 51.222, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc51222.jpg'}, {'end': 181.247, 'src': 'embed', 'start': 149.939, 'weight': 3, 'content': [{'end': 152.862, 'text': "id is auto incremented, so we don't need it right.", 'start': 149.939, 'duration': 2.923}, {'end': 157.163, 'text': 'so right now we have two variables.', 'start': 153.702, 'duration': 3.461}, {'end': 171.065, 'text': "we are going to create two more or three more, rather, and the first is the name variable, second variable i'm going to name it as surname.", 'start': 157.163, 'duration': 13.902}, {'end': 173.565, 'text': 'third variable is the age.', 'start': 171.065, 'duration': 2.5}, {'end': 181.247, 'text': 'fourth variable is the password and the fifth variable is the username.', 'start': 173.565, 'duration': 7.682}], 'summary': 'Adding 3 new variables to the existing 2, including name, surname, age, password, and username.', 'duration': 31.308, 'max_score': 149.939, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc149939.jpg'}, {'end': 250.089, 'src': 'embed', 'start': 211.408, 'weight': 0, 'content': [{'end': 218.514, 'text': 'Now, to insert data into the MySQL database, we need insert keyword.', 'start': 211.408, 'duration': 7.106}, {'end': 222.818, 'text': 'So just write insert into your table name.', 'start': 218.694, 'duration': 4.124}, {'end': 225.48, 'text': 'Your table name is employee data.', 'start': 222.898, 'duration': 2.582}, {'end': 237.285, 'text': 'okay, so just give the table name and then give the column names in which you want to insert the data.', 'start': 228.923, 'duration': 8.362}, {'end': 241.927, 'text': 'so we have column name, name and surname.', 'start': 237.285, 'duration': 4.642}, {'end': 244.408, 'text': 'third is age.', 'start': 241.927, 'duration': 2.481}, {'end': 250.089, 'text': "so just write age and let's see fourth and fifth column username and password.", 'start': 244.408, 'duration': 5.681}], 'summary': "Insert data into mysql database table 'employee data' with columns: name, surname, age, username, and password.", 'duration': 38.681, 'max_score': 211.408, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc211408.jpg'}, {'end': 521.179, 'src': 'heatmap', 'start': 415.61, 'weight': 1, 'content': [{'end': 420.511, 'text': 'break, this will break the line and then just write con error.', 'start': 415.61, 'duration': 4.901}, {'end': 423.537, 'text': 'so this is going to show you the error.', 'start': 421.095, 'duration': 2.442}, {'end': 434.984, 'text': 'if any error exists, okay, and I forgot to tell you in the last videos, if you are opening the connection from MySQL database,', 'start': 423.537, 'duration': 11.447}, {'end': 438.206, 'text': 'then you need to close it at the end of your PHP file.', 'start': 434.984, 'duration': 3.222}, {'end': 443.129, 'text': 'so just at the last, you just need to write close.', 'start': 438.206, 'duration': 4.923}, {'end': 448.393, 'text': 'okay, just call close here and just give these brackets here.', 'start': 443.129, 'duration': 5.264}, {'end': 453.773, 'text': "ok, now let's try to check if this PHP code works or not.", 'start': 448.769, 'duration': 5.004}, {'end': 467.583, 'text': "so I'm going to just give some static values here, some random name and the surname instead of this post and the age, for example, 22 username.", 'start': 453.773, 'duration': 13.81}, {'end': 473.107, 'text': 'for example, what can be the username ABC and the password?', 'start': 467.583, 'duration': 5.524}, {'end': 475.789, 'text': 'this is just for checking.', 'start': 473.487, 'duration': 2.302}, {'end': 478.19, 'text': 'we are passing these static values.', 'start': 475.789, 'duration': 2.401}, {'end': 490.719, 'text': 'okay, now, if you remember how we can open our registration.php file, you just need to call localhost and then the file name.', 'start': 478.19, 'duration': 12.529}, {'end': 502.007, 'text': 'so just write localhost and then instead of this login.php, we will just write register.php.', 'start': 490.719, 'duration': 11.288}, {'end': 509.915, 'text': 'ok, and then just run this and it says insert successful.', 'start': 503.973, 'duration': 5.942}, {'end': 521.179, 'text': 'so right now you can see our MySQL database table has two columns or two rows rather and when we refresh our table.', 'start': 509.915, 'duration': 11.264}], 'summary': 'Demonstration of opening and closing mysql connection and inserting data successfully.', 'duration': 62.58, 'max_score': 415.61, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc415610.jpg'}, {'end': 615.354, 'src': 'heatmap', 'start': 581.477, 'weight': 1, 'content': [{'end': 588.42, 'text': "so go to your Android studio and in here go to layout and let's create a new activity.", 'start': 581.477, 'duration': 6.943}, {'end': 591.822, 'text': 'so new and just search for activity.', 'start': 588.42, 'duration': 3.402}, {'end': 601.63, 'text': "we are going to create a blank activity here and let's name it as register and then click finish.", 'start': 591.822, 'duration': 9.808}, {'end': 604.09, 'text': 'And our register activity is created.', 'start': 602.03, 'duration': 2.06}, {'end': 608.152, 'text': 'I am going to just delete this component from here.', 'start': 604.11, 'duration': 4.042}, {'end': 615.354, 'text': 'And now what we need to do here is we need to place some added text and a button.', 'start': 608.172, 'duration': 7.182}], 'summary': "In android studio, create a new 'register' activity with added text and a button.", 'duration': 33.877, 'max_score': 581.477, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc581477.jpg'}], 'start': 51.222, 'title': 'Creating registration and mysql data insertion using php', 'summary': 'Demonstrates creating a registration.php file, connecting to a database, and inserting data into a table in a localhost web server, emphasizing the need for connection files, insert query, and new variables. it also covers inserting data into a mysql database using php, including writing the insert query, executing the query, and testing the php code with static values, ultimately validating the insertion process.', 'chapters': [{'end': 210.908, 'start': 51.222, 'title': 'Creating registration and inserting data using php', 'summary': 'Demonstrates the process of creating a registration.php file, connecting it to a database, and writing a query to insert data into a table in a localhost web server environment, emphasizing the need to add connection files, write the insert query, and create new variables for name, surname, age, username, and password.', 'duration': 159.686, 'highlights': ['The demonstration emphasizes the need to start the VAMP server and access the localhost web server for the demonstration.', 'The chapter highlights the process of creating a registration.php file and saving it in the web server directory, and opening a database to view column names and table structure.', 'The speaker emphasizes the creation of new variables for name, surname, age, username, and password, and the need to adjust the sequence of username and password for creating the query.', 'The chapter emphasizes the process of writing a query to insert data into the database using PHP and the need to add connection files and run the query.']}, {'end': 638.486, 'start': 211.408, 'title': 'Mysql database data insertion', 'summary': 'Covers the process of inserting data into a mysql database using php, including writing the insert query, executing the query, and testing the php code with static values, ultimately validating the insertion process.', 'duration': 427.078, 'highlights': ['The process of inserting data into a MySQL database involves writing an insert query with the table name and column names, passing the values in single quotes, and executing the query using PHP.', 'Demonstration of testing the PHP code with static values to validate the insertion process, resulting in a successful insert message.', 'Guidance on the necessity of closing the connection to the MySQL database at the end of the PHP file for proper execution.']}], 'duration': 587.264, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc51222.jpg', 'highlights': ['The process of inserting data into a MySQL database involves writing an insert query with the table name and column names, passing the values in single quotes, and executing the query using PHP.', 'Demonstration of testing the PHP code with static values to validate the insertion process, resulting in a successful insert message.', 'The chapter emphasizes the process of writing a query to insert data into the database using PHP and the need to add connection files and run the query.', 'The speaker emphasizes the creation of new variables for name, surname, age, username, and password, and the need to adjust the sequence of username and password for creating the query.', 'The chapter highlights the process of creating a registration.php file and saving it in the web server directory, and opening a database to view column names and table structure.', 'The demonstration emphasizes the need to start the VAMP server and access the localhost web server for the demonstration.', 'Guidance on the necessity of closing the connection to the MySQL database at the end of the PHP file for proper execution.']}, {'end': 928.739, 'segs': [{'end': 699.259, 'src': 'heatmap', 'start': 666.639, 'weight': 0, 'content': [{'end': 678.603, 'text': 'So just write android colon onclick and in here you can just write onreg for onregister and just copy this method from here.', 'start': 666.639, 'duration': 11.964}, {'end': 684.307, 'text': 'and go to your register.java class which you have created.', 'start': 679.483, 'duration': 4.824}, {'end': 687.33, 'text': "and in here we don't need these method.", 'start': 684.307, 'duration': 3.023}, {'end': 690.072, 'text': 'we just need onCreate method.', 'start': 687.33, 'duration': 2.742}, {'end': 699.259, 'text': 'and in here we are going to create a method for onRegister right, so public, and this will be a void method.', 'start': 690.072, 'duration': 9.187}], 'summary': 'Creating an onclick method for onregister in android using onregister method in register.java class.', 'duration': 60.773, 'max_score': 666.639, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc666639.jpg'}, {'end': 799.91, 'src': 'embed', 'start': 736.491, 'weight': 2, 'content': [{'end': 741.534, 'text': 'and i have defined these five string variables for the five columns.', 'start': 736.491, 'duration': 5.043}, {'end': 748.177, 'text': "right now i'm going to go inside my onCreate method and i'm going to cast these edit text one by one.", 'start': 741.534, 'duration': 6.643}, {'end': 753.04, 'text': 'so name is equal to bracket edit text.', 'start': 748.177, 'duration': 4.863}, {'end': 766.636, 'text': 'and then you just need to write find view by id and then r, dot, id, dot the et name right, so et and then the name.', 'start': 753.04, 'duration': 13.596}, {'end': 769.099, 'text': 'okay. so do the same for the rest of the five.', 'start': 766.636, 'duration': 2.463}, {'end': 784.48, 'text': 'Once your type casting of your edit text variables are done.', 'start': 780.097, 'duration': 4.383}, {'end': 791.644, 'text': 'what we are going to do is we are going to go to our main activity.java file and in here, if you remember,', 'start': 784.48, 'duration': 7.164}, {'end': 794.746, 'text': 'in the last videos we have created onLogin method.', 'start': 791.644, 'duration': 3.102}, {'end': 799.91, 'text': 'So just copy the code from onLogin method and this method.', 'start': 795.246, 'duration': 4.664}], 'summary': 'Defining and casting five string variables, then copying code into main activity.java.', 'duration': 63.419, 'max_score': 736.491, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc736491.jpg'}, {'end': 861.685, 'src': 'embed', 'start': 828.638, 'weight': 1, 'content': [{'end': 844.629, 'text': "so I'm just going to copy these few times five times to be precise and then just change these values name, surname, age,", 'start': 828.638, 'duration': 15.991}, {'end': 850.312, 'text': 'username and password and also change these variable names.', 'start': 844.629, 'duration': 5.683}, {'end': 861.685, 'text': 'so we have defined these variable names here string name, string surname, string age, string username and string password.', 'start': 850.312, 'duration': 11.373}], 'summary': 'Copying and updating variables 5 times, including name, surname, age, username, and password.', 'duration': 33.047, 'max_score': 828.638, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc828638.jpg'}], 'start': 638.486, 'title': 'Android app development', 'summary': 'Covers creating an android app for registration, including changing user details, creating a register button, and implementing an onclick method, with a focus on the oncreate method and the onregister method. it also covers defining and casting edittext and string variables, using them to pass values to the background worker object, and adjusting the code from onlogin method to onregister method in main activity.java file.', 'chapters': [{'end': 699.259, 'start': 638.486, 'title': 'Android app registration', 'summary': 'Covers the process of creating an android app for registration, including changing user details, creating a register button, and implementing an onclick method, with a focus on the oncreate method and the onregister method.', 'duration': 60.773, 'highlights': ['The chapter covers the process of creating an Android app for registration.', 'The speaker changes user details such as name, surname, age, username, and password.', "The speaker creates a register button with the ID 'btnreg'.", 'The speaker explains the process of adding an onclick method to the button element.', 'The chapter emphasizes the onCreate method in the register.java class and the need to create an onRegister method.']}, {'end': 928.739, 'start': 699.259, 'title': 'Android edittext and string variable tutorial', 'summary': 'Covers the process of defining and casting edittext and string variables, using them to pass values to the background worker object, and adjusting the code from onlogin method to onregister method in main activity.java file.', 'duration': 229.48, 'highlights': ['The chapter covers the process of defining and casting EditText and String variables, using them to pass values to the background worker object, and adjusting the code from onLogin method to onRegister method in main activity.java file.', 'The tutorial emphasizes defining and casting five EditText and String variables each, and passing these values as arguments to the background worker execute method.', 'The process involves adjusting the code from onLogin method to onRegister method in main activity.java file, including changing variable names and deleting global variables declared in the main activity.java file.']}], 'duration': 290.253, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc638486.jpg', 'highlights': ['The chapter covers the process of creating an Android app for registration.', 'The speaker changes user details such as name, surname, age, username, and password.', 'The tutorial emphasizes defining and casting five EditText and String variables each, and passing these values as arguments to the background worker execute method.', "The speaker creates a register button with the ID 'btnreg'.", 'The chapter emphasizes the onCreate method in the register.java class and the need to create an onRegister method.', 'The speaker explains the process of adding an onclick method to the button element.', 'The process involves adjusting the code from onLogin method to onRegister method in main activity.java file, including changing variable names and deleting global variables declared in the main activity.java file.']}, {'end': 1125.617, 'segs': [{'end': 987.089, 'src': 'embed', 'start': 928.739, 'weight': 0, 'content': [{'end': 934.104, 'text': 'it was login, but for the register we will define here register here.', 'start': 928.739, 'duration': 5.365}, {'end': 937.005, 'text': 'So this onRegister method is done.', 'start': 934.355, 'duration': 2.65}, {'end': 944.271, 'text': 'now how we are going to open this register activity from our main activity.', 'start': 937.489, 'duration': 6.782}, {'end': 953.153, 'text': 'so what we are going to do next is we are going to go to our activity underscore, main dot XML file here and we are going to take one more button.', 'start': 944.271, 'duration': 8.882}, {'end': 963.536, 'text': 'so just search for one more button and in here we are going to change the text here register and the ID here, for example BTNREG.', 'start': 953.153, 'duration': 10.383}, {'end': 971.059, 'text': 'And when we click this register button we want to open our register activity.', 'start': 965.396, 'duration': 5.663}, {'end': 984.487, 'text': 'So, go to the text and in the button of this register button, we are going to create a onClick method and we will say openRegister.', 'start': 971.099, 'duration': 13.388}, {'end': 987.089, 'text': 'So, just write openReg.', 'start': 984.567, 'duration': 2.522}], 'summary': 'Developed login and register functionality, integrated button to launch register activity.', 'duration': 58.35, 'max_score': 928.739, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc928739.jpg'}, {'end': 1088.38, 'src': 'heatmap', 'start': 1037.631, 'weight': 1, 'content': [{'end': 1044.675, 'text': "ok. so what this basically going to do is it's going to start the activity register.", 'start': 1037.631, 'duration': 7.044}, {'end': 1053.342, 'text': "so what this start activity is going to do is it's going to start the register activity now, once we are done with all this code.", 'start': 1044.675, 'duration': 8.667}, {'end': 1063.406, 'text': 'now we want to go to our background worker to identify if this request is login or register request right.', 'start': 1053.342, 'duration': 10.064}, {'end': 1066.387, 'text': 'so first of all we will create a url.', 'start': 1063.406, 'duration': 2.981}, {'end': 1078.653, 'text': "so let's copy this variable login url and we will name this variable as register url, Register URL and the last video.", 'start': 1066.387, 'duration': 12.266}, {'end': 1085.998, 'text': 'I have changed this IP address to my website name, But you can you know for the localhost?', 'start': 1078.653, 'duration': 7.345}, {'end': 1088.38, 'text': 'you can change it to your localhost.', 'start': 1085.998, 'duration': 2.382}], 'summary': 'Initiates activity register, creates register url for login or register request.', 'duration': 35.038, 'max_score': 1037.631, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc1037631.jpg'}], 'start': 928.739, 'title': 'Android register activity and creating register url for background worker', 'summary': 'Discusses creating a register activity in android, defining the onregister method, adding a button to the main activity xml file, and implementing the openregister method. it also covers creating a register url for a background worker by updating the url variable and ip address, resulting in the creation of the register.php file.', 'chapters': [{'end': 1053.342, 'start': 928.739, 'title': 'Android register activity', 'summary': 'Discusses the process of creating a register activity in android, including defining the onregister method, adding a button to the main activity xml file, and implementing the openregister method to start the register activity.', 'duration': 124.603, 'highlights': ['The onRegister method is defined to handle the register functionality in the Android app.', "The process of adding a button with the text 'register' and ID 'BTNREG' to the main activity XML file is explained.", "The openRegister method is created in the main activity.java file to handle the opening of the register activity when the 'register' button is clicked.", "The start activity method is used with a new intent to start the register activity, utilizing the class name 'register dot class'."]}, {'end': 1125.617, 'start': 1053.342, 'title': 'Creating register url for background worker', 'summary': 'Covers the process of creating a register url for a background worker by updating the url variable and ip address to facilitate the identification of login or register requests, resulting in the creation of the register.php file.', 'duration': 72.275, 'highlights': ['Updating the URL variable and IP address to establish a register URL for background worker.', 'Identifying login or register requests through the background worker.', 'Creation of register.php file for handling register requests.']}], 'duration': 196.878, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc928739.jpg', 'highlights': ["The process of adding a button with the text 'register' and ID 'BTNREG' to the main activity XML file is explained.", 'Updating the URL variable and IP address to establish a register URL for background worker.', 'The onRegister method is defined to handle the register functionality in the Android app.', "The openRegister method is created in the main activity.java file to handle the opening of the register activity when the 'register' button is clicked."]}, {'end': 1529.837, 'segs': [{'end': 1252.064, 'src': 'heatmap', 'start': 1191.858, 'weight': 0, 'content': [{'end': 1200.304, 'text': 'so we will just copy the same code as we have in our if condition for login to the end.', 'start': 1191.858, 'duration': 8.446}, {'end': 1203.326, 'text': 'and this is the end, I think, for the if condition.', 'start': 1200.304, 'duration': 3.022}, {'end': 1210.811, 'text': 'so just copy the whole code from here and paste it in your if condition for register.', 'start': 1203.326, 'duration': 7.485}, {'end': 1215.374, 'text': 'ok, so paste the same code now at the top.', 'start': 1210.811, 'duration': 4.563}, {'end': 1221.818, 'text': 'here we need to define five variable instead of two variables for registration.', 'start': 1215.374, 'duration': 6.444}, {'end': 1224.96, 'text': 'one is name, surname, age, username and password.', 'start': 1221.818, 'duration': 3.142}, {'end': 1229.203, 'text': "right. so i'm going to define these variable names.", 'start': 1224.96, 'duration': 4.243}, {'end': 1241.996, 'text': 'so just copy them five times, and first is the name, second is the surname, third is the age,', 'start': 1229.203, 'duration': 12.793}, {'end': 1250.502, 'text': 'fourth is the username and fifth is the password and the index.', 'start': 1241.996, 'duration': 8.506}, {'end': 1252.064, 'text': 'you need to change one, two.', 'start': 1250.502, 'duration': 1.562}], 'summary': 'Updating code to include five variables for registration instead of two.', 'duration': 126.447, 'max_score': 1191.858, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc1191858.jpg'}, {'end': 1305.868, 'src': 'embed', 'start': 1276.895, 'weight': 2, 'content': [{'end': 1285.819, 'text': 'ok, and the next line will be the same and we need to go to our post data variable here and in.', 'start': 1276.895, 'duration': 8.924}, {'end': 1290.481, 'text': 'here we were creating our post request right.', 'start': 1285.819, 'duration': 4.662}, {'end': 1294.763, 'text': 'so we need to modify our post request a little.', 'start': 1290.481, 'duration': 4.282}, {'end': 1302.086, 'text': 'so what we need to do is i will just copy this one line three more times right.', 'start': 1294.763, 'duration': 7.323}, {'end': 1305.868, 'text': 'so just go down one, two and three.', 'start': 1302.086, 'duration': 3.782}], 'summary': 'Modifying post request by replicating line three more times.', 'duration': 28.973, 'max_score': 1276.895, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc1276895.jpg'}, {'end': 1418.321, 'src': 'heatmap', 'start': 1390.942, 'weight': 0.766, 'content': [{'end': 1393.784, 'text': 'right and basically everything will be the same.', 'start': 1390.942, 'duration': 2.842}, {'end': 1401.01, 'text': 'so its going to return the response and its going to show this response in the alert box.', 'start': 1393.784, 'duration': 7.226}, {'end': 1403.692, 'text': 'so this is our code for the registration.', 'start': 1401.01, 'duration': 2.682}, {'end': 1409.415, 'text': "now let's run our code and let's see if it works or not.", 'start': 1404.292, 'duration': 5.123}, {'end': 1412.057, 'text': 'so our app is running now.', 'start': 1409.415, 'duration': 2.642}, {'end': 1418.321, 'text': 'so this is for the login and we need to click registration to go to the next activity.', 'start': 1412.057, 'duration': 6.264}], 'summary': 'Code returns response in alert box for registration, app is running.', 'duration': 27.379, 'max_score': 1390.942, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc1390942.jpg'}, {'end': 1529.837, 'src': 'embed', 'start': 1506.519, 'weight': 1, 'content': [{'end': 1508.561, 'text': "And let's click the register button once again.", 'start': 1506.519, 'duration': 2.042}, {'end': 1511.303, 'text': 'And insert is successful.', 'start': 1509.621, 'duration': 1.682}, {'end': 1513.284, 'text': 'Go to the phpMyAdmin.', 'start': 1511.423, 'duration': 1.861}, {'end': 1513.985, 'text': 'Refresh it.', 'start': 1513.404, 'duration': 0.581}, {'end': 1516.967, 'text': 'And now everything is fine.', 'start': 1514.005, 'duration': 2.962}, {'end': 1526.134, 'text': 'Okay So in this way you can create a register activity in your Android app to insert the data into the MySQL database.', 'start': 1517.407, 'duration': 8.727}, {'end': 1527.415, 'text': 'I hope you enjoyed this video.', 'start': 1526.194, 'duration': 1.221}, {'end': 1528.836, 'text': 'Please rate, comment and subscribe.', 'start': 1527.435, 'duration': 1.401}, {'end': 1529.837, 'text': 'And bye for now.', 'start': 1528.996, 'duration': 0.841}], 'summary': 'Demonstrated registering activity for android app with mysql database.', 'duration': 23.318, 'max_score': 1506.519, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc1506519.jpg'}], 'start': 1125.617, 'title': 'Parsing type conditions and android app registration', 'summary': 'Covers parsing different types in java, with a focus on reusing code, and explains modifying an android app to include a registration feature, involving defining new variables, modifying the post request, running the code, and refreshing the mysql database.', 'chapters': [{'end': 1215.374, 'start': 1125.617, 'title': 'Parsing type conditions in java', 'summary': 'Covers the process of parsing different types (log in and register) in java, involving conditional statements based on the type and the action to be executed, with a focus on reusing code for similar functionalities.', 'duration': 89.757, 'highlights': ['The process involves distinguishing between different types (log in and register) and executing specific methods based on the type, emphasizing the reuse of code for similar functionalities.', "The code involves conditional statements checking for the type 'log in' and executing a particular method, with a further condition for the type 'register' and its corresponding action.", "Copying and pasting the code for 'register' from the 'register.java' file to the 'background worker.java' file is part of the process, ensuring consistency in functionality implementation."]}, {'end': 1529.837, 'start': 1215.374, 'title': 'Android app registration process', 'summary': 'Explains the process of modifying an android app to include a registration feature, including defining new variables for registration, modifying the post request, running the code, and refreshing the mysql database to confirm successful data insertion.', 'duration': 314.463, 'highlights': ['The chapter explains the process of modifying an Android app to include a registration feature.', 'It includes defining new variables for registration, such as name, surname, age, username, and password.', 'Modifying the post request in the app is a crucial step in the registration process.', 'Running the modified code and refreshing the MySQL database to confirm successful data insertion is essential.']}], 'duration': 404.22, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/age2l7Rrwtc/pics/age2l7Rrwtc1125617.jpg', 'highlights': ['The process involves distinguishing between different types (log in and register) and executing specific methods based on the type, emphasizing the reuse of code for similar functionalities.', 'The chapter explains the process of modifying an Android app to include a registration feature.', 'Modifying the post request in the app is a crucial step in the registration process.', 'It includes defining new variables for registration, such as name, surname, age, username, and password.', "The code involves conditional statements checking for the type 'log in' and executing a particular method, with a further condition for the type 'register' and its corresponding action.", "Copying and pasting the code for 'register' from the 'register.java' file to the 'background worker.java' file is part of the process, ensuring consistency in functionality implementation.", 'Running the modified code and refreshing the MySQL database to confirm successful data insertion is essential.']}], 'highlights': ['The tutorial covers connecting to a MySQL database, creating a login page, and querying the database using an Android app and PHP script.', 'The process involves distinguishing between different types (log in and register) and executing specific methods based on the type, emphasizing the reuse of code for similar functionalities.', 'The process of inserting data into a MySQL database involves writing an insert query with the table name and column names, passing the values in single quotes, and executing the query using PHP.', 'The video focuses on demonstrating how to insert data into the MySQL database through a registration activity on the Android app.', 'The chapter covers the process of creating an Android app for registration.']}