Share My Creation [B4X] User Login App + [B4J] MySQL API Server (Key + Token)

Update: I recommend you to also take a look at my latest Web API Template if you want to develop B4X client apps connecting to MySQL/SQLite backend web server using JSON format API.

Finally I would like to share my B4J API server written in B4J.
Compare to my previous PHP API, this API server implements user access token to authorize user to consume the API.

SQL.zip - SQL script to create necessary database and tables in MySQL server.
jAPI.zip - Source code for server app (B4J).
B4A.zip - Source code for client app using default template (B4A)
B4X.zip - Source code for client app using B4XPages template (B4A, B4i and B4J)

Live server: https://api.puterise.com:17179

1609578113098.png


12 Jan 2021: Attached B4J client sample. This is a beta version. Some bugs and features will be fixed in the future.
13 Jan 2021: Attached B4X client sample. This is a beta version. Some bugs and features will be fixed in the future. B4J.zip removed.
 

Attachments

  • SQL.zip
    705 bytes · Views: 1,247
  • jAPI.zip
    459.8 KB · Views: 1,337
  • B4A.zip
    51.2 KB · Views: 1,292
  • B4X.zip
    406.5 KB · Views: 1,234
Last edited:

pixet

Member
Licensed User
Longtime User
There are no errors reported,
the only message displayed "[{" result ": - 1," message ":" Error-Not-Activated "}]"
The table: "tbl_users_log" contains in the field log_type = "[Not Actived] email", the table "tbl_error" is empty.
If I try to log in, it replies that the user is not active.
How can I force user activation?
Thank you
 

aeric

Expert
Licensed User
Longtime User
There are no errors reported,
the only message displayed "[{" result ": - 1," message ":" Error-Not-Activated "}]"
The table: "tbl_users_log" contains in the field log_type = "[Not Actived] email", the table "tbl_error" is empty.
If I try to log in, it replies that the user is not active.
How can I force user activation?
Thank you
Activation email. You can also append the user activation code from user table to the URL.

For example:

API documentation:
 
Top