mysql

  1. M

    Android Question How do I connect to MYSQL in my application?

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

    Share My Creation ChatApp v1.1

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

    Android Question Login Form using MySql in jRDC2 Help!

    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...
  4. José J. Aguilar

    Spanish [B4XPages] jRDC2 + MySQL CRUD + Login

    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 con bastante...
  5. José J. Aguilar

    Android Example [B4XPages] jRDC2 + MySql CRUD + Login

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

    Android Question [B4A] Cannot connect to database

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

    Android Question Placing images in xCustomListView from apache server using mysql logs

    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...
  8. Star-Dust

    B4J Library [B4X] [B4XLib] SD_SQL (direct access to MySQL, MS SQL, FireBird)

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

    Android Question JdbcSQL and SQL are compatible?

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

    B4J Library [BANanoConnect] BANanoSQL+SQLite+MySQL+MSSQL Library

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

    B4J Question Inserting data to online mysql database

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

    Android Question How to Insert any rows from XcustomListView to mysql table

    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... :)
  13. saeed10051

    Android Question How to get an array using okhttputils2

    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()...
  14. demonio_jack

    Android Question Installing B4A App with MySQL

    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"...
  15. 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.
  16. 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...
  17. 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 '...
  18. 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...
  19. 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...
  20. 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...
Top