echo "Gagal:Db Error" . $strIns . "__" . mysql_error();
}
}
break;
case 'edit':
$strEdt = "update " . $dbname . ".kebun_5hargabibit set hargasatuan='" . $hargasatuan . "' where regional='" . $regional . "' and status='" . $status . "' and periode='" . $periode . "'";
if (mysql_query($strEdt)) {
loadlist();
} else {
echo "Gagal:Db Error" . $strEdt . "__" . mysql_error();
}
break;
case 'delete':
$str = "delete from " . $dbname . ".kebun_5hargabibit where regional='" . $regional . "' and status='" . $status . "' and periode='" . $periode . "'";
if (mysql_query($str)) {
loadlist();
} else {
echo "Gagal:Db Error" . $str . "__" . mysql_error();
}
break;
default:
break;
}
function loadlist()
{
global $conn;
global $dbname;
global $pages;
echo "<div id=container>\r\n\t\t<table class=sortable cellspacing=1 cellpadding=3 border=0>\r\n\t\t\t<thead>\r\n\t\t\t<tr class=rowheader>\r\n\t\t\t <td>" . $_SESSION['lang']['regional'] . "</td>\r\n\t\t\t <td>" . $_SESSION['lang']['status'] . "</td>\r\n\t\t\t <td>" . $_SESSION['lang']['periode'] . "</td>\r\n\t\t\t <td>" . $_SESSION['lang']['hargasatuan'] . "</td>\r\n\t\t\t <td colspan='2' style='text-align:center;'>" . $_SESSION['lang']['action'] . "</td>\r\n\t\t\t</tr>\r\n\t\t\t</thead>\r\n\t\t\t<tbody>";
$limit = 12;
$page = 0;
<?php
if ($_COOKIE['user'] == '') {
header("Location: index.php");
}
include_once 'config.php';
$f = $_POST['f'];
switch ($f) {
case 'insert':
insert($_POST['day'], $_POST['month'], $_POST['year']);
break;
case 'list':
loadlist($_POST['year']);
break;
case 'delete':
delete($_POST['ferieid']);
break;
}
////////////////functions///////////////////////////
function loadlist($year)
{
$thismonth = date("m");
$mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB);
$query = sprintf("SELECT * FROM `feries` WHERE `year`='%s' ORDER BY `year`,`month`,`day` ASC", $year);
$result = $mysqli->query($query);
while ($row = $result->fetch_object()) {
if ($row->month >= $thismonth) {
$trash = "<a href='javascript:deleteferie(" . $row->ferieid . ");'><img src='img/trash.png'/></a>";
} else {
$trash = "";
}