{"id":224,"date":"2018-10-25T17:53:30","date_gmt":"2018-10-25T20:53:30","guid":{"rendered":"http:\/\/hackerzone.com.br\/blog\/?p=224"},"modified":"2022-08-13T00:08:54","modified_gmt":"2022-08-13T03:08:54","slug":"qr-code-com-o-google-e-php","status":"publish","type":"post","link":"http:\/\/hackerzone.com.br\/blog\/qr-code-com-o-google-e-php\/","title":{"rendered":"QR Code com o Google e PHP"},"content":{"rendered":"

O Google fornece a API de c\u00f3digo QR. N\u00f3s podemos usar isso usando php. Ao digitalizar o c\u00f3digo QR, obtemos informa\u00e7\u00f5es espec\u00edficas. aqui chl \u00e9 a string codificada em url que voc\u00ea tem que adicionar em um c\u00f3digo QR. O choe \u00e9 a codifica\u00e7\u00e3o (opcional).<\/p>\n

Vamos fazer o exemplo seguindo o c\u00f3digo:<\/p>\n

\r\n<!DOCTYPE html>\r\n<html lang="en">\r\n    <head>\r\n        <title>Bootstrap Example<\/title>\r\n        <meta charset="utf-8">\r\n        <meta name="viewport" content="width=device-width, initial-scale=1">\r\n        <link rel="stylesheet" href="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/css\/bootstrap.min.css">\r\n           <script src="https:\/\/ajax.googleapis.com\/ajax\/libs\/jquery\/3.2.1\/jquery.min.js"><\/script>\r\n        <script src="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/3.3.7\/js\/bootstrap.min.js"><\/script>\r\n    <\/head>\r\n    <body>\r\n \r\n        <div class="container">\r\n            <img id="qrcodeimg" \/>\r\n            <form>\r\n                <div class="form-group">\r\n                    <label for="sel1">Select list (select one):<\/label>\r\n                    <select class="form-control" id="sel1" onchange="getQrData(this.value)">\r\n                        <option value="1">Peter<\/option>\r\n                        <option value="2">Gary<\/option>\r\n                    <\/select>\r\n                    <br>\r\n                <\/div>\r\n            <\/form>\r\n        <\/div>\r\n        <script>\r\n            function getQrData(para) {\r\n                $.ajax({\r\n                    type: "POST",\r\n                    url: "getQrCode.php",\r\n                    async: false,\r\n                    data: {userId: para},\r\n                    success: function (data) {\r\n                        $('#qrcodeimg').attr('src', data);\r\n                    }\r\n                });\r\n            }\r\n        <\/script>    \r\n     \r\n    <\/body>\r\n<\/html>\r\n<\/pre>\n
E aqui est\u00e1 o arquivo PHP para obter a resposta da p\u00e1gina PHP.<\/p>\n
\r\n<?php\r\n$servername = "localhost";\r\n$username = "root";\r\n$password = "";\r\n$dbname = "albumdb";\r\n\r\n$userId = $_POST['userId'];\r\n\/\/ Create connection\r\n$conn = new mysqli($servername, $username, $password, $dbname);\r\n\/\/ Check connection\r\nif ($conn->connect_error) {\r\n    die("Connection failed: " . $conn->connect_error);\r\n}\r\n$query = "SELECT *\r\nFROM `user` WHERE userId='" . $userId . "'";\r\n$result = $conn->query($query);\r\nif ($result->num_rows > 0) {\r\n    $row = $result->fetch_assoc();\r\n    $content = json_encode($row);\r\n    $size = 300;\r\n    $google_api = "http:\/\/chart.apis.google.com\/chart?" . 'chs=' . $size . 'x' . $size . '&cht=qr&chl=' . urlencode($content);\r\n    echo $google_api;\r\n    exit;\r\n}\r\n?>\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
O Google fornece a API de c\u00f3digo QR. N\u00f3s podemos usar isso usando php. Ao digitalizar o c\u00f3digo QR, obtemos informa\u00e7\u00f5es espec\u00edficas. aqui chl \u00e9 a string codificada em url que voc\u00ea tem que adicionar em um c\u00f3digo QR. O choe \u00e9 a codifica\u00e7\u00e3o (opcional). Vamos fazer o exemplo seguindo o c\u00f3digo: E aqui est\u00e1 […]<\/p>\n","protected":false},"author":1,"featured_media":456,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[100,15,98,99],"class_list":["post-224","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","tag-google-qr-code","tag-php","tag-qr-code","tag-qrcode","cat-12-id","has_thumb"],"_links":{"self":[{"href":"http:\/\/hackerzone.com.br\/blog\/wp-json\/wp\/v2\/posts\/224","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/hackerzone.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/hackerzone.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/hackerzone.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/hackerzone.com.br\/blog\/wp-json\/wp\/v2\/comments?post=224"}],"version-history":[{"count":1,"href":"http:\/\/hackerzone.com.br\/blog\/wp-json\/wp\/v2\/posts\/224\/revisions"}],"predecessor-version":[{"id":225,"href":"http:\/\/hackerzone.com.br\/blog\/wp-json\/wp\/v2\/posts\/224\/revisions\/225"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/hackerzone.com.br\/blog\/wp-json\/wp\/v2\/media\/456"}],"wp:attachment":[{"href":"http:\/\/hackerzone.com.br\/blog\/wp-json\/wp\/v2\/media?parent=224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/hackerzone.com.br\/blog\/wp-json\/wp\/v2\/categories?post=224"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/hackerzone.com.br\/blog\/wp-json\/wp\/v2\/tags?post=224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}