mysql

Ola First, thanks to everyone and each of our sponsors and donators who has made this possible. This would not be possible without B4X and BANano. Many thanks to those intellects. Over the past few months we have been attempting to ensure BANanoVuetifyAD3 works very well with jRDC2. We have...

Which of the two do you prefer to use?

I am using mysql-connector-java-5.1.48-bin [B4J 8.90] to connect to a remote MySQL instance. I am using the REPLACE INTO command to update a table which works fine. I currently do this using Dim queryString As String = $"REPLACE INTO active VALUES...

How do I get my application to do SQL queries against an online database? The tutorial below is old and the php file no longer works. https://www.b4x.com/android/forum/threads/connect-android-to-mysql-database-tutorial.8339/#content

Overview ChatApp is a Real time chatting application. Developed in B4A, along with php and mysql, the application can be easily modified and customized. App Features Mysql database One by one chat Group Chatting Single Video & Audio Call Sent/Recived Indicatior with realtime update Last seen...

Hi! I'm an absolute newbie here, I need help in validating my database using MySQL. here's my query sql.validate=SELECT * FROM `tbl_userinfo` WHERE `Username` = '" & uName.Text & "' AND `Password`='" & pWord.Text & "' In here, I have two edit texts, uName and pWord. It works just fine when I...

Hola a todos: Por fin me he puesto a probar un poco con B4XPages, y he empezado a adaptar el ejemplo B4XPages + B4XDrawer Creo que he visto algunos ejemplos con php + mysql para hacer login, etc... pero he visto pocos con jRDC2. Los datos de la base de datos y la interfaz gráfica son bastante...

Hi all: I'm starting (at last) to work with B4XPages, so I've started to adapt the B4XPages + B4XDrawer example. I think I’ve seen more examples with php + mysql, but no projects with Jrdc2. Maybe the dummy data and the UI are too basic, but you can get some ideas. What do we need? - A...

Hello there, Can anyone help me? i tried to use b4a to mysql with b4j jRDC and show this error ResponseError. Reason: java.net.ConnectException: Failed to connect to /192.168.0.8:17178, Response: ERROR: java.net.ConnectException: Failed to connect to /192.168.0.8:17178 The IP Addresses is...

Hello, as the title indicates, I am seeing some examples of xCustomListView, but in the case of placing the images, it seems they only use the ones stored in the "File.DirAssets", I have seen the example of obtaining data from mysql and it works for me, but not I manage to put the images in the...

Based on @Peter Simpson's code (here), I developed a library that allows you to connect directly to MySql, MsSql (for the moment) databases with B4A and B4J. To be clear, you don't need JRDC to connect to the database located on a server (I am working on a version for b4i, but it is only...

Hello everyone: Today I have a fairly specific question: Are the JdbcSQL and SQL libraries compatible or not? I have been developing an app (android) using JdbcSQL, as recommended, and connecting to a MYSQL server without any problem. However, for a few days now, I have wanted to add to my...

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