Pembuatan kode otomatis pada PHP sangat diperlukan ketika ingin memasukan data, namun data yang ingin kita input akan diberikan kode sesuai dengan urutannya dan tidak boleh sama antara data yang satu dengan data yang lainnya.
\n<\/p>\n
Untuk itulah kita akan membuat sebuah fungsi php yang nanti secara otomatis ketika kita memasukan data baru, akan diberikan kode dan tentunya berbeda-beda, tanpa kita harus menghafal apakah kode tersebut sudah digunakan atau belum.<\/p>\n
Disini kita akan membuat 3 buah file:
\n1. File Input
\n2. File Proses dan
\n3. Koneksi<\/p>\n
Untuk databasenya buatlah seperti berikut ini:<\/p>\n
-- phpMyAdmin SQL Dump\r\n-- version 4.5.2\r\n-- http:\/\/www.phpmyadmin.net\r\n--\r\n-- Host: localhost\r\n-- Generation Time: Jun 07, 2017 at 06:46 AM\r\n-- Server version: 10.1.16-MariaDB\r\n-- PHP Version: 5.6.24\r\n\r\nSET SQL_MODE = \"NO_AUTO_VALUE_ON_ZERO\";\r\nSET time_zone = \"+00:00\";\r\n\r\n\r\n\/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *\/;\r\n\/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS *\/;\r\n\/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION *\/;\r\n\/*!40101 SET NAMES utf8mb4 *\/;\r\n\r\n--\r\n-- Database: `db_jual`\r\n--\r\n\r\n-- --------------------------------------------------------\r\n\r\n--\r\n-- Table structure for table `tbl_barang`\r\n--\r\n\r\nCREATE TABLE `tbl_barang` (\r\n `no_faktur` varchar(5) NOT NULL,\r\n `nama_barang` varchar(20) NOT NULL,\r\n `jumlah` int(7) NOT NULL\r\n) ENGINE=InnoDB DEFAULT CHARSET=latin1;\r\n\r\n--\r\n-- Dumping data for table `tbl_barang`\r\n--\r\n\r\nINSERT INTO `tbl_barang` (`no_faktur`, `nama_barang`, `jumlah`) VALUES\r\n('F0001', 'Gula', 1),\r\n('F0002', 'Beras', 10);\r\n\r\n--\r\n-- Indexes for dumped tables\r\n--\r\n\r\n--\r\n-- Indexes for table `tbl_barang`\r\n--\r\nALTER TABLE `tbl_barang`\r\n ADD PRIMARY KEY (`no_faktur`);\r\n\r\n\/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT *\/;\r\n\/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS *\/;\r\n\/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION *\/;\r\n<\/pre>\nUntuk Form Inputnya<\/p>\n
<?php\r\n\tinclude \"koneksi.php\";\r\n\r\n\t\/\/membaca kode barang terbesar\r\n\t$sql = \"SELECT max(no_faktur) FROM tbl_barang\";\r\n\t$query = mysql_query($sql) or die (mysql_error());\r\n\r\n\t$kode_faktur = mysql_fetch_array($query);\r\n\r\n\tif($kode_faktur){\r\n\t\t$nilai = substr($kode_faktur[0], 1);\r\n\t\t$kode = (int) $nilai;\r\n\r\n\t\t\/\/tambahkan sebanyak + 1\r\n\t\t$kode = $kode + 1;\r\n\t\t$auto_kode = \"F\" .str_pad($kode, 4, \"0\", STR_PAD_LEFT);\r\n\t} else {\r\n\t\t$auto_kode = \"F0001\";\r\n\t}\r\n\r\n?>\r\n<!DOCTYPE html>\r\n<html>\r\n<head>\r\n\t<title>Input Barang | YELLOWWEB.ID<\/title>\r\n<\/head>\r\n<body>\r\n\t<h3>Form Tambah Data Barang<\/h3>\r\n\t\r\n\t<form action=\"proses-insert.php\" method=\"POST\">\r\n\t\t<table>\r\n\t\t\t<tr>\r\n\t\t\t\t<td>No. Faktur<\/td>\r\n\t\t\t\t<td>:<\/td>\r\n\t\t\t\t<td><input type=\"text\" name=\"nofak\" value=\"<?php echo $auto_kode;?>\" readonly=\"readonly\"><\/td>\r\n\t\t\t<\/tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td>Nama Barang<\/td>\r\n\t\t\t\t<td>:<\/td>\r\n\t\t\t\t<td><input type=\"text\" name=\"nama_brg\"><\/td>\r\n\t\t\t<\/tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td>Jumlah<\/td>\r\n\t\t\t\t<td>:<\/td>\r\n\t\t\t\t<td><input type=\"text\" name=\"jumlah_brg\"><\/td>\r\n\t\t\t<\/tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td><\/td>\r\n\t\t\t\t<td><\/td>\r\n\t\t\t\t<td>\r\n\t\t\t\t\t<input type=\"submit\" name=\"simpan\" value=\"SIMPAN\">\r\n\t\t\t\t<\/td>\r\n\t\t\t<\/tr>\r\n\t\t<\/table>\r\n\t<\/form>\r\n\r\n<\/body>\r\n<\/html><\/pre>\nUntuk File Prosesnya<\/p>\n
<?php\r\n\tinclude \"koneksi.php\";\r\n\r\n\t$nama = $_POST[\"nama_brg\"];\r\n\t$jml = $_POST[\"jumlah_brg\"];\r\n\t$id = $_POST[\"nofak\"];\r\n\r\n\t$sql = \"INSERT INTO tbl_barang VALUES ('$id','$nama','$jml')\";\r\n\t$query = mysql_query($sql) or die (mysql_error());\r\n\r\n\techo \"Sukses!\";<\/pre>\nKetika sudah selesai di input maka akan diarahkan menuju file proses, kemudian dari sini silahkan teman-teman bisa cek di databasenya, karena kita tidak membuat halaman tampil datanya.<\/p>\n
Silahkan berkreasi, dan sampai jumpa di artikel berikutnya ya….<\/p>\n","protected":false},"excerpt":{"rendered":"
Pembuatan kode otomatis pada PHP sangat diperlukan ketika ingin memasukan data, namun data yang ingin kita input akan diberikan kode sesuai dengan urutannya dan tidak boleh sama antara data yang satu dengan data yang lainnya.<\/p>\n","protected":false},"author":1,"featured_media":644,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[110,11],"tags":[41,344,341,343,342,345,88],"class_list":["post-642","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php","category-tutorial","tag-id","tag-id-otomatis","tag-kode","tag-kode-barang","tag-kode-otomatis","tag-penjualan","tag-php"],"yoast_head":"\n
Membuat Kode Otomatis di PHP - YELLOWWEB.ID<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.yellowweb.id\/blog\/membuat-kode-otomatis-di-php\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Membuat Kode Otomatis di PHP - YELLOWWEB.ID\" \/>\n<meta property=\"og:description\" content=\"Pembuatan kode otomatis pada PHP sangat diperlukan ketika ingin memasukan data, namun data yang ingin kita input akan diberikan kode sesuai dengan urutannya dan tidak boleh sama antara data yang satu dengan data yang lainnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.yellowweb.id\/blog\/membuat-kode-otomatis-di-php\/\" \/>\n<meta property=\"og:site_name\" content=\"YELLOWWEB.ID\" \/>\n<meta property=\"article:published_time\" content=\"2017-06-09T05:59:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/06\/kode-otomatis-php.jpg?fit=475%2C250&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"475\" \/>\n\t<meta property=\"og:image:height\" content=\"250\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"yellowweb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"yellowweb\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/membuat-kode-otomatis-di-php\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/membuat-kode-otomatis-di-php\\\/\"},\"author\":{\"name\":\"yellowweb\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\"},\"headline\":\"Membuat Kode Otomatis di PHP\",\"datePublished\":\"2017-06-09T05:59:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/membuat-kode-otomatis-di-php\\\/\"},\"wordCount\":134,\"image\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/membuat-kode-otomatis-di-php\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/06\\\/kode-otomatis-php.jpg\",\"keywords\":[\"id\",\"id otomatis\",\"kode\",\"kode barang\",\"kode otomatis\",\"penjualan\",\"php\"],\"articleSection\":[\"PHP\",\"Tutorial\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/membuat-kode-otomatis-di-php\\\/\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/membuat-kode-otomatis-di-php\\\/\",\"name\":\"Membuat Kode Otomatis di PHP - YELLOWWEB.ID\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/membuat-kode-otomatis-di-php\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/membuat-kode-otomatis-di-php\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/06\\\/kode-otomatis-php.jpg\",\"datePublished\":\"2017-06-09T05:59:59+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/membuat-kode-otomatis-di-php\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/membuat-kode-otomatis-di-php\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/membuat-kode-otomatis-di-php\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/06\\\/kode-otomatis-php.jpg\",\"contentUrl\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/06\\\/kode-otomatis-php.jpg\",\"width\":475,\"height\":250,\"caption\":\"Kode Otomatis di PHP\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/membuat-kode-otomatis-di-php\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Membuat Kode Otomatis di PHP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/\",\"name\":\"YELLOWWEB.ID\",\"description\":\"Kursus Web Design | Kursus Web Programming | Mobile Web Apps | Digital Marketing\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/#\\\/schema\\\/person\\\/75188044e080844724e381ab6a5b9829\",\"name\":\"yellowweb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g\",\"caption\":\"yellowweb\"},\"sameAs\":[\"https:\\\/\\\/www.yellowweb.id\"],\"url\":\"https:\\\/\\\/www.yellowweb.id\\\/blog\\\/author\\\/yellowweb\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Membuat Kode Otomatis di PHP - YELLOWWEB.ID","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.yellowweb.id\/blog\/membuat-kode-otomatis-di-php\/","og_locale":"en_GB","og_type":"article","og_title":"Membuat Kode Otomatis di PHP - YELLOWWEB.ID","og_description":"Pembuatan kode otomatis pada PHP sangat diperlukan ketika ingin memasukan data, namun data yang ingin kita input akan diberikan kode sesuai dengan urutannya dan tidak boleh sama antara data yang satu dengan data yang lainnya.","og_url":"https:\/\/www.yellowweb.id\/blog\/membuat-kode-otomatis-di-php\/","og_site_name":"YELLOWWEB.ID","article_published_time":"2017-06-09T05:59:59+00:00","og_image":[{"width":475,"height":250,"url":"https:\/\/i0.wp.com\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/06\/kode-otomatis-php.jpg?fit=475%2C250&ssl=1","type":"image\/jpeg"}],"author":"yellowweb","twitter_card":"summary_large_image","twitter_misc":{"Written by":"yellowweb","Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.yellowweb.id\/blog\/membuat-kode-otomatis-di-php\/#article","isPartOf":{"@id":"https:\/\/www.yellowweb.id\/blog\/membuat-kode-otomatis-di-php\/"},"author":{"name":"yellowweb","@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829"},"headline":"Membuat Kode Otomatis di PHP","datePublished":"2017-06-09T05:59:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.yellowweb.id\/blog\/membuat-kode-otomatis-di-php\/"},"wordCount":134,"image":{"@id":"https:\/\/www.yellowweb.id\/blog\/membuat-kode-otomatis-di-php\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/06\/kode-otomatis-php.jpg","keywords":["id","id otomatis","kode","kode barang","kode otomatis","penjualan","php"],"articleSection":["PHP","Tutorial"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/www.yellowweb.id\/blog\/membuat-kode-otomatis-di-php\/","url":"https:\/\/www.yellowweb.id\/blog\/membuat-kode-otomatis-di-php\/","name":"Membuat Kode Otomatis di PHP - YELLOWWEB.ID","isPartOf":{"@id":"https:\/\/www.yellowweb.id\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.yellowweb.id\/blog\/membuat-kode-otomatis-di-php\/#primaryimage"},"image":{"@id":"https:\/\/www.yellowweb.id\/blog\/membuat-kode-otomatis-di-php\/#primaryimage"},"thumbnailUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/06\/kode-otomatis-php.jpg","datePublished":"2017-06-09T05:59:59+00:00","author":{"@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829"},"breadcrumb":{"@id":"https:\/\/www.yellowweb.id\/blog\/membuat-kode-otomatis-di-php\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.yellowweb.id\/blog\/membuat-kode-otomatis-di-php\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.yellowweb.id\/blog\/membuat-kode-otomatis-di-php\/#primaryimage","url":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/06\/kode-otomatis-php.jpg","contentUrl":"https:\/\/www.yellowweb.id\/blog\/wp-content\/uploads\/2017\/06\/kode-otomatis-php.jpg","width":475,"height":250,"caption":"Kode Otomatis di PHP"},{"@type":"BreadcrumbList","@id":"https:\/\/www.yellowweb.id\/blog\/membuat-kode-otomatis-di-php\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.yellowweb.id\/blog\/"},{"@type":"ListItem","position":2,"name":"Membuat Kode Otomatis di PHP"}]},{"@type":"WebSite","@id":"https:\/\/www.yellowweb.id\/blog\/#website","url":"https:\/\/www.yellowweb.id\/blog\/","name":"YELLOWWEB.ID","description":"Kursus Web Design | Kursus Web Programming | Mobile Web Apps | Digital Marketing","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.yellowweb.id\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.yellowweb.id\/blog\/#\/schema\/person\/75188044e080844724e381ab6a5b9829","name":"yellowweb","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5afd1bfac26e9377e8f5e36afb624cf3690dd31cb07c3961dfbc736b9ff1912f?s=96&d=mm&r=g","caption":"yellowweb"},"sameAs":["https:\/\/www.yellowweb.id"],"url":"https:\/\/www.yellowweb.id\/blog\/author\/yellowweb\/"}]}},"_links":{"self":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/642","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/comments?post=642"}],"version-history":[{"count":1,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/642\/revisions"}],"predecessor-version":[{"id":643,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/posts\/642\/revisions\/643"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/media\/644"}],"wp:attachment":[{"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/media?parent=642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/categories?post=642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yellowweb.id\/blog\/wp-json\/wp\/v2\/tags?post=642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}