I cannot, for the life of me, figure out how to get a search bar and access my database through it. I am building a bible app and have the database but i do not know how to connect the two. Any Advice?
Is it mySQL? The pages are here: http://docs.coronalabs.com/api/library/sqlite3/index.html
Once you get a text string, it looks like you do a
file:exec( SQL\_Command )
to get records back from the db. They’ve got some better than usual examples it seems on the docs page.
I have looked through all that for hours lol. im new to my sql and databases. Are there any sample codes? How can i get a search bar to search my database ? im just not understanding lol
For text entry, there’s things in the corona code exchange like: http://code.coronalabs.com/code/forms-native-text-entry-fields-based-scrollview-widget
For the mySQL, that doc page linked above has examples. Another doc is at:
http://coronalabs.com/blog/2012/04/03/tutorial-database-access-in-corona/
But you don’t need to do both at the same instant, as you only have one set of hands to type. So tackle one or the other first – either get text entry going first, or get some db action going on using temporary search text like “Pontius”.
Lol its all kinda sounding like greek to me. I have the database already. How would i code in my main.lua file to call a search box and if i want genesis 3:13 i would type genesis and it would display the book of genesis? I have been looking through these source codes and i am still not getting it srry.
Is it mySQL? The pages are here: http://docs.coronalabs.com/api/library/sqlite3/index.html
Once you get a text string, it looks like you do a
file:exec( SQL\_Command )
to get records back from the db. They’ve got some better than usual examples it seems on the docs page.
I have looked through all that for hours lol. im new to my sql and databases. Are there any sample codes? How can i get a search bar to search my database ? im just not understanding lol
For text entry, there’s things in the corona code exchange like: http://code.coronalabs.com/code/forms-native-text-entry-fields-based-scrollview-widget
For the mySQL, that doc page linked above has examples. Another doc is at:
http://coronalabs.com/blog/2012/04/03/tutorial-database-access-in-corona/
But you don’t need to do both at the same instant, as you only have one set of hands to type. So tackle one or the other first – either get text entry going first, or get some db action going on using temporary search text like “Pontius”.
Lol its all kinda sounding like greek to me. I have the database already. How would i code in my main.lua file to call a search box and if i want genesis 3:13 i would type genesis and it would display the book of genesis? I have been looking through these source codes and i am still not getting it srry.