B4J Question login and signup b4j

[nazarixxxxx123]

Hello.
How can I have an offline and online login or registration page in b4j?
Is there any source that you can send me?

 

[aeric]

If you need online login then you need to have a database server or database service like Firebase or Supabase.

 

[nazarixxxxx123]

If you need online login then you need to have a database server or database service like Firebase or Supabase.

That's right.
But I can't find offline registration source by SQLite database. Can you help me please?

 

[aeric]

Creating a new user is just inserting a new row into the user table.

You just need to check the SQL tutorial.

 

[behnam_tr]

For offline
Create a new table in the database called user, then from b4j

Dim Sql1 As SQL
Sql1.InitializeSQLite(File.DirApp, "mydb.db" , False)
   
'insert to DB
        Main.Sql1.BeginTransaction
        Try
          /// my db > user > id,name,pass,date
            Main.Sql1.ExecNonQuery2("INSERT INTO users VALUES (?,?,?,?)", Array(Null,TextField_name.Text,TextField_password.Text,DateTime.Now))
       
            Main.Sql1.TransactionSuccessful
       
        Catch
            Log(LastException)
            Main.Sql1.Rollback
        End Try

search
There are many examples in the forum

 

[josejad]

Maybe this example can help you.

Once you log for the first time, the user is saved in a kvs.
Or you can even change the mysql (online) db for a sqlite (offline) one

[B4XPages] jRDC2 + MySql CRUD + Login

Hi all: I'm starting (at last) to work with B4XPages, so I've started to adapt the B4XPages + B4XDrawer example. I think I’ve seen more examples with php + mysql, but no projects with Jrdc2. Maybe the dummy data and the UI are too basic, but you can get some ideas. What do we need? - A...

www.b4x.com

 

[nazarixxxxx123]

Maybe this example can help you.

Once you log for the first time, the user is saved in a kvs.
Or you can even change the mysql (online) db for a sqlite (offline) one

[B4XPages] jRDC2 + MySql CRUD + Login

Hi all: I'm starting (at last) to work with B4XPages, so I've started to adapt the B4XPages + B4XDrawer example. I think I’ve seen more examples with php + mysql, but no projects with Jrdc2. Maybe the dummy data and the UI are too basic, but you can get some ideas. What do we need? - A...

www.b4x.com

Thank you. Your advice is very useful and helpful.