Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
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
0
7 Jawaban:
aku ngk ngerti mas apa itu PDO, aku juga baru 2 bulan ini belajar php
0
Ooo gitu bole liat kelas "Database" tampaknya permasalahan bisa dicari disana.
0
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 '>
0
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.
0
itu tinggal di ganti buat bagian insert doang kak ? kok aku masukkin malah eror dia
0
Maksudnya supaya tau apa perintah sql nya error gak.
0