Create Registration and Login Form in Android Studio using SQLite Database[With Source Code][Part-3]

Support us on Patreon: / runcodes
This Video will show you how to create a Registration and login form or apps in android using SQLite Database.
Download DB Browser for SQLite: sqlitebrowser.org/
Source Code: runcodes.tech/...
First Part: • Create Registration an...
Second Part: • Create Registration an...
Login form in android using Shared Preference: • How to Create Login fo...
Simple Login form in android: • How to Create Simple L...
send sms using android programming: • How to Send SMS using ...
login form in java using SQL Server and NetBeans IDE: • How to Create Login Fo...
Simple Login form in java using NetBeans IDE: • Create Simple Login Fo...
Send Free SMS using Java part-1: • How to Send Free SMS u...
Send Free SMS using Java part-2: • How to Send Free SMS u...
Follow us on Social Media:
Facebook: RunCodesPage
Instagram: runcodes
Twitter: RunCodesTwit
This video is created by Ran and RunCodes own this video. Using of this video on other channels without prior permission will be strictly prohibited. (Embedding to the websites is allowed).. So stop copying and be a responsible people.

[@RunCodes]

do you like our work? does this tutorial help you? if so, you can support us at www.patreon.com/RunCodes

[@arvvv340]

I've encounter your youtube tutorial about making a registration form in android studio. Same on the second part of your video where in you run the app and suddenly it stopped I also experience that kind of error right now. I just want to know how to fix that kind of error. Your video tutorials are life saving for a beginner like me, I really hope I can fix this error with your help ma'am/sir. Thank you so much!

[@RunCodes]

just see the first part comment we told you how you can solve your problem by yourself! and the video goes here: kzbin.info/www/bejne/eGPEp3VrqdKHg68

[@rushalnaidu3449]

I m getting error.... Registration is working properly ,but if I enter login button it says "unfortunately device stopped working"

[@RunCodes]

check your query or if you have android studio of version 3.0.1 use other version than this one

[@pogikrist123]

the last video tutorial you made... your app doesnt work and did not show us how did you fix the error... i followed everything in your tutorial but my app stopped.. and says that there is an error on my "db = openHelper.getWritableDatabase(); and the other on is on my DatabaseHelper which says that that my error is on the onCreate Method "db.execSQL("CREATE_TABLE " + TABLE_NAME + "(ID INTEGER PRIMARY KEY AUTOINCREMENT,Name TEXT, Username TEXT,Email Address TEXT,Password TEXT)");

[@sachindhakne4342]

give space between in your query as like "db.execSQL(" CREATE_TABLE " + TABLE_NAME + "( ID INTEGER PRIMARY KEY AUTOINCREMENT , Name TEXT , Username TEXT , Email Address TEXT , Password TEXT )");

[@balasriharshacheeday7445]

I too got the same problem, when I kept a space between the ID and the paranthesis before ID the error is gone

[@nadhifnaufal2236]

Same for me, I'm using space like " db.execSQL(" CREATE TABLE " + TABLE_NAME + "( ID INTEGER PRIMARY KEY AUTO INCREMENT , FirstName TEXT , LastName TEXT , Password TEXT , Email TEXT , Phone TEXT )") " But the error is still happening.

[@mohamedburshaid2206]

You only add spaces just before the + sign. For example: You don't add a space when ("CREATE.... You add space when ("CREATE TABLE " +......

[@nelsalvador]

I am using Android Studio 3.3v, where can I see the Android Device Monitor? or what should I do?

[@RunCodes]

See at the lower right corner, there is device file manager and rest of the process is same!

[@boomclap267]

Very amazing tutorial.... But how about update user info! Is there a video thatyou made about it.....?!

[@RunCodes]

Here you go kzbin.info/www/bejne/oH_VfayVaJyYnpo

[@currentissues7956]

When I click the register the application will say that "Unfortunately stop. " how to fix this thing right here bro?

[@danilsonbrito851]

oiii tudo bem eu estou com uma duvida no video , quando faço o login quero pegar o id , usei o cursor.getInt(0); mas nao aparece o id como faço para pegar o id

[@Miyo960]

Just asking how can you prevent user from entering the same username that already exist in the database in the registration?

[@RunCodes]

stackoverflow.com/questions/39303107/how-to-check-if-a-user-already-exists-in-sqlite-database-in-android/39304308

[@emaanmumtaz9388]

i have done same steps but in register database->registeration table.. registered values not present am getting registered sucessfully message .could you please help on this.table is empty always doesnt have any value

[@RunCodes]

Did you have internet connection??

[@emaanmumtaz9388]

@@RunCodes yess

[@phyusinlinlatt2589]

Thank you so much. It works well. Only one thing, every time new data is inserted, the db file is not updated. I have to download db file again to see the updated data. How should I do?

[@RunCodes]

can't do anything for that!

[@phyusinlinlatt2589]

@@RunCodes Really!! Thank you for your reply. Next problem is that emulator (api 22) works well. Real android phone also works well but can't see the data from user in my database(not updated to my database). How about is it??

[@boomclap267]

Now what if i had 3 different activities for Firstname, Lastname, Email. How can i create it in one database(table)?

[@RunCodes]

Why do you need activities for name and email?

[@boomclap267]

@@RunCodes Not exactly for name and email(i was giving you an example).....I'm working on project where you first enter your information and the next activity is about your family information! I don't want to put it in the same activity because it will be confusing for the user!

[@alaa7071elsham]

No error with my code but, the DB not updated automatically i need to open DB each time. the registeration are working but when i click log in button the app not working “unfortonatelly stop”

[@RunCodes]

may be error in your login activity

[@divyarani973]

I cant create a emulator with api level 22.. There is only device with api level 26 and above? Do they work? R how i can change? There is no other api level in project structure too..

[@RunCodes]

there should be! update your SDK Tool :)

[@danilsonbrito851]

everything well I am with one doubts in the video, when I make the login want to catch the id, I used the cursor.getInt (0); but he/she doesn't appear the id as I do to catch the id

[@RunCodes]

What about writing column name?

[@sokoyaadedolapo5321]

He should have shown us how he fixed the error

[@spiritualtalks5718]

Registration page is not working. when I clicked on register button, show error unfortunately your app is stopped working

[@RunCodes]

contact us at facebook.com/TechSupportNep

[@dinokrivicic1430]

Hi there! When I click Login the app stops working. I have copied the source code from your wab page but still no result. How can I fix it?

[@RunCodes]

first of all you have to watch the full video to understand after you get the concept then you can copy code! You have to use the emulator having api less than 22!

[@dinokrivicic1430]

@@RunCodes yes.. I watched all 3 and wrote the code myself.. registration works, but login does not.. Im not getting an error on compilation, it just crashes when I click login.. and one more thing.. i have 3.3.2 version that doesnt have android device monitor.. how can I extract database?

[@RunCodes]

see at lower right corner you will see device file explorer which is similar to device monitor. when you apps crashes go back to android studio and then click at the lower left corner, you will see run button click that button, you will be able to see what's the error!

[@pankajdabhade3466]

In above video An unlock symbol(known as public) is shown ahead of each java directory classes (known as public) but, in my case its not so, is it necessery that symbol should be present there???

[@pankajdabhade3466]

and one more thing when i try to create class file , automatically singleton get created!!!

[@RunCodes]

Yes that symbol need to present! I am not familiar with singleton! Try creating new project and create the java class file inside the package where main activity is created! This may solve your problem!

[@cscastro]

Hello again I followed your videos and am 99% done. I have registered 6 users into my database. My only issue is, the validation that checks between the DB saved email account and password account only works for the first user in my database. It doesn't seem to work for users 2-6. Can I send you what I have?

[@RunCodes]

+cscastro ok!

[@Talha2533]

I have created AVD having API 22, but In FIle explorer -> data -> data -> My app is not shown!.. why??

[@RunCodes]

Update and install all sdk and sdk tools!

[@dyaa_unison5580]

I can’t find Android Device Monitor? I’m using Genymotion what should I do ?

[@RunCodes]

stackoverflow.com/questions/49574127/how-to-open-android-device-monitor-in-latest-android-studio-3-1 this may help you :)

[@hammadzafar1073]

Unfortunately app has stopped.. plzz help me.. i've checked the code so many times.. but still its isn't working...

[@RunCodes]

+hammad zafar now how can I help you?? I have provieded the source code and tell the procedure and I show you how to do it! If you still got error contact us at facebook.com/TechSupportNep

[@asriidris3358]

i got an error, which it says Incompatible types, Required : adroid.database.sqlite.SQLiteDatabase . please help meh :

[@RunCodes]

Contact us at facebook.com/TechSupportNep

[@ray_sayan]

hey there..... i also facing same problem the last video tutorial you made... your app doesnt work and did not show us how did you fix the error...plz help me out

[@RunCodes]

i am damn sure that you guyz don't watch full video! watch the full video without skipping i showed you all how i solve that problem i solved that problem just by placing the space in the query!

[@ray_sayan]

TechSupportNep i fix my problem I wrote wrong query

[@RunCodes]

recheck your code!

[@MarufRayhan375]

Android device monitor is not opening!! Can y help! i tried many things, nothing worked!

[@RunCodes]

this tutorial may help you stackoverflow.com/questions/27526596/android-device-monitor-doesnt-open-error-on-log-file

[@waqasfarooq4478]

is this code will work in latest version of android 3.2.1?

[@RunCodes]

Sure!

[@gadrian1153]

hi sir. I use my real phone for this project. I cant open data... I have api 22. And one more quest.. This project is for phones with low android sistem? like "works on < 5 Lolipop" ?

[@RunCodes]

+G Adrian inorder to show your phone data you need to root your phone! And this project is for all system but we can see the database content with the api leve 22 or below this! above this version we can not see the database content and this may be the bug of higher version hope android team will fix this problem!

[@gadrian1153]

+TechSupportNep Can I continue to make this app without root? And thx for your answear speed :)

[@gadrian1153]

Sir.. I instaled blustack 3 and now I have api 19 and it's rooted.. but I still cant open the data folder. I can.. but it's empty.. What I need to do ? do you know ? please answear..

[@RunCodes]

+G Adrian you can make!

[@RunCodes]

+G Adrian it means either your phone is not rooted completely ! Check your phone either rooted or not from the apps which is available in play store or you can check your data from builtin emulator of android studio rather than from your phone!

[@pankajdabhade3466]

please help , i stucked with error E/SQLiteLog: (1) near "TABLEregister": syntax error E/AndroidRuntime: FATAL EXCEPTION: main

[@RunCodes]

Refers the code by clicking the link from description !

[@pankajdabhade3466]

it works. thank you

[@ray_sayan]

hey how you fix it. i also got a same problem data didnt store in database plz bro help me out

[@RunCodes]

contact us at facebook facebook.com/TechSupportNep

[@pankajdabhade3466]

i did code as the way you shown till part-3. but, data is not inserted in database. and also showing nothing in file explorer of Android device monitor. please help.

[@RunCodes]

Use emulator that have API Level below 22!

[@pankajdabhade3466]

No brother , i set api level to 21 but its not working. please give me another solution. please.

[@RunCodes]

Install all sdk and sdk tools of your android studio from!

[@joepaul2515]

My registration worked successfully. Thanku so much.but the login shows no error, but it shows as app stopped unexpectedly. Why is it so

[@RunCodes]

Check your login activity 😊

[@laxmidhakal2946]

Thanku bro it really worked for me 😊😊 I want to validate the registration and login form how can I validate it.

[@jayantjadhav9566]

When I hit register button popup toast is not visible..Help me

[@RunCodes]

stackoverflow.com/questions/35853739/toast-is-not-showing this may help you!

[@ray_sayan]

After login how to show user details to user?? It's need to create another activity ??? Plz help me out

[@RunCodes]

yes you need to create another activity

[@ray_sayan]

TechSupportNep can help me the coding

[@mdmasudrana3630]

first i want to thank you.. your tutorial is best ... again thanks .. and i request to you for giving new video

[@pramodkumare9942]

I followed line by line but dint work.when i click on register button,the app crashes.Only the main page will open

[@RunCodes]

+PRAMOD KUMAR contact us at facebook.com/TechSupportNep

[@aliza.t9305]

put the insert data function in to onclick method....dont put it outside

[@pramodkumare9942]

it is inside the onclick method only

[@markvincent2205]

how do we display all the data of a user in another activity if the user logs in?

[@RunCodes]

String value = cursor.getString(cursor.getColumnIndex("column_name"));

[@markvincent2205]

@@RunCodes thank you so much.. and do you have a tutorial about logging out the current user?

[@markvincent2205]

@@RunCodes hey ahmm i get an error when i used String value = cursor.getString(cursor.getColumnIndex("column_name")); is there any other way? or can you give a little detail on how to use that line properly?

[@RunCodes]

Write your database column name which value you want to access

[@Sport-word]

do you have a toturial how to make a search in listview ? sqlite db

[@RunCodes]

really sorry

[@kittul90]

I have problems client is not ready yet please give me solution

[@RunCodes]

I cannot get you!

[@markjohnpaulmonton5318]

cursor[0] = db.rawQuery("SELECT *FROM " + DatabaseHelper.TABLE_NAME + " WHERE " + DatabaseHelper.COL_4 + " =?AND " + DatabaseHelper.COL_5 + "=?", new String[]{user, pass}); My error is " =?AND " and "=?"

[@RunCodes]

check your code with the code that I provided in my blog by clixking the link in the description section of the video😊

[@anithareddy1671]

TechSupportNep even I got the same error

[@RunCodes]

use android version other than 3.0. 3.0 have this bug

[@deepikapenmethsa8044]

can we do this without emulator connecting our phone??

[@RunCodes]

why not! you can do it on your phone but in order to show the database data you need to root your phone!

[@deepikapenmethsa8044]

tq for ur fast rply sir. how should i root my phone?

[@RunCodes]

you can get apps in google playstore to root your phone!

[@pramodkulat9316]

Thank you sir Because of this tutorial I solved my most awaited error I am very happy 🤗 Keep teaching us

[@abdulkaffoor4573]

Bro your videos are amazing...and i have one error, 20:06 in the videos ,new String[] {Name,password} ); this is a error plz

[@RunCodes]

Whats the error?

[@abdulkaffoor4573]

Tq for your reply ...sry to say I clear the error

[@cricket9077]

sir,my app become stoped.please give the solution

[@RunCodes]

Contact us on facebook

[@balasriharshacheeday7445]

I am getting a red underlined error with "?=" could you please help me with this

[@RunCodes]

Can u please refers the whole code from the link that I provided in description section and don't skip the video! You may fond the solution of your problem by yourself

[@bengoonyuka5812]

This is the part: cursor = db.rawQuery("SELECT * FROM " + DatabaseHelper.TABLE_NAME + " WHERE " + Data

[@lidiakhelifi735]

same error

[@ذرفالدموع]

Any body solve this error?

[@fawadazam4149]

"=?" unexpected got,'?'.....how to solve this

[@RunCodes]

write your complete error

[@laxmidhakal2946]

I Am also getting the same error

[@laxmidhakal2946]

How to fix it

[@RunCodes]

Contact us on facebook!

[@skrayankula6215]

here still i'm getting the error app is stopped for this reason( unfortunately stopped)

[@RunCodes]

Contact us at facebook.com/TechSupportNep

[@Hkz2020]

Very good video and useful thanks alot

[@cad021]

Thank you so much!!! You were of great help

[@AnkitaSharma-ok6nc]

Can you please explain line 30 ; that is setOnClickListener((v) --> {

[@RunCodes]

Button button= (Button)findViewById(R.id.buttonId); button.setOnClickListener(new View.OnClickListener(){ @Override public void onClick(View view) { // click handling code } });

[@sachindhakne4342]

your tutorial very helpful i want to validate in registration and login activity

[@RunCodes]

+Sachin Dhakne contact us at facebook.com/TechSupportNep

[@samahelsayed8866]

Thank you.. please I need a video to explain how to finish an app and upload it to google play.

[@RunCodes]

+Samah Elsayed you need to have a developer account in google playstore for this you need to pay $25-30

[@samahelsayed8866]

I will do soon

[@priyankapaul5780]

Thank you so much for such a great help..

[@khushboogandhi7785]

I am unable to expand the data folder

[@RunCodes]

U need to install AVD having APi level below 22, u will see it

[@ذرفالدموع]

I have error in “=?AND” plz help

[@asriidris3358]

same here :'

[@NoRegrets49]

thanks a lot, great tutorial

[@srg_err]

You are doing such a good job man, keep on doing the good work!

[@Incognitodevill]

In the last video you got an error but you din't explained about it

[@RunCodes]

Place space in your query! I had clearly explain?about that watch till the end!

[@professorclup1082]

Damn, I always mess up at SQL

[@np_rathod3708]

Thank you sir

[@lapnghiepshopee]

v what is this??

[@RunCodes]

object of view

[@lapnghiepshopee]

where is it declared??

[@RunCodes]

when you create listening event of button it automatically creates this :)

[@thulisilekhoza8234]

i can not open the data

[@RunCodes]

you need to create the AVD less than or equal to 22 api level. after installing the AVD you will able to open the data :)

[@abhishekbandekar7884]

Thank you

[@professorclup1082]

I was thinking why it isn't working, then tada it's my enemy sql

[@shashikumarlamsal6968]

nice

[@institutetoindustry9040]

hi i have done same steps but in register database->registeration table.. registered values not present am getting registered sucessfully message .could you please help on this.table is empty always doesnt have any value

[@RunCodes]

check the right table 😊 still have problem contact us at facebook.com/TechSupportNep

[@institutetoindustry9040]

still the problem persist. same table only i am checked

[@glbyb1177]

Your app doesn't work and did not show us how did you fix the error. Please show me how to fix it it always says that my app is crush after i click the register button.

[@RunCodes]

+angelo beybe first of all you should watch all video without skipping! I clearly show how i fix an error!

[@cscastro]

I did not skip anything and am having a similar issue. I followed along this video and paused it to ensure our code is the same. My question is this: What did you change/fix in your code when it crashed in order to get it to work in this video? Without you pointing that out (where the error was and how you corrected it) it's hard for a beginner like myself to trouble shoot. Please clarify for me. I've been trying for over 5 hours now. Thanks

[@RunCodes]

i show clearly that there is no any error shown by android studio but i correct it by just placing space in the query see the whole video guyz before commenting! and also if you unable to run your apps successfully contact us at facebook.com/TechSupportNep

[@МастерХало]

I have a small error expr expected, got '?'

[@RunCodes]

use android version other than 3.0 or 3.0.1

[@МастерХало]

Thanks you sooooo much! I updated the Android Studio to the latest version and it all worked))))

[@МастерХало]

Thanks you sooooo much! I updated the Android Studio to the latest version and it all worked))))

[@prachimhetre9162]

Im getting error in select query statement

[@RunCodes]

What is your error?

[@prachimhetre9162]

Im getting redmark in "=?" N its saying that compound operator,join operator is missing

[@RunCodes]

use android version other than 3.0 or 3.0.1

[@prachimhetre9162]

Bt wht if i want to continue with the sme version n still wants to resolve the error?Is there any other way to do it?

[@RunCodes]

i don't have any idea about it :)really sorry

[@pratyushsrivastava3783]

Thank you