- Beranda
- Komunitas
- Tech
- Programmer Forum
mohon bantuanya gan, binggung
TS
rangga..
mohon bantuanya gan, binggung
langsung aja deh pokok masalahnya..
jadi ane berkali2 bikin galery foto tp tiap bikin selalu foto yang di upload ga muncul per id masing2.. jadi kalo si A upload foto galery, Digaleri si B muncul juga uploadnya si A dan sebaliknya. supaya hasil uploadnya muncul di dinding galeri masing2 gmna yak..?
jadi ane berkali2 bikin galery foto tp tiap bikin selalu foto yang di upload ga muncul per id masing2.. jadi kalo si A upload foto galery, Digaleri si B muncul juga uploadnya si A dan sebaliknya. supaya hasil uploadnya muncul di dinding galeri masing2 gmna yak..?
Spoiler for galeri.php:
<?php include "koneksi.php";
$tampil=mysql_query("SELECT * from gambar order by idf desc");?>
<h2>Archive Photos (<?php $jumlah=mysql_num_rows($tampil); echo"$jumlah";?> foto)</h2>
<table width="300" border="1">
<tr>
<td><a href="galeri.php">Home Galeri </a></td>
<td><a href="tambah_foto.php">Add a Photo </a></td>
<td><a href="data_album.php">Data Album</a></td>
</tr>
</table>
<br>
<?php
$dataPerPage = 9; //jumlah foto dalam satu halaman
// apabila $_GET['page'] sudah didefinisikan, gunakan nomor halaman tersebut,
// sedangkan apabila belum, nomor halamannya 1.
if(isset($_GET['page']))
{
$noPage = $_GET['page'];
}
else $noPage = 1;
// perhitungan offset
$offset = ($noPage - 1) * $dataPerPage;
// query SQL untuk menampilkan data perhalaman sesuai offset
if (isset($_GET['alb']) && ($id_al=$_GET['alb']) && ($id_al !="")){
$hasil=mysql_query("SELECT * FROM album WHERE ida='$id_al'") or die ('ERROR');
$data = mysql_fetch_array ($hasil);
$nama_alb=$data['nma']; echo "<h2>Foto Album: $nama_alb</h2>";
$query="SELECT * FROM gambar WHERE ida=$id_al order by idf desc LIMIT $offset, $dataPerPage";
$que = "SELECT COUNT(*) AS jumData FROM gambar WHERE idf=$id_al";}
else {$query="SELECT * FROM gambar order by idf desc LIMIT $offset, $dataPerPage";
$que = "SELECT COUNT(*) AS jumData FROM gambar";
$id_al="";}
$result = mysql_query($query) or die('Error');
// menampilkan data
?>
<table>
<tr>
<?php
$i = 1;
while ($row = mysql_fetch_array ($result))
{?>
<td>
<a href="imgpost/<?php echo $row['namaf'];?>">
<img src="imgpost/<?php echo $row['namaf'];?>" alt="" width="200" border="0"/></a>
<br/><?php echo $row['ketf'];?><br/> Uploaded date : <?php echo $row['tgl'];?><br>
<a href="hapus_foto.php?id=<?php echo $row['idf'];?>">Delete</a>
| <a href="edit_foto.php?id=<?php echo $row['idf'];?>">Edit</a>
</td>
<?php
if($i % 3 == 0){
echo '</tr><tr>';
}
$i++;
}
?>
</tr>
</table>
<?php
// mencari jumlah semua data dalam tabel
$hasi = mysql_query($que);
$data = mysql_fetch_array($hasi);
$jumData = $data['jumData'];
// menentukan jumlah halaman yang muncul berdasarkan jumlah semua data
$jumPage = ceil($jumData/$dataPerPage);
// menampilkan link previous
if ($noPage > 1) echo "<a href='".$_SERVER['page=".($noPage-1)."alb=".$id_al."><< Prev</a>";
// memunculkan nomor halaman dan linknya
for($page = 1; $page <= $jumPage; $page++)
{
if ((($page >= $noPage - 3) && ($page <= $noPage + 3)) || ($page == 1) || ($page == $jumPage))
{
// if (($showPage == 1) && ($page != 2)) echo "...";
// if (($showPage != ($jumPage - 1)) && ($page == $jumPage)) echo "...";
if ($page == $noPage) echo " <b>".$page."</b> ";
else echo " <a href='".$_SERVER['page=".$page."alb=".$id_al.">".$page."</a> ";
$showPage = $page;
}
}
// menampilkan link next
if ($noPage < $jumPage) echo "<a href='".$_SERVER['page=".($noPage+1)."alb=".$id_al.">Next >></a>";
?>
$tampil=mysql_query("SELECT * from gambar order by idf desc");?>
<h2>Archive Photos (<?php $jumlah=mysql_num_rows($tampil); echo"$jumlah";?> foto)</h2>
<table width="300" border="1">
<tr>
<td><a href="galeri.php">Home Galeri </a></td>
<td><a href="tambah_foto.php">Add a Photo </a></td>
<td><a href="data_album.php">Data Album</a></td>
</tr>
</table>
<br>
<?php
$dataPerPage = 9; //jumlah foto dalam satu halaman
// apabila $_GET['page'] sudah didefinisikan, gunakan nomor halaman tersebut,
// sedangkan apabila belum, nomor halamannya 1.
if(isset($_GET['page']))
{
$noPage = $_GET['page'];
}
else $noPage = 1;
// perhitungan offset
$offset = ($noPage - 1) * $dataPerPage;
// query SQL untuk menampilkan data perhalaman sesuai offset
if (isset($_GET['alb']) && ($id_al=$_GET['alb']) && ($id_al !="")){
$hasil=mysql_query("SELECT * FROM album WHERE ida='$id_al'") or die ('ERROR');
$data = mysql_fetch_array ($hasil);
$nama_alb=$data['nma']; echo "<h2>Foto Album: $nama_alb</h2>";
$query="SELECT * FROM gambar WHERE ida=$id_al order by idf desc LIMIT $offset, $dataPerPage";
$que = "SELECT COUNT(*) AS jumData FROM gambar WHERE idf=$id_al";}
else {$query="SELECT * FROM gambar order by idf desc LIMIT $offset, $dataPerPage";
$que = "SELECT COUNT(*) AS jumData FROM gambar";
$id_al="";}
$result = mysql_query($query) or die('Error');
// menampilkan data
?>
<table>
<tr>
<?php
$i = 1;
while ($row = mysql_fetch_array ($result))
{?>
<td>
<a href="imgpost/<?php echo $row['namaf'];?>">
<img src="imgpost/<?php echo $row['namaf'];?>" alt="" width="200" border="0"/></a>
<br/><?php echo $row['ketf'];?><br/> Uploaded date : <?php echo $row['tgl'];?><br>
<a href="hapus_foto.php?id=<?php echo $row['idf'];?>">Delete</a>
| <a href="edit_foto.php?id=<?php echo $row['idf'];?>">Edit</a>
</td>
<?php
if($i % 3 == 0){
echo '</tr><tr>';
}
$i++;
}
?>
</tr>
</table>
<?php
// mencari jumlah semua data dalam tabel
$hasi = mysql_query($que);
$data = mysql_fetch_array($hasi);
$jumData = $data['jumData'];
// menentukan jumlah halaman yang muncul berdasarkan jumlah semua data
$jumPage = ceil($jumData/$dataPerPage);
// menampilkan link previous
if ($noPage > 1) echo "<a href='".$_SERVER['page=".($noPage-1)."alb=".$id_al."><< Prev</a>";
// memunculkan nomor halaman dan linknya
for($page = 1; $page <= $jumPage; $page++)
{
if ((($page >= $noPage - 3) && ($page <= $noPage + 3)) || ($page == 1) || ($page == $jumPage))
{
// if (($showPage == 1) && ($page != 2)) echo "...";
// if (($showPage != ($jumPage - 1)) && ($page == $jumPage)) echo "...";
if ($page == $noPage) echo " <b>".$page."</b> ";
else echo " <a href='".$_SERVER['page=".$page."alb=".$id_al.">".$page."</a> ";
$showPage = $page;
}
}
// menampilkan link next
if ($noPage < $jumPage) echo "<a href='".$_SERVER['page=".($noPage+1)."alb=".$id_al.">Next >></a>";
?>
Spoiler for update_foto.php:
<table align="center">
<tr>
<?php include "koneksi.php";
$namafolder="imgpost/"; //tempat menyimpan file
if (isset($_POST['kirim'])) {
$album_ft=$_POST['album'];
for($i=0; $i<count($_FILES['nama_file']); $i++)
{
if (!empty($_FILES["nama_file"]["tmp_name"][$i]))
{
$tgl=date("His");
$jenis_gambar=$_FILES['nama_file']['type'][$i];
$ket_gambar=$_POST['ket'][$i];
if($jenis_gambar=="image/jpeg" || $jenis_gambar=="image/jpg" || $jenis_gambar=="image/gif" || $jenis_gambar=="image/png")
{
$gambar = $namafolder.$tgl.basename($_FILES['nama_file']['name'][$i]);
$nama_gbr= $tgl.basename($_FILES['nama_file']['name'][$i]);
if (move_uploaded_file($_FILES['nama_file']['tmp_name'][$i], $gambar){
//tampilkan ke layar
echo "<td><img /><br />";
echo "".$ket_gambar."<br /></td>";
//proses menyimpan database berikut ini
mysql_query("insert into gambar(ida,namaf,ketf,tgl) values('$album_ft','$nama_gbr','$ket_gambar',now())") or die(mysql_error());
}
}
else
{
echo "Jenis gambar yang anda kirim salah. Harus .jpg .gif .png<br />";
}
}
}
echo "<td><a >Kembali ke Halaman Depan</a></td>";
}
?>
</tr>
</table>
<form action="" method="post" enctype="multipart/form-data" style="height:auto; margin:10px 10px; width: auto;">
<h3 align="center">Define the album, select the file to be uploaded and content descriptions:</h3>
<div align="center">
<p>Only image files jpg / gif / png
<br>
The file name must be less than 25 characters </p>
</div>
<table width="600"align="center" >
<tr>
<td width="8%"><div align="center"><strong>No.</strong></div></td>
<td width="38%"><div align="justify"><strong>File Image </strong></div></td>
<td width="54%"><div align="left"><strong> Descriptions </strong></div></td>
</tr>
<tr>
<td><div align="center">1.</div></td>
<td><input name="nama_file[]" type="file" /> </td>
<td><textarea name="ket[]"></textarea></td>
</tr>
<tr>
<td><div align="center">2.</div></td>
<td><input name="nama_file[]" type="file" /> </td>
<td><textarea name="ket[]"></textarea> </td>
</tr>
<tr>
<td><div align="center">3.</div></td>
<td><input name="nama_file[]" type="file" /> </td>
<td><textarea name="ket[]"></textarea> </td>
</tr>
<tr>
<td><div align="center">4.</div></td>
<td><input name="nama_file[]" type="file" /> </td>
<td><textarea name="ket[]"></textarea> </td>
</tr><tr><td> </td>
<td align="right">Pilih Album:</td><td><select name="album">
<?php
$query = "SELECT ida, nma FROM album ORDER BY nma";
$sql = mysql_query ($query);
while ($hasil = mysql_fetch_array ($sql)) {
echo "<option value='$hasil[ida]'>$hasil[nma]</option>";
}
?>
</select></td></tr>
</table>
<p align="center">
<input name="kirim" type="submit" id="btnKirim" value="send a file " />
</form>
<tr>
<?php include "koneksi.php";
$namafolder="imgpost/"; //tempat menyimpan file
if (isset($_POST['kirim'])) {
$album_ft=$_POST['album'];
for($i=0; $i<count($_FILES['nama_file']); $i++)
{
if (!empty($_FILES["nama_file"]["tmp_name"][$i]))
{
$tgl=date("His");
$jenis_gambar=$_FILES['nama_file']['type'][$i];
$ket_gambar=$_POST['ket'][$i];
if($jenis_gambar=="image/jpeg" || $jenis_gambar=="image/jpg" || $jenis_gambar=="image/gif" || $jenis_gambar=="image/png")
{
$gambar = $namafolder.$tgl.basename($_FILES['nama_file']['name'][$i]);
$nama_gbr= $tgl.basename($_FILES['nama_file']['name'][$i]);
if (move_uploaded_file($_FILES['nama_file']['tmp_name'][$i], $gambar){
//tampilkan ke layar
echo "<td><img /><br />";
echo "".$ket_gambar."<br /></td>";
//proses menyimpan database berikut ini
mysql_query("insert into gambar(ida,namaf,ketf,tgl) values('$album_ft','$nama_gbr','$ket_gambar',now())") or die(mysql_error());
}
}
else
{
echo "Jenis gambar yang anda kirim salah. Harus .jpg .gif .png<br />";
}
}
}
echo "<td><a >Kembali ke Halaman Depan</a></td>";
}
?>
</tr>
</table>
<form action="" method="post" enctype="multipart/form-data" style="height:auto; margin:10px 10px; width: auto;">
<h3 align="center">Define the album, select the file to be uploaded and content descriptions:</h3>
<div align="center">
<p>Only image files jpg / gif / png
<br>
The file name must be less than 25 characters </p>
</div>
<table width="600"align="center" >
<tr>
<td width="8%"><div align="center"><strong>No.</strong></div></td>
<td width="38%"><div align="justify"><strong>File Image </strong></div></td>
<td width="54%"><div align="left"><strong> Descriptions </strong></div></td>
</tr>
<tr>
<td><div align="center">1.</div></td>
<td><input name="nama_file[]" type="file" /> </td>
<td><textarea name="ket[]"></textarea></td>
</tr>
<tr>
<td><div align="center">2.</div></td>
<td><input name="nama_file[]" type="file" /> </td>
<td><textarea name="ket[]"></textarea> </td>
</tr>
<tr>
<td><div align="center">3.</div></td>
<td><input name="nama_file[]" type="file" /> </td>
<td><textarea name="ket[]"></textarea> </td>
</tr>
<tr>
<td><div align="center">4.</div></td>
<td><input name="nama_file[]" type="file" /> </td>
<td><textarea name="ket[]"></textarea> </td>
</tr><tr><td> </td>
<td align="right">Pilih Album:</td><td><select name="album">
<?php
$query = "SELECT ida, nma FROM album ORDER BY nma";
$sql = mysql_query ($query);
while ($hasil = mysql_fetch_array ($sql)) {
echo "<option value='$hasil[ida]'>$hasil[nma]</option>";
}
?>
</select></td></tr>
</table>
<p align="center">
<input name="kirim" type="submit" id="btnKirim" value="send a file " />
</form>
Spoiler for HADIAH DARI ANE:
cendol buat yg bisa bantu..
Diubah oleh rangga.. 22-10-2014 17:36
0
1.7K
Kutip
21
Balasan
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Urutan
Terbaru
Terlama
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Komunitas Pilihan