- This topic has 7 replies, 3 voices, and was last updated 11 years, 10 months ago by
.
-
Posts
-
i have created the some pages in php. i have created database in phpmyadmin. i have connect the DB and done some process like storing the given values. Now i want to bring that pages into app and also i need DB connection for update. i have way to include php files in mobione but for updating in DB i dont know what to do ?whether to put new database or is there any way to export my database to mobione? i bought this mobione and i have done 3 apps by using your help. so can you give me some example project or tell me some solution for this?
You mention embedding php in a mobione app. This is a FAIL if you are creating a traditional app that contains all of its UI and functionality. There are different ways to implement an app. For a traditional app architecture the app contains all of its UI – no UI is served from a web server. Given this, your server-side php will not be executed on the device. The php is only useful when executed on a server with the php template engine. The php files will need to be ported to html and javascript that resides in the app. The data access that the php would typically perform such as CRUD on a DB will need to be implemented as web services.
There is a lot to creating a multi-tier app. If I my response is inconsistent with your goals please restate your problem with more details.
ok. Thank you Wayne. I have question. i want to do a project like customer feedback( either by having text box or by checking the radio button). i have 5 forms, In that i need to submit the forms to store their replies in external database. when they started to give feedback from first page if the net is disconnected we want to store the data in local after connection came it will have to send. To store this data in local storage how it will be done in mobione?
I would recommend PouchDB and CouchDB. It is a syncing db and is based on Index DB.
I use PouchDB for the local app storage and when on line is will sync for you to the CouchDB server. You can also use SQlite or IndexDB for the local then you will have to provide the syncing to you Server DB.
It works well. I have been developing a CRUD framework for the DB apps and this is the way I decided to go, because of the syncing and the reliability has been great.
Cheers…
@ nvts Give me some sample codes to connect PouchDB or Mysql with mobione . It will be very useful for me. I have local database in phpmyadmin.
Hello,
It is a little more complicated than just connecting to your MySQL db.
What are you wanting to do once you connect?
If it is CRUD than that needs to be coded. I have been working on my framework for quite a while. Sorry I can not share the code as it has been developed for a client that paid for it.
In Mobione, you have to call a .php file that has the code to open the db and perform the CRUD operations that resides on your server. I put this in the app_custom.js file in Mobione that calls the data and then with scripting to display the data. Then with JSON, Ajax & JS that I use in Mobione to display the following screen shots. This displays all the data and can be sorted by each field. Then selected CRUD in a popup.
See attachment 2013-07-30_074109.png See attachment 2013-07-30_074229.png
Do you have a script that is running on your server at this time for CRUD on your db or do you just use phpmyadmin for the db access?
I will try and point in the right direction. Just remember that MobiOne is a designer with some great features, but you will have to supply the code as it is not an app generator per say.
Cheers…
@nvts Thank you for your reply.. as you asked what you want to do after connect . i want to store data in external Database. my concept is after submitting each form the data should be store as first record of that table which is in server. By submitting the forms if the net is disconnected or if they goes offline it should be stored locally and when it comes online it will send to the server. So to store locally i also need to create same database in POUCH DB ryt? so there must be two Database one is in local and another is in server. for server whether i need to create DB by using COUCH DB? or its enough to be in My SQL?
