Pengaturan

Gambar

Lainnya

Tentang KASKUS

Pusat Bantuan

Hubungi Kami

KASKUS Plus

© 2024 KASKUS, PT Darta Media Indonesia. All rights reserved

azhari1904Avatar border
TS
azhari1904
help mysql update error, saat update terjadi pesan
ini form editnya gan:
<?php
include '../koneksi.php';
$u = $_GET['u'];
$result = mysql_query("select * from daftarpesertarombongan where kode='$u'");
while ($data= mysql_fetch_array($result)){
?>
<form action="updatedatarombongan.php" method="post">
<p>
<input type="hidden" id="kode" name="kode" value="<?php echo $data['kode'] ?>"/>
</p>
<table bgcolor="#666666">
<tr>
<td><label></label></td>
<td><input type="text" disabled id="kode" name="kode" value="<?php echo $data['kode'] ?>"/></td>
</tr>
<tr>
<td><label>Nama Koordinator</label></td>
<td><input type="text" id="namakoordinator" name="namakoordinator" value="<?php echo $data['namakoordinator'] ?>"/></td>
</tr>
<tr>
<td><label>Alamat Rombongan</label></td>
<td><input type="text" id="alamat" name="alamat" value="<?php echo $data['alamat'] ?>"/></td>
</tr>
<tr>
<td><label>Jumlah Peserta Laki-laki</label></td>
<td><input type="text" id="lk" name="lk" value="<?php echo $data['lk'] ?>"/></td>
</tr>
<tr>
<td><label>Jumlah Peserta Perempuan</label></td>
<td><input type="text" id="pr" name="pr" value="<?php echo $data['pr'] ?>"/></td>
</tr>
<tr>
<td><label>Tujuan Wisata</label></td>
<td><input type="text" id="tujuan" name="tujuan" value="<?php echo $data['tujuan'] ?>"/></td>
</tr>
<tr>
<td><label>Tanggal Berangkat</label></td>
<td><input type="text" id="tanggalberangkat" name="tanggalberangkat" value="<?php echo $data['tanggalberangkat'] ?>"/></td>
</tr>
<tr>
<td><label>Waktu Berangkat</label></td>
<td><input type="text" id="waktuberangkat" name="waktuberangkat" value="<?php echo $data['waktuberangkat'] ?>"/></td>
</tr>
<tr>
<td><label>Tanggal Pulang</label></td>
<td><input type="text" id="tanggalpulang" name="tanggalpulang" value="<?php echo $data['tanggalpulang'] ?>"/></td>
</tr>
<tr>
<td><label>Waktu Pulang</label></td>
<td><input type="text" id="waktupulang" name="waktupulang" value="<?php echo $data['waktupulang'] ?>"/></td>
</tr>
<tr>
<td><label>Jenis Mobil</label></td>
<td><input type="text" id="jenismobil" name="jenismobil" value="<?php echo $data['jenismobil'] ?>"/></td>
</tr>
<tr>
<td><label>Supir</label></td>
<td><input type="text" id="supir" name="supir" value="<?php echo $data['supir'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 01</label></td>
<td><input type="text" id="b1" name="b1" value="<?php echo $data['b1'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 02</label></td>
<td><input type="text" id="b2" name="b2" value="<?php echo $data['b2'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 03</label></td>
<td><input type="text" id="b3" name="b3" value="<?php echo $data['b3'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 04</label></td>
<td><input type="text" id="b4" name="b4" value="<?php echo $data['b4'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 05</label></td>
<td><input type="text" id="b5" name="b5" value="<?php echo $data['b5'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 06</label></td>
<td><input type="text" id="b6" name="b6" value="<?php echo $data['b6'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 07</label></td>
<td><input type="text" id="b7" name="b7" value="<?php echo $data['b7'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 08</label></td>
<td><input type="text" id="b8" name="b8" value="<?php echo $data['b8'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 09</label></td>
<td><input type="text" id="b9" name="b9" value="<?php echo $data['b9'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 10</label></td>
<td><input type="text" id="b10" name="b10" value="<?php echo $data['b10'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 11</label></td>
<td><input type="text" id="b11" name="b11" value="<?php echo $data['b11'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 12</label></td>
<td><input type="text" id="b12" name="b12" value="<?php echo $data['b12'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 13</label></td>
<td><input type="text" id="b13" name="b13" value="<?php echo $data['b13'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 14</label></td>
<td><input type="text" id="b14" name="b14" value="<?php echo $data['b14'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 15</label></td>
<td><input type="text" id="b15" name="b15" value="<?php echo $data['b15'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 16</label></td>
<td><input type="text" id="b16" name="b16" value="<?php echo $data['b16'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 17</label></td>
<td><input type="text" id="b17" name="b17" value="<?php echo $data['b17'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 18</label></td>
<td><input type="text" id="18" name="b18" value="<?php echo $data['b18'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 19</label></td>
<td><input type="text" id="b19" name="b19" value="<?php echo $data['b19'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 20</label></td>
<td><input type="text" id="b20" name="b20" value="<?php echo $data['b20'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 21</label></td>
<td><input type="text" id="b21" name="b21" value="<?php echo $data['b21'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 22</label></td>
<td><input type="text" id="b22" name="b22" value="<?php echo $data['b22'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 23</label></td>
<td><input type="text" id="b23" name="b23" value="<?php echo $data['b23'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 24</label></td>
<td><input type="text" id="b24" name="b24" value="<?php echo $data['b24'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 25</label></td>
<td><input type="text" id="b25" name="b25" value="<?php echo $data['b25'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 26</label></td>
<td><input type="text" id="b26" name="b26" value="<?php echo $data['b26'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 27</label></td>
<td><input type="text" id="b27" name="b27" value="<?php echo $data['b27'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 28</label></td>
<td><input type="text" id="b28" name="b28" value="<?php echo $data['b28'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 29</label></td>
<td><input type="text" id="b29" name="b29" value="<?php echo $data['b29'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 30</label></td>
<td><input type="text" id="b30" name="b30" value="<?php echo $data['b30'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 31</label></td>
<td><input type="text" id="b31" name="b31" value="<?php echo $data['b31'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 32</label></td>
<td><input type="text" id="b32" name="b32" value="<?php echo $data['b32'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 33</label></td>
<td><input type="text" id="b33" name="b33" value="<?php echo $data['b33'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 34</label></td>
<td><input type="text" id="b34" name="b34" value="<?php echo $data['b34'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 35</label></td>
<td><input type="text" id="b35" name="b35" value="<?php echo $data['b35'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 36</label></td>
<td><input type="text" id="b36" name="b36" value="<?php echo $data['b36'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 37</label></td>
<td><input type="text" id="b37" name="b37" value="<?php echo $data['b37'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 38</label></td>
<td><input type="text" id="b38" name="b38" value="<?php echo $data['b38'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 39</label></td>
<td><input type="text" id="b39" name="b39" value="<?php echo $data['b39'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 40</label></td>
<td><input type="text" id="b40" name="b40" value="<?php echo $data['b40'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 41</label></td>
<td><input type="text" id="b41" name="b41" value="<?php echo $data['b41'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 42</label></td>
<td><input type="text" id="b42" name="b42" value="<?php echo $data['b42'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 43</label></td>
<td><input type="text" id="b43" name="b43" value="<?php echo $data['b43'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 44</label></td>
<td><input type="text" id="b44" name="b44" value="<?php echo $data['b44'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 45</label></td>
<td><input type="text" id="b45" name="b45" value="<?php echo $data['b45'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 46</label></td>
<td><input type="text" id="b46" name="b46" value="<?php echo $data['b46'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 47</label></td>
<td><input type="text" id="b47" name="b47" value="<?php echo $data['b47'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 48</label></td>
<td><input type="text" id="b48" name="b48" value="<?php echo $data['b48'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 49</label></td>
<td><input type="text" id="b49" name="b49" value="<?php echo $data['b49'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 50</label></td>
<td><input type="text" id="b50" name="b50" value="<?php echo $data['b50'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 51</label></td>
<td><input type="text" id="b51" name="b51" value="<?php echo $data['b51'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 52</label></td>
<td><input type="text" id="b52" name="b52" value="<?php echo $data['b52'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 53</label></td>
<td><input type="text" id="b53" name="b53" value="<?php echo $data['b53'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 54</label></td>
<td><input type="text" id="b54" name="b54" value="<?php echo $data['b54'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 55</label></td>
<td><input type="text" id="b55" name="b55" value="<?php echo $data['b55'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 56</label></td>
<td><input type="text" id="b56" name="b56" value="<?php echo $data['b56'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 57</label></td>
<td><input type="text" id="b57" name="b57" value="<?php echo $data['b57'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 58</label></td>
<td><input type="text" id="b58" name="b58" value="<?php echo $data['b58'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 59</label></td>
<td><input type="text" id="b59" name="b59" value="<?php echo $data['b59'] ?>"/></td>
</tr>
<tr>
<td><label>Bangku No 60</label></td>
<td><input type="text" id="b60" name="b60" value="<?php echo $data['b60'] ?>"/></td>
</tr>
<tr>
<td><label></label></td>
<td><input type="submit" value="update" name="update"/></td>
</tr>
</form>
<?php
}
?>

***setelah diklik update ke form ini****
update.php

<?php
include "../koneksi.php";

$kode=$_POST['kode'];
$namakoordinator=$_POST['namakoordinator'];
$alamat=$_POST['alamat'];
$lk=$_POST['lk'];
$pr=$_POST['pr'];
$tujuan=$_POST['tujuan'];
$tanggalberangkat=$_POST['tanggalberangkat'];
$waktuberangkat=$_POST['waktuberangkat'];
$tanggalpulang=$_POST['tanggalpulang'];
$waktupulang=$_POST['waktupulang'];
$jenismobil=$_POST['jenismobil'];
$supir=$_POST['supir'];
$b1=$_POST['b1'];
$b2=$_POST['b2'];
$b3=$_POST['b3'];
$b4=$_POST['b4'];
$b5=$_POST['b5'];
$b6=$_POST['b6'];
$b7=$_POST['b7'];
$b8=$_POST['b8'];
$b9=$_POST['b9'];
$b10=$_POST['b10'];
$b11=$_POST['b11'];
$b12=$_POST['b12'];
$b13=$_POST['b13'];
$b14=$_POST['b14'];
$b15=$_POST['b15'];
$b16=$_POST['b16'];
$b17=$_POST['b17'];
$b18=$_POST['b18'];
$b19=$_POST['b19'];
$b20=$_POST['b20'];
$b21=$_POST['b21'];
$b22=$_POST['b22'];
$b23=$_POST['b23'];
$b24=$_POST['b24'];
$b25=$_POST['b25'];
$b26=$_POST['b26'];
$b27=$_POST['b27'];
$b28=$_POST['b28'];
$b29=$_POST['b29'];
$b30=$_POST['b30'];
$b31=$_POST['b31'];
$b32=$_POST['b32'];
$b33=$_POST['b33'];
$b34=$_POST['b34'];
$b35=$_POST['b35'];
$b36=$_POST['b36'];
$b37=$_POST['b37'];
$b38=$_POST['b38'];
$b39=$_POST['b39'];
$b40=$_POST['b40'];
$b41=$_POST['b41'];
$b42=$_POST['b42'];
$b43=$_POST['b43'];
$b44=$_POST['b44'];
$b45=$_POST['b45'];
$b46=$_POST['b46'];
$b47=$_POST['b47'];
$b48=$_POST['b48'];
$b49=$_POST['b49'];
$b50=$_POST['b50'];
$b51=$_POST['b51'];
$b52=$_POST['b52'];
$b53=$_POST['b53'];
$b54=$_POST['b54'];
$b55=$_POST['b55'];
$b56=$_POST['b56'];
$b57=$_POST['b57'];
$b58=$_POST['b58'];
$b59=$_POST['b59'];
$b60=$_POST['b60'];

$query = mysql_query("update daftarpesertarombongan SET namakoordinator='$namakoordinator', alamat='$alamat', lk='$lk', pr='$pr', tujuan='$tujuan',tanggalberangkat='$tanggalberangkat', waktuberangkat='$waktuberangkat', tanggalpulang='$tanggalpulang', waktupulang='$waktupulang', jenismobil='$jenismobil', supir='$supir', b1='$b1', b2='$b2', b3='$b3', b4='$b4', b5='$b5', b6='$b6', b7='$b7', b8='$b8', b9='$b9', b10'$b10', b11='$b11', b12='$b12', b13='$b13', b14='$b14', b15='$b15', b16='$b16', b17='$b17', b18='$b18', b19='$b19', b20='$b20', b21='$b21', b22='$b22', b23='$b23', b24='$b24', b25='$b25', b26='$b26', b27='$b27', b28='$b28', b29='$b29', b30='$b30', b31='$b31', b32='$b32', b33='$b33', b34='$b34', b35='$b35', b36='$b36', b37='$b37', b38='$b38', b39='$b39', b40='$b40', b41='$b41', b42='$b42', b43='$b43', b44='$b44', b45='$b45', b46='$b46', b47='$b47', b48='$b48', b49='$b49', b50='$b50', b51='$b51', b52='$b52', b53='$b53', b54='$b54', b55='$b55', b56='$b56', b57='$b57', b58='$b58', b59='$b59', b60='$b60' where kode='$kode'") or die(mysql_error());
if ($query) {
header('location:jadwalrombongan.php?message=success');
}
?>

***lalu muncul pesan *****
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''x', b11='xx', b12='x', b13='xx', b14='xx', b15='xx', b16='xx', b17='xx', b18='x' at line 1



tolong bantu gannnnnn
0
1.1K
6
GuestAvatar border
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Mari bergabung, dapatkan informasi dan teman baru!
Website, Webmaster, Webdeveloper
Website, Webmaster, WebdeveloperKASKUS Official
23.3KThread4.4KAnggota
Urutkan
Terlama
GuestAvatar border
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Ikuti KASKUS di
© 2023 KASKUS, PT Darta Media Indonesia. All rights reserved.