Android Question JRDC2 MYSQL COMMAND

Ayabonga

Member
Hello guys,

I have two tables from PhpMyadmin: Users table , History table. I want to insert 3 values into history table but according to user logged-in. The username and password must be selected from the users table. Can you please help me structure the sql command.
B4A CODE: 
    Dim cmd As DBCommand = CreateCommand("save", Array As String(Remytxt.Text, Hennytxt.Text, Sodatxt.Text,Starter.Username,Starter.Password))
MSQL Command from B4J config file: 
sql.save =INSERT INTO history(Remy, Henny, Soda) VALUES (?, ?, ?)
SELECT * FROM users WHERE Username = ? AND Password = ?
 
Sort by date Sort by votes

Ayabonga

Member
Erel said:
Not sure that it is not worth splitting it into two commands. It will be simple to implement and will allow you to show a meaningful error message if the username and password are wrong.
Click to expand...
Thanks for the response. I am not really good at creating SQL commands. If I create these commands separately, the insert and select command, How will I integrate/join them to do what I'm trying to achieve.
 
Upvote 0

OliverA

Expert
Licensed User
Longtime User
Try
B4X: 
sql.save =INSERT INTO history (Remy, Henny, Soda) SELECT ?, ?, ? WHERE (SELECT COUNT(Username) FROM users WHERE Username = ? AND Password = ?) <> 0
Note: May not work due to restrictions of where ? can be placed
 
Upvote 0

Erel

B4X founder
Staff member
Licensed User
Longtime User
Ayabonga said:
. I am not really good at creating SQL commands. If I create these commands separately, the insert and select command, How will I integrate/join them to do what I'm trying to achieve.
Click to expand...
You will call req.ExecuteQuery, get the value that you need and later use it when you insert data.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

E
  • Question
Android Question ResponseError. Reason: java.net.SocketTimeoutException: timeout, Response:
Replies
4
Views
3K
Enoch Taylor
E
  • Question
Android Question Record audio with system default app
Replies
12
Views
1K
vecino
  • Question
Android Question Placing parking spots on streets
Replies
5
Views
889
Andrew (Digitwell)
  • Question
Android Question java.lang.SecurityException: Permission Denial: reading com.android.providers.downloads.DownloadStorageProvider uri
Replies
0
Views
9K
Nokia
  • Question
Android Question read all rows in a MySql db with PHP
Replies
17
Views
3K
KevinSuzanne
K
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…