View difference between Paste ID: xLjKFVuv and dGx993qa
SHOW: | | - or go back to the newest paste.
1
<?php 
2-
include('config.php');
2+
require('config.php');
3-
include('cek-login.php');
3+
require('cek-login.php');
4
?>
5
<style>
6
    tbody > tr:nth-child(2n+1) > td, tbody > tr:nth-child(2n+1) > th {
7
        background-color: #CCC;
8
    }
9
    table{
10
11
        margin: auto;
12
        border-collapse: collapse;
13
        box-shadow: darkgrey 3px;
14
    }
15
    thead tr {
16
        background-color: #36c2ff;
17
    }
18
</style>
19
20
<?php 
21-
if (!empty($_GET['message']) && $_GET['message'] == 'success') {
21+
if (isset($_GET['message']) && $_GET['message'] == 'success') {
22
	echo '<h3>Berhasil meng-update data!</h3>';
23-
} else if (!empty($_GET['message']) && $_GET['message'] == 'delete') {
23+
} elseif(isset($_GET['message']) && $_GET['message'] == 'delete') {
24
	echo '<h3>Berhasil menghapus data!</h3>';
25
}
26
?>
27
<h3>Data Customer</h3>
28
<table border="1" cellpadding="5" cellspacing="0">
29
	<thead>
30
    	<tr align="center">
31
        	<td><b>No</b></td>
32
        	<td><b>Customer</b></td>
33
        	<td><b>Pelapor</b></td>
34
        	<td><b>Problem</b></td>
35
        	<td><b>Tanggal Keluhan</b></td>
36
        	<td><b>Tanggapan</b></td>
37
        	<td><b>Tanggal Tanggapan</b></td>
38
            <td><b>Waktu</b></td>
39
            <td><b>Status</b></td>
40
           	<td><b>Opsi</b></td>
41
42
        </tr>
43
    </thead>
44
    <tbody>
45
    <?php 
46
$query = mysql_query("select customer.*, tindakan.*
47
					 FROM customer LEFT JOIN tindakan
48
					ON customer.idcustomer_st=tindakan.idcustomer");
49
	//$query = mysql_query("select * from customer");
50
//$query = mysql_query("select customer.*, tindakan.*, DATEDIFF(tindakan.date,customer.datecustomer) selisih
51
//FROM customer LEFT JOIN tindakan
52
//ON customer.idcustomer_st=tindakan.idcustomer");	
53-
$query = mysql_query("select customer.*, tindakan.*, TIMESTAMPDIFF(tindakan.date,customer.datecustomer) selisih
53+
$sql="select customer.*, tindakan.*, TIMESTAMPDIFF(tindakan.date,customer.datecustomer) selisih
54
FROM customer LEFT JOIN tindakan
55-
ON customer.idcustomer_st=tindakan.idcustomer");
55+
ON customer.idcustomer_st=tindakan.idcustomer";
56
$query = mysql_query($sql) or die('error:'.mysql_error()."<br/>".$sql );
57
	$no = 1;
58
	while ($data = mysql_fetch_array($query)) {
59
	?>
60
    	<tr>
61
        	<td><?php echo $no; ?></td>
62
        	<td><?php echo $data['customer']; ?></td>
63
        	<td><?php echo $data['pelapor']; ?></td>
64
        	<td><?php echo $data['problem']; ?></td>
65
        	<td><?php echo $data['datecustomer']; ?></td>
66
			<td><?php if(empty($data['tindakan'])){ echo '<span style="color: #f00; ">Belum ada tanggapan</span>'; } else { echo $data['tindakan']; } ?></td>
67
        	<td><?php if(empty($data['date'])){ echo '<span style="color: #f00; ">Belum ada data</span>'; } else { echo $data['date']; } ?></td>
68
            <td><?php echo $data['selisih']; ?></td>
69
        	<td></td>
70
            
71
            <td>
72
            <a href="edittanggapan.php?id=<?php echo $data['idcustomer_st']; ?>"><img alt="edit" src="gambar/edit.png" /></a>
73
            <a href="deletetanggapan.php?id=<?php echo $data['idcustomer_st']; ?>" onclick="return confirm('Anda yakin akan menghapus data?')"><img alt="hapus" src="gambar/hapus.png" /></a>
74
            </td>
75
        </tr>
76
    <?php 
77
	$no++;
78
	} 
79
	?>
80
    </tbody>
81
</table>