if($_GET[action]=="delete"){
// dapatkan nama file
$sql_="select id_video, judul, file
from tb_video where id_video=$_GET[id]";
$hasil_=mysqli_query($link,$sql_);
$data_=mysqli_fetch_array($hasil_);
//delete row
$sql = "delete from tb_video where id_video=$_GET[id]";
$hasil = mysqli_query($link,$sql);
//delete file
if($hasil_) {
unlink("../source/$data_[file]");
}
//reload page otomatis dengan javascript
echo "<script language=javascript>
alert('Data Berhasil Dihapus');</script>";
echo '<script type=text/javascript>
<!--
window.location = "index.php"
//-->
</script>';
}
function waktuindo($datawaktu)
{
$waktu=explode('-',$datawaktu);
if ($waktu[1] == '01') //jika 01 maka januari
{
$bulan='Januari';
}
elseif ($waktu[1] == '02')
{
$bulan='Februari';
}
elseif ($waktu[1] == '03')
{
$bulan='Maret';
}
elseif ($waktu[1] == '04')
{
$bulan='April';
}
elseif ($waktu[1] == '05')
{
$bulan='Mei';
}
elseif ($waktu[1] == '06')
{
$bulan='Juni';
}
elseif ($waktu[1] == '07')
{
$bulan='Juli';
}
elseif ($waktu[1] == '08')
{
$bulan='Agustus';
}
elseif ($waktu[1] == '09')
{
$bulan='September';
}
elseif ($waktu[1] == '10')
{
$bulan='Oktober';
}
elseif ($waktu[1] == '11')
{
$bulan='November';
}
elseif ($waktu[1] == '12')
{
$bulan='Desember';
}
else
{
$bulan='00';
}
echo"$waktu[2] $bulan $waktu[0]";
}
$query = "SELECT `date_col` AS `date_mysql`,DATE_FORMAT(`date_col`, '%W, %M %e') AS `date_text`FROM `table_name`"; 
if ($baris[date_text]=='Monday'){
$baris[date_text]='Senin';
}
else if ($baris[date_text]=='Tuesday'){
$baris[date_text]='Selasa';
}
else if ($baris[date_text]=='Wednesday'){
$baris[date_text]='Rabu';
}
else if ($baris[date_text]=='Thursday'){
$baris[date_text]='Kamis';
}
else if ($baris[date_text]=='Friday'){
$baris[date_text]='Jumat';
}
else if ($baris[date_text]=='Saturday'){
$baris[date_text]='Sabtu';
}
else if ($baris[date_text]=='Monday'){
$baris[date_text]='Minggu';
}
else {
$baris[date_text]='--';
}
How we call the image from the common file ?
<?php
require_once('../include/koneksi.php');
header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");;
header("Content-Disposition: attachment;filename=
". "kkkk". date('Ymd'). ".sql ");
header("Content-Transfer-Encoding: binary ");
echo "create database if not exists `db_wisuda`;\r\n";
echo "\r\n";
echo "use `db_wisuda`;\r\n";
echo "\r\n";
$m = "SHOW TABLE STATUS FROM db_wisuda";
$n = mysqli_query($link,$m);
while ($datao = mysqli_fetch_array($n))
{
$table=$datao[0];
echo "/*Table structure for table `$table` */\r\n";
echo "\r\n";
echo "DROP TABLE IF EXISTS `$table`;\r\n";
echo "\r\n";
echo "CREATE TABLE `$table` (\r\n";
$sql0="desc $table";
$res0= mysqli_query($link,$sql0);
$jum0=mysqli_num_rows($res0);
$j=0;
$key=0;
while($row0= mysqli_fetch_row($res0)){
$j++;
if($jum0==$j and $key==0)
{
if($row0[2]=='NO')
{
echo "`$row0[0]` $row0[1] NOT NULL);\r\n";
}
else
{
echo "`$row0[0]` $row0[1] default NULL);\r\n";
}
}
else
{
if($row0[2]=='NO')
{
echo "`$row0[0]` $row0[1] NOT NULL,\r\n";
}
else
{
echo "`$row0[0]` $row0[1] default NULL,\r\n";
}
}
if($row0[3]=='PRI')
{
$key=$key+1;
}
}
$sql1= "desc $table";
$res1= mysqli_query($link,$sql1);
$k=0;
while ($row1= mysqli_fetch_row($res1))
{
if($row1[3]=='PRI')
{
$k++;
if($key-1==0)
{
echo "PRIMARY KEY (`$row1[0]`)\r\n";
echo ");\r\n";
}
else if($k>1 and $k<$key)
{
echo "`$row1[0]`,";
}
else if($k==$key)
{
echo "`$row1[0]`)\r\n";
echo ");\r\n";
}
else
{
echo "PRIMARY KEY (`$row1[0]`,";
}
}
}
echo "\r\n";
$sql= "SELECT * FROM $table";
$res= mysqli_query($link,$sql);
while($row= mysqli_fetch_row($res)){
echo "INSERT INTO `$table` VALUES('".implode("','",$row)."');\r\n";
}
}
echo "\r\n";
?>
<?php
$birthdate = '1987-04-11';
$age = ((time() - strtotime($birthdate))/(60*60*24*365.2425));
echo"$age";
?>
Semoga Berhasil..