Insert/import dengan mysql query kok bisa gagal?Dibuat
Login Terakhir
1 Tahun lalu,
Telah Dilihat 1872 Kali
| |
Sultan Account |
|
|
abdurahman
Mengatakan :
Sultan Account
if(isset($_POST[tambah])){
cek_session_admin();
mysql_query("INSERT INTO rb_kls_pararel VALUES('','$_POST[nm_kls_pararel]','$_POST[kode_kelas]')");
echo "<script>document.location='index.php?view=kelaspararel&act=tambah';</script>";
}
}
?>
<div class="col-md-3">
<div class="box box-solid">
<div class="box-header with-border">
<h3 class="box-title">PILIHAN</h3>
<div class="box-tools">
</div>
<div class="box-body no padding" style="display: block;">
<ul class="nav nav-pills nav-stacked">
<form action="" method="POST" enctype="multipart/form-data">
<label>Kelas</label>
<select class="form-control" name="kode_kelas">
<option value="0">Pilih Kelas</option>
<?php
$kelas = mysql_query("SELECT * FROM rb_kelas ORDER BY kode_kelas");
while ($k = mysql_fetch_array($kelas)){
echo "<option value='$k[kode_kelas]'>$k[nama_kelas]</option>";
}
?>
</select>
</br>
<label>Kelas Pararel</label>
<input type='text' class="form-control" name="nm_kls_pararel">
</ul>
</div>
</div>
<div style='clear:both'></div>
<div class='box-footer'>
<button type='submit' name='tambah' class='btn btn-info'>Tambahkan</button>
</div>
</div>
</div>
yang ke input hanya 1 x yang ke 2 dan strusnya gagal padahal sudah bener ada yang tahu?
|
|
| PHPMU.COM Support commented on 12 Mar 2018 10:00:32 Sultan Account |
|
|
|
Share table DB (rb_kls_pararel) nya,.. |
|
| abdurahman commented on 12 Mar 2018 10:36:59 Sultan Account |
|
|
|
terlampir mas Terdapat 1 File dilampirkan : 1. Maaf File 'rb_kls_pararel.sql (0)' Gagal Terkirim! |
|
| abdurahman commented on 12 Mar 2018 10:37:59 Sultan Account |
|
|
|
-- phpMyAdmin SQL Dump -- version 4.2.11 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Mar 12, 2018 at 02:40 AM -- Server version: 5.6.21 -- PHP Version: 5.6.3 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `cless` -- -- -------------------------------------------------------- -- -- Table structure for table `rb_kls_pararel` -- CREATE TABLE IF NOT EXISTS `rb_kls_pararel` ( `id_kls_pararel` int(10) NOT NULL, `kode_kelas` varchar(20) NOT NULL, `nm_kls_pararel` varchar(50) NOT NULL ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; -- -- Indexes for dumped tables -- -- -- Indexes for table `rb_kls_pararel` -- ALTER TABLE `rb_kls_pararel` ADD PRIMARY KEY (`id_kls_pararel`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `rb_kls_pararel` -- ALTER TABLE `rb_kls_pararel` MODIFY `id_kls_pararel` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
|
| PHPMU.COM Support commented on 14 Mar 2018 06:08:27 Sultan Account |
|
|
|
Assalam, saya lihat untuk aksi simpan kurung kurawal penutupnya lebih mas,..
di atas saya lihat begini :
if(isset($_POST[tambah])){
cek_session_admin();
mysql_query("INSERT INTO rb_kls_pararel VALUES('','$_POST[nm_kls_pararel]','$_POST[kode_kelas]')");
echo "<script>document.location='index.php?view=kelaspararel&act=tambah';</script>";
}
}
Seharusnya begini (Kurung kurawal penutup 1 saja :
if(isset($_POST[tambah])){
cek_session_admin();
mysql_query("INSERT INTO rb_kls_pararel VALUES('','$_POST[nm_kls_pararel]','$_POST[kode_kelas]')");
echo "<script>document.location='index.php?view=kelaspararel&act=tambah';</script>";
} |
|
| abdurahman commented on 14 Mar 2018 08:43:49 Sultan Account |
|
|
|
wa'alaikumussalam mas, alhamdulillah sudah solve mas,, oh ya kalau saya ingin mengembangkan aplikasi sekolah ini lebih dari 1 sekolah dengan klu sbg berikut : 1. setiap sekolah yang pakai aplikasi ini membentuk database baru 2. pengaturan terpusat ? saya mikir harus rubah semua ya hehe |
|