Android app, SQL database, and QR Codes

Closed

Android

BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Aug 6, 2018 at 05:15 PM
Ambucias Posts 47356 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 - 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.

Android qr code scanner with database
Www.gameloft.com unlock code ✓ - Phones, PDA & GPS Forum
Flixtor.to app android - Download - Movies, series and TV
Access database download - Download - Databases
Samsung keypad reset code - Guide
Battery reset code - Guide

3 responses

Answer 1 / 3

Blocked Profile
Aug 6, 2018 at 05:21 PM

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?

BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 150
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.

Blocked Profile
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!

Answer 2 / 3

Ambucias Posts 47356 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,172
Aug 6, 2018 at 06:11 PM

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.

BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 150
Updated on Aug 7, 2018 at 09:40 AM

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.

Ambucias Posts 47356 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,172 > BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021
Aug 7, 2018 at 05:43 PM

As they pipe and say in the Royal Navy: "Up spirits!"

Answer 3 / 3

Ambucias Posts 47356 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,172
Aug 6, 2018 at 05:38 PM

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 ?

BrianGreen Posts 1005 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 150
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.

Similar discussions

How do I fix a corrupted MS Access database?

how to store textbox value in database

Google Calendar icon displays wrong date

How to download and use for android

How to enable print services Samsung Android

Sending msg through ip address

Similar discussions

Subscribe To Our Newsletter!