Postingan lainnya
inserted data not found
ketika ingin menambah data, data tidak masuk ke database
<?php
if ($_GET[gos]=='tambah'){
//include "../class.php";
$resultx = new database;
$w=$resultx->cari("select * from tblmeja where id_meja='$_GET[id_meja]'");
if (empty($w)){
$no=date("Ymd");
}else{
$no=$w[id_meja];
}
echo "
<div class='col-md-6'>
<!-- general form elements -->
<div class='box box-primary'>
<div class='box-header with-border'>
<h3 class='box-title'>Tambah Meja </h3>
</div>
<!-- /.box-header -->
<!-- form start -->
<form id='form-wizard' class='form-horizontal' method='post'>
<div class='box-body'>
";
echo"
<div class='col-md-12'>
<label for='exampleInputEmail1'>No Meja</label>
<input type='text' name=id_meja value='$w[id_meja]' class='form-control' id='id_meja' placeholder='No'>
</div>
<div class='col-md-12'>
<label for='exampleInputEmail1'>Nama Meja </label>
<input type='text' name=nama_meja value='$w[nama_meja]' class='form-control' id='nama_meja' placeholder='Nama Meja'>
</div>
";
echo"
<div class='col-md-12'>
<label for='ket_meja'>Keterangan Meja </label>
<select class='form-control' required='required' name=ket_meja id='ket_meja' >
<option disabled selected >- Pilih Keterangan -</option>
<option value=1 >Lantai 1</option>
<option value=2 >Lantai 2</option>
</select>
</div>
";
echo"
<div class='col-md-12'>
<label for='status'>Status </label>
<select class='form-control' required='required' name=status id='status' >
<option disabled selected >- Pilih Status -</option>
<option value=1 >Kosong</option>
<option value=2 >Proses</option>
</select>
</div>
";
echo"
</div>
<!-- /.box-body -->
<div class='box-footer'>
<input type='submit' name=simpan class='btn btn-primary' value=Submit>
</div>
</form>
</div>
</div>
";
}
elseif ($_GET[gos]=='ubah'){
//include "../class.php";
$resultx = new database;
$w=$resultx->cari("select * from tblmeja");
if (empty($w)){
$no=date("Ymd");
}else{
$no=$w[id_meja];
}
echo "
<div class='col-md-6'>
<!-- general form elements -->
<div class='box box-primary'>
<div class='box-header with-border'>
<h3 class='box-title'>Ubah Menu </h3>
</div>
<!-- /.box-header -->
<!-- form start -->
<form id='form-wizard' class='form-horizontal' method='post'>
<div class='box-body'>
";
echo"
<div class='col-md-12'>
<label for='exampleInputEmail1'>No </label>
<input type='text' name=id_meja value='$w[id_meja]' class='form-control' id='id_meja' placeholder='No'>
</div>
<div class='col-md-12'>
<label for='exampleInputEmail1'>Nama Meja </label>
<input type='text' name=nama_meja value='$w[nama_meja]' class='form-control' id='nama_meja' placeholder='Nama Meja'>
</div>
<div class='col-md-12'>
<label for='exampleInputEmail1'>Keterangan </label>
<input type='text' name=ket_meja value='$w[ket_meja]' class='form-control' id='ket_meja' placeholder='Keterangan'>
</div>
<div class='col-md-12'>
<label for='exampleInputEmail1'>Status </label>
<input type='text' name=status value='$w[status]' class='form-control' id='status' placeholder='Status'>
</div>
";
echo"
<div class='col-md-12'>
<label for='exampleInputEmail1'>Keterangan Meja </label>
<select class='form-control' required='required' name=id_meja id='id_meja' >
<option disabled selected >- Pilih Kategori -</option>
<option value=1 >Lantai 1</option>
<option value=2 >Lantai 2</option>
</select>
</div>
";
echo"
</div>
<!-- /.box-body -->
<div class='box-footer'>
<input type='submit' name=simpan class='btn btn-primary' value=Submit>
</div>
</form>
</div>
</div>
";
}
elseif(empty($_GET[gos])){
//table
echo "
<div class='container-fluid'><hr>
<div class='row-fluid'>
<div class='span12'><h3></h3>
<div class='widget-box'>
<div class='pull-right'><a href='?menu=meja&gos=tambah' class='fa fa-plus fa-2x'></i></a></div>
<div class='widget-title'> <span class='icon'> <i class='icon-pencil'></i> </span>
</div>
";
if ($_SESSION[id_meja]=="1"){
echo"
<div class='pull-right'><a href='?menu=meja&gos=tambah' class='fa fa-plus fa-2x'></i></a></div>
"; }
echo"
<div class='widget-title'> <span class='icon'> <i class='icon-pencil'></i> </span>
<h5>List Meja </h5>
</div>
<div class='content table-responsive table-full-width'>
<table id=example1 class='table table-bordered data-table'>
<thead>
<th>No</th>
<th>Nama Meja</th>
<th>Keterangan</th>
<th>Status</th>
<th>#</th>
</thead>
<tbody>
";
$resultx=new database();
$w=$resultx->cari("select * from tblmeja");
if (ket_meja=="1"){
$ket_meja = "select * from tblmeja";
}else{
$ket_meja = "select * from tblmeja where id_meja";
}
foreach($resultx->tampil_data($ket_meja) as $w)
echo " <tr>
<td>$w[id_meja]</td>
<td>$w[nama_meja]</td>
<td>$w[ket_meja]</td>
<td>$w[status]</td>
<td>
<a href='?menu=meja&gos=tambah&kd=$w[id_meja]'> <i class='fa fa-edit text-warning'></i> </a>
<a href='?menu=meja&gos=hapus&kd=$w[id_meja]'> <i class='fa fa-trash'></i> </a>
</td>
</tr> ";
echo "
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
";
}
if (isset($_POST[simpan])){
//simpan
if(empty($_POST[id_meja])){
$resultx = new database;
$w=$resultx->cari("select * from tblmeja where id_meja='$_POST[id_meja]'");
if(empty($w)){
$insert =new database();
$data['id_meja'] ="$_POST[id_meja]";
$data['nama_meja'] ="$_POST[nama_meja]";
$data['ket_meja'] ="$_POST[ket_meja]";
$data['status'] ="$_POST[status]";
$insert ->insert("tblmeja",$data);
$pesan = new database;
$pesan->pesanMasuk("?menu=meja","Berhasil simpan data");
}else{
$pesan = new database;
$pesan->pesanMasuk("?menu=meja&gos=tambah","Maaf, data yang anda masukkan salah");
}
}else{
//ubah
$ubah = new database;
$data['id_meja'] ="1";
$data['nama_meja'] ="$_POST[nama_meja]";
$data['ket_meja'] ="$_POST[ket_meja]";
$data['status'] ="$_POST[status]";
$ubah->update("tblmeja",$data,"id_meja = '$_POST[id_meja]'");
$ubah->pesanMasuk("?menu=meja","Berhasil simpan data");
}
}
if($_GET[gos]=="hapus"){
$hapus = new database;
$kode =1;
$hapus ->delete("tblmeja","id_meja = '$_GET[kd]'");
$hapus->pesanMasuk("?menu=meja","Berhasil hapus data");
}
kira" dimana ya masalahnya
7 Jawaban:
aku ngk ngerti mas apa itu PDO, aku juga baru 2 bulan ini belajar php
Ooo gitu bole liat kelas "Database" tampaknya permasalahan bisa dicari disana.
maksudnya kelas yg ini ya ? <pre> <?php error_reporting(0); class database { var $koneksi ; var $selectDb; var $query ; var $result ; var $row; var $jumlah ;
function database()
{
$nameSer = "localhost";
$username ="root";
$pass = "";
$dbname = "lavitabella";
$koneksi = mysql_connect($names,$username,$pass)or die('error'.mysql_errno());
$this-&gt;selectDb = mysql_select_db($dbname,$koneksi);
if ( !$this-&gt;selectDb )
{
echo "gagal";
}
}
function query($query)
{
$this-&gt;result = mysql_query($query);
}
public function cari($sql){
$this-&gt;result=mysql_query($sql);
$this-&gt;row = mysql_fetch_array($this-&gt;result);
return $this-&gt;row;
}
function tampilkan()
{
$this-&gt;row = mysql_fetch_array($this-&gt;result);
return $this-&gt;row;
}
function tampil_data($sql){
$r = mysql_query($sql);
while($d = mysql_fetch_array($r )){
$hasil[] = $d;
}
return $hasil;
}
function view()
{
$this-&gt;row = mysql_fetch_object($this-&gt;result);
return $this-&gt;row;
}
function getJumlah()
{
$this-&gt;jumlah = mysql_num_rows($this-&gt;result);
return $this-&gt;jumlah;
}
function get($table)
{
$this-&gt;result = mysql_query("SELECT * FROM ".$table);
}
function getJumlahFromTable($table)
{
$this-&gt;get($table);
return $this-&gt;getJumlah();
}
function insert( $database , $data)
{
$row = array();
$nilai = array();
foreach ( $data as $kolom =&gt;$value )
{
$row[] = $kolom;
$nilai[] = "'".$value."'";
}
$this-&gt;result = $this-&gt;query("INSERT INTO ". $database ."(". implode(',' ,$row) .")
VALUES (". implode(',' , $nilai) .")");
}
function update($table , $data , $where)
{
foreach ( $data as $kolom =&gt; $row )
{
$set[]= $kolom."='".$row."'" ;
}
$set = implode(',',$set);
$query = "UPDATE ".$table." SET ".$set." WHERE ".$where ;
$this-&gt;query($query);
}
function delete($table , $where)
{
$this-&gt;query("DELETE FROM ".$table." WHERE ".$where);
}
public function combo($sql,$cari){
$r=mysql_query($sql);
while($w=mysql_fetch_array($r)){
if ($cari==$w[kd]){
$sel="selected";
}else{
$sel="";
}
$x="$x &lt;option value=$w[kd]&gt; $w[f] &lt;/option&gt;";
}
return $x;
}
function PesanMasuk($url,$n){
echo "
<script>
alert(' $n ' );
setTimeout(function(){location.href='$url', 5000} );
</script>
";
}
function masukGambar($nama){ $fileName = $_FILES[$nama]['name']; $fileSize = $_FILES[$nama]['size']; $fileError = $_FILES[$nama]['error']; if($fileSize > 0 || $fileError == 0){ $move = move_uploaded_file($_FILES[$nama]['tmp_name'], '../../gambar/'.$fileName);}
$hasil="$fileName" ;
return $hasil;
} } </pre>
atau yg ini kak ? <img src=' http://images2.imagebam.com/bc/1c/32/c75d3c1044950104.png '>
Coba rubah pada bagiam insert menjadi seperti kode dibawah ini :
<pre> function insert( $database , $data) { $row = array(); $nilai = array(); foreach ( $data as $kolom =>$value ) { $row[] = $kolom; $nilai[] = "'".$value."'"; } $sql = "INSERT INTO ". $database ."(". implode(',' ,$row) .") VALUES (". implode(',' , $nilai) .")"; echo $sql; $this->result = $this->query($sql ); } </pre>
Selajutnya ulang proses insert nya.
Inti perubahan pada kode tersebut adalah untuk melihat perintah SQL yang tergenerate udah benar atau tidak.
itu tinggal di ganti buat bagian insert doang kak ? kok aku masukkin malah eror dia
Maksudnya supaya tau apa perintah sql nya error gak.