Discussion Forums  >  Plugins, Customizing, Source Code

Replies: 10    Views: 120

LockTech
Aspiring developer
Profile
Posts: 34
Reg: Feb 26, 2013
biloxi
1,340
03/06/13 10:16 AM (12 years ago)

Database Plugins??

Are there any database type plugins? I am looking to have a database store information and then populate on a form. Also possibly populate menu options from a database as well. Thanks
 
chris1
Code is Art
Profile
Posts: 3862
Reg: Aug 10, 2012
Austin, TX
50,120
like
03/06/13 12:38 PM (12 years ago)
I have a webform generator plugin in review that can connect to a database. If you want to create a menu screen from a database, you can easily do so by using php to pull data from your db and present it as JSON data. Then point your dataURL to the php script.
 
LockTech
Aspiring developer
Profile
Posts: 34
Reg: Feb 26, 2013
biloxi
1,340
like
04/16/13 04:39 PM (12 years ago)
Can the data base file stay local on the device? Important to be able to use app with no connection.
 
chris1
Code is Art
Profile
Posts: 3862
Reg: Aug 10, 2012
Austin, TX
50,120
like
04/16/13 04:51 PM (12 years ago)
It could be modified to do that, but the plugin doesn't initiate an sql database at it currently stands - that would invoke unnecessary resources for a lot of people. However, it does grab the result from the web response and store it in a variable, which could then be parsed and fed into a local database, depending on the data received back. It really all depends on how you are using the form you create. I envision most people using the plugin to gather information to send an email via php, as that is the simplest way to use it. But the possibilities are endless if you have even a small amount of skill with sql and php.
 
LockTech
Aspiring developer
Profile
Posts: 34
Reg: Feb 26, 2013
biloxi
1,340
like
04/16/13 05:19 PM (12 years ago)
skill=0....but im a fast learner. the data base would be populated with known text items. the entries would then be pulled from the data base to fill in a form template.. that would fill in diff info into that form ...depenedent on what menu selections was chosen to get to said form template. basicaly just displaying the info to the user.
 
chris1
Code is Art
Profile
Posts: 3862
Reg: Aug 10, 2012
Austin, TX
50,120
like
04/16/13 05:27 PM (12 years ago)
Hmm - not sure I completely understand what you're trying to achieve, but I actually have two plugins coming out. One is the Webform Generator plugin, and the other is called "User Settings". They are similar, but what makes User Settings different is that instead of sending the data to a php file, it saves the data to the device. By simply making up a filename and adding it to the control panel for both the User Settings screen and the Webform Generator screen, the Webform will automatically pull the data saved in the User Settings. So, here's a practical example of how that might be used: Screen 1: Plugin Type: User Settings Name: "Profile" Filename: "savedProfile" Fields: -Name -Email -Address -"save" button Screen 2: Plugin Type: Webform Generator Name: "Submit Data" Filename: "savedProfile" Fields: -Name -Email -Address -"submit" button ----- User first loads the "Profile" screen, fills out their information, and hits the save button. An alert appears showing them that their info was saved to the device. (User may then closes the app) User then loads the "Submit Data" screen. The fields are automatically populated with their data.
 
LockTech
Aspiring developer
Profile
Posts: 34
Reg: Feb 26, 2013
biloxi
1,340
like
04/17/13 05:49 AM (12 years ago)
im going to try and explain a little better and in more detail. and give you link to sample in works app.... https://www.dropbox.com/s/68x03byyv2e3jsk/BT_activity_root_test.apk for example ... suzuki>byModel>hayabusa>anyYEAR ..that will get you to a info page...some of the years goto same info page.. some goto diff info pages. ok here it goes ... the app is basicly and huge menu tree( hundreds of diff menu choices ). all menu choices all lead to only a few different information pages which are simple text/html/word pages. in its current state with simple menus and custom/html pages it is fine providing i can figure out why there is a delay on the initial load of any information page. after the first time it loads an info page i believe its in cache memory and then loads immediately. this is only a small part of the overall finished app. in the end the menu tree will be very very big ..thousands of menu choices and hundreds on info pages. all the info on the info pages are constant..doesn't change. instead of having all the many info pages as individual pages..i would like to use a form or template that would call the information it needed to display from a database. just seems to me the way it should be done as opposed to the way i am actually doing it now. anyways hope this helps clear up any questions you had about the app.
 
fredd648
Apple Fan
Profile
Posts: 14
Reg: May 11, 2013
waterloo
3,940
like
11/12/13 02:14 PM (12 years ago)
@chris1 did you publish those plug-ins you were talking about in this forum? Or where would I be able to get those? I am interested in making a connection to an oracle/mySQL database from an app Thanks!
 
chris1
Code is Art
Profile
Posts: 3862
Reg: Aug 10, 2012
Austin, TX
50,120
like
11/14/13 01:13 AM (12 years ago)
Not sure which plugins you're referring to? The database one above is for creating/connecting to a SQLite database on the device, not something in the cloud. I have built several plugins for people that do connect to backend databases on the cloud though. But they're generally not something that can be published in the market, as they're very tailored and customized.
 
chris1
Code is Art
Profile
Posts: 3862
Reg: Aug 10, 2012
Austin, TX
50,120
like
11/14/13 01:16 AM (12 years ago)
sorry - thought this was the newer database thread that started yesterday! Ah, yes - the web form generator and user settings plugins. Those are still sitting in the queue waiting to come out. David and the rest of the BT crew have been pretty busy behind the scenes trying to get the iOS7 project done and the automated plugin market done. Trying real hard to get those done before the end of 2013. Once that happens, those two plugins I mentioned above should come out fairly quickly, as well as a host of others from other people.
 
fredd648
Apple Fan
Profile
Posts: 14
Reg: May 11, 2013
waterloo
3,940
like
11/18/13 05:16 PM (12 years ago)
@chris1, yes I was referring to the web form generator and user settings plugins. I am trying to access data in an SQL DB and retrieving it on the screen using the HTML plugin... so I have been doing a bit of research and asking in the forum on how to do the connection. However, if there was a plugin that does this, it would save me a lot of time! I have been following a tutorial by GoNorthWest, however, if you have other information on how to do the connection, or examples you could share with me, I would really appreciate it!
 

Login + Screen Name Required to Post

pointerLogin to participate so you can start earning points. Once you're logged in (and have a screen name entered in your profile), you can subscribe to topics, follow users, and start learning how to make apps like the pros.