PHP AutoCode

Small:

<?php
  $sql="select `kode_matpel` from `$tbmatpel` order by `kode_matpel` desc";
  $jum= getJum($conn,$sql);
  $kd="MTL";
if($jum > 0){
$d=getField($conn,$sql);
    $idmax=$d['kode_matpel'];
$urut=substr($idmax,3,3)+1;//01
if($urut<10){$idmax="$kd"."00".$urut;}
else if($urut<100){$idmax="$kd"."0".$urut;}
else{$idmax="$kd".$urut;}
}
else{$idmax="$kd"."001";}
$kode_matpel=$idmax;
?>


Large
<?php
  $sql="select `kode_soal` from `$tbsoal` order by `kode_soal` desc";
$q=mysqli_query($conn, $sql);
  $jum=mysqli_num_rows($q);
  $th=date("y");
  $bl=date("m")+0;if($bl<10){$bl="0".$bl;}

  $kd="EXC".$th.$bl;//KEG1610001
  if($jum > 0){
   $d=mysqli_fetch_array($q);
   $idmax=$d["kode_soal"];
 
   $bul=substr($idmax,5,2);
   $tah=substr($idmax,3,2);
    if($bul==$bl && $tah==$th){
     $urut=substr($idmax,7,3)+1;
     if($urut<10){$idmax="$kd"."00".$urut;}
     else if($urut<100){$idmax="$kd"."0".$urut;}
     else{$idmax="$kd".$urut;}
    }//==
    else{
     $idmax="$kd"."001";
     }  
   }//jum>0
  else{$idmax="$kd"."001";}
  $kode_soal=$idmax;
?>

Komentar

Posting Komentar

Postingan populer dari blog ini

Source Code Koleksi Php dan java script

<?php //PHP: LOOP THROUGH EACH STRING LINE IN A TEXTAREA //trim off excess whitespace off the whole $text = trim($_POST['textareaname']); //explode all separate lines into an array $textAr = explode("\n", $text); //trim all lines contained in the array. $textAr = array_filter($textAr, 'trim'); //loop through the lines foreach($textAr as $line){ echo "$line"; } function bubble_sort($arr) {     $size = count($arr);     for ($i=0; $i<$size; $i++) {         for ($j=0; $j<$size-1-$i; $j++) {             if ($arr[$j+1] < $arr[$j]) {                 swap($arr, $j, $j+1);             }         }     }     return $arr; } function swap(&$arr, $a, $b) {     $tmp = $arr[$a];     $arr[$a] = $arr[$b];     $arr[$b] = $tmp; } /* test bubble sort *...
Baca selengkapnya

Java Script Auto refresh

<?php session_start(); $jmldata=10; ?> <html> <head> <script type="text/javascript"> function Ajax(){ var $http,$self = arguments.callee; if (window.XMLHttpRequest) {$http = new XMLHttpRequest();} else if (window.ActiveXObject) { try {$http = new ActiveXObject('Msxml2.XMLHTTP');} catch(e) {$http = new ActiveXObject('Microsoft.XMLHTTP');} } if ($http) { $http.onreadystatechange = function(){ if (/4|^complete$/.test($http.readyState)) { document.getElementById('ReloadThis').innerHTML = $http.responseText; setTimeout(function(){$self();}, 1000); } }; $http.open('GET', 'songinfo.php' + '?' + new Date().getTime(), true); $http.send(null); } } </script> <script type="text/javascript">setTimeout(function() {Ajax();}, 1000);</script> <meta http-equiv="Content-...
Baca selengkapnya

Java Script Membaca Lokasi Kita

Gambar
<!DOCTYPE html> <html> <head>     <title>Demo Cek Lokasi Geolocation HTML5</title> </head> <body> <center> <p id="tampilkan"></p> <p>Cek lokasi anda! >> <button onclick="getLocation()">Cek</button></p> <div id="mapcanvas"></div> </center> <script type="text/javascript" src="//maps.googleapis.com/maps/api/js?key=AIzaSyBhSg6I2JvHNU_jLqIpvc5MEwc_xi3Ttvg&sensor=true"></script> <script> var view = document.getElementById("tampilkan"); function getLocation() {     if (navigator.geolocation) {         navigator.geolocation.getCurrentPosition(showPosition, showError);     } else {         view.innerHTML = "Yah browsernya ngga support Geolocation bro!";     } } function showPosition(position) {     lat = position.coords.latitude;     lon = pos...
Baca selengkapnya