function SQLExec($sql)
{
$koneksi = koneksi();
$hasil = $koneksi->Execute($sql);
if ($hasil == false) {
die("error SQL" . $koneksi->ErrorMsg() . "<br><br>{$sql}<br><br><br>");
} else {
return $hasil;
}
}
function q($query)
{
$koneksi = koneksi();
if ($koneksi) {
$result = mysqli_query($koneksi, $query);
if ($result) {
return $result;
} else {
exit("kueri gagal");
}
} else {
exit("database tidak terkoneksi");
}
}
</head>
<body class="hold-transition skin-blue layout-top-nav">
<div class="wrapper">
<?php
include 'menu.php';
?>
<!-- mulai nulis isinya -->
<div class="content-wrapper">
<div class="container">
<section class="content-header">
<h1></h1>
</section>
<?php
if (isset($_POST['submit'])) {
$con = koneksi();
$userId = $_POST['id_user'];
$iklanId = $_POST['id_iklan'];
$harga = $_POST['harga'];
$ikhtisar = $_POST['ikhtisar'];
$lokasi_file = $_FILES['karya']['tmp_name'];
$tipe_file = $_FILES['karya']['type'];
$nama_file = $_FILES['karya']['name'];
$nama_new = "{$userId}-" . date('dmYHis') . "-{$nama_file}";
$direktori = "../file/{$nama_new}";
move_uploaded_file($lokasi_file, $direktori);
$insert = "insert into lelang values('','{$userId}','{$iklanId}','{$harga}','{$ikhtisar}','{$nama_new}','0','1')";
$query = mysqli_query($con, $insert);
if ($query) {
?>
<div class="pad margin no-print">
<?php
ob_start();
require_once "lib/function.php";
session();
koneksi();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>E-Learning Music Studio</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" href="css/style.css" />
<link rel="stylesheet" href="css/skin.css" />
<link rel="shortcut icon" href="img/music_icon.png" />
<script type="text/javascript" src="js/button.js"></script>
<script type="text/javascript" src="js/button2.js"></script>
<script type="text/javascript" src="js/hcb.js"></script>
<!-- MP3 Player -->
<script type="text/javascript" src="js/jquery-1.10.2.js"></script>
<script type="text/javascript" src="js/mp3player/blur.min.js"></script>
<script type="text/javascript" src="js/mp3player/mobile_init.js"></script>
<script type="text/javascript" src="js/mp3player/jquery.mobile-1.4.2.min.js"></script>
<script type="text/javascript" src="js/mp3player/jquery-ui-1.10.4.custom.min.js"></script>
<script type="text/javascript" src="js/mp3player/detectmobilebrowser.js"></script>
<script type="text/javascript" src="js/mp3player/ssplayer.js"></script>
<link href="css/mp3player/style.css" rel="stylesheet" type="text/css">
<link href="css/mp3player/settings.css" rel="stylesheet" type="text/css">
<script>
/*Set the player here when document is ready!*/
$(document).ready(function(e) {
function cekIkutLelang($iduser, $idiklan)
{
$con = koneksi();
$select = "select count(*) as hitung from lelang where id_user='******' and id_iklan='{$idiklan}'";
$query = mysqli_query($con, $select);
$row = mysqli_fetch_array($query);
if ($row['hitung'] == 1) {
return true;
} else {
return false;
}
}
