B4J Question login and signup b4j

Sort by date Sort by votes

behnam_tr

Active Member
Licensed User
Longtime User
For offline
Create a new table in the database called user, then from b4j

B4X: 
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
 
Upvote 0

josejad

Expert
Licensed User
Longtime User
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
 
Upvote 0

nazarixxxxx123

Member
Thank you. Your advice is very useful and helpful.?
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
B4J Question ABKeystoreSSL - download link?
Replies
3
Views
875
tsteward
C
  • Question
B4J Question Where is address of website to download B4J8.1?
Replies
3
Views
817
cbal03
C
  • Question
B4J Question Where is address of website to download B4J8.1?
Replies
1
Views
591
Sandman
B
  • Question
B4J Question B4J Call OpenCV
Replies
3
Views
2K
Tayfur
R
  • Question
B4J Question jGoogleMap - offline
Replies
2
Views
1K
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…