<?php
class Database
{
private $hostname = "localhost";
private $db_name = "db_login_role";
private $username = "root";
private $password = "";
public $conn;
public function dbConnection()
{
$this->conn = null;
try {
$this->conn =new PDO("mysql:host=" . $this->hostname . ";dbname=" . $this->db_name, $this->username, $this->password);
$this->conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
echo "Connection error: " . $e->getMessage();
}
return $this->conn;
}
}
class Note
{
private $conn;
public function __construct()
{
$database = new Database();
$db = $database->dbConnection();
$this->conn = $db;
}
public function runQuery($sql)
{
$stmt = $this->conn->prepare($sql);
return $stmt;
}
public function insertNote($satker, $mitra, $tipe_mitra, $judul_lingkup, $nomor, $periode, $lokasi, $peran, $progres, $masalah_upaya, $keterangan, $pengelola, $jadwal)
{
try {
$stmt = $this->conn->prepare(
"INSERT INTO tb_note(satker,mitra,tipe_mitra,judul_lingkup,nomor,periode,lokasi,peran,progres,masalah_upaya,keterangan,pengelola,photo)
VALUES(:satker,:mitra,:tipe_mitra,:judul_lingkup,:nomor,:periode,:lokasi,:peran,:progres,:masalah_upaya,:keterangan,:pengelola,:photo)"
);
$stmt->bindParam(':satker', $satker);
$stmt->bindParam(':mitra', $mitra);
$stmt->bindParam(':tipe_mitra', $tipe_mitra);
$stmt->bindParam(':judul_lingkup', $judul_lingkup);
$stmt->bindParam(':nomor', $nomor);
$stmt->bindParam(':periode', $periode);
$stmt->bindParam(':lokasi', $lokasi);
$stmt->bindParam(':peran', $peran);
$stmt->bindParam(':progres', $progres);
$stmt->bindParam(':masalah_upaya', $masalah_upaya);
$stmt->bindParam(':keterangan', $keterangan);
$stmt->bindParam(':pengelola', $pengelola);
$stmt->bindParam(':photo', $photo);
$stmt->execute();
return $stmt;
} catch (PDOException $e) {
echo $e->getMessage();
}
}
public function updateNote($satker, $mitra, $tipe_mitra, $judul_lingkup, $nomor, $periode, $lokasi, $peran, $progres, $masalah_upaya, $keterangan, $pengelola, $photo, $id)
{
try {
$stmt = $this->conn->prepare(
"UPDATE tb_note
SET satker=:satker,
mitra=:mitra,
tipe_mitra=:tipe_mitra,
judul_lingkup=:judul_lingkup,
nomor=:nomor,
periode=:periode,
lokasi=:lokasi,
peran=:peran,
progres=:progres,
masalah_upaya=:masalah_upaya,
keterangan=:keterangan,
pengelola=:pengelola,
photo=:photo
WHERE id_note=:id"
);
$stmt->bindParam(':satker', $satker);
$stmt->bindParam(':mitra', $mitra);
$stmt->bindParam(':tipe_mitra', $tipe_mitra);
$stmt->bindParam(':judul_lingkup', $judul_lingkup);
$stmt->bindParam(':nomor', $nomor);
$stmt->bindParam(':periode', $periode);
$stmt->bindParam(':lokasi', $lokasi);
$stmt->bindParam(':peran', $peran);
$stmt->bindParam(':progres', $progres);
$stmt->bindParam(':masalah_upaya', $masalah_upaya);
$stmt->bindParam(':keterangan', $keterangan);
$stmt->bindParam(':pengelola', $pengelola);
$stmt->bindParam(':photo', $photo);
$stmt->bindParam(':id', $id);
$stmt->execute();
return $stmt;
} catch (PDOException $e) {
echo $e->getMessage();
}
}
public function deleteNote($id)
{
if (isset($_GET['delete_id'])) {
$stmt = $this->conn->prepare(
"DELETE FROM tb_note WHERE id_note=:id"
);
$stmt->bindParam(':id', $_GET['delete_id']);
$stmt->execute();
return $stmt;
}
}
public function redirect($url, $statusCode = 303)
{
header('Location: ' . $url, true, $statusCode);
die();
}
}
$auth_pro = new Note();
$stmt = $auth_pro->runQuery("SELECT * FROM tb_note");
$stmt->execute();
$result = null;
if ($stmt->rowCount() == 0) {
}
else {
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
if (date('y-m-d') - $row['crdate']){
$result[] =
"<td>".$row['id_note']."</td>
<td>".$row['crdate']."</td>
<td>".$row['satker']."</td>
<td>".$row['mitra']."</td>
<td>".$row['tipe_mitra']."</td>
<td>".$row['judul_lingkup']."</td>
<td style='background-color:red'>".$row['nomor']."<br>".$row['periode']." Tahun</td>
<td>".$row['lokasi']."</td>
<td>".$row['peran']."</td>
<td>".$row['progres']."</td>
<td>".$row['masalah_upaya']."</td>
<td>".$row['keterangan']."</td>
<td>".$row['pengelola']."</td>
<td>
<div class='btn-group btn-group-sm'>
<a href='system/delete.php?id_note=".$row['id_note']."'' class='btn btn-danger fa fa-trash-o' onClick='return confirm('Anda yakin ingin hapus seluruh data ini?');' class='on-default'> Hapus</a>
</div>
<div class='btn-group btn-group-sm'>
<a href='views/edit.php?id_note=".$row['id_note']."' class='btn btn-warning fa fa-pencil'>Ubaaah</a>
</div>
</td>";
}else{
"<td>".$row['id_note']."</td>
<td>".$row['crdate']."</td>
<td>".$row['satker']."</td>
<td>".$row['mitra']."</td>
<td>".$row['tipe_mitra']."</td>
<td>".$row['judul_lingkup']."</td>
<td>".$row['nomor']."<br>".$row['periode']." Tahun</td>
<td>".$row['lokasi']."</td>
<td>".$row['peran']."</td>
<td>".$row['progres']."</td>
<td>".$row['masalah_upaya']."</td>
<td>".$row['keterangan']."</td>
<td>".$row['pengelola']."</td>
<td>
<div class='btn-group btn-group-sm'>
<a href='system/delete.php?id_note=".$row['id_note']."'' class='btn btn-danger fa fa-trash-o' onClick='return confirm('Anda yakin ingin hapus seluruh data ini?');' class='on-default'> Hapus</a>
</div>
<div class='btn-group btn-group-sm'>
<a href='views/edit.php?id_note=".$row['id_note']."' class='btn btn-warning fa fa-pencil'>Ubaaah</a>
</div>
</td>";
}
}
}
?>
<table id="data" class="table datatable table-striped table-bordered table-hover">
<thead>
<tr>
<th>No.</th>
<th>ID.</th>
<th>Waktu Pencatatan</th>
<th>Satker Pelaksana</th>
<th>Mitra</th>
<th>Tipe Mitra</th>
<th>Judul dan Ruang Lingkup</th>
<th>Nomor dan Periode</th>
<th>Lokasi</th>
<th>Peran Kerja Sama Terhadap Kinerja KLHK (IKU, IKP, dan IKK)</th>
<th>Progres Pelaksanaan Kerja Sama</th>
<th>Permasalahan dan Upaya Tindak Lanjut</th>
<th>Ket.</th>
<th>Direktorat Pengelola Teknis</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php $no = 1; ?>
<tr id="trow_1">
<?php for ($i=0; $i < count($result); $i++) {
echo "<td>".$no++."</td>";
echo $result[$i]."</tr>";
} ?>
</tr>
</tbody>
</table>
?>
mercredi 15 avril 2020
if statement in if while statement php? how to change bg color only for the expired date 'nomor' & 'periode' rows. or any other way to solve this? [closed]
Inscription à :
Publier les commentaires (Atom)
Aucun commentaire:
Enregistrer un commentaire