mysql

SubName: Create a single .sql backup file of a MySQL database that is ready to restore. Description: You can use the following code to create a backup of MySQL databases, the backup file is saved in a folder on your desktop called 'Backup Database'. The code below creates a single .sql file that...

MiniORMUtils Version: 4.03 This library can be use for creating database tables and performing CRUD operations. It is suitable for B4X apps, non-UI web app or REST API servers. Currently it supports SQLite (for B4A, B4i, B4J), MariaDB and MySQL (for B4J only). Project Template: [B4X]...

I have a greenhouse which uses and STM32h7 processor to control the temperature. The controller has an ethernet port using LwIP. This port connects to a wireless bridge into my home LAN. I use a c# system tray application to get the data from the LAN an put it into an MySQL db. The ethernet...

Check out the second spoiler. It's another example of the possible integration of this application. This small application might be a great help in creating reports and SQL statements. In the first tab you can select a SQLite database file and get all the tables in that database. In the...

Why/What? A CloudKVS didn't cover my needs so I developed this class. Features: - It synchronises a table between two SQL instances; one is called the Client, the other the Server - All columns that exist in the Server table must be present in the Client table - Additional columns that exist in...

For any project where a database is required - it's very important to have possibility to see the database data, to debug the app. If the app is used on a remote server host, and the database is getting bigger and bigger - it's not comfortable to see file-based SQLite database, as file copying...

One my project has to be using not only SQLite database (actually, two different ones, as separate classes), but MySQL also, due to big size that now is more convenient to see via web-browser remotely (without downloading big SQLite db file). So, i have combined 2 DBUtils modules: latest...

Hello. I am a newbie. I have been tasked with writing a new application for collecting shop floor information such as clocking in and out, starting a job, ending a job etc. I've already written the first version in VB.NET and Windows Forms. The shop floor have touchscreens so this works. The SQL...

Hello, today is my 3rd day using this wonderful tool, and I would like to create a simple program, for example, an Product Inventory. Let me explain: The program should have the capability to establish a connection via jrdc2 to a server, enabling the seamless transfer and creation of a table...

Current version: 1.03 Status: Released Price: $150 $112.50 (25% off New Year Promotion until 28 Feb 2025) What's new? Preview Demo Video FAQs

Hi ! New library ! MysqlConn. It is fully written in B4X ! This library is compatible with B4J & B4A. It depends on OkHttpUtils2 and a PHP Script. PHP Script : <?php $host_name = $_GET['Hostname']; $database = $_GET['DbName']; $user_name = $_GET['username']; $password = $_GET['password']...

Hi. I'm trying to make a small app just for me that connects directly to our MySQL-database. I've tried multiple examples and libraries but with the same result every time. Now I'm beginning to think it might be my phone or if I'm missing some of them manifest-rows or whatever (yea, I'm kinda...

transform any database into a rest api in just 5 minutes and without programming or knowing php instucciones: 1. create a database on your web server 2. create your tables it is important that each table created has the id field 3. upload the files inside the zip file to your server in the...

Hello Community, Well, I was working with PHP files for a project on the server side, when I ran into a problem. After changing the PHP file or changing MYSQL, the string received from the server as a Result is the same as the previous string and has not changed. Due to the caching of...

Hi to all, i have made a App based on httpUtils, i pick my entry with php page and mysql_maria db, all work fine, now i decie to use private page with .htpasswd ah .htaccess and here come the problem. If i use this type of link http(s)/username:passwod@website.something in the browser (i have...

Are you up for another challenge? Try this tutorial. Maybe you like the end result. This is how it will look like: You will find some interesting links to other study material in this tutorial. And of course here is the link: B4A-JSON Happy coding! Paul.

Hello, I have a problem when trying to connect to a mysql server online using jdbc. I have copy the jdbcSQLExemple from here : link I've only changed the url, the id and the password and i have this error : (SQLException) java.sql.SQLException: No suitable driver found for "SERVERNAME" I've...

Hi, I am using this tutorial on how to connect to MySQL DB https://www.b4x.com/android/forum/threads/connect-android-to-mysql-database-tutorial.8339/ But I have a problem because I need to wait for the query to finish before proceeding on to the next process. I send a SELECT * FROM and I need to...

I am using this tutorial https://www.b4x.com/android/forum/threads/connect-android-to-mysql-database-tutorial.8339/ To connect to a MySQL DB, everything works fine, but I have a problem. Sometimes I need for the query to finish before proceeding to the next line of code This is what I want to do...

I'm new to encryption, btw, and I want to be able to compare encrypted mysql data on the fly while executing a select query like SELECT * from myTable WHERE encrytedField=selectedEncryptedValue or SELECT * from myTable WHERE aes_decrypt(encrytedField, '123')=selectedValue Therefore I need...