0

This is piece of my syntax if I don't write "or die (mysql_error())" then "Gagal" I don't know where is my fault. Please help ! thanks before 

include "konekdb.php";

$query = mysql_query(
   "UPDATE proyek 
   SET nama_panj_proyek='$_POST[nama_panj_proyek]',
   nama_pend_proyek='$_POST[nama_pend_proyek]', 
   unit='$_POST[unit]', 
   tsk='$_POST[tsk]', 
   no_kontrak='$_POST[no_kontrak]', 
   tgl_kontrak='$_POST[tgl_kontrak]', 
   jenis_proyek='$_POST[jenis_proyek]', 
   no_sla='$_POST[no_sla]', 
   tanggal_sla='$tanggal_sla', 
   kode_akun='$_POST[kode_akun]', 
   pemberi_kerja='$_POST[pemberi_kerja]', 
   mulai_proyek='$mulai_proyek', 
   akhir_proyek='$akhir_proyek, 
   jangka_waktu='$jangka_waktu', 
   prog_overall='$_POST[prog_overall]', 
   prog_sipil='$_POST[prog_sipil]', 
   prog_mekanik='$_POST[prog_mekanik]', 
   prog_elektrik='$_POST[prog_elektrik]', 
   mm_sla='$_POST[mm_sla]', 
   mm_real='$_POST[mm_real]', 
   rbt_sla='$_POST[rbt_Sla]', 
   rbt_real='$_POST[rbt_real]', 
   bln_pro='$bln_pro', 
   thn_pro='$thn_pro', 
   ket='$_POST[ket]' 
   WHERE id_proyek='$_POST[id_proyek]'"
) or die (mysql_error());

   if($query){
      echo"Berhasil !";
      if($_POST['jenis_proyek']=='Pembangkit'){
         echo"<script>window.location='tampilproyekkit.php;'</script>";
      } else if($_POST['jenis_proyek']=='Jaringan'){
         echo"<script>window.location='tampilproyekjar.php;'</script>";
      }
   }else {
      echo"Gagal !";
   }
   exit;

And this is line 13

$tanggal_sla = $tgl_sla."-".$bln_sla."-".$thn_sla;
$tgl_mulai_proyek = $_POST['tgl_mulai_proyek'];
zero298
  • 25,467
  • 10
  • 75
  • 100
refikanissa
  • 3
  • 3

1 Answers1

1

Line 13 of your SQL string, not your Code file :)

akhir_proyek='$akhir_proyek,

this is missing a closing quote should be:

akhir_proyek='$akhir_proyek',

You might also want to check up on SQL Injection, i may not be a PHP developer but the code above looks ripe for injection attack:

Check this stack question for some help: How can I prevent SQL injection in PHP?

Community
  • 1
  • 1
White Dragon
  • 1,259
  • 1
  • 8
  • 20