Ok - a new project in an area have never played with before.
I am trying to build an android app where the user scans a QR code (or a bar code) and then is presented with details about the item scanned from an SQL database that has been pre-prepared. The user should not have any way to change the database. Everything I have seen on google gives users the ability to change the database.
Background about me - I have a little HTML and PHP and minimal SQL experience but nothing about programing an app.
Any ideas of what websites I can go toto help me build this app would be appreciated.
Set the Back end TO QUERY the DB, not write to it. The SQL statement does this. Use a SELECT statement.
If the platform you are using allows for account control, set the APP to a USER that only has READ ONLY access. Never allow the APP to connect on an account that has full.
Now, if the account is set to read, all the user can do is scrape the data out, and never can alter it.
Im not using anything just yet - this will be my first android app attempt, so I really have no idea what Im doing - in fact I dont even know what language I will be using to build it.
OK, well to start off, the APP will just RUN stored procedures, and return the product of those procedures to the device. So, you will need something that will allow STORED procedures. Then you will not have to worry abut the user, as NO STORED procedure will ever WRITE!
SO, so far, you will need a client device (app), and a server to handle web request. The web server will serve the client, and send commands to the DB server. The DB server will run a stored procedure, and send the product (listing) back to the Webserver, who will send it to the client. There is a 10K foot view of the wireframe!
Have FUN!
Just took a quick look at that and it looks like its just what I need. I will take a closer look tomorrow and see where it takes me. Hopefully a new plethera of apps will soon be on the market!
I think you get todays beer, but ac3mark also gets one as well. Thank you both fo your help.
Who would be the potential users and for what purpose ? What kind of business is it? You should give more details, as you explain it, you make it mysterious. Will you app be published on Android ?
How did you manage to inherit this new challenging project for which you have little or no knowledge ?
I have recently joined a slimming club and just want a quick way of scanning a barcode when in the shop and seeing how many points the slimming club thinks it has. I know there are hundreds of products out there, but I am hoping the idea might get a little help from some trusted helpers who will be able to advise on food items. It will be destributed for free to the club members.
Currently there is a book which members use to look up the foods they buy, but this requires a lot of pre-shopping planning. This app has the advantage that on the days that you just get in late and need something to eat you can scan what you have in the fridge and count the points easily.
If this works it could be multi-club compatible, but Im starting small and just want this for me at the moment - using the foods I already have in the fridge.
- Posts
- 1005
- Registration date
- Saturday January 17, 2015
- Status
- Moderator
- Last seen
- October 2, 2019
211Im not using anything just yet - this will be my first android app attempt, so I really have no idea what Im doing - in fact I dont even know what language I will be using to build it.
- Posts
- 13029
- Registration date
- Monday June 3, 2013
- Status
- Member
- Last seen
- October 11, 2019
1628SO, so far, you will need a client device (app), and a server to handle web request. The web server will serve the client, and send commands to the DB server. The DB server will run a stored procedure, and send the product (listing) back to the Webserver, who will send it to the client. There is a 10K foot view of the wireframe!
Have FUN!