Hal Yang Harus Diperhatikan Dalam Membuat QrCode di PHP dan Mysql di localhost
Langsung saja saya mencontoh dari Membuat QR Code Dengan PHP – Malas Ngoding
disini saya hanya menambahkan terjadi error nya php library phpqrcode qrimage online 74;
kenapa bisa error?? ini terjadi karena settingan php.ini belum di setting
caranya sebagai berikut :
|
1 2 3 |
bukafilephp.inixampp/php/php.ini cari;ekstensi=gddan;ekstensi=gd2 Hapus;darikeduajalur,lalurestartwebserverapachenya |
kalau mau menuruti coding saya yang sederhana ya seperti di bawah ini
pertama download bootstrap di web bootstrap
kedua download library phpqrcode
buatlah database bernama qrcode dan tabel qrcode
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 |
-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Mar 11, 2024 at 11:06 PM -- Server version: 10.4.28-MariaDB -- PHP Version: 8.2.4 SETSQL_MODE="NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SETtime_zone="+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `qrcode` -- -- -------------------------------------------------------- -- -- Table structure for table `qrcode` -- CREATETABLE`qrcode`( `id`int(11)NOT NULL, `qrtext`varchar(125)NOT NULL, `qrimage`varchar(125)NOT NULL )ENGINE=InnoDBDEFAULTCHARSET=utf8mb4COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `qrcode` -- INSERTINTO`qrcode`(`id`,`qrtext`,`qrimage`)VALUES (1,'Moh Andyra Eka Saputra','1710190641.png'); -- -- Indexes for dumped tables -- -- -- Indexes for table `qrcode` -- ALTERTABLE`qrcode` ADDPRIMARY KEY(`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `qrcode` -- ALTERTABLE`qrcode` MODIFY`id`int(11)NOT NULLAUTO_INCREMENT,AUTO_INCREMENT=2; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
buat file koneksi.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
<?php $servername="localhost"; $database="qrcode"; $username="root"; $password=""; //membuat koneksi $db=mysqli_connect($servername,$username,$password,$database); //mengecek koneksi if(!$db){ die("koneksi gagal : ".mysqli_connect_error()); } |
buat file index.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
<html> <head> <title>Testqrcode</title> <linkrel="stylesheet"type="text/css"href="bootstrap-5.3.2/dist/css/bootstrap.min.css"/> </head> <body> <divclass="container"> <divtable-responsive> <divclass="box"> <formmethod="post"action="proses.php"> <divclass="card col-xs-6"style="width:100%;"> <divclass="card-header"style="text-align: center;"> <h1>MembuatQRcodeGenerator</h1> </div> <divclass="card-body"> <divclass="form-group"> <labelclass="control-label ">NamaLengkap</label> <inputtype="text"class="form-control"name="nama"id="nama"> </div> </div> <divclass="card-footer"> <buttontype="submit"name="submit"class="btn btn-primary btn-user btn-block">Submit</button> </div> </div> </form> </div> </div> </div> </body> </html> |
lalu buat proses.php
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
<?php require_once"koneksi.php"; require_once"phpqrcode/qrlib.php"; $path="images/"; $qrcode=$path.time().".png"; $qrimage=time().".png"; if(isset($_REQUEST['submit'])){ $qrtext=$_REQUEST['nama']; $query=mysqli_query($db,"INSERT INTO qrcode set qrtext='$qrtext', qrimage='$qrimage'"); if($query){ ?> <script> alert("Data berhasil"); </script> <?php } } QRcode::png("syncrome.biz.id/blog",$qrcode,'H',5,5); echo"<img src='".$qrcode."'>"; |
