# insert a record to a database from QR code FROM cellphone **URL:** \ **Category:** General\ **Created:** [May 16, 2018, 11:50pm UTC](https://forum.xojo.com/t/insert-a-record-to-a-database-from-qr-code-from-cellphone/43542 "2018-05-16T23:50:29Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![nicolás\_canessa](https://forum.xojo.com/letter_avatar_proxy/v4/letter/n/9de053/32.png) [@nicolás\_canessa](https://forum.xojo.com/u/nicol%C3%A1s_canessa)\ **Post date:** [May 16, 2018, 11:50pm UTC](https://forum.xojo.com/t/insert-a-record-to-a-database-from-qr-code-from-cellphone/43542/1 "2018-05-16T23:50:29Z")
i searched the forum and i wasn’t able to find anything related. i want to use my cellphone to scan QR barcodes and insert it into a database. any idea of how could i achive this? ---
**Author:** ![Mark\_Strickland](https://forum.xojo.com/user_avatar/forum.xojo.com/mark_strickland/32/628_2.png) [@Mark\_Strickland](https://forum.xojo.com/u/Mark_Strickland)\ **Post date:** [May 17, 2018, 12:51am UTC](https://forum.xojo.com/t/insert-a-record-to-a-database-from-qr-code-from-cellphone/43542/2 "2018-05-17T00:51:23Z")
I have used Pic2ShopPRO on my iPhone to capture barcode data into a Web App. The App has a built in browser and you can capture the bar code then do whatever you want with the data. I built an inventory tracking system that would scan a bar code, accept a little keyboard input, then save the transaction in a database. It supports many different bar codes including QR codes. It appears there is also an Android version. If you decide you want to explore this as a possibility post back here and I will share the code for you. ---
**Author:** ![nicolás\_canessa](https://forum.xojo.com/letter_avatar_proxy/v4/letter/n/9de053/32.png) [@nicolás\_canessa](https://forum.xojo.com/u/nicol%C3%A1s_canessa)\ **Post date:** [May 17, 2018, 2:33pm UTC](https://forum.xojo.com/t/insert-a-record-to-a-database-from-qr-code-from-cellphone/43542/3 "2018-05-17T14:33:46Z")
yes please, i want to explore that as a possibility ---
**Author:** ![Hal\_Gumbert](https://forum.xojo.com/user_avatar/forum.xojo.com/hal_gumbert/32/160_2.png) [@Hal\_Gumbert](https://forum.xojo.com/u/Hal_Gumbert)\ **Post date:** [May 17, 2018, 4:41pm UTC](https://forum.xojo.com/t/insert-a-record-to-a-database-from-qr-code-from-cellphone/43542/4 "2018-05-17T16:41:19Z")
> [@388156:@nicolscanessa](#): > > i searched the forum and i wasn’t able to find anything related. i want to use my cellphone to scan QR barcodes and insert it into a database. any idea of how could i achive this? Do you want to scan QRCodes that you create or random QRCodes that you happen to find? If you’re creating the QRCodes: - Create QRCodes that look something like [myDomain.com/api/someaction?name=hal](http://myDomain.com/api/someaction?name=hal) or use a static IP address instead of a domain. - Create a Xojo Web App that has code in WebApplication.HandleURL to read from the WebRequest. - Write the WebRequest data to the Database. ---
**Author:** ![nicolás\_canessa](https://forum.xojo.com/letter_avatar_proxy/v4/letter/n/9de053/32.png) [@nicolás\_canessa](https://forum.xojo.com/u/nicol%C3%A1s_canessa)\ **Post date:** [May 18, 2018, 3:11am UTC](https://forum.xojo.com/t/insert-a-record-to-a-database-from-qr-code-from-cellphone/43542/5 "2018-05-18T03:11:42Z")
i like this approach @Hal Gumbert . but i was thinking… if i assign an url to the qr code, the user could easily replace the code i want to send, using any web browser… just changing the parameters manually ---
**Author:** ![Emile\_Schwarz](https://forum.xojo.com/letter_avatar_proxy/v4/letter/e/90ced4/32.png) [@Emile\_Schwarz](https://forum.xojo.com/u/Emile_Schwarz)\ **Post date:** [May 18, 2018, 3:57am UTC](https://forum.xojo.com/t/insert-a-record-to-a-database-from-qr-code-from-cellphone/43542/6 "2018-05-18T03:57:02Z")
Why this can be bad ? ---
**Author:** ![nicolás\_canessa](https://forum.xojo.com/letter_avatar_proxy/v4/letter/n/9de053/32.png) [@nicolás\_canessa](https://forum.xojo.com/u/nicol%C3%A1s_canessa)\ **Post date:** [May 18, 2018, 11:50am UTC](https://forum.xojo.com/t/insert-a-record-to-a-database-from-qr-code-from-cellphone/43542/7 "2018-05-18T11:50:55Z")
maybe is there a few scenarios where it could suppose a security breach? perhaps a user could potentially insert records with the incorrect information? i am just thinking the possibilities, i’m not a security expert ---
**Author:** ![Hal\_Gumbert](https://forum.xojo.com/user_avatar/forum.xojo.com/hal_gumbert/32/160_2.png) [@Hal\_Gumbert](https://forum.xojo.com/u/Hal_Gumbert)\ **Post date:** [May 18, 2018, 1:40pm UTC](https://forum.xojo.com/t/insert-a-record-to-a-database-from-qr-code-from-cellphone/43542/8 "2018-05-18T13:40:47Z")
> [@388325:@nicolscanessa](#): > > i like this approach @HalGumbert . but i was thinking… if i assign an url to the qr code, the user could easily replace the code i want to send, using any web browser… just changing the parameters manually You could encode the parameter string. ---
**Author:** ![system](https://forum.xojo.com/uploads/default/original/1X/455b4dcc0e61630e9f81940004ddffa49c432a46.png) [@system](https://forum.xojo.com/u/system)\ **Post date:** [October 29, 2020, 7:13pm UTC](https://forum.xojo.com/t/insert-a-record-to-a-database-from-qr-code-from-cellphone/43542/9 "2020-10-29T19:13:06Z")