Android app, SQL database, and QR Codes

Posts
984
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
November 17, 2018
- Aug 6, 2018 at 05:15 PM - Latest reply:
Posts
55832
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
November 17, 2018
- Aug 7, 2018 at 05:43 PM
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.
See more 

Your reply

8 replies

Best answer
Posts
10861
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
November 17, 2018
- Aug 6, 2018 at 05:21 PM
1
Thank you
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.

What platform are you using already?

Thank you, ac3mark 1

Something to say? Add comment

CCM has helped 1680 users this month

Posts
984
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
November 17, 2018
- Aug 6, 2018 at 05:43 PM
Thanks ac3mark,

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.
Posts
10861
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
November 17, 2018
- Aug 6, 2018 at 05:53 PM
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!
Respond to ac3mark
Best answer
Posts
55832
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
November 17, 2018
- Aug 6, 2018 at 06:11 PM
1
Thank you
With all due respect, I suggest that the easiest way to create the app would be to use Android Studio for any type of Android devices.

Thank you, Ambucias 1

Something to say? Add comment

CCM has helped 1680 users this month

Posts
984
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
November 17, 2018
- Aug 6, 2018 at 06:43 PM
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.
Posts
55832
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
November 17, 2018
>
Posts
984
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
November 17, 2018
- Aug 7, 2018 at 05:43 PM
As they pipe and say in the Royal Navy: "Up spirits!"
Respond to Ambucias
Posts
55832
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
November 17, 2018
- Aug 6, 2018 at 05:38 PM
0
Thank you
Greetings Brian

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 ?
Posts
984
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
November 17, 2018
- Aug 6, 2018 at 06:07 PM
Hi Ambucias,

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.
Respond to Ambucias