PHP ILU INU IMU: 2018

Minggu, 30 Desember 2018

Selisih Waktu dan AJAX

pada index.php

<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', 'expire.php' + '?' + new Date().getTime(), true);
$http.send(null);
}
}
</script>
<script type="text/javascript">setTimeout(function() {Ajax();}, 1000);</script>

<label id="ReloadThis">...</label><br>

Secara Automatis dan periodeik sistem akan membaca data order.....
jika waktu order > 10 menit system akan menginfokan ada keterlambatan pembuatan menu dan denda deh................

<?php
require_once"konmysqli.php";
$w=date("Y-m-d H:i:s");

$sql="select kode_order,tanggal_order,jam_order from `tb_order` where status_order='Konfirmasi'";
$jum=getJum($conn,$sql);
if($jum>0){
$arr=getData($conn,$sql);
foreach($arr as $d) {
$kode_order=$d["kode_order"];
$tanggal_order=$d["tanggal_order"];
$jam_order=$d["jam_order"];
if(getEXP($tanggal_order,$jam_order)==1){

echo $sql="update `tb_order` set status_order='Denda' where `kode_order`='$kode_order'";
$up=process($conn,$sql);
}
}
}//jum
echo $w;

function process($conn,$sql){
$s=false;
$conn->autocommit(FALSE);
try {
$rs = $conn->query($sql);
if($rs){
$conn->commit();
$last_inserted_id = $conn->insert_id;
$affected_rows = $conn->affected_rows;
$s=true;
}
}
catch (Exception $e) {
echo 'fail: ' . $e->getMessage();
$conn->rollback();
}
$conn->autocommit(TRUE);
return $s;
}

function getEXP($tanggal,$jam){

$awal = date_create($tanggal ." ".$jam);
$akhir = date_create(); // waktu sekarang
$diff = date_diff( $awal, $akhir );

$jummenit=$diff->i;
$kon=0;
if($jummenit>10){
$kon=1;
}
return $kon;
}
function getJum($conn,$sql){
$rs=$conn->query($sql);
$jum= $rs->num_rows;
$rs->free();
return $jum;
}

function getField($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
$d= $rs->fetch_assoc();
$rs->free();
return $d;
}

function getData($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
$arr = $rs->fetch_all(MYSQLI_ASSOC);
//foreach($arr as $row) {
// echo $row['nama_kelas'] . '*<br>';
//}

$rs->free();
return $arr;
}
?>

Sabtu, 11 Agustus 2018

PHP CODE Import Excel File to Mysql

<html>
<head>
<title>How To Import Excel (.xls) File To MySql Database Using PHP</title>
</head>
<body>
<center><h1>lp2maray</h1></center>
<form name="import_export_form" method="post" action="" enctype="multipart/form-data">
<label>Select Excel File : </label><input type="file" name="excelfile"/><br>
<input type="submit" name="form_submit"/>
</form>
</body>
</html>

<?php
if(isset($_POST['form_submit'])){

error_reporting(0);
require_once 'excel_reader2.php';

$filename = $_FILES['excelfile']['tmp_name'];
$data = new Spreadsheet_Excel_Reader($filename);

for ($x = 2; $x <= count($data->sheets[0]["cells"]); $x++) {
$first = $data->sheets[0]["cells"][$x][1];
$middle = $data->sheets[0]["cells"][$x][2];
$last = $data->sheets[0]["cells"][$x][3];
$sql = "INSERT INTO mytable (First,Middle,Last) VALUES ('$first','$middle','$last')";
echo $sql."\n";
//mysql_query($sql);
}
echo"<hr>";
echo $data->dump(true,true);
}
?>

==========================

Download Code

Jumat, 10 Agustus 2018

Cuplik-Cuplik Code

Konvert Tanggal ke Hari:

function cekhari($tanggal){
$dayofweek = date('w', strtotime($tanggal));
$day= date('Y-m-d', strtotime(($day - $dayofweek).' day', strtotime($date)));
$hari="Senin";
if($day=="Sunday"){$hari="Minggu";}
else if($day=="Monday"){$hari="Senin";}
else if($day=="Tuesday"){$hari="Selasa";}
else if($day=="Wednesday"){$hari="Rabu";}
else if($day=="Thrusday"){$hari="Kamis";}
else if($day=="Friday"){$hari="Jumat";}
else if($day=="Saturday"){$hari="Sabtu";}
return $hari;
}
-----------------------------------------------------------------

function cekHuruf ada atau tidak

function cekData($cari,$database){
$ada=strlen(strstr($cari,$database));
$hasil=false;
if($ada>0){$hasil=true;}
return $hasil;
}

Contoh:
echo "<h1>##".cekData("LP2MARAY","Saya Belajar di LP2MARAY")."</h1>";
#hasilnya adalah 1 atau True

echo "<h1>##".cekData("LP2M ARAY","Saya Belajar di LP2MARAY")."</h1>";

#hasilnya adalah 0 atau False

Batasan Waktu Terhadap Order

$jamn=date("H:i:s");
$tgln=date("Y-m-d");

//cek apakah ada order di database
$sql="select * from `$tbso` where `status`='Order'";
$jum=getJum($conn,$sql);
if($jum > 0){
$arr=getData($conn,$sql);
foreach($arr as $d) {
$kode_so=$d["kode_so"];
$tanggal_so=$d["tanggal_so"];
$jam=$d["jam"];
$deskripsi=$d["deskripsi"];
$nama=$d["nama"];
$telepon=$d["telepon"];
$email=$d["email"];
$status=$d["status"];

$awal = strtotime("$tanggal_so $jam");//waktu order
$akhir = strtotime("$tgln $jamn");//waktu sekarang
$diff = $akhir - $awal;//selisih waktu

$jam = floor($diff / (60 * 60));
$menit = $diff - $jam * (60 * 60);
$MM=$menit / 60;
echo $kode_so.' Waktu tinggal: ' . $jam . ' jam, ' . floor( $MM ) . ' menit <br>';

if($MM>=$BATASMAX){//bila sudah lewat batasan menitnya
$not=" Expire = Waktu tinggal: ". $jam . " jam, " . floor( $menit / 60 ) . " menit";
echo $not;

$sql="update `$tbso` set `status`='Expire',`keterangan_order`='$not' where `kode_so`='$kode_so'";
$ubah=process($conn,$sql);

$sqlc="select * from `$tbsodetail` where `kode_so`='$kode_so'";
$arrc=getData($conn,$sqlc);
foreach($arrc as $dc) {
$idc=$dc["id"];
$kode_barangc=$dc["kode_barang"];
$jumlah=$dc["jumlah"];

$sqlm="update `$tbbarang` set `stok`=`stok`+'$jumlah' where `kode_barang`='$kode_barang'";
$up=process($conn,$sqlm);

}//for
}//if
}
}

Senin, 06 Agustus 2018

Shoutbox LP2mARAY

chatting.php

<script language="JavaScript" type="text/javascript">
function addSmiley(textToAdd){
document.formshout.pesanShout.value += textToAdd;
document.formshout.pesanShout.focus();
}
</script>

<link href="smiley/style.css" rel="stylesheet" type="text/css" />

<script type="text/javascript">
function MM_validateForm() { //v4.0
if (document.getElementById){
var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;
for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=document.getElementById(args[i]);
if (val) { nm=val.name; if ((val=val.value)!="") {
if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');
if (p<1 || p==(val.length-1)) errors+='- '+nm+' Haruslah memiliki nama @domain.\n';
} else if (test!='R') { num = parseFloat(val);
if (isNaN(val)) errors+='- '+nm+' Haruslah berupa angka.\n';
if (test.indexOf('inRange') != -1) { p=test.indexOf(':');
min=test.substring(8,p); max=test.substring(p+1);
if (num<min || max<num) errors+='- '+nm+' Haruslah angka antara '+min+' dan '+max+'.\n';
} } } else if (test.charAt(0) == 'R') errors += '- '+nm+' Haruslah diisi terlebih dahulu.\n'; }
} if (errors) alert('Maaf, Terjadi beberapa kesalahan masukan data :\n'+errors);
document.MM_returnValue = (errors == '');
} }
</script>

<iframe src="shoutbox.php" width="100%" height="250" border="1" solid></iframe><br /><br />

<table class='date' width='100%'>
<form name="formshout" action="" method="POST">
<tr>
<td width='10%' class="highlight2">Nama</td>
<td width='90%'><input name='namaShout' type=text class=shout id="namaShout" value="<?php echo $_SESSION["cnama"];?>" disabled size='21'></td></tr>
<tr>
<td width='10%' class="highlight2">Email</td>
<td><input name='emailShout' type=text class=shout id="emailShout" value="<?php echo $_SESSION["cemail"];?>" disabled size='21'></td></tr>
<tr>
<td width='10%' valign='top' class='highlight2'>Pesan</td>
<td><textarea name='pesanShout' class=shout id="pesanShout" style='width: 100%; height: 35px;'></textarea></td></tr>

<tr><td colspan='2'>
<a onClick="addSmiley(':-)')"><img src='smiley/1.gif'></a>
<a onClick="addSmiley(':-(')"><img src='smiley/2.gif'></a>
<a onClick="addSmiley(';-)')"><img src='smiley/3.gif'></a>
<a onClick="addSmiley(';-D')"><img src='smiley/4.gif'></a>
<a onClick="addSmiley(';;-)')"><img src='smiley/5.gif'></a>
<a onClick="addSmiley(';:D;')"><img src='smiley/6.gif'></a>
</td></tr>
<tr>
<td colspan=2>
<input name="SimpanShout" type="submit" class onclick="MM_validateForm('namaShout','','R','emailShout','','RisEmail','pesanShout','','R');return document.MM_returnValue" value='Kirim''"shout>
<input class="shout" type="reset" name="reset" value="Reset">
</td></tr>
</form>
</table>

<hr color="#e0cb91" noshade="noshade" />

<?php
if(isset($_POST["SimpanShout"])){
$nama = anti_injection($_SESSION["cnama"]);
$email = anti_injection($_SESSION["cemail"]);
$pesan = anti_injection($_POST["pesanShout"]);
$tgl_sekarang=date("Y-m-d");
$jam_sekarang=date("h:m:s");

$statusadabadwords = "none";
$badWords = array("sex","xxx","viagra","http","porn");// daftar bad words

for($i = 0; $i <= count($badWords)-1; $i++){if (!(strpos($pesan, $badWords[$i]) == false)){$statusadabadwords = "ada";break;}}
if ($statusadabadwords == "none"){

$sql="INSERT INTO `$tbshoutbox`(`nama`, `email`, `pesan`, `tanggal`, `status`) VALUES('$nama', '$email', '$pesan', '$tgl_sekarang $jam_sekarang','Y')";
$proses=process($conn,$sql);
if (empty($proses)){
echo "<script>alert('Data Gagal Disimpan, Silakan Cek Data Anda...'); document.location.href='?mnu=chatting';</script>\n";
}
else{die("<script>location.href='?mnu=chatting';</script>");}
}//statusadabadwords
else{echo "<script>alert('Maaf data Anda mengandung kata-kata tidak sopan');document.location.href='?mnu=chatting';</script>";}
}//ISSET

function anti_injection($data){
$filter = mysql_real_escape_string(stripslashes(strip_tags(htmlspecialchars($data,ENT_QUOTES))));
return $filter;
}

?>
++++++++++++++++++++++++++

<?php
session_start();
require_once"koneksi.php";
?>

<link href="smiley/style.css" rel="stylesheet" type="text/css" />

<?php

$sql="SELECT * FROM `$tbshoutbox` WHERE `status`='Y' ORDER BY `id` DESC LIMIT 10";
$arr=getData($conn,$sql);
foreach($arr as $d) {
$email= $d["email"];
$nama= $d["nama"];
$pesan= $d["pesan"];
$tanggal= $d["tanggal"];

$pesan = str_replace(":-)", "<img src=\"smiley/1.gif\">", $pesan);
$pesan = str_replace(":-(", "<img src=\"smiley/2.gif\">", $pesan);
$pesan = str_replace(";-)", "<img src=\"smiley/3.gif\">", $pesan);
$pesan = str_replace(";-D", "<img src=\"smiley/4.gif\">", $pesan);
$pesan = str_replace(";;-)", "<img src=\"smiley/5.gif\">", $pesan);
$pesan = str_replace(";:D;", "<img src=\"smiley/6.gif\">", $pesan);

echo "<span class='shout'><b><a href='mailto:$email' target='_blank'>$nama</a> : </b></span>";
echo "<span class=shout>$pesan</span><br />";
echo "<span class=date><font color='#6515ff'>".$tanggal."#</font></span>";
echo "<hr color='#e0cb91' noshade='noshade' />";
}

function getData($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
$arr = $rs->fetch_all(MYSQLI_ASSOC);
//foreach($arr as $row) {
// echo $row['nama_kelas'] . '*<br>';
//}
$rs->free();
return $arr;
}
?>

Download Code

GoogleMap Frame

<?php
echo"<div class='center_content'>";
echo "<div class='center_title_bar'>Lokasi Kami</b></div>";
echo "<div class='center_prod_box_big'>";

$url="http://maps.google.com/maps/ms?msa=0&msid=203038942996608606794.000499e7b9b2535ca5b0d&ie=UTF8&t=m&vpsrc=0&z=14&output=embed";

echo "<iframe width='96%' height='630' frameborder='0' scrolling='no' marginheight='0' marginwidth='0' src='$url'></iframe><br />

<div align='center'>
<a href='$url' title='Lokasi Kita'><strong>Lihat Lebih Dekat</strong></a><br>LP2MARAY<br> Jakarta
</div>";
}
echo"</div></div>";
?>

Minggu, 05 Agustus 2018

BUKUTAMU ILU INU IMU

Membuat Bukutamu Captcha

<tr>

<td>scode

<td>

</tr>

<tr>

<td>

(Masukkan 6 kode diatas)

</td>

</tr>

ATAU CODE LENGKAPNYA bukutamu,php

<?php

echo"<link href=ydata/amazon.css' rel='stylesheet' type='text/css' />";

$s="select * from `$tbbukutamu` order by `kode_bukutamu` desc";

$q=mysql_query($s);

$jum=mysql_num_rows($q);

$th=date("y");

$bl=date("m")+0;if($bl<10){$bl="0".$bl;}

$kd="GSS".$th.$bl;//KEG1610001

if($jum > 0){

$d=mysql_fetch_array($q);

$idmax=$d["kode_bukutamu"];

$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_bukutamu=$idmax;

<tr>

<th width="9">:

<tr>

</td></tr>

<tr>

<td height="24"><label for="telepon">telepon</label>

</td></tr>

<tr>

<td height="24"><label for="email">email</label>

</td></tr>

<tr>

<td><label for="pesan">pesan</label>

</td></tr>

<tr>

<td>scode

<td>

</tr>

<tr>

<td>

(Masukkan 6 kode diatas)

</td>

</tr>

<tr>

<td>

</td></tr>

</table>

</form>

ini isifile: ydata/mycaptcha.php

<?php

session_start();

header("Content-type: image/png");

$captcha_image = imagecreatefrompng("../ydata/captcha.png");

$captcha_font = imageloadfont("../ydata/font.gdf");

$captcha_text = substr(md5(uniqid('')),-6,6);

$_SESSION['captcha_session'] = $captcha_text;

$captcha_color = imagecolorallocate($captcha_image,0,0,0);

imagestring($captcha_image,$captcha_font,15,5,$captcha_text,$captcha_color);

imagepng($captcha_image);

imagedestroy($captcha_image);

<?php

if(isset($_POST["Simpan"])){

$kode_bukutamu=strip_tags($_POST["kode_bukutamu"]);

$tanggal=date("Y-m-d");

$nama=strip_tags($_POST["nama"]);

$email=strip_tags($_POST["email"]);

$pesan=htmlentities($_POST["pesan"]);

$telepon=strip_tags($_POST["telepon"]);

$status="Aktif";

if($_POST["kodecaptcha"]==$_SESSION["captcha_session"]){

$sql="INSERT INTO `$tbbukutamu` (`kode_bukutamu` ,`tanggal` ,`nama` ,`telepon` ,`email` ,`pesan` ,`status`) VALUES ('$kode_bukutamu', '$tanggal', '$nama','$telepon', '$email', '$pesan', 'Y')";

$simpan=mysql_query($sql);

if($simpan) {echo "<script>alert('Data Bukutamu $nama Berhasil di simpan !');document.location.href='?mnu=bukutamu';</script>";}

else{echo"<script>alert('Data $nama Gagal di simpan...');document.location.href='?mnu=bukutamu';</script>";}

}//cocok captcha

else{

echo"<script>alert('Maaf, Security Code Anda salah...Seharusnya ".$_SESSION["captcha_session"].",Atau Silakan cek kembali...');document.location.href='javascript:history.go(-1)';</script>";}

}

+++++++++++++++++++++++++++++++++++++++++++++++++

BUKUTAMU LIST

<?php

echo"<link href='ydata/amazon.css' rel='stylesheet' type='text/css' />";

$batas = 2;

$halaman = $_GET['halaman'];

if(empty($halaman)){$posisi = 0;$halaman = 1;}

else{$posisi = ($halaman-1) * $batas;}

$tampil = "SELECT * FROM `$tbbukutamu` LIMIT $posisi,$batas";

$hasil = mysql_query($tampil);

$no = $posisi+1;

while($r=mysql_fetch_array($hasil)){

$no++;

$tanggal=WKT($r["tanggal"]);

$nama=$r["nama"];

$kode_bukutamu=$r["kode_bukutamu"];

$email=$r["email"];

$telepon=$r["telepon"]; $telepon=substr($telepon,0,strlen($telepon)-3)."XXX";

$pesan=$r["pesan"];

$gab=$gab."<b>No.      : $kode_bukutamu/$no</b><br>Nama   : <a href='mailto:$email'>$nama</a><br>Telepon: $telepon<br>Pesan   : $pesan ($tanggal)</p><hr color=#e0cb91 noshade=noshade />";

}

echo $gab;

$tampil2 = mysql_query("SELECT * FROM `$tbbukutamu`");

$jmldata = mysql_num_rows($tampil2);

$jmlhal = ceil($jmldata/$batas);

echo "<div class=paging>";

if($halaman > 1){

$prev=$halaman-1;

echo "<span class=prevnext><a href='$_SERVER[PHP_SELF]?halaman=$prev&mnu=bukutamu'>« Prev</a></span> ";

}

else{

echo "<span class=disabled>« Prev</span> ";

}

for($i=1;$i<=$jmlhal;$i++)

if ($i != $halaman){echo " <a href='$_SERVER[PHP_SELF]?halaman=$i&mnu=bukutamu'>$i</a> ";}

else{echo " <span class=current>$i</span> ";}

if($halaman < $jmlhal){$next=$halaman+1;echo "<span class=prevnext><a href='$_SERVER[PHP_SELF]?halaman=$next&mnu=bukutamu'>Next »</a></span>";}

else{echo "<span class=disabled>Next »</span>";}

echo "</div>";

echo "<p align=center>Total Pengunjung : <b>$jmldata</b> Orang...</p>";

++++++++++++++++++++++++++++++++

bukutamu.php

isi bukutamulistuframe.php

<?php

error_reporting(0);

require_once "../koneksi.php";

echo"<link href='ydata/amazon.css' rel='stylesheet' type='text/css' />";

$batas = 10;

$halaman = $_GET['halaman'];

if(empty($halaman)){$posisi = 0;$halaman = 1;}

else{$posisi = ($halaman-1) * $batas;}

$tampil = "SELECT * FROM `$tbbukutamu` LIMIT $posisi,$batas";

$hasil = mysql_query($tampil);

$no = $posisi+1;

while($r=mysql_fetch_array($hasil)){

$no++;

$tanggal=WKT2($r["tanggal"]);

$nama=$r["nama"];

$kode_bukutamu=$r["kode_bukutamu"];

$email=$r["email"];

$telepon=$r["telepon"]; $telepon=substr($telepon,0,strlen($telepon)-3)."XXX";

$pesan=$r["pesan"];

$gab=$gab."<b>No.      : $kode_bukutamu/$no</b><br>Nama   : <a href='mailto:$email'>$nama</a><br>Telepon: $telepon<br>Pesan   : $pesan ($tanggal)</p><hr color=#e0cb91 noshade=noshade />";

}

echo $gab;

$tampil2 = mysql_query("SELECT * FROM `$tbbukutamu`");

$jmldata = mysql_num_rows($tampil2);

$jmlhal = ceil($jmldata/$batas);

echo "<div class=paging>";

if($halaman > 1){

$prev=$halaman-1;

echo "<span class=prevnext><a href='$_SERVER[PHP_SELF]?halaman=$prev&mnu=bukutamu'>« Prev</a></span> ";

}

else{

echo "<span class=disabled>« Prev</span> ";

}

for($i=1;$i<=$jmlhal;$i++)

if ($i != $halaman){echo " <a href='$_SERVER[PHP_SELF]?halaman=$i&mnu=bukutamu'>$i</a> ";}

else{echo " <span class=current>$i</span> ";}

if($halaman < $jmlhal){$next=$halaman+1;echo "<span class=prevnext><a href='$_SERVER[PHP_SELF]?halaman=$next&mnu=bukutamu'>Next »</a></span>";}

else{echo "<span class=disabled>Next »</span>";}

echo "</div>";

echo "<p align=center>Total Pengunjung : <b>$jmldata</b> Orang...</p>";

<?php

function WKT2($sekarang){

$tanggal = substr($sekarang,8,2)+0;

$bulan = substr($sekarang,5,2);

$tahun = substr($sekarang,0,4);

$judul_bln=array(1=> "Januari", "Februari", "Maret", "April", "Mei","Juni", "Juli", "Agustus", "September","Oktober", "Nopember", "Desember");

$wk=$tanggal." ".$judul_bln[(int)$bulan]." ".$tahun;

return $wk;

}

++++++++++++++++++++++++++++++++++++++++++++

<?php

echo"<link href='ydata/amazon.css' rel='stylesheet' type='text/css' />";

echo "<table align=center width='100%' border=1>

<tr>

<th width='15%'>Telepon</th>

<th width='60%'>Pesan</th>

</tr>";

$batas = 10;

$halaman = $_GET['halaman'];

if(empty($halaman)){$posisi = 0;$halaman = 1;}

else{$posisi = ($halaman-1) * $batas;}

$tampil = "SELECT * FROM `$tbbukutamu` LIMIT $posisi,$batas";

$hasil = mysql_query($tampil);

$no = $posisi+1;

while($r=mysql_fetch_array($hasil)){

$kode_bukutamu=$r["kode_bukutamu"];

$nama=$r["nama"];

$email=$r["email"];

$telepon=$r["telepon"];

$pesan=$r["pesan"];

$telepon=substr($telepon,0,strlen($telepon)-3)."XXX";

if($no%2==0){

echo "<tr bgcolor='#cccccc'>

<td>$telepon</td>

<td>$pesan</td>

</tr>";

}

else {

echo "<tr bgcolor='#9999999'>

<td>$telepon</td>

<td>$pesan</td>

</tr>";

}

$no++;

}

echo "</table><br>";

$tampil2 = mysql_query("SELECT * FROM `$tbbukutamu`");

$jmldata = mysql_num_rows($tampil2);

$jmlhal = ceil($jmldata/$batas);

echo "<div class=paging>";

if($halaman > 1){

$prev=$halaman-1;

echo "<span class=prevnext><a href='$_SERVER[PHP_SELF]?halaman=$prev&mnu=bukutamu'>« Prev</a></span> ";

}

else{

echo "<span class=disabled>« Prev</span> ";

}

for($i=1;$i<=$jmlhal;$i++)

if ($i != $halaman){echo " <a href='$_SERVER[PHP_SELF]?halaman=$i&mnu=bukutamu'>$i</a> ";}

else{echo " <span class=current>$i</span> ";}

if($halaman < $jmlhal){$next=$halaman+1;echo "<span class=prevnext><a href='$_SERVER[PHP_SELF]?halaman=$next&mnu=bukutamu'>Next »</a></span>";}

else{echo "<span class=disabled>Next »</span>";}

echo "</div>";

echo "<p align=center>Total Pengunjung : <b>$jmldata</b> Orang...</p>";

++++++++++++++++++++++++

BUKUTAMUUP.php

<?php

echo"<link href='ydata/amazon.css' rel='stylesheet' type='text/css' />";

$query = "SELECT * FROM `$tbbukutamu` order by `kode_bukutamu` asc";

$result = mysql_query($query);

$no=0;$gab="";

while ($r= mysql_fetch_array($result)) {

$no++;

$kode_bukutamu=$r["kode_bukutamu"];

$tanggal=WKT($r["tanggal"]);

$nama=$r["nama"];

$email=$r["email"];

$telepon=$r["telepon"]; $telepon=substr($telepon,0,strlen($telepon)-3)."XXX";

$pesan=$r["pesan"];

$gab=$gab."

No. : $kode_bukutamu/$no<br>

Nama : <a href='mailto:$email'>$nama</a><br>

Telepon : $telepon<br>

Pesan    : $pesan ($tanggal)</p><hr color=#e0cb91 noshade=noshade />";

}

echo ("<marquee scrollamount=\"4\" onmouseover=\"this.stop()\" onmouseout=\"this.start()\" direction=\"up\">$gab</marquee>");

Membaca Hari:

$seminggu = array("Minggu","Senin","Selasa","Rabu","Kamis","Jumat","Sabtu");

$hari = date("w");

$hari_ini = $seminggu[$hari];

Menghindari TextPanjang:

$isi=nl2br($isi);

Download

Selasa, 31 Juli 2018

Ajax ajax Dunk

<?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-Type" content="text/html; charset=utf-8" />
</head>
<body></body>
</html>
<hr />HTTP://www.LP2M-ARAY: <div id="ReloadThis">Default text</div>

Hmm...ini program sakti lho.........banyak yang sudah terbantu dgn koding seerhana itu..............

Main Catur yuk's

<base href="http://chessboardjs.com/" />
<link rel="stylesheet" href="css/chessboard.css" />

<div id="board" style="width: 400px"></div>
<script src="js/json3.min.js"></script>
<script src="js/jquery-1.10.1.min.js"></script>
<script src="js/chessboard.js"></script>
<script>
var init = function() {
var board = ChessBoard('board', 'start');

}; // end init()
$(document).ready(init);
</script>

var init = function() {

var cfg2 = {

position: {

d4: 'wP',

d6: 'bK',

e4: 'wK'

}

};

var cfg = {

draggable: true,

dropOffBoard: 'snapback',

position: 'start'

};

var board = ChessBoard('board', cfg2);

}; // end init()

$(document).ready(init);

</script>

Hmm....mudah yaaaaa......yang sulit adalah main caturnyaaaaaaaaaaa......

Senin, 16 Juli 2018

Kode Download PHP

<?php
// <a href='download.php?file=$file' title='Download File'>Download Dokumen</a>

$direktori = "ypathfile/";
$namafile=$_GET["file"];

if (!file_exists($direktori.$namafile)) {
echo "<h1>Access forbidden!</h1>
<p>Maaf, file $namafile yang Anda download sudah tidak tersedia atau filenya (direktorinya) telah diproteksi. <br />
Silahkan hubungi <a href='mailto:adiarray@lp2maray,com'>
Administrator web</a>.</p>";
exit();
}
else {
header("Content-Type: octet/stream");
header("Content-Disposition: attachment; filename=\"".$namafile."\"");
$fp = fopen($direktori.$namafile, "r");
$data = fread($fp, filesize($direktori.$namafile));
fclose($fp);
print $data;
}
?>

BUKUTAMU SCROLL

<?php
$s="select * from `tb_bukutamu` order by `kode_bukutamu` desc";
$q=mysql_query($s);
$jum=mysql_num_rows($q);
$gab="";
$no=0;
while($d=mysql_fetch_array($q)){
$kode_bukutamu=$d["kode_bukutamu"];
$nama=$d["nama"];
$email=$d["email"];
$pesan=$d["pesan"];
$tanggals=WKT($d["tanggal"]);
$no++;
$gab=$gab."No $no. $kode_bukutamu<br>Nama : $nama<br>Pesan: $pesan ($tanggals)<hr>";
}
echo'<marquee onmouseover=this.stop() onmouseout=this.start() scrollamount=2 scrolldelay=90 direction=up width=100% height=150>'.$gab.'</marquee>';
?>

BUAT-KALENDER

<?php

function buatkalender($tanggal,$bulan,$tahun) {

$bulanan=array(1=>"Januari","Februari","Maret","April",

"Mei","Juni","Juli","Agustus","September",

"Oktober","November","Desember");

$bln=date("n");

$thn=date("Y");

$jmlhari = date("t",mktime(0,0,0,$bulan,1,$tahun));

$haritglsatu = date("w",mktime(0,0,0,$bulan,1,$tahun));

$kalender = "<table cellspacing=1 cellpadding=4

border=0 class=tabel_data>\n";

$kalender .= "<tr class=tr_terang>

<td colspan=7>$bulanan[$bln], $thn

</td></tr>\n";

$kalender .= "<tr class=tr_judul>

<td>K</td><td>J</td><td>S</td></tr>\n";

$a = 1;

$adabaris = TRUE;

$mulaicetak = 0;

while ($adabaris) {

$kalender .= "<tr align=center class=tr_terang>";

for ($i = 0; $i < 7; $i++ ) {

if ($mulaicetak < $haritglsatu) {

$kalender .= "<td> </td>";

$mulaicetak++;

}

elseif ($a <= $jmlhari) {

$tt = $a;

if ($a == $tanggal) {

$tt = "<span style='color: blue; font-weight: bold;

font-size: larger; text-decoration: blink;'>

$tt</span>";

}

if ($i == 0) {

$tt = "<font color=\"#FF0000\">$tt</font>";

}

$kalender .= "<td>$tt</td>";

$a++;

}

else {

$kalender .= "<td> </td>";

}

$kalender .= "</tr>\n";

if ($a <= $jmlhari) {

$adabaris = TRUE;

}

else {

$adabaris = FALSE;

}

$kalender .= "</table>\n";

return $kalender;

}

SEARCHING GOOGLE

</FORM>

KALENDER TABEL:

<?php

$month= date ("m");

$year=date("Y");

$day=date("d");

$endDate=date("t",mktime(0,0,0,$month,$day,$year));

echo '<font face="arial" size="2">';

echo '<table align="center" border="0" cellpadding=5 cellspacing=5 style=""><tr><td align=center>';

echo "Hari ini tanggal : ".date("d F Y ",mktime(0,0,0,$month,$day,$year));

echo '</td></tr></table>';

echo '<table align="center" border="0" cellpadding=1 cellspacing=1 style="border:1px solid #CCCCCC">

<td align=center><font color=red>Minggu</font></td>

<td align=center>Senin</td>

<td align=center>Selasa</td>

<td align=center>Kamis</td>

<td align=center>Jumat</td>

<td align=center>Sabtu</td>

</tr>';

$s=date ("w", mktime (0,0,0,$month,1,$year));

for ($ds=1;$ds<=$s;$ds++) {

echo "<td style=\"font-family:arial;color:#B3D9FF\" align=center valign=middle bgcolor=\"#FFFFFF\"></td>";

}

for ($d=1;$d<=$endDate;$d++) {

if (date("w",mktime (0,0,0,$month,$d,$year)) == 0) { echo "<tr>"; }

$fontColor="#000000";

if (date("D",mktime (0,0,0,$month,$d,$year)) == "Sun") { $fontColor="red"; }

echo "<td style=\"font-family:arial;color:#333333\" align=center valign=middle> <span style=\"color:$fontColor\">$d</span></td>";

if (date("w",mktime (0,0,0,$month,$d,$year)) == 6) { echo "</tr>"; }}

echo '</table>';

MARQUEE GAMBAR LEFT

function bukajendela(url) {

window.open(url, "window_baru", "width=800,height=600,left=320,top=100,resizable=1,scrollbars=1");

}

</script>

<?php

$s = mysql_query("SELECT * FROM `galeri`");

while ($w = mysql_fetch_array($s)) {

$idgaleri=$w["id-galeri"];

echo "

</a> ";

}

</marquee>

DIE

<?php

die("<script>location.href='index.php';</script>");

ENKRIPSI KATA UBAH_TEKS:

<?php

function ubah_teks($teks){

$teks = strrev($teks);

$st = "";

for ($i=0; $i < strlen($teks); $i++){

$ascii = ord(substr($teks, $i, 1));

$hex = dechex($ascii);

if (strlen($hex) == 1)

$hex = "0" . $hex;

$st = $st . $hex;

}

return $st;

}

function balik_teks($teks){

$st = "";

for ($i=0; $i < strlen($teks) / 2; $i++){

$dua_angka = substr($teks, 2 * $i, 2);

$des = hexdec($dua_angka);

$kar = chr($des);

$st = $st . $kar;

}

$st = strrev($st);

return $st;

}

REFRESH META

<?php

echo "<meta http-equiv='refresh' content='0; url=berita-$_POST[id].html'>";

BACK JAVASCIPT

<?php

echo "Kode yang Anda masukkan tidak cocok<br /><a href=javascript:history.go(-1)><b>Ulangi Lagi</b></a>";

<?php

function ANTITEXTPANJANG($isi_komentar){

// Mengatasi input komentar tanpa spasi

$split_text = explode(" ",$isi_komentar);

$split_count = count($split_text);

$max = 57;

for($i = 0; $i <= $split_count; $i++){

if(strlen($split_text[$i]) >= $max){

for($j = 0; $j <= strlen($split_text[$i]); $j++){

$char[$j] = substr($split_text[$i],$j,1);

if(($j % $max == 0) && ($j != 0)){

$v_text .= $char[$j] . ' ';

}else{

$v_text .= $char[$j];

}

}else{

$v_text .= " " . $split_text[$i] . " ";

}

return $v_text;

}

VALIDASI EMPTY

<?php

$nama=trim($_POST['nama_komentar']);

$komentar=trim($_POST['isi_komentar']);

if (empty($nama)){echo "Anda belum mengisikan NAMA<br /><a href=javascript:history.go(-1)><b>Ulangi Lagi</b>";}

elseif (empty($komentar)){echo "Anda belum mengisikan KOMENTAR<br /><a href=javascript:history.go(-1)><b>Ulangi Lagi</b>";}

elseif (strlen($komentar) > 1000){echo "KOMENTAR Anda terlalu panjang (max 1000 char)<br /><a href=javascript:history.go(-1)><b>Ulangi Lagi</b>";}

else{}

CAPTCA.PHP

<?php

session_start();

header("Content-type: image/png");

$captcha_image = imagecreatefrompng("ypathicon/captcha.png");

$captcha_font = imageloadfont("ypathicon/font.gdf");

$captcha_text = substr(md5(uniqid('')),-6,6);

$_SESSION['captcha_session'] = $captcha_text;

$captcha_color = imagecolorallocate($captcha_image,0,0,0);

imagestring($captcha_image,$captcha_font,15,5,$captcha_text,$captcha_color);

imagepng($captcha_image);

imagedestroy($captcha_image);

<?php

//Form komentar

$materi="berita";

$idberita="B1108001";

$iddata=$idberita;

echo "<br /><br /><b>Isi Komentar Anda :</b>

<tr><td>Email </td><td> : <input type='text' name='email_komentar' size='50' maxlength='50'></td></tr>

<tr><td valign=top>Komentar </td><td> <textarea name='isi_komentar' style='width: 300px; height: 100px;'></textarea></td></tr>

<tr><td>  </td><td> (Masukkan 6 kode diatas)<br />

</form></table><br />";

<?php

if(!empty($_POST['kodecaptcha'])){

if($_POST['kodecaptcha']==$_SESSION['captcha_session']){

$nama_komentar=trim($_POST['nama_komentar']);

$isi_komentar=trim($_POST['isi_komentar']);

$email_komentar=trim($_POST['email_komentar']);

if (empty($nama_komentar)){echo "Maaf, Anda belum mengisikan Nama Anda...<br /><a href=javascript:history.go(-1)><b>Ulangi Lagi</b>";}

elseif (empty($komentar)){echo "Anda belum mengisikan Komentar Anda <br /><a href=javascript:history.go(-1)><b>Ulangi Lagi</b>";}

elseif (strlen($komentar) > 1000){echo "Maaf, KOMENTAR Anda terlalu panjang (max 1000 char)<br /><a href=javascript:history.go(-1)><b>Ulangi Lagi</b>";}

else{

//SIMPAN KOMENTAR

}

else{

echo"<script>alert('Maaf, Kode Captcha Anda salah...Silakan cek kembali...');

document.location.href='javascript:history.go(-1)';</script>";

}

else{

echo"<script>alert('Silakan isi Kode Captcha Anda...Atau Silakan cek kembali...');

document.location.href='javascript:history.go(-1)';</script>";

}

BACA TXT

function bacatext(){

$myFile = "notepad.txt";

$FP = fopen($myFile, 'r');

while(!feof($FP)){

$line = fgets($FP);

$line = htmlspecialchars($line);

echo($line);

}

fclose($FP);

}

echo bacatext();

<?php

echo date("d-m-Y H:i:s");

3GP PLAYER

<?php

echo ("<embed src='multimedia/ironman.3gp' autostart='false' width='200' height='200'></embed>");

AJAX

var xmlHttp

function showUser(str){

xmlHttp=GetXmlHttpObject()

if (xmlHttp==null){

alert ("Browser tidak support HTTP Request")

return

}

var url="getuser.php"

url=url+"?q="+str

url=url+"&sid="+Math.random()

xmlHttp.onreadystatechange=SC1

xmlHttp.open("GET",url,true)

xmlHttp.send(null)

}

function SC1() {

if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){

document.getElementById("txtHint").innerHTML=xmlHttp.responseText

}

function GetXmlHttpObject(){

var xmlHttp=null;

try{xmlHttp=new XMLHttpRequest();}

catch (e){

try{xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");}

catch (e){xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");}

}

return xmlHttp;

}

</script>

</head>

<body>

<form>

Pilih User:

</select>

</form>

<p>

<div id="txtHint"><b>Informasi user akan tampil di sini...</b></div>

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++

GMAP LINK

echo "<iframe width='96%' height='630' frameborder='0' scrolling='no' marginheight='0' marginwidth='0' src='$t[iframe]'></iframe><br />

MYCALENNDER

<?php

echo mycalender(date("d"),date("m"),date("Y"));

<?php

function mycalender($tanggal,$bulan,$tahun) {

$bulanan=array(1=>"Januari","Februari","Maret","April",

"Mei","Juni","Juli","Agustus","September",

"Oktober","November","Desember");

$bln=date("n");

$thn=date("Y");

$jmlhari = date("t",mktime(0,0,0,$bulan,1,$tahun));

$haritglsatu = date("w",mktime(0,0,0,$bulan,1,$tahun));

$kalender = "<table cellspacing=1 cellpadding=4

border=0 class=tabel_data>\n";

$kalender .= "<tr class=tr_terang>

<td colspan=7>$bulanan[$bln], $thn

</td></tr>\n";

$kalender .= "<tr class=tr_judul>

<td>K</td><td>J</td><td>S</td></tr>\n";

$a = 1;

$adabaris = TRUE;

$mulaicetak = 0;

while ($adabaris) {

$kalender .= "<tr align=center class=tr_terang>";

for ($i = 0; $i < 7; $i++ ) {

if ($mulaicetak < $haritglsatu) {

$kalender .= "<td> </td>";

$mulaicetak++;

}

elseif ($a <= $jmlhari) {

$tt = $a;

if ($a == $tanggal) {

$tt = "<span style='color: blue; font-weight: bold;

font-size: larger; text-decoration: blink;'>

$tt</span>";

}

if ($i == 0) {

$tt = "<font color=\"#FF0000\">$tt</font>";

}

$kalender .= "<td>$tt</td>";

$a++;

}

else {

$kalender .= "<td> </td>";

}

$kalender .= "</tr>\n";

if ($a <= $jmlhari) {

$adabaris = TRUE;

}

else {

$adabaris = FALSE;

}

$kalender .= "</table>\n";

return $kalender;

}

MYCALLENDER2

<?php

$month= date ("m");

$year=date("Y");

$day=date("d");

$endDate=date("t",mktime(0,0,0,$month,$day,$year));

echo '<font face="arial" size="2">';

echo '<table align="center" border="0" cellpadding=5 cellspacing=5 style=""><tr><td align=center>';

echo "Hari ini tanggal : ".date("d F Y ",mktime(0,0,0,$month,$day,$year));

echo '</td></tr></table>';

echo '<table align="center" border="0" cellpadding=1 cellspacing=1 style="border:1px solid #CCCCCC">

<td align=center><font color=red>Minggu</font></td>

<td align=center>Senin</td>

<td align=center>Selasa</td>

<td align=center>Kamis</td>

<td align=center>Jumat</td>

<td align=center>Sabtu</td>

</tr>';

$s=date ("w", mktime (0,0,0,$month,1,$year));

for ($ds=1;$ds<=$s;$ds++) {

echo "<td style=\"font-family:arial;color:#B3D9FF\" align=center valign=middle bgcolor=\"#FFFFFF\"></td>";

}

for ($d=1;$d<=$endDate;$d++) {

if (date("w",mktime (0,0,0,$month,$d,$year)) == 0) { echo "<tr>"; }

$fontColor="#000000";

if (date("D",mktime (0,0,0,$month,$d,$year)) == "Sun") { $fontColor="red"; }

echo "<td style=\"font-family:arial;color:#333333\" align=center valign=middle> <span style=\"color:$fontColor\">$d</span></td>";

if (date("w",mktime (0,0,0,$month,$d,$year)) == 6) { echo "</tr>"; }}

echo '</table>';

ADD SMILLEY

function addSmiley(textToAdd){

document.formshout.pesanShout.value += textToAdd;

document.formshout.pesanShout.focus();

}

</script>

</td></tr>

<tr>

OUTNYA:

<?php

require_once "../koneksi.php";

$shoutbox=mysql_query("SELECT * FROM `$tbshoutbox` WHERE `status`='Y' ORDER BY `kode_shout` DESC LIMIT 10");

while($d=mysql_fetch_array($shoutbox)){

$pesan = $d["pesan"];

$email=$d["email"];

$pesan = str_replace(":-)", "<img src=\"smiley/1.gif\">", $pesan);

$pesan = str_replace(":-(", "<img src=\"smiley/2.gif\">", $pesan);

$pesan = str_replace(";-)", "<img src=\"smiley/3.gif\">", $pesan);

$pesan = str_replace(";-D", "<img src=\"smiley/4.gif\">", $pesan);

$pesan = str_replace(";;-)", "<img src=\"smiley/5.gif\">", $pesan);

$pesan = str_replace(";:D;", "<img src=\"smiley/6.gif\">", $pesan);

// Apabila ada link website diisi, tampilkan dalam bentuk link

if ($email!=''){

echo "<span class=shout><b><a href='mailto:$d[email]' target='_blank'>$d[nama]</a> : </b></span>";

}

else{

echo "<span class=shout><b>$d[nama] : </b></span>";

}

echo "<span class=shout>$pesan</span><br />";

echo "<span class=date><font color='#6515ff'>".WKT2($d["tanggal"])."#</font></span>";

echo "<hr color=#e0cb91 noshade=noshade />";

}

Sabtu, 14 Juli 2018

Fungsi Waktu

Selasa, 10 Juli 2018

PHP Code Grafik Realtime

<!DOCTYPE html>
<html>
<body>
<script>

function changeImage() {
var image = document.getElementById('myImage');
image.src = "http://localhost/Master/grafikRealtimes/myGrafik/indexgrafik.php?" + new Date().getTime();
}

function countdown() {
var count = 2;
var timerId = setInterval(function() {
count--;// console.log(count);
document.getElementById("cdown").innerHTML = count.toString();
if(count == 0) {
changeImage();
count = 2;
}
}, 1000);
}

countdown();
</script>
<p>welcome lp2m aray : <span id="cdown" style="color:blue; font-size:20px"></span></p>
<img id="myImage" src="http://localhost/Master/grafikRealtimes/myGrafik/indexgrafik.php?" width="800" height="500" />

</body>
</html>

Download Code

PHP CODE Generate QRCODE

<?php

$NF="lp2maray.png";

include "qrlib.php";
$errorCorrectionLevel = 'L';//'L','M','Q','H'
$matrixPointSize = 4;//sd 10

$PNG_WEB_DIR = 'ypathfile/';
$namaPathFile=$PNG_WEB_DIR.$NF;

$isipesan="LP2M ARAY JAKARTA";
QRcode::png($isipesan, $namaPathFile, $errorCorrectionLevel, $matrixPointSize, 2);

echo '<img src="'.$namaPathFile.'" /><hr/>';

?>

Download LIB:

Web Montecarlo Prediksi Harga Pasar

Simulasi Perhitungan
Download

<?php
$range=10;
$hari="150";
if(isset($_POST["Hitung"])){
$id_pasar=$_POST["id_pasar"];;
$id_jenisbahan=$_POST["id_jenisbahan"];;
$range=$_POST["range"];;
$hari=$_POST["hari"];;
}
?>

<form id="form1" name="form1" method="post" action="">
<table width="60%" border="1">
<tr>
<td width="33%">Pilih Jenis Bahan</td>
<td width="2%">:</td>
<td width="65%"><select name="id_jenisbahan" id="id_jenisbahan">
<option>-</option>
<?php
$sql="select * from `$tbjenisbahan`";
$arr=getData($conn,$sql);
foreach($arr as $d) {
$id_jenisbahan0=$d["id_jenisbahan"];
$nama_jenisbahan=$d["nama_jenisbahan"];
echo"<option value='$id_jenisbahan0' ";if($id_jenisbahan0==$id_jenisbahan){echo"selected";} echo">$nama_jenisbahan</option>";
}
?>
</select></td>
</tr>
<tr>
<td>Pilih Pasar</td>
<td>:</td>
<td><select name="id_pasar" id="id_pasar">
<option>-</option>
<?php
$sql="select * from `tb_pasar`";
$arr=getData($conn,$sql);
foreach($arr as $d) {
$id_pasar0=$d["id_pasar"];
$nama_pasars=$d["nama_pasar"];
echo"<option value='$id_pasar0' ";if($id_pasar0==$id_pasar){echo"selected";} echo">$nama_pasars</option>";
}
?>
</select></td>
</tr>
<tr>
<td>Tentukan Range</td>
<td>:</td>
<td><input name="range" type="text" id="range" value="<?php echo $range;?>" size="30" /></td>
</tr>
<tr>
<td>Prediksi YAD</td>
<td>:</td>
<td><input name="hari" type="text" id="hari" value="<?php echo $hari;?>" size="30" /></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Hitung" id="Hitung" value="Hitung" /></td>
</tr>
</table>
</form>

<?php
if(isset($_POST["Hitung"])){
$id_pasar=$_POST["id_pasar"];;
$id_jenisbahan=$_POST["id_jenisbahan"];;
$range=$_POST["range"];;
$hari=$_POST["hari"];;

$dur=$hari;

//Full texts id_harga id_jenisbahan id_pasar harga id_user tanggal key
$sql="select * from `$tbharga` where id_pasar='$id_pasar' and id_jenisbahan ='$id_jenisbahan'";
$arr=getData($conn,$sql);
$i=0;
foreach($arr as $d) {
$atanggal[$i]=WKT($d["tanggal"]);
$ajenis[$i]=$d["id_jenisbahan"];
$aharga[$i]=$d["harga"];
$i++;
}
$lop=$i;
$min=min($aharga);
$max=max($aharga);
$int=$range;
$sel=($max-$min)/$int;

echo"Harga id_jenisbahan $id_jenisbahan id_pasar $id_pasar :<br>";
echo"Min : $min s/d Max : $max / Interval $int = $sel<hr>";

echo"<table width='100%'><tr><td>No<td>Harga1<td>Harga2<td>Mid<td>frek<td>Range</tr>";
$harga2=$min;
$data0=0;
$tot=0;
for($i=0;$i<$int;$i++){
$no=$i+1;
$harga1=$harga2;
$harga2=$harga1+$sel;
$mid=($harga1+$harga2)/2;
$frek=getHitung($conn,$harga1,$harga2,$id_pasar,$id_jenisbahan)/100;

$armin[$i]=$data0;
$armax[$i]=$armin[$i]+$frek;
$data0=$armax[$i];
$armid[$i]=$mid;
$tot+=$frek;
echo"<tr>";
echo"
<td>$no
<td>".round($harga1)."
<td>".round($harga2)."
<td>".round($mid)."
<td>$frek
<td>".$armin[$i]. " s/d ".$armax[$i]."
</tr>";
}
echo"</table>";

echo"Total frek=$tot";

$tgl =date("Y-m-d");

echo"<hr>Prediksi $dur hari next";
echo"<table width='100%'><tr><td>No<td>Tanggal<td>Random<td>Prediksi<td>Note</td></tr>";
for($i=0;$i<$dur;$i++){
$no=$i+1;
$R=rand(0,(100*$tot))/100;

for($j=0;$j<$int;$j++){
$pre=0;
if($R>=$armin[$j] && $R<$armax[$j]){$pre=$armid[$j];break;}
}

$m=$i+1;
$date=date_create($tgl);
date_add($date,date_interval_create_from_date_string($m." days"));
$date=date_format($date,"Y-m-d");

echo"<tr>
<td>$no
<td>".$date."
<td>$R
<td>".round($pre,2)."
<td>-</td></tr>";

}
echo"</table>";

}//isset

function getHitung($conn,$h1,$h2,$id_pasar,$id_jenisbahan){
$h2=$h2-1;
//Full texts id_harga id_jenisbahan id_pasar harga id_user tanggal key
$sql="select count(id_harga) as jum from `tb_harga` where `id_pasar`='$id_pasar' and id_jenisbahan='$id_jenisbahan' and harga between '$h1' and '$h2'";
$d=getField($conn,$sql);
$jum=$d["jum"];
return $jum;
}

Sip bisa yaaa