1. Buat database dengan nama purchase.
2. Buat tabel dengan nama purchase_order dan buat seperti dibawah ini.
3. Dan dibawah adalah scriptnya yang joss banget. wkwkwk
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<?php
try {
$pdo = new pdo('mysql:host=localhost;dbname=purchase', 'root', '');
print 'Database was connected!!!!';
} catch (PDOException $e) {
exit('Database error.');
}
$query = $pdo->query('SELECT MAX(id) AS id FROM purchase_order');
$data = $query->fetch();
$id = $data['id']+1;
$length = 6;
$nol = '00000';
$nol1 = '0';
$string = '';
$mm = array();
if ($id) {
$get_code = $pdo->query('SELECT purchase_code FROM purchase_order where id = '.$id.'') or die (mysql_error());
$obj_purchase = $get_code->fetch();
$purchase_code = $obj_purchase['purchase_code'];
if ($purchase_code == Null) {
$code_po = 'PO-';
$kata = $id.''.$nol;
$panjang = strlen($kata);
if ($length < $panjang){
$ini = $panjang - $length;
$wiw = $length - $ini;
for ($i=1; $i < $wiw; $i++) {
array_push($mm, $nol1);
}
foreach ($mm as $key) {
$string .= $key;
}
$macan = $code_po.''.$string.''.$id;
} else {
$macan = $code_po.''.$nol.''.$id;
}
}
}
if (isset($_POST['id'],$_POST['purchase_code'])) {
$id = $_POST['id'];
$purchase_code = $_POST['purchase_code'];
$result = $pdo->prepare('INSERT INTO purchase_order (id, purchase_code) VALUES (?,?)');
$result->bindValue(1, $id);
$result->bindValue(2, $purchase_code);
$result->execute();
header('Location: latihan1.php');
}
?>
<br/><br/>
<form action="" method="POST">
<input type="hidden" name="id" value="<?php echo $id;?>">
<table>
<tr>
<th>Purchase Code</th>
</tr>
<tr>
<td><input type="text" name="purchase_code" value="<?php echo $macan;?>"></td>
</tr>
<tr>
<td colspan="3"><input type="submit" name="submit" style="float: right;"></td>
</tr>
</table>
</form>
</body>
</html>
Ini dia penampakan hasilnya gan.
Oke kalau masih ada kebingungan dihati dijiwa dan raga bisa di komen di bawah pada hari itu juga saya balas.
Download Source Code Membuat kode pembelian otomatis dengan PHP dan MySQL
0 Comments