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

aeric · Jan 13, 2021

Maybe you can check this post by @Mashiane

[BANanoServer] [SOLVED] Handling User Sessions

Ola I've just seen this example. https://www.b4x.com/android/forum/threads/server-guess-my-number-example.37458/#content Am I right to assume that the way to handle user sessions also with BANano is Sub Handle(req As ServletRequest, resp As ServletResponse) If...

www.b4x.com

cklester · Jan 13, 2021

aeric said:
Sorry I am not sure about session. When we use API, we are not using session. We are sending a token as authentication.

What do you mean by a token? In the headers? That's similar to what I'm talking about. A POST with headers or data.

Currently, I can POST traffic to the server (and back) in JSON format. In that JSON, I will put the session_id, which, I guess, I should be putting in a header instead.

Back to the drawing board.

cklester · Jan 13, 2021

aeric said:
Maybe you can check this post by @Mashiane

[BANanoServer] [SOLVED] Handling User Sessions

Ola I've just seen this example. https://www.b4x.com/android/forum/threads/server-guess-my-number-example.37458/#content Am I right to assume that the way to handle user sessions also with BANano is Sub Handle(req As ServletRequest, resp As ServletResponse) If...

www.b4x.com

Is that relevant to a desktop/mobile app that doesn't use cookies to store session variables?

aeric · Jan 13, 2021

cklester said:
Is that relevant to a desktop/mobile app that doesn't use cookies to store session variables?

There are difference between web apps which use session (store in server) and cookies (store in client browser) versus mobile apps which is using API to communicate (stateless) with server. In my sample, I am only using 2 fields, API key and Token, so I think keyvaluestore is much simpler than SQLite.

cklester · Jan 13, 2021

aeric said:
There are difference between web apps which use session (store in server) and cookies (store in client browser) versus mobile apps which is using API to communicate (stateless) with server. In my sample, I am only using 2 fields, API key and Token, so I think keyvaluestore is much simpler than SQLite.

So, using your API, we could send up the API key (which would identify the user), and the Byte() I want to store in the MySQL database. Is that correct?

aeric · Jan 13, 2021

cklester said:
So, using your API, we could send up the API key (which would identify the user), and the Byte() I want to store in the MySQL database. Is that correct?

My app will get the API key when user login using email and password. This API key acts like a cookie inside the app. Then it will proceed to get the token. The token will expired which is like a session. You can post any data together with the token so it will identified by the token.
To make it more simpler, we can use Base64Encode to convert the file then post as JSON string. When you want to read the data, you can reverse it by using Base64Decode.

aeric · Jan 13, 2021

B4X client attached in post #1. The B4X.zip contains all 3 platforms using B4XPages. Take note that there are some bugs I haven't fix. If anyone is kind to help me to fix them, I am very welcome and appreciate. Cheers.

Elric · Jan 17, 2021

Edit: I've red later about bugs. So take the following as notes, please!

Hi aeric,

I'd like to test you work but, in B4X.zip, for B4J:

B4X:

Sub Class_Globals
    Private Root As B4XView 'ignore
    #If B4i
    Dim hud As HUD
    #End If
    #If B4J
    Private fx As JFX
    Private clx As clXToastMessage1
    #End If
    Private xui As XUI 'ignore
    Private KVS As KeyValueStore
    Dim strMode As String
    Private txtUserEmail As B4XFloatTextField
    Private txtOldPassword As B4XFloatTextField
    Private txtUserPassword1 As B4XFloatTextField
    Private txtUserPassword2 As B4XFloatTextField  
End Sub

This declaration "Private clx As clXToastMessage1" hasn't a class or library.

And for B4A, error message "relinker-1.3.1.aar" not found:

Thank you!

sfsameer · Jan 17, 2021

Elric said:
Edit: I've red later about bugs. So take the following as notes, please!

Hi aeric,

I'd like to test you work but, in B4X.zip, for B4J:

B4X:

Sub Class_Globals Private Root As B4XView 'ignore #If B4i Dim hud As HUD #End If #If B4J Private fx As JFX Private clx As clXToastMessage1 #End If Private xui As XUI 'ignore Private KVS As KeyValueStore Dim strMode As String Private txtUserEmail As B4XFloatTextField Private txtOldPassword As B4XFloatTextField Private txtUserPassword1 As B4XFloatTextField Private txtUserPassword2 As B4XFloatTextField End Sub

This declaration "Private clx As clXToastMessage1" hasn't a class or library.

And for B4A, error message "relinker-1.3.1.aar" not found:
View attachment 106428

Thank you!

Download the relinker-1.3.1.aar
from :

https://www.b4x.com/android/forum/attachments/b4a-dependencies-zip.96328/

"unzip it and copy the files to the additional libraries folder" by erel

original post : https://www.b4x.com/android/forum/threads/b4x-b4xgifview-cross-platform-animated-gif-view.118550/

aeric · Jan 18, 2021

Elric said:
Edit: I've red later about bugs. So take the following as notes, please!

Hi aeric,

I'd like to test you work but, in B4X.zip, for B4J:

B4X:

Sub Class_Globals Private Root As B4XView 'ignore #If B4i Dim hud As HUD #End If #If B4J Private fx As JFX Private clx As clXToastMessage1 #End If Private xui As XUI 'ignore Private KVS As KeyValueStore Dim strMode As String Private txtUserEmail As B4XFloatTextField Private txtOldPassword As B4XFloatTextField Private txtUserPassword1 As B4XFloatTextField Private txtUserPassword2 As B4XFloatTextField End Sub

This declaration "Private clx As clXToastMessage1" hasn't a class or library.

And for B4A, error message "relinker-1.3.1.aar" not found:
View attachment 106428

Thank you!

Hi Elric,
I use [B4X] B4XGifView - Cross platform animated gif view to load animated image in Splash screen
~~For B4J: [B4X] [XUI] ToastMessage class to show toast message in B4J~~

Edit: See post #32 for clXToastMessage1

Elric · Jan 18, 2021

Thank you sfsameer.

aeric said:
For B4J: [B4X] [XUI] ToastMessage class to show toast message in B4J

Thank you aeric.

Just to make it clear for me: it is a class module not a library. I've just added and renamed it from "clXToastMessage" in "clXToastMessage1" (as per declaration).

I've got an error:

B4X:

Compiling code.    Error
Error compiling program.
Error description: Unknown member: show
Error occurred on line: 749
clx.Show(Message, LongDuration)
Word: show

Just no sub "Show" is in clXToastMessage1; only the sub ShowMessage but without arguments.

aeric · Jan 18, 2021

Elric said:
Thank you sfsameer.

Thank you aeric.

Just to make it clear for me: it is a class module not a library. I've just added and renamed it from "clXToastMessage" in "clXToastMessage1" (as per declaration).

I've got an error:

B4X:

Compiling code. Error Error compiling program. Error description: Unknown member: show Error occurred on line: 749 clx.Show(Message, LongDuration) Word: show

Just no sub "Show" is in clXToastMessage1; only the sub ShowMessage but without arguments.

Sorry, this is the correct thread.
[B4X] [XUI] ToastMessage Class Modifications

Puthut Wibowo · Jan 28, 2021

this examples of applications that are very useful ...

Can I get tutorial how to install into the hosting, I'm using the php version here

Thank you in advance

aeric · Jan 28, 2021

Puthut Wibowo said:
this examples of applications that are very useful ...

Can I get tutorial how to install into the hosting, I'm using the php version here

Thank you in advance

Please start a new thread with your question e.g. "How to host my PHP web application in shared hosting?"

aeric · Jan 28, 2021

I tried to add emoticon to the varchar field and getting error.

[user/update][Exception] (SQLException) java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x9C' for column 'user_name' at row 1

The solution is to use utf8mb4 collation for MySQL database.

The problem is with the SET NAMES utf8 command. In MySQL the utf8 character set is not truly utf8, it supports characters up 3 bytes only and the character in question has 4 bytes

https://stackoverflow.com/questions/39095860/how-to-connect-to-mysql-using-utf8-within-a-perl-script

Puthut Wibowo · Feb 15, 2021

Hi Aeric

I mean is it different from the previous PHP version?

or api still using php while the client uses B4j and B4X?

aeric said:
Please start a new thread with your question e.g. "How to host my PHP web application in shared hosting?"

aeric · Feb 15, 2021

Puthut Wibowo said:
Hi Aeric

I mean is it different from the previous PHP version?

or api still using php while the client uses B4j and B4X?

This project is totally no PHP. The API is completely written in B4J.

Puthut Wibowo · Mar 28, 2021

Hi Aeric,

I've create a Threat :

[ASK]Build B4J MySQL API Server

Hello, all, Based on the threat made by aeric with the title [B4X] User Login App + [B4J] MySQL API Server (Key + Token), I currently rent hosting with Cpanel in it, are there any tutorials on making a B4J webserver into Hosting ? Because I am not a B4J user and this is make me confused...

www.b4x.com

Thanks

aeric said:
Please start a new thread with your question e.g. "How to host my PHP web application in shared hosting?"

pixet · Aug 15, 2021

I tried to fill in as indicated, but I can't activate the registered user.
Any suggestions ?

aeric · Aug 15, 2021

pixet said:
I tried to fill in as indicated, but I can't activate the registered user.
Any suggestions ?

Check if there are any errors in B4A logs or MySQL table tbl_error and tbl_users_log.

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

Attachments

Expert

Well-Known Member

Well-Known Member

Expert

Well-Known Member

Expert

Expert

Well-Known Member

Well-Known Member

Expert

Well-Known Member

Expert

Member

Expert

Expert

Member

Expert

Member

Member

Expert

Similar Threads