View difference between Paste ID: M8P95Car and 6cKX7Atp
SHOW: | | - or go back to the newest paste.
1
<?php
2
include '../koneksi.php';
3
include "kepala.php";
4
//print_r($_POST);
5
		if (isset($_POST["action"]) && $_POST["action"]=="update") {
6-
		$simpan = myquery("UPDATE jadwal SET tgl_berangkat= '$_POST[tgl_berangkat]', id_tujuan='$_POST[id_tujuan]', tgl_berangkat= '$_POST[tgl_berangkat]', jam_berangkat= '$_POST[jam_berangkat]', markup= '$_POST[markup]' WHERE kd_jadwal = '$_POST[kd_jadwal]'");
6+
		$sql="UPDATE jadwal SET tgl_berangkat= '$_POST[tgl_berangkat]', id_tujuan='$_POST[id_tujuan]', tgl_berangkat= '$_POST[tgl_berangkat]', jam_berangkat= '$_POST[jam_berangkat]', markup= '$_POST[markup]' WHERE kd_jadwal = '$_POST[kd_jadwal]'";
7
		$simpan = myquery($sql);
8-
		header('Location: jadwal.php');
8+
9
		header('Location: jadwal.php?kd_jadwal='.$_POST[kd_jadwal]);
10
		}else{
11
				echo "Gagal!";
12
				die("<br/>".$sql);
13-
$kd_jadwal = $_POST['kd_jadwal'];
13+
14
		}
15
$kd_jadwal = isset($_POST['kd_jadwal'])?$_POST['kd_jadwal']:null;
16
if($kd_jadwal==null){
17
$kd_jadwal = isset($_GET['kd_jadwal'])?$_GET['kd_jadwal']:null;
18
}
19
$tampil = mysqli_fetch_array(myquery("SELECT * FROM jadwal WHERE kd_jadwal= '$kd_jadwal'"));
20
?>
21
 <div class="content">
22
            <div class="container-fluid">
23
                <div class="row">                   
24
                    <div class="col-md-6">
25
                        <div class="card">
26
							<h3 style="padding: 15px;">Tambah jadwal</h3>
27
							   <div class="content table-responsive table-full-width" style="padding: 1px 15px 10px 15px;">
28
								<div style="widht: 500px; border: 0px solid black; padding: 8px">
29
									<form action="editjadwal.php" method="POST" class="form1" 
30
										style="
31
										  margin:0 auto;
32
										  background: rgb(241, 239, 226);
33
										  padding: 20px 30px;
34
										  border: 1px solid #D9D7D8;
35
										  border-radius: 5px;
36
										  box-shadow: 0px 1px 0px rgba(0,0,0,0.3),inset 0px 1px 0px rgba(255,255,255,0.04)
37
										  right: 0px;">
38
										<input type="hidden" name="kd_jadwal" value="<?php echo $tampil['kd_jadwal'];?>">
39
										<input type="hidden" name="action" value="update">
40
										<input type="text"required name="id_tujuan" value="<?php echo $tampil['id_tujuan'];?>" style="color:#151212;border-color: #ECB300;padding: 7px;font-size:15px">
41
										<input type="text" required name="id_bus" value="<?php echo $tampil['id_bus'];?>"style="color:#151212;border-color: #ECB300;padding: 7px;font-size:15px">
42
										<input type="text" required name="harga" value="<?php echo $tampil['harga'];?>" style="color:#151212;border-color: #ECB300;padding: 7px;font-size:15px">
43
										<input type="date" required name="tgl_berangkat" value="<?php echo $tampil['tgl_berangkat'];?>" style="color:#151212;border-color: #ECB300;padding: 7px;font-size:15px">
44
45
										<input type="text" required name="jam_berangkat" value="<?php echo $tampil['jam_berangkat'];?>"style="color:#151212;border-color: #ECB300;padding: 7px;font-size:15px">
46
										<button type="submit" class="glyphicon glyphicon-ok" name="simpan" style="width: 20%;margin-right: 0px;background-color:crgb(245, 187, 5);padding: 7px;font-size:15px">Save</button>
47
									
48
									</form>
49
								</div>
50
							</div>
51
						</div>
52
                    </div>     
53
                </div>                    
54
            </div>
55
        </div>
56
<?php
57
include "../footer.php";
58
?>