mysql

  1. fernando1987

    Magic api (transforms any Mysql database into a rest api in just 5 minutes)

    transform any database into a rest api in just 5 minutes and without programming or knowing php instucciones: 1. create a database on your web server 2. create your tables it is important that each table created has the id field 3. upload the files inside the zip file to your server in the...
  2. M

    Android Question OKHttpUtils2 Hard Refresh?

    Hello Community, Well, I was working with PHP files for a project on the server side, when I ran into a problem. After changing the PHP file or changing MYSQL, the string received from the server as a Result is the same as the previous string and has not changed. Due to the caching of...
  3. AkuryuBR

    Android Question Error in private page with OkHttpUtils2

    Hi to all, i have made a App based on httpUtils, i pick my entry with php page and mysql_maria db, all work fine, now i decie to use private page with .htpasswd ah .htaccess and here come the problem. If i use this type of link http(s)/username:passwod@website.something in the browser (i have...
  4. PaulMeuris

    B4A-JSON app tutorial using B4A, JSON, MySQL and PHP.

    Are you up for another challenge? Try this tutorial. Maybe you like the end result. This is how it will look like: You will find some interesting links to other study material in this tutorial. And of course here is the link: B4A-JSON Happy coding! Paul.
  5. N

    Android Question connexion to mysql server online

    Hello, I have a problem when trying to connect to a mysql server online using jdbc. I have copy the jdbcSQLExemple from here : link I've only changed the url, the id and the password and i have this error : (SQLException) java.sql.SQLException: No suitable driver found for "SERVERNAME" I've...
  6. Oscarin

    Android Question Wait for, need help on how to use it

    Hi, I am using this tutorial on how to connect to MySQL DB https://www.b4x.com/android/forum/threads/connect-android-to-mysql-database-tutorial.8339/ But I have a problem because I need to wait for the query to finish before proceeding on to the next process. I send a SELECT * FROM and I need to...
  7. Oscarin

    Android Question MySql, PHP, B4A wait for query to finish

    I am using this tutorial https://www.b4x.com/android/forum/threads/connect-android-to-mysql-database-tutorial.8339/ To connect to a MySQL DB, everything works fine, but I have a problem. Sometimes I need for the query to finish before proceeding to the next line of code This is what I want to do...
  8. toby

    Android Question Having trouble implementing mysql AES_Encrypt/Aes_Decrypt compatible functions

    I'm new to encryption, btw, and I want to be able to compare encrypted mysql data on the fly while executing a select query like SELECT * from myTable WHERE encrytedField=selectedEncryptedValue or SELECT * from myTable WHERE aes_decrypt(encrytedField, '123')=selectedValue Therefore I need...
  9. Mashiane

    B4J Question [SOLVED] Hikari usage with MySQL: Connection Leaks / Connection not available

    Hi there I am trying out the Hikari connection pool and still learning its usage. There are two warnings I see often on my app. Connection Leaks [HikariPool-1 housekeeper] WARN com.zaxxer.hikari.pool.ProxyLeakTask - Connection leak detection triggered for...
  10. B

    German Daten an SQL Server

    Hallo, ich habe eine App geschrieben, welche einwandfrei funktioniert und Daten über Bluetooth empfängt und diese in eine SQL Datenbank mithilfe der SQL Bibliothek schreibt. Dies funktioniert alles super. Nun wäre es super, wenn parallel dazu alle Werte, welche in die lokale SQL Datenbank...
  11. Col

    Android Question SQL Builder - is a Library needed?

    I sometimes build long complex SQL statements from code, and it takes a lot of effort to code and test, so figured why not build a class to do it for me? Here's a very simple class (the example is in B4J) to build SQL statements from code. It consists of a very basic screen (only needed for the...
  12. S

    B4J Question What type should the variable be, when importing Date from DB?

    Hello, it's looks that importing data from mariadb with jRDC is very very strict, causing errors which take a lot of time to understand. (no offence, no doubt I'm the biggest cause) If I import via Select a row from DB and a column has date like yyyy-mm-dd, should the variable where this data...
  13. S

    B4J Question Get error when request data from jRDC server

    Hello, Some strange is happening, I can't figure out what, it must be something very small or it is a bug. I have a few buttons,which are to do something else, but I misuse them for now to figure something out. Strange thing is that I get errors depending on who knows what. I'm just testing...
  14. aeric

    Share My Creation Web API Template

    Web API Template Version: 1.15 Description: A boilerplate for creating REST API Server with database CRUD functionalities. Depends on following libraries: ByteConverter, JavaObject, jServer, Json, jSQL Features: CRUD based - RESTful Web API (GET, POST, PUT, DELETE) Front-end (HTML...
  15. Mashiane

    BANanoVuetifyAD3 - Contact Manager WebApp featuring MySQL + jRDC2 (no PHP)

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

    B4J Question MS Sql or MySql/Maria DB?

    Which of the two do you prefer to use?
  17. labcold

    B4J Question MySQL retrieve attributes from ResultSet

    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...
  18. 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
  19. Abdull Cadre

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