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
Urutan
Terbaru
Terlama
GuestAvatar border
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Komunitas Pilihan