Album&foto
(Album.php)
<?php
session_start();
include '../config/koneksi.php';
if($_SESSION['status']!='login'){
echo "<script>
alert('Anda belum Login!');
location.href='../index.php';
</script>";
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Website Gallery Foto</title>
<link rel="stylesheet" type="text/css" href="../assets/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.3/font/bootstrap-icons.min.css">
</head>
<body>
<nav class="navbar navbar-expand-lg bg-body-tertiary bg-info border-bottom">
<div class="container">
<a class="navbar-brand text-white" href="index.php">Website Galerry Foto</a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNavAltMarkup" aria-controls="navbarNavAltMarkup" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse mt-2" id="navbarNavAltMarkup">
<div class="navbar-nav me-auto"></div>
<ul class="navbar-nav">
<li class="nav-item"><a href="home.php" class="nav-link text-white"><i class="bi bi-house-door-fill">Home</i></a></li>
<a href="album.php" class="nav-link text-dark"><i class="bi bi-journal-album">Album</i></a>
<a href="foto.php" class="nav-link text-white"><i class="bi bi-file-image">Foto</i></a>
</div>
</ul>
</div>
<a href="../config/proses_logout.php" class="btn btn-outline-danger m-1 text-white"><i class="bi bi-box-arrow-right"></i></a>
</nav>
<div class="container table-responsive">
<div class="row">
<div class="col-md-4">
<div class="card mt-2">
<div class="card-header">Tambah Album</div>
<div class="card-body">
<form action="../config/proses_album.php" method="POST">
<label class="form-label text-dark">Nama Album</label>
<input type="text" name="namaalbum" class="form-control" required>
<label class="form-label">Deskripsi</label>
<textarea class="form-control" name="deskripsi" required></textarea>
<button type="submit" class="btn btn-primary mt-2" name="tambah">Tambah</button>
</form>
</div>
</div>
</div>
<div class="col-md-8">
<div class="card mt-2">
<div class="card-header">Data Album</div>
<div class="card-body">
<table class="table table-bordered table-striped">
<thead>
<tr class="table-primary">
<th>ID</th>
<th>Nama Album</th>
<th>Deskripsi</th>
<th>Tanggal</th>
<th>Aksi</th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
$userid = $_SESSION['userid'];
$sql = mysqli_query($conn, "select * from album where userid='$userid'");
while($data=mysqli_fetch_array($sql)) {
?>
<tr>
<td><?php echo $no++ ?></td>
<td><?php echo $data['namaalbum'] ?></td>
<td><?php echo $data['deskripsi'] ?></td>
<td><?php echo $data['tanggaldibuat'] ?></td>
<td>
<button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#edit<?php echo $data['albumid']?>">
<i class="bi bi-pencil-square"></i>
</button>
<div class="modal fade" id="edit<?php echo $data['albumid']?>" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h1 class="modal-title fs-5" id="exampleModalLabel">Edit Data</h1>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body">
<form action="../config/proses_album.php" method="POST" enctype="multipart/form-data">
<input type="hidden" name="albumid" value="<?php echo $data['albumid'] ?>">
<label class="form-label">Nama Album</label>
<input type="text" name="namaalbum" value="<?php echo $data['namaalbum'] ?>" class="form-control" required>
<label class="form-label">Deskripsi</label>
<textarea class="form-control" name="deskripsi" required> <?php echo $data['deskripsi']; ?>
</textarea>
</div>
<div class="modal-footer">
<button type="submit" name="edit" class="btn btn-primary">Edit</button>
</form>
</div>
</div>
</div>
</div>
<button type="button" class="btn btn-danger" data-bs-toggle="modal" data-bs-target="#hapus<?php echo $data['albumid']?>">
<i class="bi bi-trash3-fill"></i>
</button>
<div class="modal fade" id="hapus<?php echo $data['albumid']?>" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h1 class="modal-title fs-5" id="exampleModalLabel">Hapus Data</h1>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body">
<form action="../config/proses_album.php" method="POST">
<input type="hidden" name="albumid" value="<?php echo $data['albumid']?>">
Apakah anda yakin ingin menghapus <strong><?php echo $data['namaalbum']?></strong> ?
</div>
<div class="modal-footer">
<button type="submit" name="hapus" class="btn btn-primary"><i class="bi bi-check-lg"></i></button>
</form>
</div>
</div>
</div>
</div>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<footer class="d-flex justify-content-center border-top mt-3 bg-secondary text-white fixed-bottom">
<p>© UKK RPL 2024 | Jaya Supriadi</p>
</footer>
<script type="text/javascript" src="../assets/js/bootstrap.min.js"></script>
</body>
</html>
(Foto.php)
include "../config/koneksi.php";
session_start();
if($_SESSION['status']!='login'){
echo "<script>
alert('Anda belum Login!');
location.href='../index.php';
</script>";
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Website Gallery Foto</title>
<link rel="stylesheet" type="text/css" href="../assets/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.3/font/bootstrap-icons.min.css">
</head>
<body>
<nav class="navbar navbar-expand-lg bg-body-tertiary bg-info text-dark border-bottom">
<div class="container">
<a class="navbar-brand text-white" href="index.php">Website Galerry Foto</a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNavAltMarkup" aria-controls="navbarNavAltMarkup" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse mt-2" id="navbarNavAltMarkup">
<div class="navbar-nav me-auto"></div>
<ul class="navbar-nav">
<li class="nav-item"><a href="home.php" class="nav-link text-white"><i class="bi bi-house-door-fill">Home</i></a></li>
<a href="album.php" class="nav-link text-white"><i class="bi bi-journal-album">Album</i></a>
<a href="foto.php" class="nav-link text-dark"><i class="bi bi-file-image">Foto</i></a>
</div>
</ul>
</div>
<a href="../config/proses_logout.php" class="btn btn-outline-danger m-1 text-white"><i class="bi bi-box-arrow-right"></i></a>
</nav>
<div class="container">
<div class="row">
<div class="col-md-4">
<div class="card mt-2">
<div class="card-header">Tambah Foto</div>
<div class="card-body">
<form action="../config/proses_foto.php" method="POST" enctype="multipart/form-data">
<label class="form-label">Judul Foto</label>
<input type="text" name="judulfoto" class="form-control" required>
<label class="form-label">Deskripsi</label>
<textarea class="form-control" name="deskripsifoto" required></textarea>
<label class="form-label">Album</label>
<select class="form-control" name="albumid" required>
<?php
$userid = $_SESSION['userid'];
$sql_album = mysqli_query($conn, "select * from album where userid='$userid'");
while($data_album=mysqli_fetch_array($sql_album)){ ?>
<option value="<?php echo $data_album['albumid'] ?>"><?php echo $data_album['namaalbum'] ?></option>
<?php
}
?>
</select>
<label class="form-label">File</label>
<input type="file" class="form-control" name="lokasifile" required>
<button type="submit" class="btn btn-primary mt-2" name="tambah">Tambah</button>
</form>
</div>
</div>
</div>
<div class="col-md-8">
<div class="card mt-2">
<div class="card-header">Data Gallery Foto</div>
<div class="card-body">
<table class="table table-bordered table-striped">
<thead>
<tr class="table-primary">
<th>ID</th>
<th>Foto</th>
<th>Judul Foto</th>
<th>Deskripsi</th>
<th>Tanggal</th>
<th>Aksi</th>
</tr>
</thead>
<tbody>
<?php
$no = 1;
$userid = $_SESSION['userid'];
$sql = mysqli_query($conn, "select * from foto where userid='$userid'");
while($data=mysqli_fetch_array($sql)){
?>
<tr>
<td><?php echo $no++ ?></td>
<td><img src="../assets/img/<?php echo $data['lokasifile']?>" width="100"></td>
<td><?php echo $data['judulfoto'] ?></td>
<td><?php echo $data['deskripsifoto'] ?></td>
<td><?php echo $data['tanggalunggah'] ?></td>
<td>
<button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#edit<?php echo $data['fotoid']?>">
<i class="bi bi-pencil-square"></i>
</button>
<div class="modal fade" id="edit<?php echo $data['fotoid']?>" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h1 class="modal-title fs-5" id="exampleModalLabel">Edit Data</h1>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body">
<form action="../config/proses_foto.php" method="POST" enctype="multipart/form-data">
<input type="hidden" name="fotoid" value="<?php echo $data['fotoid']?>">
<label class="form-label">Judul Foto</label>
<input type="text" name="judulfoto" value="<?php echo $data['judulfoto']?>" class="form-control" required>
<label class="form-label">Deskripsi</label>
<textarea class="form-control" name="deskripsifoto" required><?php echo $data['deskripsifoto'];?>
</textarea>
<label class="form-label">Album</label>
<select class="form-control" name="albumid">
<?php
$userid = $_SESSION['userid'];
$sql_album = mysqli_query($conn, "select * from album where userid='$userid'");
while($data_album=mysqli_fetch_array($sql_album)){ ?>
<option <?php if($data_album['albumid']==$data['albumid']) {?> selected="selected" <?php } ?> value="<?php echo $data_album['albumid'] ?>"><?php echo $data_album['namaalbum'] ?></option>
<?php
}
?>
</select>
<label class="form-label">Foto</label>
<div class="row">
<div class="col-md-4">
<img src="../assets/img/<?php echo $data['lokasifile']?>" width="100">
</div>
<div class="col-md-8">
<label class="form-label">Ganti File</label>
<input type="file" class="form-control" name="lokasifile">
</div>
</div>
</div>
<div class="modal-footer">
<button type="submit" name="edit" class="btn btn-primary">Edit</button>
</form>
</div>
</div>
</div>
</div>
<button type="button" class="btn btn-danger" data-bs-toggle="modal" data-bs-target="#hapus<?php echo $data['fotoid']?>">
<i class="bi bi-trash3-fill"></i>
</button>
<div class="modal fade" id="hapus<?php echo $data['fotoid']?>" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h1 class="modal-title fs-5" id="exampleModalLabel">Hapus Data</h1>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body">
<form action="../config/proses_foto.php" method="POST">
<input type="hidden" name="fotoid" value="<?php echo $data['fotoid']?>">
Apakah anda yakin ingin menghapus <strong><?php echo $data['judulfoto']?></strong>?
</div>
<div class="modal-footer">
<button type="submit" name="hapus" class="btn btn-primary">Hapus</button>
</form>
</div>
</div>
</div>
</div>
</td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<footer class="d-flex justify-content-center border-top mt-3 bg-secondary fixed-bottom">
<p>© UKK RPL 2024 | Jaya Supriadi</p>
</footer>
<script type="text/javascript" src="../assets/js/bootstrap.min.js"></script>
</body>
</html>
Index.php
<?php
session_start();
$userid = $_SESSION['userid'];
include '../config/koneksi.php';
if($_SESSION['status']!='login'){
echo "<script>
alert('Anda belum Login!');
location.href='../index.php';
</script>";
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Website Gallery Foto</title>
<link rel="stylesheet" type="text/css" href="../assets/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.1/css/all.min.css"/>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.3/font/bootstrap-icons.min.css">
<body>
<nav class="navbar navbar-expand-lg bg-body-tertiary bg-info text-white border-bottom border-light">
<div class="container">
<a class="navbar-brand text-dark" href="index.php">Website Galerry Foto</a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNavAltMarkup" aria-controls="navbarNavAltMarkup" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse mt-2" id="navbarNavAltMarkup">
<div class="navbar-nav me-auto"></div>
<ul class="navbar-nav">
<li class="nav-item"><a href="home.php" class="nav-link text-white"><i class="bi bi-house-door-fill">Home</i></a></li>
<a href="album.php" class="nav-link text-white"><i class="bi bi-journal-album">Album</i></a>
<a href="foto.php" class="nav-link text-white"><i class="bi bi-file-image">Foto</i></a>
</div>
<a href="../config/proses_logout.php" class="btn btn-outline-danger m-1 text-white"><svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-box-arrow-right" viewBox="0 0 16 16">
<path fill-rule="evenodd" d="M10 12.5a.5.5 0 0 1-.5.5h-8a.5.5 0 0 1-.5-.5v-9a.5.5 0 0 1 .5-.5h8a.5.5 0 0 1 .5.5v2a.5.5 0 0 0 1 0v-2A1.5 1.5 0 0 0 9.5 2h-8A1.5 1.5 0 0 0 0 3.5v9A1.5 1.5 0 0 0 1.5 14h8a1.5 1.5 0 0 0 1.5-1.5v-2a.5.5 0 0 0-1 0z"/>
<path fill-rule="evenodd" d="M15.854 8.354a.5.5 0 0 0 0-.708l-3-3a.5.5 0 0 0-.708.708L14.293 7.5H5.5a.5.5 0 0 0 0 1h8.793l-2.147 2.146a.5.5 0 0 0 .708.708z"/>
</svg></a>
</ul>
</div>
</div>
</nav>
<div class="container mt-3">
<div class="row">
<?php
$query=mysqli_query($conn, "SELECT * FROM foto inner join user on foto.userid=user.userid inner join album on foto.albumid=album.albumid");
while($data = mysqli_fetch_array($query)) {
?>
<div class="col-md-3 mt-2">
<a type="button" data-bs-toggle="modal" data-bs-target="#komentar<?php echo $data['fotoid'] ?>">
<div class="card mb-2">
<img style="height:12rem;" src="../assets/img/<?php echo $data['lokasifile'] ?>" class="card-img-top" title="<?php echo $data['judulfoto'] ?>" >
<div class="card-footer text-center">
<?php
$fotoid=$data['fotoid'];
$ceksuka=mysqli_query($conn, "select * from likefoto where fotoid='$fotoid' and userid='$userid'");
if (mysqli_num_rows($ceksuka) == 1) { ?>
<a href="../config/proses_like.php?fotoid=<?php echo $data['fotoid'] ?>" type="submit" name="batalsuka"><i class="fa fa-heart"></i></a>
<?php }else{ ?>
<a href="../config/proses_like.php?fotoid=<?php echo $data['fotoid'] ?>" type="submit" name="suka"><i class="fa-regular fa-heart"></i></a>
<?php }
$like=mysqli_query($conn, "SELECT * FROM likefoto WHERE fotoid='$fotoid'");
echo mysqli_num_rows($like). ' Suka';
?>
<a href="#" type="button" data-bs-toggle="modal" data-bs-target="#komentar<?php echo $data['fotoid'] ?>"><i class="fa-regular fa-comment"></i></a>
<?php
$jmlkomen=mysqli_query($conn, "select * from komentarfoto where fotoid='$fotoid'");
echo mysqli_num_rows($jmlkomen).' Komentar';
?>
</div>
</div>
</a>
<!-- Modal -->
<div class="modal fade" id="komentar<?php echo $data['fotoid'] ?>" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog modal-xl">
<div class="modal-content">
<div class="modal-body">
<div class="row">
<div class="col-md-8">
<img src="../assets/img/<?php echo $data['lokasifile'] ?>" class="card-img-top" title="<?php echo $data['judulfoto'] ?>">
</div>
<div class="col-md-4">
<div class="m-2">
<div class="overflow-auto">
<div class="sticky-top">
<strong><?php echo $data['judulfoto'] ?></strong><br>
<span class="badge bg-secondary"><?php echo $data['namalengkap'] ?></span>
<span class="badge bg-secondary"><?php echo $data['tanggalunggah'] ?></span>
<span class="badge bg-primary"><?php echo $data['namaalbum'] ?></span>
</div>
<hr>
<p align="left">
<?php echo $data['deskripsifoto'] ?>
</p>
<hr>
<?php
$fotoid= $data['fotoid'];
$komentar=mysqli_query($conn, "select * from komentarfoto inner join user on komentarfoto.userid=user.userid where komentarfoto.fotoid='$fotoid'");
while($row=mysqli_fetch_array($komentar)) {
?>
<p align="left">
<strong><?php echo $row['namalengkap'] ?></strong>
<?php echo $row['isikomentar'] ?>
<button align="left" type="button" class="btn btn-danger" data-bs-toggle="modal" data-bs-target="#hapus<?php echo $data['userid']?>">
<i class="bi bi-trash3-fill"></i>
</button>
<div class="modal fade" id="hapus<?php echo $data['userid']?>" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h1 class="modal-title fs-5" id="exampleModalLabel">Hapus Data</h1>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body">
<form action="../config/proses_komentar.php" method="POST">
<input type="hidden" name="userid" value="<?php echo $data['userid']?>">
Apakah anda yakin ingin menghapus <strong><?php echo $row['isikomentar']?></strong>?
</div>
<div class="modal-footer">
<button type="submit" name="hapus" class="btn btn-primary">Hapus</button>
</form>
</div>
</div>
</div>
</div>
</p>
<?php } ?>
<hr>
<div class="sticky-bottom">
<form action="../config/proses_komentar.php" method="POST">
<div class="input-group">
<input type="hidden" name="fotoid" value="<?php echo $data['fotoid']?>">
<input type="text" name="isikomentar" class="form-control" placeholder="Tambah Komentar">
<div class="input-group-prepend">
<button type="submit" name="kirimkomentar" class="btn btn-outline-primary"><i class="bi bi-send-fill"></i></button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php } ?>
</div>
</div>
<footer class="d-flex justify-content-center border-top mt-3 bg-secondary fixed-bottom">
<p>© UKK RPL 2024| Jaya Supriadi</p>
</footer>
<script type="text/javascript" src="../assets/js/bootstrap.min.js"></script>
</body>
</html>
Home
php
session_start();
$userid = $_SESSION['userid'];
include '../config/koneksi.php';
if($_SESSION['status']!='login'){
echo "<script>
alert('Anda belum Login!');
location.href='../index.php';
</script>";
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Website Gallery Foto</title>
<link rel="stylesheet" type="text/css" href="../assets/css/bootstrap.min.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.5.1/css/all.min.css"/>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap-icons@1.11.3/font/bootstrap-icons.min.css">
</head>
<body>
<nav class="navbar navbar-expand-lg bg-body-tertiary bg-info text-dark border-bottom">
<div class="container">
<a class="navbar-brand text-white" href="index.php">Website Galerry Foto</a>
<button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarNavAltMarkup" aria-controls="navbarNavAltMarkup" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse mt-2" id="navbarNavAltMarkup">
<div class="navbar-nav me-auto"></div>
<ul class="navbar-nav">
<li class="nav-item"><a href="home.php" class="nav-link text-dark"><i class="bi bi-house-door-fill">Home</i></a></li>
<a href="album.php" class="nav-link text-white"><i class="bi bi-journal-album">Album</i></a>
<a href="foto.php" class="nav-link text-white"><i class="bi bi-file-image">Foto</i></a>
</div>
</ul>
</div>
<a href="../config/proses_logout.php" class="btn btn-outline-danger m-1 text-white"><i class="bi bi-box-arrow-right"></i></a>
</nav>
<div class="container mt-3">
Album :
<?php
$album = mysqli_query($conn, "select * from album where userid='$userid'");
while ($row=mysqli_fetch_array($album)) { ?>
<a href="home.php?albumid=<?php echo $row['albumid'] ?>" class="btn btn-outline-primary"><?php echo $row['namaalbum'] ?></a>
<?php } ?>
<div class="row">
<?php
if (isset($_GET['albumid'])) {
$albumid=$_GET['albumid'];
$query=mysqli_query($conn, "select * from foto where userid='$userid' and albumid='$albumid'");
while($data = mysqli_fetch_array($query)) { ?>
<div class="col-md-3 mt-2">
<di class="card">
<img style="height:12rem;" src="../assets/img/<?php echo $data['lokasifile'] ?>" class="card-img-top" title="<?php echo $data['judulfoto'] ?>" >
<div class="card-footer text-center">
<?php
$fotoid=$data['fotoid'];
$ceksuka=mysqli_query($conn, "select * from likefoto where fotoid='$fotoid' and userid='$userid'");
if (mysqli_num_rows($ceksuka) == 1) { ?>
<a href="../config/proses_like.php?fotoid=<?php echo $data['fotoid'] ?>" type="submit" name="batalsuka"><i class="fa fa-heart"></i></a>
<?php }else{ ?>
<a href="../config/proses_like.php?fotoid=<?php echo $data['fotoid'] ?>" type="submit" name="suka"><i class="fa-regular fa-heart"></i></a>
<?php }
$like=mysqli_query($conn, "SELECT * FROM likefoto WHERE fotoid='$fotoid'");
echo mysqli_num_rows($like). ' Suka';
?>
<a href=""><i class="fa-regular fa-comment"></i></a>3 Komentar
</div>
</di>
</div>
<?php } }else {
$query=mysqli_query($conn, "SELECT * FROM foto WHERE userid='$userid'");
while($data = mysqli_fetch_array($query)) {
?>
<div class="col-md-3 mt-2">
<di class="card">
<img style="height:12rem;" src="../assets/img/<?php echo $data['lokasifile'] ?>" class="card-img-top" title="<?php echo $data['judulfoto'] ?>" >
<div class="card-footer text-center">
<?php
$fotoid=$data['fotoid'];
$ceksuka=mysqli_query($conn, "select * from likefoto where fotoid='$fotoid' and userid='$userid'");
if (mysqli_num_rows($ceksuka) == 1) { ?>
<a href="../config/proses_like.php?fotoid=<?php echo $data['fotoid'] ?>" type="submit" name="batalsuka"><i class="fa fa-heart"></i></a>
<?php }else{ ?>
<a href="../config/proses_like.php?fotoid=<?php echo $data['fotoid'] ?>" type="submit" name="suka"><i class="fa-regular fa-heart"></i></a>
<?php }
$like=mysqli_query($conn, "SELECT * FROM likefoto WHERE fotoid='$fotoid'");
echo mysqli_num_rows($like). ' Suka';
?>
<a href="#" type="button" data-bs-toggle="modal" data-bs-target="#komentar<?php echo $data['fotoid'] ?>"><i class="fa-regular fa-comment"></i></a>
<?php
$jmlkomen=mysqli_query($conn, "select * from komentarfoto where fotoid='$fotoid'");
echo mysqli_num_rows($jmlkomen).' Komentar';
?>
</div>
</div>
</a>
<!-- Modal -->
<div class="modal fade" id="komentar<?php echo $data['fotoid'] ?>" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog modal-xl">
<div class="modal-content">
<div class="modal-body">
<div class="row">
<div class="col-md-8">
<img src="../assets/img/<?php echo $data['lokasifile'] ?>" class="card-img-top" title="<?php echo $data['judulfoto'] ?>">
</div>
<div class="col-md-4">
<div class="m-2">
<div class="overflow-auto">
<div class="sticky-top">
<strong><?php echo $data['judulfoto'] ?></strong><br>
<span class="badge bg-secondary"><?php echo $data['namalengkap'] ?></span>
<span class="badge bg-secondary"><?php echo $data['tanggalunggah'] ?></span>
<span class="badge bg-primary"><?php echo $data['namaalbum'] ?></span>
</div>
<hr>
<p align="left">
<?php echo $data['deskripsifoto'] ?>
</p>
<hr>
<?php
$fotoid= $data['fotoid'];
$komentar=mysqli_query($conn, "select * from komentarfoto inner join user on komentarfoto.userid=user.userid where komentarfoto.fotoid='$fotoid'");
while($row=mysqli_fetch_array($komentar)) {
?>
<p align="left">
<strong><?php echo $row['namalengkap'] ?></strong>
<?php echo $row['isikomentar'] ?>
<button align="left" type="button" class="btn btn-danger" data-bs-toggle="modal" data-bs-target="#hapus<?php echo $data['userid']?>">
Hapus
</button>
<div class="modal fade" id="hapus<?php echo $data['userid']?>" tabindex="-1" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h1 class="modal-title fs-5" id="exampleModalLabel">Hapus Data</h1>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body">
<form action="../config/proses_komentar.php" method="POST">
<input type="hidden" name="userid" value="<?php echo $data['userid']?>">
Apakah anda yakin ingin menghapus <strong><?php echo $data['isikomentar']?></strong>?
</div>
<div class="modal-footer">
<button type="submit" name="hapus" class="btn btn-primary">Hapus</button>
</form>
</div>
</div>
</div>
</div>
</p>
<?php } ?>
<hr>
<div class="sticky-bottom">
<form action="../config/proses_komentar.php" method="POST">
<div class="input-group">
<input type="hidden" name="fotoid" value="<?php echo $data['fotoid']?>">
<input type="text" name="isikomentar" class="form-control" placeholder="Tambah Komentar">
<div class="input-group-prepend">
<button type="submit" name="kirimkomentar" class="btn btn-outline-primary">Kirim</button>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<?php } } ?>
</div>
</div>
<footer class="d-flex justify-content-center border-top mt-3 bg-secondary fixed-bottom">
<p>© UKK RPL 2024 | Jaya Supriadi</p>
</footer>
<script type="text/javascript" src="../assets/js/bootstrap.min.js"></script>
</body>
</html>
Komentar
Posting Komentar