}
$sInsertSql = buildSQLInsert('goods', $axInsert);
if ($mysqli->query($sInsertSql)) {
echo "";
}
if ($per_page == 5) {
$next_page = $page + 1;
echo '<form name="page" method="post" action="' . $_SERVER['PHP_SELF'] . '">', '<input type="hidden" name="page" value="' . $next_page . '">', '<script language="JavaScript">document.page.submit();</script></form>';
}
if ($per_page == 0 and $page == 1) {
echo '<script type="text/javascript">window.setTimeout(window.location="' . $_SERVER['PHP_SELF'] . '",0);</script>';
}
}
//ทำการลบสินค้าจากฐานข้อมูล
if (isset($_POST['submit_del'])) {
$sDelSql = buildSQLDelete('goods', 'ID_goods', "{$_POST['ID_goods']}");
if ($mysqli->query($sDelSql)) {
echo "";
}
if ($per_page == 1 and $page != 1) {
$pre_page = $page - 1;
echo '<form name="page" method="post" action="' . $_SERVER['PHP_SELF'] . '">', '<input type="hidden" name="page" value="' . $pre_page . '">', '<script language="JavaScript">document.page.submit();</script></form>';
}
echo '<script type="text/javascript">window.setTimeout(window.location="' . $_SERVER['PHP_SELF'] . '",0);</script>';
}
//ทำการแก้ไขตารางสินค้า
if (isset($_POST['submit_edit'])) {
if ($_FILES['new_Pic_goods']['name'] != '') {
upLoad('new_Pic_goods');
$axUpdate = array('Name_goods' => "{$_POST['new_Name_goods']}", 'Date_goods' => "{$_POST['new_Date_goods']}", 'Type_goods' => "{$_POST['new_Type_goods']}", 'Price_goods' => "{$_POST['new_Price_goods']}", 'Stock_goods' => "{$_POST['new_Stock_goods']}", 'Discount_goods' => "{$_POST['new_Discount_goods']}", 'DiscountDateStart_goods' => "{$_POST['new_DiscountDateStart_goods']}", 'DiscountTimeStart_goods' => "{$_POST['new_DiscountTimeStart_goods']}", 'DiscountDateEnd_goods' => "{$_POST['new_DiscountDateEnd_goods']}", 'DiscountTimeEnd_goods' => "{$_POST['new_DiscountTimeEnd_goods']}", 'Pic_goods' => "./images/" . basename($_FILES["new_Pic_goods"]["name"]), 'Add_goods' => "{$_POST['new_Add_goods']}");
} else {
$axInsert = array('ID_key' => "{$_POST['new_ID_key']}", 'Code_key' => "{$_POST['new_Code_key']}", 'Status_key' => "{$_POST['new_Status_key']}", 'ID_goods' => "{$_POST['new_ID_goods']}");
$sInsertSql = buildSQLInsert('key', $axInsert);
if ($mysqli->query($sInsertSql)) {
echo "";
}
if ($per_page == $limit) {
$next_page = $page + 1;
echo '<form name="page" method="post" action="' . $_SERVER['PHP_SELF'] . '">', '<input type="hidden" name="page" value="' . $next_page . '">', '<script language="JavaScript">document.page.submit();</script></form>';
}
if ($per_page == 0 and $page == 1) {
echo '<script type="text/javascript">window.setTimeout(window.location="' . $_SERVER['PHP_SELF'] . '",0);</script>';
}
}
//ทำการลบากฐานข้อมูล
if (isset($_POST['submit_del'])) {
$sDelSql = buildSQLDelete('key', 'ID_key', "{$_POST['ID_key']}");
if ($mysqli->query($sDelSql)) {
echo "";
}
if ($per_page == 1 and $page != 1) {
$pre_page = $page - 1;
echo '<form name="page" method="post" action="' . $_SERVER['PHP_SELF'] . '">', '<input type="hidden" name="page" value="' . $pre_page . '">', '<script language="JavaScript">document.page.submit();</script></form>';
}
echo '<script type="text/javascript">window.setTimeout(window.location="' . $_SERVER['PHP_SELF'] . '",0);</script>';
}
//ทำการแก้ไขตาราง
if (isset($_POST['submit_edit'])) {
$axUpdate = array('Code_key' => "{$_POST['new_Code_key']}", 'Status_key' => "{$_POST['new_Status_key']}", 'ID_goods' => "{$_POST['new_ID_goods']}");
$sEditSql = buildSQLUpdate('key', 'ID_key', "{$_POST['ID_key']}", $axUpdate);
if ($mysqli->query($sEditSql)) {
echo "";
