My Source Code Compilation

[aeric]

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)

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

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...

www.b4x.com

[B4A] B4A Bridge (Reskinned UI)

B4A Bridge (Reskinned UI)

Github: https://github.com/pyhoon/B4A-Bridge The original attachment is from this post. 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.

www.b4x.com

github: https://github.com/pyhoon/B4A-Bridge

[B4A] User Login + MySQL PHP API

User Login + MySQL PHP API

Update: For B4J API Server and cross platform client apps, please check [B4X] User Login App + [B4J] MySQL API Server (Key + Token) Android App Web API This is the 3rd version of login example I share in this forum. The first version I shared when I started learning B4A is just a very...

www.b4x.com

[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:

www.b4x.com

[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/

www.b4x.com

[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...

www.b4x.com

p/s: Source code not available yet

[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/

www.b4x.com

[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...

www.b4x.com

[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...

www.b4x.com

github: https://github.com/pyhoon/jAdmin

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...

www.b4x.com

[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...

www.b4x.com

[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...

www.b4x.com

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...

www.b4x.com

[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 =...

www.b4x.com

[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

www.b4x.com

[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...

www.b4x.com

[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?

www.b4x.com

[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?

www.b4x.com

[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...

www.b4x.com

[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...

www.b4x.com

[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.

www.b4x.com

[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...

www.b4x.com

[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

www.b4x.com

[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...

www.b4x.com

[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...

www.b4x.com

[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...

www.b4x.com

[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...

www.b4x.com

[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...

www.b4x.com

[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...

www.b4x.com

[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...

www.b4x.com

[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...

www.b4x.com

[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...

www.b4x.com

[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...

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/

 

[aeric]

Reserved