Sabtu, 24 Agustus 2013

PHP Indonesia - Facebook: mau nanya nih...function untuk generate kode...tpi...

PHP Indonesia - Facebook
PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ 
mau nanya nih...function untuk generate kode...tpi...
Aug 24th 2013, 14:06, by Chang Sherly

Chang Sherly 2:06pm Aug 24
mau nanya nih...function untuk generate kode...tpi gak jalan...selalu B0000 pdhal maunya B0001

function buatID($tabel, $inisial){
$struktur = mysql_query("select * from $tabel") or die("query tidak dapat dijalankan!");
$field = mysql_field_name($struktur,0);
$panjang = mysql_field_len($struktur,4);
$row = mysql_num_rows($struktur);

$panjanginisial = strlen($inisial);
$awal = $panjanginisial + 1;
$bnyk = $panjang-$panjanginisial;

if ($row >= 1){
$query = mysql_query("select max(substring($field,$awal,$bnyk)) as max from $tabel") or die("query tidak dapat dijalankan!");
$hasil = mysql_fetch_assoc($query);
$angka = intval($hasil['max']);
}
else{
$angka = 0;
}

$angka++;
$tmp= "";
for ($i=0; $i < ($panjang-$panjanginisial-strlen($angka)) ; $i++){
$tmp = $tmp."0";
}
//return hasil generate ID
return strval($inisial.$tmp.$angka);
}

manggilnya seperti ini :

$idbarang = buatID("barang","B");

mohon pencerahannya nih thx

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions

Tidak ada komentar:

Posting Komentar