insert a QR code scanner result using Php and ajax with mysql database

Inserting a QR code scanned result in MySQL without reloading the web page
source code: drive.google.c...

[@axnxn]

Oh my god maraming salamat! Nangarap ako na gumawa nang ganito sa university namin pero kaso beginner palang ako, marami akong natutunan dito salamat talaga!

[@calvinplacio2744]

Maraming salamat po , sorry hindi na me makagawa ng content wala kasi ako maisip na next

[@axnxn]

@@calvinplacio2744 oks lang

[@leowilsacoso5949]

sir salamat ng marami laking tulong po ng project na ginawa mo para sa capstone namin God bless.

[@calvinplacio2744]

[@sandrajohannylararico5121]

bro, where or how you clone the index, cause i want to modifique with some CSS but when i scan appears the index clean again

[@1979supat]

Great, thank you. 2 more questions. 1. How to default the back camera phone? 2. Use sound to check the information. If correct, use one sound. If it's not correct, use another sound. What should I do? please advise.

[@TheElminaorg]

i scan barcode from image but it`s not inseret im used it on my website

[@tin_9342]

Sir, tanong lang paano kapag kailangan sa attendance yung qr code. Based sa 4:07 hindi na siya malalagay diba? Paano po kapag sa mga susunod na araw bali nagscan bali hindi niya made-detect and lalagay sa database na?

[@meisyasuandarialtyn5381]

Please help me create a web input for incoming and outgoing goods using a qr coe scan

[@calvinplacio2744]

Do you mean products?

[@markanasarias7515]

hello po ask ko lang po sir kung yung pag save sa database ng attendance is once a day lang po? salamat po god bless.

[@calvinplacio2744]

As long as nag iscan sya ng qr nag sasave sya sa db pero pede mo yun gawin using if else sa code

[@markanasarias7515]

Kasi po nakalagay countrow == 0 so pag may nakasave na po na same ng value ng qr di na po sya mag sasave

[@calvinplacio2744]

@@markanasarias7515 if want mopo mag save every scan pede naman po tanggalin yun if parang ginawa ko lang un para hindi mag save if ever po na scan na

[@aisyahzainal59]

hello, i couldnt find the index.html file

[@calvinplacio2744]

There is no index html file it is on PHP file format to be able to run PHP scripts

[@NatchYeal]

Good day sir May tutorial po ba, sir, na mag-scan ng QR code ang user pagkatapos lalabas ang form na kaylangan nilang e fill up

[@calvinplacio2744]

@@NatchYeal try natin yan

[@romsandro3811]

great. Hi who tried with phone back camera?

[@calvinplacio2744]

I tried it also it works i deploy it in webhosting

[@drezny]

muy bueno muchas gracias, tambien funciona en navegador móvil solo que no tengo el nivel para poder modificarlo

[@tahamidebnarouftahamid6381]

It works fine in localhost but in the client side camera cannot work, please give solution

[@calvinplacio2744]

You need SSL for the camera to work

[@tahamidebnarouftahamid6381]

@@calvinplacio2744 if i want to work within the intranet, then that will be the solution please?

[@tahamidebnarouftahamid6381]

@@calvinplacio2744 thanks for your quick replay

[@calvinplacio2744]

@@tahamidebnarouftahamid6381 you can use sql hosting for the database and a web server for the php code to run

[@jerryinn650]

@@calvinplacio2744 sir, can you provide a tutorial for the SSL configuration

[@itsMeRem684]

Lods pano paganahin ung camera pag dineploy na dineploy ko sakin sa infinity free di nagana camer tiningnan ko sa console may error

[@calvinplacio2744]

May SSL CERTIFICATE napo ba ang website mo? Need kasi nyan ng SSL cert para mapagana

[@itsMeRem684]

@@calvinplacio2744 libre lang ba yon lods ? Newbie lang ako eh

[@itsMeRem684]

@@calvinplacio2744 eto po ung error eh ma fifix bato pag meron ng ssl certificate?? Error: attendance.php:306 Error: Cannot access video stream (TypeError). at new i (instascan.min.js:9:8741) at Function. (instascan.min.js:9:11540) at n (instascan.min.js:4:22972) at Generator._invoke (instascan.min.js:4:24092) at e. [as throw] (instascan.min.js:4:23151) at n (instascan.min.js:4:22972) at r (instascan.min.js:4:23207) at instascan.min.js:4:23385

[@calvinplacio2744]

@@itsMeRem684 opo libre lang yun hanapin mo lang free ssl sa infinity free

[@calvinplacio2744]

@@itsMeRem684 Oo need talaga SSL ganan rin na encounter ko na error nung capstoblne ko pagdating sa Geolocation API

[@bascbrims]

boss baka meron kapo pang barcode?

[@robipastores]

Pag nag add ba ng employee auto generated na din ang QR Code sa system?

[@calvinplacio2744]

Pwede po you can refer to this project kzbin.info/www/bejne/i6fPZmp8aNmJpZo

[@jomarbombita5078]

Nice ....🙂

[@calvinplacio2744]

thanks sir

[@sithusoe8797]

Thanks a lot.... God Bless U

[@calvinplacio2744]

Welcome po

[@joeybayona]

good eve ... thanks for sharing this .. Ask ko lang sir kung meron kang script ng pag generate ng qrcode na ang code ay from mysql table at i display siya by fetch array example Ang table ko ay list of names wtih corresponding unique number na siyang magigng qrcode .. at i echo siya sa php at ang display niya ay names with qrcode na siya thanks i hope na get mo ang ibig kong sabihin

[@calvinplacio2744]

Meron mam will post that soon

[@joeybayona]

@@calvinplacio2744 KUMUSTA po .. meron na po ba ?

[@calvinplacio2744]

@@joeybayona will do that soon mam i just recently posted is converting a text to qr but not from MySQL tables

[@leowilsacoso5949]

matanong q na din sir ano po ang function ng lists of names dito sa hint at gethint?maraming salamat po.

[@calvinplacio2744]

ay sorry for that you can disregard that or just remove it nalimutan ko kasi yan alisin jan nung inupload ko sa drive.

[@leowilsacoso5949]

ok sir salamuch ng marami God bless

[@markrumbaoa7153]

Hi po pano po ilagay sa Google sheet or i print po

[@calvinplacio2744]

Iprint ang? Qr code scanned result ba is that what u mean sir?

[@markrumbaoa7153]

@@calvinplacio2744 yes po yung result po sana sir

[@calvinplacio2744]

@@markrumbaoa7153 ahh don sa gen.php just use the echo $qr para maprint mo sya via ajax request while done naman sa gsto mo. Ilagay sa google sheet alam ko pede un via google Api kaso need mo ng payment account di kase na basta basta nag papagamit si google ng API unless connected ang bank account mo sa gmail

[@tito-ace]

anong library yang nag sscan boss ginamitan mo yan ng composer pag install? may github ba nyan?

[@tito-ace]

or documentation

[@calvinplacio2744]

Instascan sir , nasa github po sya

[@Phynxlyrics]

hi po sir pano naman po gumawa ng qr code?

[@calvinplacio2744]

Here is the link for that kzbin.info/www/bejne/i6fPZmp8aNmJpZosi=4vWTl3IdEYLLJRWS

[@aldrinmicoadalin5914]

pwede po ba yan idagdag po sa isang system din ? At how po iinsert ty po

[@calvinplacio2744]

Oo naman po

[@aldrinmicoadalin5914]

@@calvinplacio2744 How po? nahihirapan po kasi ako kung paano iinsert

[@jimboymanliguez9800]

Bossing same lang po ba dito ang log in system ng students Ano kasi imbis na mag susulat pa sa logbook e scan nalang yong qr code para sa time in and out ng students

[@calvinplacio2744]

Yes lods parang ganan nga purpose ng module na yan

[@xaiveryplays]

kuya pano yung sa qr scanner design ?

[@calvinplacio2744]

What do u mean by design sir

[@xaiveryplays]

@@calvinplacio2744 yung ui

[@calvinplacio2744]

@@xaiveryplays using bootstrap po pede po yan malagyan nyo po design just always include the ht.js po un kasi library nya paramagamit scanner

[@ryanbelangel8199]

Nice ser,

[@calvinplacio2744]

Hi i appreciate it

[@pyroiloco]

boss pano maging accurate yung time nya

[@calvinplacio2744]

Accurate na?

[@pyroiloco]

@@calvinplacio2744 yung oras nya idol hndi same sa oras natin

[@pyroiloco]

Yung time in nya

[@miku4065]

Sir panu bumuo ng qr code

[@calvinplacio2744]

I have a another video on that sir check my channel tnx

[@junbejarin7094]

boss gumagana po audio sa ginawa niyo

[@calvinplacio2744]

Yes?

[@junbejarin7094]

@@calvinplacio2744 boss pwede po ung mageexport to excel lahat ng mga nagpaqr?

[@calvinplacio2744]

@@junbejarin7094 pede nyo po iexplain nyo pa hehe medyo naconfuse ako

[@junbejarin7094]

@@calvinplacio2744 un po sanang mga name na nailalagay na scan ay meron po sanang export to excel or pdf po

[@calvinplacio2744]

@@junbejarin7094 yung qrcode ba ay in excel format possible ba yun diko pa sya natry sir

[@pattanarat]

very thank you.

[@elizabethdumaran2112]

bat di ko gagana sa akin $q = $_REQUEST['q'];

[@elizabethdumaran2112]

indi po gagana xmlhttp.open("GET", "qr_scanadd.php?q=" + res, true); wala pong laman si ['q']

[@yovia5849]

thank you

[@meisyasuandarialtyn5381]

Please help me create a web input for incoming and outgoing goods using a qr code scan