public function inserttrip()
{
$tripidser = mysql_real_escape_string($_POST['tripidser']);
$uidser = mysql_real_escape_string($_POST['uidser']);
$now = date("F j, Y, g:i a");
function autonumber($tabel, $kolom, $lebar = 0, $awalan = '')
{
$query = "select {$kolom} from {$tabel} order by {$kolom} desc limit 1";
$hasil = mysql_query($query);
$jumlahrecord = mysql_num_rows($hasil);
if ($jumlahrecord == 0) {
$nomor = 1;
} else {
$row = mysql_fetch_array($hasil);
$nomor = intval(substr($row[0], strlen($awalan))) + 1;
}
if ($lebar > 0) {
$angka = $awalan . str_pad($nomor, $lebar, "0", STR_PAD_LEFT);
} else {
$angka = $awalan . $nomor;
}
return $angka;
}
$resid = autonumber("ts_reseru", "resid", 7, "res");
$data = array('resid' => $resid, 'tripidser' => $tripidser, 'uidser' => $uidser, 'type' => 'trip', 'waktu' => $now);
$this->db->insert('ts_reseru', $data);
}
public function insert()
{
$triporder = mysql_real_escape_string($_POST['triporder']);
$namadestinasi = mysql_real_escape_string($_POST['namadestinasi']);
$uidorder = mysql_real_escape_string($_POST['uidorder']);
$berangkat = mysql_real_escape_string($_POST['berangkat']);
$hargades = mysql_real_escape_string($_POST['hargades']);
$pax = mysql_real_escape_string($_POST['pax']);
$email = mysql_real_escape_string($_POST['email']);
$totalbayar = mysql_real_escape_string($_POST['totalbayar']);
$now = date("F j, Y, g:i a");
function autonumber($tabel, $kolom, $lebar = 0, $awalan = '')
{
$query = "select {$kolom} from {$tabel} order by {$kolom} desc limit 1";
$hasil = mysql_query($query);
$jumlahrecord = mysql_num_rows($hasil);
if ($jumlahrecord == 0) {
$nomor = 1;
} else {
$row = mysql_fetch_array($hasil);
$nomor = intval(substr($row[0], strlen($awalan))) + 1;
}
if ($lebar > 0) {
$angka = $awalan . str_pad($nomor, $lebar, "0", STR_PAD_LEFT);
} else {
$angka = $awalan . $nomor;
}
return $angka;
}
$ordid = autonumber("ts_order", "ordid", 5, "ord");
$data = array('ordid' => $ordid, 'triporder' => $triporder, 'namadestinasi' => $namadestinasi, 'uidorder' => $uidorder, 'berangkat' => $berangkat, 'hargades' => $hargades, 'jumlah' => $pax, 'email' => $email, 'totalbayar' => $totalbayar, 'waktu' => $now, 'stat' => 'pending');
$this->db->insert('ts_order', $data);
}
public function insert()
{
$uid = mysql_real_escape_string($_POST['uid']);
$slug = url_title($this->input->post('judul'), 'dash', TRUE);
$judul = mysql_real_escape_string($_POST['judul']);
$deskripsi = htmlspecialchars($_POST['deskripsi']);
$now = date("F j, Y, g:i a");
function autonumber($tabel, $kolom, $lebar = 0, $awalan = '')
{
$query = "select {$kolom} from {$tabel} order by {$kolom} desc limit 1";
$hasil = mysql_query($query);
$jumlahrecord = mysql_num_rows($hasil);
if ($jumlahrecord == 0) {
$nomor = 1;
} else {
$row = mysql_fetch_array($hasil);
$nomor = intval(substr($row[0], strlen($awalan))) + 1;
}
if ($lebar > 0) {
$angka = $awalan . str_pad($nomor, $lebar, "0", STR_PAD_LEFT);
} else {
$angka = $awalan . $nomor;
}
return $angka;
}
$stoid = autonumber("ts_story", "stoid", 5, "STO");
$tags = explode(',', strtolower($_POST['tag']));
for ($x = 0; $x < count($tags); $x++) {
//Add new tag if not exist
$queryt = "INSERT INTO `ts_tag` (`tag_id`, `tag`) VALUES ('', '" . $tags[$x] . "')";
$maket = mysql_query($queryt);
//Get tag id
$tag_id = mysql_insert_id();
//Add the relational Link, now this is not working, beacasue this is only draft
$querytm = "insert into `ts_tagmap` (`id`, `tag_id`, `articleid`) VALUES ('', '{$tag_id}', '{$stoid}')";
$maketm = mysql_query($querytm);
}
$data = array('uidsto' => $uid, 'stoid' => $stoid, 'judul' => $judul, 'deskripsi' => $deskripsi, 'slug' => $slug, 'tgl' => $now);
$this->db->insert('ts_story', $data);
}
if ($lebar > 0) {
$angka = $awalan . str_pad($nomor, $lebar, "0", STR_PAD_LEFT);
} else {
$angka = $awalan . $nomor;
}
return $angka;
}
//Kode simpan
if (isset($_POST['simpan'])) {
mysql_query("INSERT INTO produk values('{$_POST['kode']}','{$_POST['produk']}')");
}
?>
<form action="autonumber.php" method="post">
<label>Kode Produk</label><br>
<input type="text" style="background:#CCC; border:none" name="kode" value="<?php
echo autonumber("produk", "kd_produk", 4, "PRD");
?>
" readonly="readonly"><br>
<label>Nama Produk</label><br>
<input type="text" name="produk"><br>
<input type="submit" value="Simpan" name="simpan" />
</form>
<table width="308" border="1" style="border-collapse:collapse; border:#000 1px solid;">
<tr>
<td width="84" align="center">Kode Produk</td><td width="161" align="center">Nama Produk</td>
</tr>
<?php
$q = mysql_query("SELECT * FROM produk order by kd_produk");
while ($data = mysql_fetch_array($q)) {
echo "<tr>\n\t\t\t\t<td>{$data['kd_produk']}</td><td>{$data['produk']}</td>\n\t\t\t </tr>";
}
<link href="css/bootstrap-responsive.css" rel="stylesheet">
<script src="js/jquery.js"></script>
<script src="js/bootstrap.js"></script>
</head>
<body>
<script src="selectharga.js"></script>
<h2>Tambah Data transaksi</h2>
<form method="post" enctype="multipart/form-data">
<table class="table table-stripped">
<tr>
<td>ID transaksi</td>
<td>:</td>
<td><input type="text" name="idtransaksi" value="<?php
echo autonumber("transaksi", "ID_TRANSAKSI", 3, "trans");
?>
" ></td>
</tr>
<tr>
<td>Tanggal</td>
<td>:</td>
<td><input type="date" name="tanggal">
</td>
</tr>
<tr>
<td>Jumlah transaksi</td>
<td>:</td>
<td><input type="number" name="jumlah"></td>
if ($jumlahrecord == 0) {
$nomor = 1;
} else {
$row = mysql_fetch_array($hasil);
$nomor = intval(substr($row[0], strlen($awalan))) + 1;
}
if ($lebar > 0) {
$angka = $awalan . str_pad($nomor, $lebar, "0", STR_PAD_LEFT);
} else {
$angka = $awalan . $nomor;
}
return $angka;
}
if (!empty($lokasi_file)) {
// Tentukan folder gambar untuk galeri
$folder = "images/";
// Gunakan fungsi thumb untuk membuat thumbnail
thumb($nama_file_unik, $folder);
}
$kodeberita = autonumber("berita", "idberita", 4, "BER");
$sql = mysqli_query($conn, "insert into berita values ('{$kodeberita}','{$_POST['judul']}','{$_POST['isi']}','{$nama_file_unik}','{$_POST['wkt']}','{$_POST['headline']}','{$_POST['slide']}')");
if ($_POST['headline'] == 'Yes') {
$sql1 = mysqli_query($conn, "insert into headline values ('','{$kodeberita}','{$_POST['judul']}','{$_POST['isi']}','{$nama_file_unik}','{$_POST['wkt']}')");
}
if ($_POST['slide'] == 'Yes') {
$sql2 = mysqli_query($conn, "insert into slide values ('','{$kodeberita}','{$_POST['judul']}','{$_POST['isi']}','{$nama_file_unik}','{$_POST['wkt']}')");
}
header('location:berita.php');
?>
public function register_to()
{
//$poin = mysql_real_escape_string($_POST['poin']);
$nama = mysql_real_escape_string($_POST['nama']);
$email = mysql_real_escape_string($_POST['email']);
$perusahaan = mysql_real_escape_string($_POST['perusahaan']);
$legal = mysql_real_escape_string($_POST['legal']);
$password = mysql_real_escape_string($_POST['password']);
$stat = 0;
function autonumber($tabel, $kolom, $lebar = 0, $awalan = '')
{
$query = "select {$kolom} from {$tabel} order by {$kolom} desc limit 1";
$hasil = mysql_query($query);
$jumlahrecord = mysql_num_rows($hasil);
if ($jumlahrecord == 0) {
$nomor = 1;
} else {
$row = mysql_fetch_array($hasil);
$nomor = intval(substr($row[0], strlen($awalan))) + 1;
}
if ($lebar > 0) {
$angka = $awalan . str_pad($nomor, $lebar, "0", STR_PAD_LEFT);
} else {
$angka = $awalan . $nomor;
}
return $angka;
}
$partid = autonumber("ts_partner", "partid", 5, "TO");
$datareg = array('email' => $email, 'nama' => $nama, 'perusahaan' => $perusahaan, 'legal' => $legal, 'password' => md5($password), 'join_date' => date("d/m/Y H:i:s"), 'partid' => $partid, 'tipe' => 'TO');
//var_dump($datareg);
$this->db->insert('ts_partner', $datareg);
$sessiondata = array('partid' => $partid, 'username' => $nama, 'email' => $email, 'logged_in' => TRUE);
//var_dump($userdata);
$this->session->set_userdata($sessiondata);
//sending email
//$this->load->library('email');
// $this->email->set_mailtype("html");
// $email_body ="<html><head><style type='text/css'>
// #outlook a{padding:0;}
// body{width:100% !important;} .ReadMsgBody{width:100%;} .ExternalClass{width:100%;}
// body{-webkit-text-size-adjust:none;}
// body{margin:0; padding:0;}
// img{border:0; height:auto; line-height:100%; outline:none; text-decoration:none;}
// table td{border-collapse:collapse;}
// #backgroundTable{height:100% !important; margin:0; padding:0; width:100% !important;}
// body, #backgroundTable{
// background-color:#FAFAFA;
// }
// #templateContainer{
// border: 1px solid #DDDDDD;
// }
// h1, .h1{
// color:#202020;
// display:block;
// font-family:Arial;
// font-size:34px;
// font-weight:bold;
// line-height:100%;
// margin-top:0;
// margin-right:0;
// margin-bottom:10px;
// margin-left:0;
// text-align:left;
// }
// h2, .h2{
// color:#202020;
// display:block;
// font-family:Arial;
// font-size:30px;
// font-weight:bold;
// line-height:100%;
// margin-top:0;
// margin-right:0;
// margin-bottom:10px;
// margin-left:0;
// text-align:left;
// }
// h3, .h3{
// color:#202020;
// display:block;
// font-family:Arial;
// font-size:26px;
// font-weight:bold;
// line-height:100%;
// margin-top:0;
// margin-right:0;
// margin-bottom:10px;
// margin-left:0;
// text-align:left;
// }
// h4, .h4{
// color:#202020;
// display:block;
// font-family:Arial;
// ont-size:22px;
// font-weight:bold;
// line-height:100%;
// margin-top:0;
// margin-right:0;
// margin-bottom:10px;
// margin-left:0;
// ext-align:left;
// }
// #templateHeader{
// background-color:#FFFFFF;
// border-bottom:0;
// }
// .headerContent{
// color:#202020;
// font-family:Arial;
// font-size:34px;
// font-weight:bold;
// line-height:100%;
// padding:10px;
// text-align:center;
// vertical-align:middle;
// background: none repeat scroll 0 0 #EEEEEE;
// }
// .headerContent a:link, .headerContent a:visited, .headerContent a .yshortcuts {
// color:#336699;
// font-weight:normal;
// text-decoration:underline;
// }
// #headerImage{
// height:auto;
// max-width:600px !important;
// }
// #templateContainer, .bodyContent{
// background-color:#FFFFFF;
// }
// .bodyContent div{
// color:#505050;
// font-family:Arial;
// font-size:14px;
// line-height:150%;
// text-align:left;
// }
// .bodyContent div a:link, .bodyContent div a:visited, /* Yahoo! Mail Override */ .bodyContent div a .yshortcuts /* Yahoo! Mail Override */{
// color:#336699;
// font-weight:normal;
// text-decoration:underline;
// }
// .templateDataTable{
// background-color:#FFFFFF;
// border:1px solid #DDDDDD;
// }
// .dataTableHeading{
// background-color:#D8E2EA;
// color:#336699;
// font-family:Helvetica;
// font-size:14px;
// font-weight:bold;
// line-height:150%;
// text-align:left;
// }
// .dataTableHeading a:link, .dataTableHeading a:visited, /* Yahoo! Mail Override */ .dataTableHeading a .yshortcuts /* Yahoo! Mail Override */{
// color:#FFFFFF;
// font-weight:bold;
// text-decoration:underline;
// }
// .dataTableContent{
// border-top:1px solid #DDDDDD;
// border-bottom:0;
// color:#202020;
// font-family:Helvetica;
// font-size:12px;
// font-weight:bold;
// line-height:150%;
// text-align:left;
// }
// .dataTableContent a:link, .dataTableContent a:visited, /* Yahoo! Mail Override */ .dataTableContent a .yshortcuts /* Yahoo! Mail Override */{
// color:#202020;
// font-weight:bold;
// text-decoration:underline;
// }
// .templateButton{
// -moz-border-radius:3px;
// -webkit-border-radius:3px;
// background-color:#336699;
// border:0;
// border-collapse:separate !important;
// border-radius:3px;
// }
// .templateButton, .templateButton a:link, .templateButton a:visited, /* Yahoo! Mail Override */ .templateButton a .yshortcuts /* Yahoo! Mail Override */{
// color:#FFFFFF;
// font-family:Arial;
// font-size:15px;
// font-weight:bold;
// letter-spacing:-.5px;
// line-height:100%;
// text-align:center;
// text-decoration:none;
// }
// .bodyContent img{
// display:inline;
// height:auto;
// }
// #templateFooter{
// background-color:#FFFFFF;
// border-top:0;
// }
// .footerContent div{
// color:#707070;
// font-family:Arial;
// font-size:12px;
// line-height:125%;
// text-align:center;
// }
// .footerContent div a:link, .footerContent div a:visited, /* Yahoo! Mail Override */ .footerContent div a .yshortcuts /* Yahoo! Mail Override */{
// color:#336699;
// font-weight:normal;
// text-decoration:underline;
// }
// .footerContent img{
// display:inline;
// }
// #utility{
// background-color:#FFFFFF;
// border:0;
// }
// #utility div{
// text-align:center;
// }
// #monkeyRewards img{
// max-width:190px;
// }
// </style>
// </head>
// <body leftmargin='0' marginwidth='0' topmargin='0' marginheight='0' offset='0'>
// <center>
// <table border='0' cellpadding='0' cellspacing='0' height='100%' width='100%' id='backgroundTable'>
// <tr>
// <td align='center' valign='top' style='padding-top:20px;'>
// <table border='0' cellpadding='0' cellspacing='0' width='600' id='templateContainer'>
// <tr>
// <td align='center' valign='top'>
// <!-- // Begin Template Header \\ -->
// <table border='0' cellpadding='0' cellspacing='0' width='600' id='templateHeader'>
// <tr>
// <td class='headerContent'>
// <td width='65%' style='background:#eee'>
// <img src='http://ayopeduli.com/wp-content/themes/ayopeduli/images/logo.png' style='max-width:600px;width:80px;' id='headerImage campaign-icon' mc:label='header_image' mc:edit='header_image' mc:allowdesigner mc:allowtext />
// </td>
// <td width='35%' style='background:#eee'>Mulai petik kesuksesanmu sekarang!</td>
// </td>
// </tr>
// </table>
// <!-- // End Template Header \\ -->
// </td>
// </tr>
// <tr>
// <td align='center' valign='top'>
// <!-- // Begin Template Body \\ -->
// <table border='0' cellpadding='0' cellspacing='0' width='600' id='templateBody'>
// <tr>
// <td valign='top'>
// <!-- // Begin Module: Standard Content \\ -->
// <table border='0' cellpadding='20' cellspacing='0' width='100%'>
// <tr>
// <td valign='top' class='bodyContent'>
// <div mc:edit='std_content00'>
// <h4 class='h4'>Hi $nama,</h4>
// Selamat, Kamu telah bergabung menjadi bagian dari ribuan agent tripseru.com:
// </div>
// </td>
// </tr>
// <tr>
// <td valign='top' style='padding-top:0; padding-bottom:0;'>
// <table border='0' cellpadding='10' cellspacing='0' width='100%' class='templateDataTable'>
// <tr mc:repeatable>
// <td valign='top' class='dataTableContent' mc:edit='data_table_content00'>
// Untuk selanjutnys
// :</td>
// <td valign='top' class='dataTableContent' mc:edit='data_table_content01'>
//
// </td>
// </tr>
//
// </table>
// </td>
// </tr>
// <tr>
//
// </tr>
// </table>
// <!-- // End Module: Standard Content \\ -->
// </td>
// </tr>
// </table>
// <!-- // End Template Body \\ -->
// </td>
// </tr>
// <tr>
// <td align='center' valign='top'>
// <!-- // Begin Template Footer \\ -->
// <table border='0' cellpadding='10' cellspacing='0' width='600' id='templateFooter'>
// <tr>
// <td valign='top' class='footerContent'>
// <!-- // Begin Module: Transactional Footer \\ -->
// <table border='0' cellpadding='10' cellspacing='0' width='100%'>
// <tr>
// <td valign='top'>
// <div mc:edit='std_footer'>
// <em>Copyright © 2015 tripseru.com.com, All rights reserved.</em>
// </div>
// </td>
// </tr>
// <tr>
// <td valign='middle' id='utility'>
// </td>
// </tr>
// </table>
// <!-- // End Module: Transactional Footer \\ -->
// </td>
// </tr>
// </table>
// <!-- // End Template Footer \\ -->
// </td>
// </tr>
// </table>
// <br />
// </td>
// </tr>
// </table>
// </center>
// </body>
// </html>";
// $this->email->from('*****@*****.**', 'Partner Tripseru.com');
// //$list = array('*****@*****.**');
// $this->email->to($email);
// //$this->email->cc('*****@*****.**');
// $this->email->subject('Selamat bergabung menjadi partner Tripseru.com');
// $this->email->message($email_body);
//
// $this->email->send();
// //echo $this->email->print_debugger();
}
<?php
require "connect.php";
mysql_connect("localhost", "root", "");
mysql_select_db("uniraweb");
function autonumber($tabel, $kolom, $lebar = 0, $awalan = '')
{
$query = "select {$kolom} from {$tabel} order by {$kolom} desc limit 1";
$hasil = mysql_query($query);
$jumlahrecord = mysql_num_rows($hasil);
if ($jumlahrecord == 0) {
$nomor = 1;
} else {
$row = mysql_fetch_array($hasil);
$nomor = intval(substr($row[0], strlen($awalan))) + 1;
}
if ($lebar > 0) {
$angka = $awalan . str_pad($nomor, $lebar, "0", STR_PAD_LEFT);
} else {
$angka = $awalan . $nomor;
}
return $angka;
}
$kodeadmin = autonumber("admin", "idadmin", 4, "adm");
$pass = md5($_GET['password']);
$sql = mysqli_query($conn, "insert into admin values ('{$kodeadmin}','{$_GET['nama']}','{$_GET['email']}','{$_GET['username']}','{$pass}')");
header('location:user.php');
?>
<link href="css/bootstrap-responsive.css" rel="stylesheet">
<script src="js/jquery.js"></script>
<script src="js/bootstrap.js"></script>
</head>
<body>
<script src="selectharga.js"></script>
<h2>Tambah Data Barang</h2>
<form method="post" enctype="multipart/form-data">
<table class="table table-stripped">
<tr>
<td>ID Barang</td>
<td>:</td>
<td><input type="text" name="idbarang" value="<?php
echo autonumber("tabel_barang", "ID_barang", 3, "fil");
?>
" ></td>
</tr>
<tr>
<td>Nama Barang</td>
<td>:</td>
<td><input type="text" name="namabarang">
</td>
</tr>
<tr>
<td>Harga Barang</td>
<td>:</td>
<td><input type="number" name="harga"></td>
if ($jumlahrecord == 0) {
$nomor = 1;
} else {
$row = mysql_fetch_array($hasil);
$nomor = intval(substr($row[0], strlen($awalan))) + 1;
}
if ($lebar > 0) {
$angka = $awalan . str_pad($nomor, $lebar, "0", STR_PAD_LEFT);
} else {
$angka = $awalan . $nomor;
}
return $angka;
}
if (!empty($lokasi_file)) {
// Tentukan folder gambar untuk galeri
$folder = "images/";
// Gunakan fungsi thumb untuk membuat thumbnail
thumb($nama_file_unik, $folder);
}
$kodepeng = autonumber("pengumuman", "idpeng", 4, "PENG");
$sql = mysqli_query($conn, "insert into pengumuman values ('{$kodepeng}','{$_POST['judul']}','{$_POST['isi']}','{$nama_file_unik}','{$_POST['wkt']}','{$_POST['headline']}','{$_POST['slide']}')");
if ($_POST['headline'] == 'Yes') {
$sql1 = mysqli_query($conn, "insert into headline values ('','{$kodepeng}','{$_POST['judul']}','{$_POST['isi']}','{$nama_file_unik}','{$_POST['wkt']}')");
}
if ($_POST['slide'] == 'Yes') {
$sql2 = mysqli_query($conn, "insert into slide values ('','{$kodepeng}','{$_POST['judul']}','{$_POST['isi']}','{$nama_file_unik}','{$_POST['wkt']}')");
}
header('location:pengumuman.php');
?>
<form method="post" class="form-search">
<?php
$queryselectfilm = "select *from tabel_barang where ID_BARANG='{$id_barang}'";
$resultfilm = mysqli_query($koneksi, $queryselectfilm);
$row = mysqli_fetch_array($resultfilm, MYSQLI_ASSOC);
if (mysqli_num_rows($resultfilm) == 0) {
echo '<center><h2><font color="red">Data tidak ditemukan</font></h2></center>';
} else {
?>
<h3> Form Edit Data</h3>
<table class="table hovered">
<tr>
<td>ID transaksi</td>
<td>:</td>
<td><input type="text" name="idchart" readonly value="<?php
echo autonumber("tabel_chart", "ID_CHART", 3, "CHART");
?>
" style='color:grey' ></td>
</tr>
<tr>
<td>ID Barang</td>
<td>:</td>
<td><input type="text" name="idbarang" readonly value="<?php
echo $row['ID_BARANG'];
?>
" style='color:grey' /></td>
</tr>
<tr>
<td>Nama </td>
<td>:</td>
<td><input type="text" name="namabarang" readonly value="<?php
public function insert($filename)
{
$namadestinasi = mysql_real_escape_string($_POST['namadestinasi']);
$slug = url_title($this->input->post('namadestinasi'), 'dash', TRUE);
$harga = mysql_real_escape_string($_POST['harga']);
$lama = mysql_real_escape_string($_POST['lama']);
$tgl = mysql_real_escape_string($_POST['tgl']);
$bulan = mysql_real_escape_string($_POST['bulan']);
$tahun = mysql_real_escape_string($_POST['tahun']);
$kota = mysql_real_escape_string($_POST['kota']);
$ittinery = htmlspecialchars($_POST['ittinery']);
$now = date("F j, Y, g:i a");
function autonumber($tabel, $kolom, $lebar = 0, $awalan = '')
{
$query = "select {$kolom} from {$tabel} order by {$kolom} desc limit 1";
$hasil = mysql_query($query);
$jumlahrecord = mysql_num_rows($hasil);
if ($jumlahrecord == 0) {
$nomor = 1;
} else {
$row = mysql_fetch_array($hasil);
$nomor = intval(substr($row[0], strlen($awalan))) + 1;
}
if ($lebar > 0) {
$angka = $awalan . str_pad($nomor, $lebar, "0", STR_PAD_LEFT);
} else {
$angka = $awalan . $nomor;
}
return $angka;
}
$tripid = autonumber("ts_destinasi", "tripid", 5, "dest");
$data = array('tripid' => $tripid, 'destinasi' => $namadestinasi, 'slug' => $slug, 'harga' => $harga, 'lama' => $lama, 'tgl' => $tgl, 'bulan' => $bulan, 'tahun' => $tahun, 'kota' => $kota, 'ittineri' => $ittinery, 'pic' => $filename);
$this->db->insert('ts_destinasi', $data);
}
if ($jumlahrecord == 0) {
$nomor = 1;
} else {
$row = mysql_fetch_array($hasil);
$nomor = intval(substr($row[0], strlen($awalan))) + 1;
}
if ($lebar > 0) {
$angka = $awalan . str_pad($nomor, $lebar, "0", STR_PAD_LEFT);
} else {
$angka = $awalan . $nomor;
}
return $angka;
}
if (!empty($lokasi_file)) {
// Tentukan folder gambar untuk galeri
$folder = "images/";
// Gunakan fungsi thumb untuk membuat thumbnail
thumb($nama_file_unik, $folder);
}
$kodekeg = autonumber("kegiatan", "idkeg", 4, "KEG");
$sql = mysqli_query($conn, "insert into kegiatan values ('{$kodekeg}','{$_POST['judul']}','{$_POST['isi']}','{$nama_file_unik}','{$_POST['wkt']}','{$_POST['headline']}','{$_POST['slide']}')");
if ($_POST['headline'] == 'Yes') {
$sql1 = mysqli_query($conn, "insert into headline values ('','{$kodekeg}','{$_POST['judul']}','{$_POST['isi']}','{$nama_file_unik}','{$_POST['wkt']}')");
}
if ($_POST['slide'] == 'Yes') {
$sql2 = mysqli_query($conn, "insert into slide values ('','{$kodekeg}','{$_POST['judul']}','{$_POST['isi']}','{$nama_file_unik}','{$_POST['wkt']}')");
}
header('location:kegiatan.php');
?>
