I am not sure it is appropriate to post here. Some one asked me to list all my source code so I thought to create a post (for my "followers").
This post is to list some of the posts I have posted in this forum (that I think are useful).
(List latest updated since Jan 2021. I will add in more older post when I have time)
Share My Creation
[B4X] User Login App + [B4J] MySQL API Server (Key + Token)
www.b4x.com
[B4A] B4A Bridge (Reskinned UI)
www.b4x.com
github: https://github.com/pyhoon/B4A-Bridge
[B4A] User Login + MySQL PHP API
www.b4x.com
[B4i] Aco (source code)
www.b4x.com
[B4i] Todo List (source code)
www.b4x.com
[B4J] Creating My Own DDNS Solution
www.b4x.com
p/s: Source code not available yet
[B4J] B4JQuiz - Desktop App
www.b4x.com
[B4J] JQuiz - API Server / Web Service for B4XQuiz (with SSL)
www.b4x.com
[B4J] jAdmin (MySQL Database Admin)
www.b4x.com
github: https://github.com/pyhoon/jAdmin
Code Snippet
[B4A] How to download text in a file.txt from a server
www.b4x.com
[B4i] Get country Code
www.b4x.com
[B4J] JRDC2 connect to MSSQLLocalDb
www.b4x.com
Answers / Tips (worth reading)
[B4A] (ask) jdbc url dynamic database and implementation
www.b4x.com
[B4A] how to update db with jrdc2 (MSSQL)
www.b4x.com
[B4A] Date time parse [SOLVED]
www.b4x.com
[B4A] Database update when installing the application
www.b4x.com
[B4A] Android Emulator for MacOS

www.b4x.com
[B4A] Remove Views
www.b4x.com
[B4i] httpjob error (HttpJob demo and Mini server)
www.b4x.com
[B4i] Getting started with B4i from B4A. Where to start?
www.b4x.com
[B4J] Simple Console IO in B4J?
www.b4x.com
[B4J] B4J jar to Linux
www.b4x.com
[B4J] read xml files
www.b4x.com
[B4J] jRDC2 is it safe?
www.b4x.com
[B4J] [jRDC] SELECT column name with special characters from MySQL
www.b4x.com
[B4J] B4J Server Redirect After Registration Confirmation
www.b4x.com
[B4J] HttpJob StreamReader (TextReader) to JSON
www.b4x.com
[B4J] [Databases] How can I store ONLY the last 20 records for each unique key?
www.b4x.com
[B4J] rdc2 & SELECT LAST_INSERT_ID()
www.b4x.com
[B4J] [Solved][Server] Warning when using mysql-connector-java-5.1.49-bin
www.b4x.com
[B4J] ServletResponse has ended when calling SMTP.Send
www.b4x.com
[B4J] 3DPrinter simulator and monitoring server
www.b4x.com
[B4J] jRDC Client
www.b4x.com
[P H P] Send Email using PHPMailer
https://www.b4x.com/android/forum/threads/user-login-mysql-php-api.117826/post-788553
Advice following a tutorial
https://www.b4x.com/android/forum/t...erview-problems-running-it.127074/post-795557
Naming variables
https://www.b4x.com/android/forum/threads/naming-variables.126976/post-794720
POST vs GET request (google translate rapidapi)
https://www.b4x.com/android/forum/threads/post-request-endpoint-does-not-exist.126978/post-794719
Save Image to Database using jRDC2
https://www.b4x.com/android/forum/threads/how-to-convert-image-to-byte.128689/post-807420
Call stored procedure in jRDC2
https://www.b4x.com/android/forum/t...eters-to-stored-procedures.126938/post-794453
Tutorial
[B4J Tutorial] [Server] Using Let's Encrypt on Ubuntu VPS
https://www.b4x.com/android/forum/threads/server-using-lets-encrypt-on-ubuntu-vps.124059/
This post is to list some of the posts I have posted in this forum (that I think are useful).
(List latest updated since Jan 2021. I will add in more older post when I have time)
Share My Creation
[B4X] User Login App + [B4J] MySQL API Server (Key + Token)
[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...

[B4A] B4A Bridge (Reskinned UI)
B4A-Bridge (Reskinned UI)
Github: https://github.com/pyhoon/B4A-Bridge I repost the source code here hopefully it is more organize and easy to find. It is for future discussion on my version too. Thanks. 25 April 2022: New UI Older version is available in this post.

[B4A] User Login + MySQL PHP API
User Login + MySQL PHP API
Web API Updates: For B4J API Server and cross platform client apps, please check [B4X] User Login App + [B4J] MySQL API Server (Key + Token) https://www.b4x.com/android/forum/threads/b4x-user-login-app-b4j-mysql-api-server-key-token.126081/ Android App This is the 3rd version of...

[B4i] Aco (source code)
Aco (source code)
Aco-B4i A "very stupid" companion app that only understand "how are you" and "say ???". A Siri clone? Language available in English and 粤语 (Cantonese). Press the title to switch. Press Microphone button to start Source code: https://github.com/pyhoon/aco-b4i Video:

[B4i] Todo List (source code)
Todo List (source code)
todo-B4i Made with ❤ in B4X Source code: https://github.com/pyhoon/todo-b4i For B4A: https://www.b4x.com/android/forum/threads/todo-list-b4a-b4i-source-code.115532/

[B4J] Creating My Own DDNS Solution
Creating My Own DDNS Solution
Introduction There are times we want to demonstrate to our client about the app we have developed which requires to connect to a MS SQL Server. Windows hosting server is usually not cheap. So what we can do is temporary transform our local PC into a public server. The problem is we are using...

[B4J] B4JQuiz - Desktop App
B4JQuiz - Desktop App
This is a B4XPages app. For the server, please check: https://www.b4x.com/android/forum/threads/jquiz-api-server-web-service-for-b4xquiz-with-ssl.124200/

[B4J] JQuiz - API Server / Web Service for B4XQuiz (with SSL)
JQuiz - API Server / Web Service for B4XQuiz (with SSL)
This is the full source code for B4XQuiz server. For the B4J client app, please check: https://www.b4x.com/android/forum/threads/b4jquiz-desktop-app.124202/ SQL script to generate database in post #2 SSL Tutorial: [Server] Using Let's Encrypt on Ubuntu VPS 'Non-UI application (console / server...

[B4J] jAdmin (MySQL Database Admin)
jAdmin
This app is inspired by Adminer (a lightweight app to manage mySQL database). I haven't seen any web app built using B4J to manage remote MySQL database, so I build one. This project is still work in progress. I also successfully tested that I can run 2 B4J servers in the same VPS using...

Code Snippet
[B4A] How to download text in a file.txt from a server
How to download text in a file.txt from a server
Hello, With OKHttputilis2 I want to download text in a file.txt from a server and put it into a variable. I Know to download an image and I use this Sub which runs fine Sub DownloadImage(Link As String, iv As ImageView) Dim j As HttpJob j.Initialize("", Me) j.Download(Link) Wait...

[B4i] Get country Code
Get country Code
Sub GetLanguage As String Dim no As NativeObject Dim s As String = no.Initialize("NSLocale") _ .RunMethod("preferredLanguages", Null).RunMethod("objectAtIndex:", Array(0)).AsString If s.Length > 2 Then s = s.Substring2(0, 2) Return s End Sub Sub GetCountry As String...

[B4J] JRDC2 connect to MSSQLLocalDb
JRDC2 connect to MSSQLLocalDb
# MS SQL Server Express Edition DriverClass=net.sourceforge.jtds.jdbc.Driver JdbcUrl=jdbc:jtds:sqlserver://./DatabaseName;instance=LOCALDB#AC2F9943;namedPipe=true;domain=DomainName You need to use jTDS 1.3.2 Reference...

Answers / Tips (worth reading)
[B4A] (ask) jdbc url dynamic database and implementation
(ask) jdbc url dynamic database and implementation
hi people, please help me a link / a good way so I don't have to write the database name in JdbcUrl = jdbc: mysql: // localhost / test? CharacterEncoding = utf8 so that I can set which database that I will select via the client side. this is an example that more or less I mean...

[B4A] how to update db with jrdc2 (MSSQL)
how to update db with jrdc2
I use jrdc2-b4j connection MSSQL But there is no update process in the example How should i write my db: in config.properties: sql.update_app=update animals set kg=? where id=? B4X: My code , it has Errors Sub UpdateRecord(kg As String,id As Int) Dim cmd As DBCommand =...

[B4A] Date time parse [SOLVED]
Date time parse [SOLVED]
Hello all How can I parse a date-time in the formula : 2021-01-08T11:39:00.000Z thanks

[B4A] Database update when installing the application
Database update when installing the application
What is the most effective method in the following situation: the application has a database attached. The file is copied from File.DirAssets to SafeDirectory = rp.GetSafeDirDefaultExternal ("") when the application is opened if it does not already exist. The problem arises if the database is...

[B4A] Android Emulator for MacOS


Android Emulator for MacOS 📱💻
I used to develop B4X using a PC. Now, I want to develop B4X using a MacBook only. I tried NoxAppPlayer, I can't configure it to connect to the local network. BlueStacks doesn't look like Android Phone size. I skip Genymotion since it requires registration. What do you guys use? Any recommendation?

[B4A] Remove Views
Multiple executions of the same loadlayout
If my app does multiple executions of the same Loadlayout, do the previous Loadlayouts accumulate in memory? Or is there something I need to do to cleanup older Loadlayouts?

[B4i] httpjob error (HttpJob demo and Mini server)
httpjob error
Hi, need your help, i am work with iHttpUtils2 but can´t send data way job.download i need send : http://192.168.4.1/$$YY%02%& but the error for ever is ResponseError: unsupported URL, status code: 0 Sub Enviar_dato( env As String) Dim job As HttpJob Dim en As String Dim...

[B4i] Getting started with B4i from B4A. Where to start?
Getting started with B4i from B4A. Where to start?
Hi guys, Happy new year to everyone! Working on the 2021 targets I am inclined to add a "port one B4A app to B4i". Is there a suggested path to follow? Right now I don't have any mac nor iPhone. I only have an iPad. Some questione: - do I need a mac or can i use windows - do I need an actual...

[B4J] Simple Console IO in B4J?
Simple Console IO in B4J?
I'm having trouble finding an example of a simple input/output Console example in the tutorial documentation. I've found bits and pieces like reading from a text file. But, essentially, how would one translate this Java example (see pic) to B4J? Thank you.

[B4J] B4J jar to Linux
B4J jar to Linux
I'm starting with B4J on Windows10 and I was really positive surprised how "smooth" is to create UI application. I created my first App and this works on all Windows 10 machines. In company we have about 20 Linux machines... I try to distribute this app to Linux - and app will not start...

[B4J] read xml files
read xml files
Good evening, I would need to read an xml file and identify a data and read it in a label. example: if I insert 0 in a textbox I would like to read toast in a label. toast sandwich salad Kindly does anyone have any examples? Thanks for your attention

[B4J] jRDC2 is it safe?
jRDC2 is it safe?
sorry for my ignorance but i hear a lot of people saying using PHP is not safe to connect to a MySQL DB. and i hear a lot erel saying the best solution is to use jRDC2. so i tried and watched the whole tutorial of him here i must say that i was surprised that everything worked. so i managed to...

[B4J] [jRDC] SELECT column name with special characters from MySQL
[jRDC] SELECT column name with special characters from MySQL
I created a view with column name in german word and I tried to select the data. Eg. SELECT `Color`, `Januar` AS `January`, `Februar` AS `February`, `März` AS `March`, `April` AS `April`, `Mai` AS `May`, `Juni` AS `June`, `Juli` AS `July`, `August` AS...

[B4J] B4J Server Redirect After Registration Confirmation
B4J Server Redirect After Registration Confirmation
I've got users clicking a confirmation link from their email. I'm processing the click, but I want to send them to a Success or Fail page, depending on the result of the confirmation check. I've seen the SendRedirect, but I don't want to send a code 302. It should just be normal. For example...

[B4J] HttpJob StreamReader (TextReader) to JSON
With httpjob Post json to jServer(server handler)
Hi I use following code post a json to jserver. What function could let me read json via ServletRequest ? o_O Dim sn As Map=jyAuth.LoadMachineSn sn.Put("license",result) Dim jg As JSONGenerator jg.Initialize(sn) Dim HTTPTask As HttpJob...

[B4J] [Databases] How can I store ONLY the last 20 records for each unique key?
[Databases] How can I store ONLY the last 20 records for each unique key?
Ola What is the best way to implement something like this. Lets assume that.... 1. A timer is running every 5 minutes, this sends a payload with a unique key, timestamp etc. 2. I receive the payload and save it to a database of choice. Over time, the database will be huge. 3. To deal with...

[B4J] rdc2 & SELECT LAST_INSERT_ID()
rdc2 & SELECT LAST_INSERT_ID()
Hi, how can we get the last inserted ID from MariaDB/MySQL ? sending a query one by one does not work for LAST_INSERT_ID e.g. request: INSERT INTO books (title) VALUES ('test'); followed by: request: SELECT LAST_INSERT_ID(); will return always 0 (zero) request everything at once returns...

[B4J] [Solved][Server] Warning when using mysql-connector-java-5.1.49-bin
[Solved][Server] Warning when using mysql-connector-java-5.1.49-bin
When I develop B4J server locally, I set #AdditionalJar: mysql-connector-java-5.1.49-bin and I get the following warning (the bottom 3 lines) Waiting for debugger to connect... Program started. 2021-01-06 12:03:05.646:INFO::main: Logging initialized @1721ms to...

[B4J] ServletResponse has ended when calling SMTP.Send
ServletResponse has ended when calling SMTP.Send
I tried to use ServletResponse.Write but the ServletResponse has already ended once I called SMTP.Send. How can I use ServletResponse.Write to return a Response text after the SMTP completed? Line #16 and #19 have no effect. Response.Write("EmailTest is running...") LogDebug("Sending...

[B4J] 3DPrinter simulator and monitoring server
Error handling will not work
Hi, I have written a quick and (maybe) dirty program which connect to my 3D Printer to get some information. My problem is that i sometimes get connection errors like time out or connection resets. I have tried to catch those with try & Catch and with the Application_Error sub but without...

[B4J] jRDC Client
[B4XPages] [SOLVED] jRDC2 Client Code Should All be in Main Activity?
Ola I have a couple of B4XPages that will speak to JRDC2. The commands and things that each page will do will be different depending on the purpose of the page. Should all the methods be defined on the Main Activity. For example GetRecord/InsertRecord. Is it possible to have such methods per...

[P H P] Send Email using PHPMailer
https://www.b4x.com/android/forum/threads/user-login-mysql-php-api.117826/post-788553
Advice following a tutorial
https://www.b4x.com/android/forum/t...erview-problems-running-it.127074/post-795557
Naming variables
https://www.b4x.com/android/forum/threads/naming-variables.126976/post-794720
POST vs GET request (google translate rapidapi)
https://www.b4x.com/android/forum/threads/post-request-endpoint-does-not-exist.126978/post-794719
Save Image to Database using jRDC2
https://www.b4x.com/android/forum/threads/how-to-convert-image-to-byte.128689/post-807420
Call stored procedure in jRDC2
https://www.b4x.com/android/forum/t...eters-to-stored-procedures.126938/post-794453
Tutorial
[B4J Tutorial] [Server] Using Let's Encrypt on Ubuntu VPS
https://www.b4x.com/android/forum/threads/server-using-lets-encrypt-on-ubuntu-vps.124059/