function savepostedcats()
{
global $settings;
$countcat = max_id("lb_categories");
//delete or update existing categories
for ($j = 1; $j <= $countcat; $j++) {
//preparing looped post-array-things
$tempcat = "cat" . $j;
$tempdesc = "desc" . $j;
$tempdel = "del" . $j;
//delete categories, if requested
if (isset($_POST[$tempdel])) {
$dosql = "DELETE FROM " . $GLOBALS['prefix'] . "lb_categories \n WHERE id = '" . $j . "';";
$result = mysql_query($dosql) or die(mysql_error());
} else {
//or update existing categories
if (isset($_POST[$tempcat])) {
$putcat = htmlentities($_POST[$tempcat], ENT_QUOTES, "UTF-8");
$putdes = htmlentities($_POST[$tempdesc], ENT_QUOTES, "UTF-8");
$dosql = "UPDATE " . $GLOBALS['prefix'] . "lb_categories SET\n name = '" . $putcat . "',\n description = '" . $putdes . "'\n WHERE id = '" . $j . "';";
$result = mysql_query($dosql) or die(mysql_error());
}
}
}
//add new categories
if (isset($_POST['newcat']) and $_POST['newcat'] != "") {
$putcat = htmlentities($_POST['newcat'], ENT_QUOTES, "UTF-8");
$putdes = htmlentities($_POST['newdesc'], ENT_QUOTES, "UTF-8");
$dosql = "INSERT INTO " . $GLOBALS['prefix'] . "lb_categories\n (name, description)\n VALUES (\n '" . $putcat . "', '" . $putdes . "' );";
$result = mysql_query($dosql) or die(mysql_error());
}
echo "<p class=\"msg\">";
echo "Successfully updated categories.</p>";
}
</div>
</form>
</div>
</div> <!-- card-body card-padding -->
</div> <!-- card -->
</div> <!-- col-md-12 -->
</div> <!-- row -->
<script type="text/javascript">
var app = angular.module('variableValue', []);
app.controller('MainCtrl', function($scope) {
$scope.id_variable_value = <?php
echo max_id('id_variable_value', 'variable_value');
?>
;
$scope.variable_alias = "<?php
echo $data['variable_alias'];
?>
";
$scope.variable_name = "<?php
echo $data['variable_name'];
?>
";
$scope.variable_value_alias = "<?php
echo $data['variable_value_alias'];
?>
";
$scope.change = function() {
$w_ids = array();
$snum = 0;
}
}
if ($snum) {
statuses_update($w_ids, $conn, $tc);
}
unset($w_ids);
mysql_free_result($result);
}
$c = new SaeTClientV2(WB_AKEY, WB_SKEY, $_SESSION['token']['access_token']);
/*
* Start looping
* 1. New statuses fetching
* 2. Expired statuses removing
* 3. Old statuses updating
*/
//mysql_connect
$conn = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("connect failed: " . mysql_error());
mysql_select_db(DB_DATABASENAME, $conn);
$max_id = max_id($conn);
while (true) {
$max_id = new_statuses_fetch($conn, $c, $max_id);
expired_statuses_remove($conn);
old_statuses_update($conn, $c);
mysql_close($conn);
sleep(REFRESH_PERIOD);
//mysql_connect
$conn = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die("connect failed: " . mysql_error());
mysql_select_db(DB_DATABASENAME, $conn);
}
<div class="card">
<div class="card-header">
<h2>Tambah Pegawai <small>Silahkan isi data Pegawai melalui form dibawah ini.</small></h2>
</div>
<!-- CONTENT -->
<form method="POST" action='aksi.php?module=pegawai&act=input' enctype='multipart/form-data' align='center'>
<div class="row m-10">
<div class="col-sm-6">
<dl class="dl-horizontal">
<dt class="p-t-10">No Pegawai</dt>
<dd>
<div class="input-group">
<div class="fg-line">
<input type="text" class="form-control" placeholder="Masukkan No Pegawai ..." name='id_karyawan' value="<?php
echo max_id('id_karyawan', 'karyawan');
?>
">
</div>
<span class="input-group-addon"><i class="md md-format-list-numbered"></i></span>
</div>
</dd>
</dl>
<dl class="dl-horizontal">
<dt class="p-t-10">Nama Pegawai</dt>
<dd>
<div class="input-group">
<div class="fg-line">
<input type="text" class="form-control" placeholder="Masukkan Nama Pegawai ..." name='nama_karyawan'>
</div>
<span class="input-group-addon"><i class="md md-person"></i></span>
<div class="card-header">
<h2>Tambah Anggota <small>Silahkan isi data anggota melalui form dibawah ini.</small></h2>
</div>
<!-- CONTENT -->
<form method=POST action='dynamic_aksi.php?module=data_anggota&act=input' align='center'>
<div class="row m-10">
<div class="col-sm-12">
<div class="pmbb-edit">
<dl class="dl-horizontal">
<dt class="p-t-10">No Anggota</dt>
<dd>
<div class="input-group">
<div class="fg-line">
<input type="text" class="form-control" placeholder="Masukkan No Anggota ..." name='id_nasabah' value="<?php
echo max_id('id_nasabah', 'nasabah');
?>
">
</div>
<span class="input-group-addon"><i class="md md-format-list-numbered"></i></span>
</div>
</dd>
</dl>
<dl class="dl-horizontal">
<dt class="p-t-10">Nama Anggota</dt>
<dd>
<div class="input-group">
<div class="fg-line">
<input type="text" class="form-control" placeholder="Masukkan Nama Anggota ..." name='nasabah_name'>
</div>
<span class="input-group-addon"><i class="md md-person"></i></span>
<div class="card-header">
<h2>Tambah Variable<small>Silahkan isi data variable baru melalui form dibawah ini.</small></h2>
</div>
<!-- CONTENT -->
<div class="card-body card-padding">
<form method=POST action='dynamic_aksi.php?module=dynamic_variable&act=input' align='center'>
<div class="row m-10">
<div class="col-sm-12">
<div class="pmbb-edit">
<dl class="dl-horizontal">
<dt class="p-t-10">ID Variable</dt>
<dd>
<div class="input-group">
<div class="fg-line">
<input type="text" class="form-control" placeholder="Masukkan ID Variable ..." name='id_variable' value="<?php
echo max_id('id_variable', 'variable');
?>
">
</div>
<span class="input-group-addon"><i class="md md-format-list-numbered"></i></span>
</div>
</dd>
</dl>
<dl class="dl-horizontal">
<dt class="p-t-10">Nama Variable</dt>
<dd>
<div class="input-group">
<div class="fg-line">
<input type="text" class="form-control" placeholder="Masukkan Nama Variable ..." name='variable_name' value="{{ nama_variable | lowercase | removeSpaces}}">
</div>
<span class="input-group-addon"><i class="md md-person"></i></span>
';
}
} else {
main_menu();
echo '
<table>
<form method=post>
<tr>
<td></td><td><input type=submit name=action value=new></td>
<td bgcolor=lightgray><input type=submit name=action value=edit></td>
<td bgcolor=lightgray><input type=submit name=action value=delete></td>
<td bgcolor=lightgray><input type=submit name=action value=view></td>
<td bgcolor=lightgray><input type=submit name=action value=print></td>
</tr>
<tr><td>Letter ID:</td><td colspan=5 bgcolor=lightgray><input type=text name=id></td>
<td bgcolor=lightgreen>last_id=' . max_id() . '</td></tr>
</table>
<table>
<tr>
<td bgcolor=lightpink><input type=submit name=action value=register></td>
<td>From ID:</td><td bgcolor=lightpink><input type=text name=from_id></td>
<td>To ID:</td><td bgcolor=lightpink><input type=text name=to_id></td>
</tr>
</form>
</table>
';
}
if (isset($_POST['action'])) {
if ($_POST['action'] == 'save') {
save_letter($_POST);
