mysql

Hello everyone. I'm trying to load Mysql database table data into B4XTable by using JRDC2. I can print results in logs. But the data is not showing in B4XTable columns it shows table empty. Anyone can explain how to load result rows into B4XTable? Thank you.

I have an app that stores an image in a SQLite BLOB and happily retrieves and displays it in a form. However I need to push that up to a PHP Webserver and store it in the corresponding MySQL BLOB field. Do I have to retrieve the BLOB, store it locally as a file then Post it to the Server for...

So I'm most likely just being a bit thick today but i can't get my head around how to get this to work; The aim being to have an xml builder populated from a database. 'Handler class Sub Class_Globals Private mreq As ServletRequest 'ignore Private mresp As ServletResponse 'ignore '...

Hi Everyone! Gotten stuck trying to receive some data from a post request and put it into a database, I get data like this; 'PIRTIMEOUT 001306894=5000' I need to put the 5000 (**** in the code)part into the database the other number being the device number (Num, in the code) it has to go...

I'm trying to use jShell to run MySQLDump.exe to dump a database: DumpDB.Initialize("DumpDB","C:/xampp/mysql/bin/mysqldump.exe" , _ Array As String("-u root","-pxxxxx#","dbname","> ", "C:\xampp\htdocs\enctrans\Dumps\test.sql" )) It fails with: When I start a batch file via jShell...

https://www.b4x.com/android/forum/threads/jdbcsql-directly-connect-to-remote-databases.84016/ Hello, I was following what Erel published, but I do not know how to do it with Shared Web Hosting, for example with Hostinger. I have the Mysql database there, and I activate Remote Mysql for that...

Hola, soy nuevo en B4A, alguien me puede ayudar con el control de WebView, en una pagina web que muestro, hay imágenes y videos, que los videos si cargan, pero no funcionan los controles como el de pantalla completa. Saben si hay alguna forma? Ademas los botones no me funcionan, eso lo note en...

Hola, tengo un problema es que no alcanzo a comprender del todo como "Bloquear" una petición HTTP por que utilizo Wait For (Resumable). Miren el caso: Selecciono mis elementos de mi base de datos local, y luego envío los datos a una API pero no se envían de forma apropiada por que, como es un...

Ola NB: The code here explains the use of parameter based queries for CRUD I have been exploring MySQL with BANano, this was previously done using external PHP files and thus using .CallAjax BANano Calls. This was explained in [BANano] MySQL CRUD with PHP - Part 1 [BANano] MySQL CRUD with...

Hi I'm trying to connect to my sql server from android. I am at the beginning, that is, with the connection and I am already at rest I wrote this with my credentials but it never initializes Sub Button1_Click Dim db As MYSQL Dim L As List...

Ciao sto tentando di connettermi al mio sql server da android. sono all' inizio cioè alla connesisone e già sono fermo- Ho scritto questo con le mie credenziali ma non inizializza mai Sub Button1_Click Dim db As MYSQL Dim L As List...

Ola Kinda excited that this is starting to form a shape. This second part of the tutorial deals with reading the users from the MySQL users table and then displaying them in a table. The first part we just did an intro into what we intend doing and showed how to 1. CREATE a user 2. READ a...

Ola [BANAno] MySQL CRUD with PHP - Part 2 Well, the Business College website I'm creating has a portion of where the potential students need to register online. The data needs to be stored in a MySQL database. I intend to use various php files that should be sitting on a webserver so the...

Is there any way to validate that an INSERT query was succesfull on a remote MySQL database? Other than to then run another query to retrieve the recordset created? e.g. sSQL="INSERT INTO statements_collected(ID, Client, DeviceID) VALUES(" & Crsr.getint("ID") & "," & Main.iUserID & ",'" &...

Hi there The purpose of this is to demo how one can add, update, read and display mysql database records into a webview. 1. Setting up development environment For this we have used, Xampp with MySQL, BlueStacks android emulator to install and test our apk, some php with CRUD functions etc...

Hi there Update: April 8, 2019 Solution [BANAno] MySQL CRUD with PHP - Part 1 [BANano] MySQL CRUD with PHP - Part 2 I have an issue that I need to address. I have a backend that I need to speak to from my BANano App, this could either be MySQL or either MSSQL (no decision as yet). I guess...

Hola a todos!, soy nuevo en el tema de B4A y estuve revisando un poco varios foros y veo que hablan mucho de JRDC y JRDC2(recomendado), como soy nuevo en esto mi pregunta es si este Middleware que codificó Erel se puede correr en Linux mediante, Apache, Tomcat, Daemon ú otra forma. Alguno tiene...

Buenas a todos. En este enlace https://mega.nz/#!jKRDXCgT!3BgdgywykwpV4tXfR5A6s7lemuvj0Pl8DUnKajYkB0Q podran descargar un zip con ejemplos de modelo cliente servidor. Veran que no es nada nuevo pero: No fallan con las ñ y acentos. Corren en las versiones ultimas de WAMP (mysql vs msqli) Hay...

Hello, I'm facing a big problem with an app developed in B4A already on production, that is driving me crazy. The problem started this morning with no reason. I was working yesterday and sent an update to customer to check everything was ok before upload it to google play. until this morning...

Hello. I'm writing an app that allows several computers to add new orders to the database. To avoid any conflicts, I want to make sure that when one system is adding a new list of orders, no others can interrupt and will have to wait for the first one to finish up. I understand that the most...