mysql

Ola For a while I have been exploring backend connectivity using BANano for BANanoSQL, SQLite, MSSQL and MySQL. The purpose of this lib is for a one place for all your connectivity with these backends. This library as a couple of class utilities for connecting to BANAnoSQL, SQLite, MSSQL and...

i am trying to insert data to my online database using following php script <?php $conn = new mysqli("fdb23.awardspace.net", "3373050_restaurant", "abc123", "3373050_restaurant"); if ($conn->connect_error) { die("ERROR: Unable to connect: " . $conn->connect_error); } echo...

Dear All, please helm me for this case.. I have already displaying data from MySQL table into xcustomlistview panel, next on the Xcustomlistview will be added data (the number of order items) and will be inserted in to the other MySQL table (table name "salesorder") please help me... :)

I am using following php script and it is returning an array to me. How can i get the data out of this array as i am using j as httpjob, but httpjob does not have a get array type of method. $result = $conn->query("SELECT * FROM menuitems"); if ($result->num_rows > 0) { $rows = array()...

Hi everyone!!! This is my very first time in B4A and trying to install a small app with MySQL. It's work in debugging environment... but when I compile it to install in a android phone, fail. I'm not sure what I have to do, I've seen a lot of videos and posts but I haven't found "the procedure"...

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 UPDATE 2020-05-19: Please use this library instead [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...

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