mysql

  1. A

    Android Question Load Mysql table into B4XTable

    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.
  2. Kevin Hartin

    Android Question Put SQLite BLOB into MySQL BLOB using PHP

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

    B4J Question mysql resultset to xml

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

    B4J Question String parse

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

    Other jShell: MySQLDump.exe (does not work) vs. batch file (works)

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

    Android Question Connect Mysql Library

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

    Spanish Problema con Webview

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

    Spanish [RESUELTO] OkHTTPUtils2 - MySQL Bloqueante

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

    B4J Tutorial [BANano] MySQL CRUD with PHP - Part 3.1 (A look an inline PHP)

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

    Android Question mysql connection problem

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

    Italian Errore connessione DB mysql

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

    B4J Tutorial [BANano] MySQL CRUD with PHP - Part 2

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

    B4J Tutorial [BANano] MySQL CRUD with PHP - Part 1

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

    Android Question JDBC MySQL

    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 & ",'" &...
  15. Mashiane

    Android Tutorial MySQL data to webview using PHP

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

    B4J Question [BANano]: [SOLVED] Using MySQL / MSSQL with PHP

    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...
  17. Guillermo Manoukian

    Spanish JRDC2

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

    Spanish EJEMPLOS VARIOS: Modelo cliente-servidor con MySQL, ODBC,ANDROID,WAMP etc.

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

    Android Question Problem with JRDC2 / java and "Object should first be initialized"

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

    B4J Question Using jSQL to Lock a mySQL table for writing

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