Android Question B4A Mysql question

A

apty

Active Member
Licensed User
Longtime User
I am connecting to an online mysql db using B4A job. My table has questions and i would like to move from one question to the next using previous/next buttons.

What i have done so far is to add the id of the questions to a list. I then use an index and set it to
B4X: 
    CurrentIndex = questionslist.Size
my questionslist.size returns the correct number of questions from the table

How can i use it to get the exact question and post it on current page, then when i click next, it moves to the next question?
 
Sort by date Sort by votes
A

apty

Active Member
Licensed User
Longtime User
i am connecting as below:
B4X: 
Sub selectquestions
 
    ExecuteSelectQuery("select question,id from questions",Q_SELECT)
  

End Sub
Sub ExecuteSelectQuery(Query As String, JobName As String)
    Dim job2 As HttpJob
  
    job2.Initialize("job2", Me)
  
    job2.PostString(url, Query)
  
End Sub

I then use the below code in JobDone

B4X: 
questionslist.Add(m.Get("id"))

The questionslist contains ids of the questions.
 
Upvote 0
A

apty

Active Member
Licensed User
Longtime User
Thanks. The problem i am having is how to move to next and previous pages showing next and previous questions. For example if my list has the following
B4X: 
[{"question":"test question"},{"question":"test question2"},{"question":"test question3"}]
and i have a layout with a label and two buttons (previous and next buttons). How can i show the question on the label and move to next question on clicking next button?
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Question
Android Question SQL Query??
Replies
7
Views
750
Mahares
M
  • Question
Android Question how to create a quiz in B4A?
Replies
15
Views
3K
DonManfred
  • Locked
  • Sticky
  • Question
Other For new(er) members: How to post a question/issue
Replies
18
Views
41K
Erel
A
  • Question
Android Question SQLite Insert Question
Replies
8
Views
1K
AndyChang
A
  • Question
Android Question Playing a Query in Listview
Replies
2
Views
678
Computersmith64
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…