6 {{ upvoteCount | shortNum }}
6 {{ upvoteCount | shortNum }}

Qr code with database question

by Jimi b
3 replies
hello fellow warriors.
I need a little advice on how to create a sign in/verification program using qr codes. This is how it should work.

A lead signs up for an offline service via web form. Their info is collected and then sent to a database In wich A qr code is automatically generated containing the info the lead input into the web form. The lead then goes to the offline location and the service provider scans their printed out qr code to do three things, 1) sign them in 2) alert duplicate sign ins 3) and verify the qr codes info is listed in the database.

If anyone can point me in the right direction or have knowledge pertaining to this I would highly appreciate it. Thanks in advance.
#code #database #qrcode #question
  • Profile picture of the author maxmalini
    Well,

    Basically, the QR code is going to act as a GUID for that user/person. So, when you are designing your DB, you would create a field to designate for the ID generated from the QR code and use that as the GUID or link it to the GUID of the user. This way, when they get "logged in" by scanning the QR code, your application will be able to decode the QR and compare it to what is stored in the DB to find a match. You can alert to multiple logins by keeping a sessions table and if the count for a certain GUID/QR is higher than 1, then obviously there are more than 1 current logons.

    - Max
    {{ DiscussionBoard.errors[4303796].message }}
  • Profile picture of the author dudeontheweb
    All the QR code would need is an URL with the user ID number in the query string. This would be generated when the user signs up.

    example (http://www.offersite.com/index.php?ID=12345)

    You could also pass other variables like the sales person id or any type of tracking number.

    The lead then goes to the offline location and the service provider scans their printed out qr code to do three things, 1) sign them in 2) alert duplicate sign ins 3) and verify the qr codes info is listed in the database.
    Why would you want to login each individual QR code? Would the customer have access to a terminal or kiosk? Or would you have an associate run the terminal ? If the latter, I would think it would be simpler to have the associate access the data with his/her account.
    Signature

    Need a QR Code? Check out my QR Code Generator. It's FREE!

    {{ DiscussionBoard.errors[4304707].message }}
  • Profile picture of the author KirkMcD
    Why do you want to do this via a QR code? Because QR Codes are "hot"? Why do you make them print out the QR code? If you are going to use it, and if the person has a smartphone send the QR code to the phone, so it can be scanned from the phone screen

    Otherwise, all the person really needs is an id code that they would just give to whoever to enter to do the lookup in the database.

    It seems like you are making this much more complicated than it should be.
    {{ DiscussionBoard.errors[4306913].message }}

Trending Topics