<?

function select_tb_proses_perusahaan(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_proses_perusahaan" ;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_proses_perusahaan_by_id_proses_perusahaan($var_id_proses_perusahaan){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_proses_perusahaan WHERE id_proses_perusahaan = '" .mysqli_real_escape_string($connection, trim($var_id_proses_perusahaan)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_proses_perusahaan_by_id_perusahaan($var_id_perusahaan){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_proses_perusahaan WHERE id_perusahaan = '" .mysqli_real_escape_string($connection, trim($var_id_perusahaan)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_proses_perusahaan_by_nama_proses_perusahaan($var_nama_proses_perusahaan){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_proses_perusahaan WHERE nama_proses_perusahaan = '" .mysqli_real_escape_string($connection, trim($var_nama_proses_perusahaan)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_proses_perusahaan_by_icon_proses_perusahaan($var_icon_proses_perusahaan){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_proses_perusahaan WHERE icon_proses_perusahaan = '" .mysqli_real_escape_string($connection, trim($var_icon_proses_perusahaan)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_proses_perusahaan_by_keterangan_proses_perusahaan($var_keterangan_proses_perusahaan){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_proses_perusahaan WHERE keterangan_proses_perusahaan = '" .mysqli_real_escape_string($connection, trim($var_keterangan_proses_perusahaan)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_proses_perusahaan_by_status_publish_proses_perusahaan($var_status_publish_proses_perusahaan){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_proses_perusahaan WHERE status_publish_proses_perusahaan = '" .mysqli_real_escape_string($connection, trim($var_status_publish_proses_perusahaan)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_proses_perusahaan_by_status_delete_proses_perusahaan($var_status_delete_proses_perusahaan){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_proses_perusahaan WHERE status_delete_proses_perusahaan = '" .mysqli_real_escape_string($connection, trim($var_status_delete_proses_perusahaan)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}


function delete_tb_proses_perusahaan_by_id_perusahaan($var_id_perusahaan){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="DELETE FROM tb_proses_perusahaan WHERE id_perusahaan = " .mysqli_real_escape_string($connection, trim($var_id_perusahaan)). " LIMIT 1";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnDetete_tb_proses_perusahaan=1; } else { $returnDetete_tb_proses_perusahaan=0; }
	return $returnDetete_tb_proses_perusahaan;
}

function insert_tb_proses_perusahaan($var_id_perusahaan,$var_nama_proses_perusahaan,$var_icon_proses_perusahaan,$var_keterangan_proses_perusahaan,$var_status_publish_proses_perusahaan,$var_status_delete_proses_perusahaan){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="INSERT INTO tb_proses_perusahaan (id_proses_perusahaan,id_perusahaan,nama_proses_perusahaan,icon_proses_perusahaan,keterangan_proses_perusahaan,status_publish_proses_perusahaan,status_delete_proses_perusahaan) VALUES (NULL,'" .mysqli_real_escape_string($connection, trim($var_id_perusahaan)). "','" .mysqli_real_escape_string($connection, trim($var_nama_proses_perusahaan)). "','" .mysqli_real_escape_string($connection, trim($var_icon_proses_perusahaan)). "','" .mysqli_real_escape_string($connection, trim($var_keterangan_proses_perusahaan)). "','" .mysqli_real_escape_string($connection, trim($var_status_publish_proses_perusahaan)). "','" .mysqli_real_escape_string($connection, trim($var_status_delete_proses_perusahaan)). "')";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnInsert_tb_proses_perusahaan=1; } else { $returnInsert_tb_proses_perusahaan=0; }
	return $returnInsert_tb_proses_perusahaan;
}

function update_tb_proses_perusahaan($var_id_proses_perusahaan,$var_id_perusahaan,$var_nama_proses_perusahaan,$var_icon_proses_perusahaan,$var_keterangan_proses_perusahaan,$var_status_publish_proses_perusahaan,$var_status_delete_proses_perusahaan){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="UPDATE tb_proses_perusahaan SET id_perusahaan = '" .mysqli_real_escape_string($connection, trim($var_id_perusahaan)). "', nama_proses_perusahaan = '" .mysqli_real_escape_string($connection, trim($var_nama_proses_perusahaan)). "', icon_proses_perusahaan = '" .mysqli_real_escape_string($connection, trim($var_icon_proses_perusahaan)). "', keterangan_proses_perusahaan = '" .mysqli_real_escape_string($connection, trim($var_keterangan_proses_perusahaan)). "', status_publish_proses_perusahaan = '" .mysqli_real_escape_string($connection, trim($var_status_publish_proses_perusahaan)). "', status_delete_proses_perusahaan = '" .mysqli_real_escape_string($connection, trim($var_status_delete_proses_perusahaan)). "' WHERE id_proses_perusahaan = '" .mysqli_real_escape_string($connection, trim($var_id_proses_perusahaan)). "' LIMIT 1";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_proses_perusahaan=1; } else { $returnUpdate_tb_proses_perusahaan=0; }
	return $returnUpdate_tb_proses_perusahaan;
}

?><?

function select_tb_web_setting(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_web_setting" ;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_web_setting_by_id_setting($var_id_setting){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_web_setting WHERE id_setting = '" .mysqli_real_escape_string($connection, trim($var_id_setting)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_web_setting_by_id_perusahaan($var_id_perusahaan){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_web_setting WHERE id_perusahaan = '" .mysqli_real_escape_string($connection, trim($var_id_perusahaan)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_web_setting_by_web_title($var_web_title){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_web_setting WHERE web_title = '" .mysqli_real_escape_string($connection, trim($var_web_title)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_web_setting_by_web_icon($var_web_icon){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_web_setting WHERE web_icon = '" .mysqli_real_escape_string($connection, trim($var_web_icon)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_web_setting_by_web_logo($var_web_logo){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_web_setting WHERE web_logo = '" .mysqli_real_escape_string($connection, trim($var_web_logo)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_web_setting_by_web_master_email($var_web_master_email){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_web_setting WHERE web_master_email = '" .mysqli_real_escape_string($connection, trim($var_web_master_email)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_web_setting_by_web_address($var_web_address){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_web_setting WHERE web_address = '" .mysqli_real_escape_string($connection, trim($var_web_address)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_web_setting_by_web_tagline($var_web_tagline){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_web_setting WHERE web_tagline = '" .mysqli_real_escape_string($connection, trim($var_web_tagline)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}


function delete_tb_web_setting_by_id_perusahaan($var_id_perusahaan){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="DELETE FROM tb_web_setting WHERE id_perusahaan = " .mysqli_real_escape_string($connection, trim($var_id_perusahaan)). " LIMIT 1";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnDetete_tb_web_setting=1; } else { $returnDetete_tb_web_setting=0; }
	return $returnDetete_tb_web_setting;
}

function insert_tb_web_setting($var_id_perusahaan,$var_web_title,$var_web_icon,$var_web_logo,$var_web_master_email,$var_web_address,$var_web_tagline){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="INSERT INTO tb_web_setting (id_setting,id_perusahaan,web_title,web_icon,web_logo,web_master_email,web_address,web_tagline) VALUES (NULL,'" .mysqli_real_escape_string($connection, trim($var_id_perusahaan)). "','" .mysqli_real_escape_string($connection, trim($var_web_title)). "','" .mysqli_real_escape_string($connection, trim($var_web_icon)). "','" .mysqli_real_escape_string($connection, trim($var_web_logo)). "','" .mysqli_real_escape_string($connection, trim($var_web_master_email)). "','" .mysqli_real_escape_string($connection, trim($var_web_address)). "','" .mysqli_real_escape_string($connection, trim($var_web_tagline)). "')";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnInsert_tb_web_setting=1; } else { $returnInsert_tb_web_setting=0; }
	return $returnInsert_tb_web_setting;
}

function update_tb_web_setting($var_id_setting,$var_id_perusahaan,$var_web_title,$var_web_icon,$var_web_logo,$var_web_master_email,$var_web_address,$var_web_tagline){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="UPDATE tb_web_setting SET id_perusahaan = '" .mysqli_real_escape_string($connection, trim($var_id_perusahaan)). "', web_title = '" .mysqli_real_escape_string($connection, trim($var_web_title)). "', web_icon = '" .mysqli_real_escape_string($connection, trim($var_web_icon)). "', web_logo = '" .mysqli_real_escape_string($connection, trim($var_web_logo)). "', web_master_email = '" .mysqli_real_escape_string($connection, trim($var_web_master_email)). "', web_address = '" .mysqli_real_escape_string($connection, trim($var_web_address)). "', web_tagline = '" .mysqli_real_escape_string($connection, trim($var_web_tagline)). "' WHERE id_setting = '" .mysqli_real_escape_string($connection, trim($var_id_setting)). "' LIMIT 1";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_web_setting=1; } else { $returnUpdate_tb_web_setting=0; }
	return $returnUpdate_tb_web_setting;
}

?>
<?

function select_tb_media(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media" ;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_media_by_id_media($var_id_media){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE id_media = '" .mysqli_real_escape_string($connection, trim($var_id_media)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_media_by_id_kategori($var_id_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE id_kategori = '" .mysqli_real_escape_string($connection, trim($var_id_kategori)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_media_by_id_identifikasi($var_id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE id_identifikasi = '" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_media_by_nama_media($var_nama_media){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE nama_media = '" .mysqli_real_escape_string($connection, trim($var_nama_media)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_media_by_foto_media($var_foto_media){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE foto_media = '" .mysqli_real_escape_string($connection, trim($var_foto_media)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_media_by_alt_media($var_alt_media){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE alt_media = '" .mysqli_real_escape_string($connection, trim($var_alt_media)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_media_by_tagline_media($var_tagline_media){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE tagline_media = '" .mysqli_real_escape_string($connection, trim($var_tagline_media)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_media_by_keterangan_media($var_keterangan_media){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE keterangan_media = '" .mysqli_real_escape_string($connection, trim($var_keterangan_media)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_media_by_tanggal_rilis_media($var_tanggal_rilis_media){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE tanggal_rilis_media = '" .mysqli_real_escape_string($connection, trim($var_tanggal_rilis_media)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_media_by_tanggal_delete_media($var_tanggal_delete_media){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE tanggal_delete_media = '" .mysqli_real_escape_string($connection, trim($var_tanggal_delete_media)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_media_by_status_kategori_media($var_status_kategori_media){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE status_kategori_media = '" .mysqli_real_escape_string($connection, trim($var_status_kategori_media)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_media_by_status_konten_media($var_status_konten_media){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE status_konten_media = '" .mysqli_real_escape_string($connection, trim($var_status_konten_media)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_media_by_status_publish_media($var_status_publish_media){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE status_publish_media = '" .mysqli_real_escape_string($connection, trim($var_status_publish_media)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_media_by_status_delete_media($var_status_delete_media){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE status_delete_media = '" .mysqli_real_escape_string($connection, trim($var_status_delete_media)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_media_by_informasi_media_satu($var_informasi_media_satu){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE informasi_media_satu = '" .mysqli_real_escape_string($connection, trim($var_informasi_media_satu)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_media_by_informasi_media_dua($var_informasi_media_dua){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE informasi_media_dua = '" .mysqli_real_escape_string($connection, trim($var_informasi_media_dua)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}


function delete_tb_media_by_id_kategori($var_id_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="DELETE FROM tb_media WHERE id_kategori = " .mysqli_real_escape_string($connection, trim($var_id_kategori)). " LIMIT 1";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnDetete_tb_media=1; } else { $returnDetete_tb_media=0; }
	return $returnDetete_tb_media;
}

function insert_tb_media($var_id_kategori,$var_id_identifikasi,$var_nama_media,$var_foto_media,$var_alt_media,$var_tagline_media,$var_keterangan_media,$var_tanggal_rilis_media,$var_tanggal_delete_media,$var_status_kategori_media,$var_status_konten_media,$var_status_publish_media,$var_status_delete_media,$var_informasi_media_satu,$var_informasi_media_dua){ 

$connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);	$sql="INSERT INTO tb_media (id_media,id_kategori,id_identifikasi,nama_media,foto_media,alt_media,tagline_media,keterangan_media,tanggal_rilis_media,tanggal_delete_media,status_kategori_media,status_konten_media,status_publish_media,status_delete_media,informasi_media_satu,informasi_media_dua) VALUES (NULL,'" .mysqli_real_escape_string($connection, trim($var_id_kategori)). "','" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "','" .mysqli_real_escape_string($connection, trim($var_nama_media)). "','" .mysqli_real_escape_string($connection, trim($var_foto_media)). "','" .mysqli_real_escape_string($connection, trim($var_alt_media)). "','" .mysqli_real_escape_string($connection, trim($var_tagline_media)). "','" .mysqli_real_escape_string($connection, trim($var_keterangan_media)). "','" .mysqli_real_escape_string($connection, trim($var_tanggal_rilis_media)). "','" .mysqli_real_escape_string($connection, trim($var_tanggal_delete_media)). "','" .mysqli_real_escape_string($connection, trim($var_status_kategori_media)). "','" .mysqli_real_escape_string($connection, trim($var_status_konten_media)). "','" .mysqli_real_escape_string($connection, trim($var_status_publish_media)). "','" .mysqli_real_escape_string($connection, trim($var_status_delete_media)). "','" .mysqli_real_escape_string($connection, trim($var_informasi_media_satu)). "','" .mysqli_real_escape_string($connection, trim($var_informasi_media_dua)). "')";

	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnInsert_tb_media=1; } else { $returnInsert_tb_media=0; }
	return $returnInsert_tb_media;
}

function update_tb_media($var_id_media,$var_id_kategori,$var_id_identifikasi,$var_nama_media,$var_foto_media,$var_alt_media,$var_tagline_media,$var_keterangan_media,$var_tanggal_rilis_media,$var_tanggal_delete_media,$var_status_kategori_media,$var_status_konten_media,$var_status_publish_media,$var_status_delete_media,$var_informasi_media_satu,$var_informasi_media_dua){ 
	$sql="UPDATE tb_media SE
	$connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);T id_kategori = '" .mysqli_real_escape_string($connection, trim($var_id_kategori)). "', id_identifikasi = '" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "', nama_media = '" .mysqli_real_escape_string($connection, trim($var_nama_media)). "', foto_media = '" .mysqli_real_escape_string($connection, trim($var_foto_media)). "', alt_media = '" .mysqli_real_escape_string($connection, trim($var_alt_media)). "', tagline_media = '" .mysqli_real_escape_string($connection, trim($var_tagline_media)). "', keterangan_media = '" .mysqli_real_escape_string($connection, trim($var_keterangan_media)). "', tanggal_rilis_media = '" .mysqli_real_escape_string($connection, trim($var_tanggal_rilis_media)). "', tanggal_delete_media = '" .mysqli_real_escape_string($connection, trim($var_tanggal_delete_media)). "', status_kategori_media = '" .mysqli_real_escape_string($connection, trim($var_status_kategori_media)). "', status_konten_media = '" .mysqli_real_escape_string($connection, trim($var_status_konten_media)). "', status_publish_media = '" .mysqli_real_escape_string($connection, trim($var_status_publish_media)). "', status_delete_media = '" .mysqli_real_escape_string($connection, trim($var_status_delete_media)). "', informasi_media_satu = '" .mysqli_real_escape_string($connection, trim($var_informasi_media_satu)). "', informasi_media_dua = '" .mysqli_real_escape_string($connection, trim($var_informasi_media_dua)). "' WHERE id_media = '" .mysqli_real_escape_string($connection, trim($var_id_media)). "' LIMIT 1";
		//echo "sql :".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_media=1; } else { $returnUpdate_tb_media=0; }
	return $returnUpdate_tb_media;
}

?><?

function select_tb_kategori(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_kategori" ;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_kategori_by_id_kategori($var_id_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_kategori WHERE id_kategori = '" .mysqli_real_escape_string($connection, trim($var_id_kategori)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_kategori_by_id_identifikasi($var_id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_kategori WHERE id_identifikasi = '" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_kategori_by_nama_kategori($var_nama_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_kategori WHERE nama_kategori = '" .mysqli_real_escape_string($connection, trim($var_nama_kategori)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_kategori_by_keterangan_kategori($var_keterangan_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_kategori WHERE keterangan_kategori = '" .mysqli_real_escape_string($connection, trim($var_keterangan_kategori)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_kategori_by_tanggal_rilis_kategori($var_tanggal_rilis_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_kategori WHERE tanggal_rilis_kategori = '" .mysqli_real_escape_string($connection, trim($var_tanggal_rilis_kategori)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_kategori_by_tanggal_delete_kategori($var_tanggal_delete_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_kategori WHERE tanggal_delete_kategori = '" .mysqli_real_escape_string($connection, trim($var_tanggal_delete_kategori)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_kategori_by_status_publish_kategori($var_status_publish_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_kategori WHERE status_publish_kategori = '" .mysqli_real_escape_string($connection, trim($var_status_publish_kategori)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_kategori_by_status_delete_kategori($var_status_delete_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_kategori WHERE status_delete_kategori = '" .mysqli_real_escape_string($connection, trim($var_status_delete_kategori)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}


function delete_tb_kategori_by_id_kategori($var_id_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="DELETE FROM tb_kategori WHERE id_kategori = " .mysqli_real_escape_string($connection, trim($var_id_kategori)). " LIMIT 1";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnDetete_tb_kategori=1; } else { $returnDetete_tb_kategori=0; }
	return $returnDetete_tb_kategori;
}

function insert_tb_kategori($var_id_identifikasi,$var_nama_kategori,$var_keterangan_kategori,$var_tanggal_rilis_kategori,$var_tanggal_delete_kategori,$var_status_publish_kategori,$var_status_delete_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="INSERT INTO tb_kategori (id_kategori,id_identifikasi,nama_kategori,keterangan_kategori,tanggal_rilis_kategori,tanggal_delete_kategori,status_publish_kategori,status_delete_kategori) VALUES (NULL,'" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "','" .mysqli_real_escape_string($connection, trim($var_nama_kategori)). "','" .mysqli_real_escape_string($connection, trim($var_keterangan_kategori)). "','" .mysqli_real_escape_string($connection, trim($var_tanggal_rilis_kategori)). "','" .mysqli_real_escape_string($connection, trim($var_tanggal_delete_kategori)). "','" .mysqli_real_escape_string($connection, trim($var_status_publish_kategori)). "','" .mysqli_real_escape_string($connection, trim($var_status_delete_kategori)). "')";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnInsert_tb_kategori=1; } else { $returnInsert_tb_kategori=0; }
	return $returnInsert_tb_kategori;
}

function update_tb_kategori($var_id_kategori,$var_id_identifikasi,$var_nama_kategori,$var_keterangan_kategori,$var_tanggal_rilis_kategori,$var_tanggal_delete_kategori,$var_status_publish_kategori,$var_status_delete_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="UPDATE tb_kategori SET id_identifikasi = '" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "', nama_kategori = '" .mysqli_real_escape_string($connection, trim($var_nama_kategori)). "', keterangan_kategori = '" .mysqli_real_escape_string($connection, trim($var_keterangan_kategori)). "', tanggal_rilis_kategori = '" .mysqli_real_escape_string($connection, trim($var_tanggal_rilis_kategori)). "', tanggal_delete_kategori = '" .mysqli_real_escape_string($connection, trim($var_tanggal_delete_kategori)). "', status_publish_kategori = '" .mysqli_real_escape_string($connection, trim($var_status_publish_kategori)). "', status_delete_kategori = '" .mysqli_real_escape_string($connection, trim($var_status_delete_kategori)). "' WHERE id_kategori = '" .mysqli_real_escape_string($connection, trim($var_id_kategori)). "' LIMIT 1";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_kategori=1; } else { $returnUpdate_tb_kategori=0; }
	return $returnUpdate_tb_kategori;
}

?><?

function select_tb_foto(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto" ;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_id_foto($var_id_foto){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE id_foto = '" .mysqli_real_escape_string($connection, trim($var_id_foto)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_id_kategori($var_id_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE id_kategori = '" .mysqli_real_escape_string($connection, trim($var_id_kategori)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_id_identifikasi($var_id_identifikasi){ 
	$sql="SELECT * FROM 
	$connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);tb_foto WHERE id_identifikasi = '" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "'  ";
	//echo "SQL :".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_jenis_konten_foto($var_jenis_konten_foto){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE jenis_konten_foto = '" .mysqli_real_escape_string($connection, trim($var_jenis_konten_foto)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_nama_foto($var_nama_foto){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE nama_foto = '" .mysqli_real_escape_string($connection, trim($var_nama_foto)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_alt_foto($var_alt_foto){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE alt_foto = '" .mysqli_real_escape_string($connection, trim($var_alt_foto)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_konten_foto($var_konten_foto){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE konten_foto = '" .mysqli_real_escape_string($connection, trim($var_konten_foto)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_isi_foto($var_isi_foto){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE isi_foto = '" .mysqli_real_escape_string($connection, trim($var_isi_foto)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_no_identifikasi($var_no_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE no_identifikasi = '" .mysqli_real_escape_string($connection, trim($var_no_identifikasi)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_tanggal_rilis_foto($var_tanggal_rilis_foto){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE tanggal_rilis_foto = '" .mysqli_real_escape_string($connection, trim($var_tanggal_rilis_foto)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_tanggal_delete_foto($var_tanggal_delete_foto){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE tanggal_delete_foto = '" .mysqli_real_escape_string($connection, trim($var_tanggal_delete_foto)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_status_publish_foto($var_status_publish_foto){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE status_publish_foto = '" .mysqli_real_escape_string($connection, trim($var_status_publish_foto)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_status_delete_foto($var_status_delete_foto){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE status_delete_foto = '" .mysqli_real_escape_string($connection, trim($var_status_delete_foto)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_informasi_foto_satu($var_informasi_foto_satu){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE informasi_foto_satu = '" .mysqli_real_escape_string($connection, trim($var_informasi_foto_satu)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_informasi_foto_dua($var_informasi_foto_dua){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE informasi_foto_dua = '" .mysqli_real_escape_string($connection, trim($var_informasi_foto_dua)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}


function delete_tb_foto_by_id_kategori($var_id_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="DELETE FROM tb_foto WHERE id_kategori = " .mysqli_real_escape_string($connection, trim($var_id_kategori)). " LIMIT 1";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnDetete_tb_foto=1; } else { $returnDetete_tb_foto=0; }
	return $returnDetete_tb_foto;
}

function insert_tb_foto($var_id_kategori,$var_id_identifikasi,$var_jenis_konten_foto,$var_nama_foto,$var_alt_foto,$var_konten_foto,$var_isi_foto,$var_no_identifikasi,$var_tanggal_rilis_foto,$var_tanggal_delete_foto,$var_status_publish_foto,$var_status_delete_foto,$var_informasi_foto_satu,$var_informasi_foto_dua){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="INSERT INTO tb_foto (id_foto,id_kategori,id_identifikasi,jenis_konten_foto,nama_foto,alt_foto,konten_foto,isi_foto,no_identifikasi,tanggal_rilis_foto,tanggal_delete_foto,status_publish_foto,status_delete_foto,informasi_foto_satu,informasi_foto_dua) VALUES (NULL,'" .mysqli_real_escape_string($connection, trim($var_id_kategori)). "','" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "','" .mysqli_real_escape_string($connection, trim($var_jenis_konten_foto)). "','" .mysqli_real_escape_string($connection, trim($var_nama_foto)). "','" .mysqli_real_escape_string($connection, trim($var_alt_foto)). "','" .mysqli_real_escape_string($connection, trim($var_konten_foto)). "','" .mysqli_real_escape_string($connection, trim($var_isi_foto)). "','" .mysqli_real_escape_string($connection, trim($var_no_identifikasi)). "','" .mysqli_real_escape_string($connection, trim($var_tanggal_rilis_foto)). "','" .mysqli_real_escape_string($connection, trim($var_tanggal_delete_foto)). "','" .mysqli_real_escape_string($connection, trim($var_status_publish_foto)). "','" .mysqli_real_escape_string($connection, trim($var_status_delete_foto)). "','" .mysqli_real_escape_string($connection, trim($var_informasi_foto_satu)). "','" .mysqli_real_escape_string($connection, trim($var_informasi_foto_dua)). "')";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnInsert_tb_foto=1; } else { $returnInsert_tb_foto=0; }
	return $returnInsert_tb_foto;
}

function update_tb_foto($var_id_foto,$var_id_kategori,$var_id_identifikasi,$var_jenis_konten_foto,$var_nama_foto,$var_alt_foto,$var_konten_foto,$var_isi_foto,$var_no_identifikasi,$var_tanggal_rilis_foto,$var_tanggal_delete_foto,$var_status_publish_foto,$var_status_delete_foto,$var_informasi_foto_satu,$var_informasi_foto_dua){ 
	$sql="UPDATE tb_foto
	$connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);SET id_kategori = '" .mysqli_real_escape_string($connection, trim($var_id_kategori)). "', id_identifikasi = '" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "', jenis_konten_foto = '" .mysqli_real_escape_string($connection, trim($var_jenis_konten_foto)). "', nama_foto = '" .mysqli_real_escape_string($connection, trim($var_nama_foto)). "', alt_foto = '" .mysqli_real_escape_string($connection, trim($var_alt_foto)). "', konten_foto = '" .mysqli_real_escape_string($connection, trim($var_konten_foto)). "', isi_foto = '" .mysqli_real_escape_string($connection, trim($var_isi_foto)). "', no_identifikasi = '" .mysqli_real_escape_string($connection, trim($var_no_identifikasi)). "', tanggal_rilis_foto = '" .mysqli_real_escape_string($connection, trim($var_tanggal_rilis_foto)). "', tanggal_delete_foto = '" .mysqli_real_escape_string($connection, trim($var_tanggal_delete_foto)). "', status_publish_foto = '" .mysqli_real_escape_string($connection, trim($var_status_publish_foto)). "', status_delete_foto = '" .mysqli_real_escape_string($connection, trim($var_status_delete_foto)). "', informasi_foto_satu = '" .mysqli_real_escape_string($connection, trim($var_informasi_foto_satu)). "', informasi_foto_dua = '" .mysqli_real_escape_string($connection, trim($var_informasi_foto_dua)). "' WHERE id_foto = '" .mysqli_real_escape_string($connection, trim($var_id_foto)). "' LIMIT 1";
	//echo "sql :".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_foto=1; } else { $returnUpdate_tb_foto=0; }
	return $returnUpdate_tb_foto;
}

?><?
//digunakan untuk mengubah status sosial media dari publish menjadi unpublish dan sebaliknya
function update_status_publish_sosialmedia($var_id_sosialmedia,$var_status_sosialmedia){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="UPDATE tb_sosial_media SET status_publish_sosialmedia = '" .mysqli_real_escape_string($connection, trim($var_status_sosialmedia)). "' WHERE id_sosialmedia = '" .mysqli_real_escape_string($connection, trim($var_id_sosialmedia)). "' AND id_perusahaan = 1 LIMIT 1";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_sosialmedia=1; } else { $returnUpdate_tb_sosialmedia=0; }
	return $returnUpdate_tb_sosialmedia;
}

//digunakan untuk mengubah status sosial media ke mode delete
function update_status_delete_sosialmedia($var_id_sosialmedia,$var_status_sosialmedia,$var_tanggal_delete_sosialmedia){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="UPDATE tb_sosial_media SET status_delete_sosialmedia = '" .mysqli_real_escape_string($connection, trim($var_status_sosialmedia)). "', tanggal_delete_sosialmedia = '" .mysqli_real_escape_string($connection, trim($var_tanggal_delete_sosialmedia)). "' WHERE id_sosialmedia = '" .mysqli_real_escape_string($connection, trim($var_id_sosialmedia)). "' AND id_perusahaan = 1 LIMIT 1";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_sosialmedia=1; } else { $returnUpdate_tb_sosialmedia=0; }
	return $returnUpdate_tb_sosialmedia;
}

//digunakan untuk mengubah status user ke delete
function update_status_delete_tb_user($var_id_user,$var_status_publish_user,$var_tanggal_delete_user){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="UPDATE tb_user SET status_delete_user = '" .mysqli_real_escape_string($connection, trim($var_status_publish_user)). "', tanggal_delete_user = '" .mysqli_real_escape_string($connection, trim($var_tanggal_delete_user)). "' WHERE id_user = '" .mysqli_real_escape_string($connection, trim($var_id_user)). "' LIMIT 1";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_user=1; } else { $returnUpdate_tb_user=0; }
	return $returnUpdate_tb_user;
}

//digunakan untuk menambah field kontak pada frontend
function insert_tb_kontak_tambahan($var_nama_pengunjung,$var_email_pengunjung,$var_isi_pengunjung,$var_ip_pengunjung,$var_status_replay_pengunjung,$var_status_publish_kontak,$var_status_delete_kontak){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="INSERT INTO tb_kontak (id_kontak,nama_pengunjung,email_pengunjung,isi_pengunjung,ip_pengunjung,status_replay_kontak,status_publish_kontak,status_delete_kontak) VALUES (NULL,'" .mysqli_real_escape_string($connection, trim($var_nama_pengunjung)). "','" .mysqli_real_escape_string($connection, trim($var_email_pengunjung)). "','" .mysqli_real_escape_string($connection, trim($var_isi_pengunjung)). "','" .mysqli_real_escape_string($connection, trim($var_ip_pengunjung)). "','" .mysqli_real_escape_string($connection, trim($var_status_replay_pengunjung)). "','" .mysqli_real_escape_string($connection, trim($var_status_publish_kontak)). "','" .mysqli_real_escape_string($connection, trim($var_status_delete_kontak)). "')";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnInsert_tb_kontak=1; } else { $returnInsert_tb_kontak=0; }
	return $returnInsert_tb_kontak;
}

//digunakan sebagai view sosial media pada bagian frontend  dengan status publish 1 dan status delete 0
function select_tb_sosial_media_publish(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_sosial_media WHERE status_publish_sosialmedia = 1 AND status_delete_sosialmedia = 0" ;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_kategori_by_id_identifikasi_not_hidden($identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT *  FROM tb_kategori WHERE id_identifikasi =  '".$identifikasi."' AND status_delete_kategori = 0";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_work_not_hidden(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT *  FROM tb_work WHERE status_delete_work = 0";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}


function update_upblish_kategori($status,$id_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql=" UPDATE tb_kategori SET status_publish_kategori ='".$status."'  WHERE id_kategori =  '".$id_kategori."'  ";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_media=1; } else { $returnUpdate_tb_media=0; }
	return $returnUpdate_tb_media;

}

function hidden_kategori_work($id_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql=" UPDATE tb_kategori SET status_delete_kategori = '1' WHERE id_kategori = '".$id_kategori."' ";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_media=1; } else { $returnUpdate_tb_media=0; }
	return $returnUpdate_tb_media;

}

function hidden_kategori_client($id_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql=" UPDATE tb_kategori SET status_delete_kategori = '1' WHERE id_kategori = '".$id_kategori."' ";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_media=1; } else { $returnUpdate_tb_media=0; }
	return $returnUpdate_tb_media;
}

// function get_foto_profile_klien(){ 
$connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
// 	$sql="SELECT id_client FROM tb_client order by id_client  Desc limit 1 ";
// 	$resultQuery=mysqli_query($connection, $sql);
// 	while ($rows=mysqli_fetch_row($resultQuery)){ 
// 		$data[] = $rows;
// 	}
// 	return $data;
// }

function get_foto_profile_work($id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT konten_foto  FROM tb_foto WHERE  id_kategori = 1 AND id_identifikasi =  '".$id_identifikasi."' AND no_identifikasi = 1 ";	
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function get_id_work_terakhir(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT id_work FROM tb_work order by id_work  Desc limit 1 ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function update_upblish_work($status,$id_work){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql=" UPDATE tb_work SET status_publish_work ='".$status."'  WHERE id_work =  '".$id_work."'  ";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_media=1; } else { $returnUpdate_tb_media=0; }
	return $returnUpdate_tb_media;

}

function get_no_identifikasi_foto_work($id_work){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE id_kategori = 1 AND id_identifikasi = '".$id_work."' order by id_foto Desc limit 1";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function get_foto_profile_work_by_id($id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT *  FROM tb_foto WHERE id_kategori = 1 AND id_identifikasi = '".$id_identifikasi."' AND no_identifikasi = 1 ";	
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function get_foto_profile_background_by_id($id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT *  FROM tb_foto WHERE id_kategori = 1 AND id_identifikasi = '".$id_identifikasi."' AND no_identifikasi = 2 ";	
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function get_foto_profile_konten_by_id($id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT *  FROM tb_foto WHERE id_kategori = 1 AND id_identifikasi = '".$id_identifikasi."' AND no_identifikasi = 3   ";	
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function update_upblish_foto_konten_work($status,$id_foto){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql=" UPDATE tb_foto SET status_publish_foto ='".$status."'  WHERE id_foto =  '".$id_foto."'  ";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_media=1; } else { $returnUpdate_tb_media=0; }
	return $returnUpdate_tb_media;

}

function hidden_work($id_work){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql=" UPDATE tb_work SET status_delete_work = '1' WHERE id_work = '".$id_work."' ";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_media=1; } else { $returnUpdate_tb_media=0; }
	return $returnUpdate_tb_media;

}

function hidden_media_slider($id_work){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql=" UPDATE tb_media SET status_delete_media = '0' WHERE id_media = '".$id_work."' ";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_media=1; } else { $returnUpdate_tb_media=0; }
	return $returnUpdate_tb_media;

}

function select_tb_media_by_status_kategori_media_view_frontend($var_status_kategori_media){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE status_kategori_media = '" .mysqli_real_escape_string($connection, trim($var_status_kategori_media)). "' AND status_delete_media = '1' ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_klien_not_hidden(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT *  FROM tb_client WHERE status_delete_client = 0";
	///echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function get_foto_profile_klien($id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT konten_foto  FROM tb_foto WHERE id_kategori = 2 AND  id_identifikasi =  '".$id_identifikasi."' AND no_identifikasi = 1 ";	
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function get_id_client_terakhir(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT id_client FROM tb_client order by id_client  Desc limit 1 ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function update_upblish_klien($status,$id_client){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql=" UPDATE tb_client SET status_publish_client ='".$status."'  WHERE id_client =  '".$id_client."'  ";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_media=1; } else { $returnUpdate_tb_media=0; }
	return $returnUpdate_tb_media;

}

function get_no_identifikasi_foto_klien($id_client){ 
	$connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);    
	$sql="SELECT *  FROM tb_foto WHERE id_kategori = 2 AND id_identifikasi = '".$id_client."' order by id_foto Desc limit 1";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function get_foto_profile_client_by_id($id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT *  FROM tb_foto WHERE id_kategori = 2 AND  id_identifikasi = '".$id_identifikasi."' AND no_identifikasi = 1 ";	
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function get_foto_profile_client_background_by_id($id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT *  FROM tb_foto WHERE id_kategori = 2 AND id_identifikasi = '".$id_identifikasi."' AND no_identifikasi = 2 ";	
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function get_foto_profile_client_konten_by_id($id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT *  FROM tb_foto WHERE id_kategori = 2 AND id_identifikasi = '".$id_identifikasi."' AND no_identifikasi = 3   ";	
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function hidden_client($id_client){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql=" UPDATE tb_client SET status_delete_client = '1' WHERE id_client = '".$id_client."' ";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_media=1; } else { $returnUpdate_tb_media=0; }
	return $returnUpdate_tb_media;

}

function select_tb_kategori_client_status_publish(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_kategori WHERE id_identifikasi = 2 AND status_publish_kategori =1 AND status_delete_kategori = 0" ;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}


//******************FRONTEND*********************************\\
//digunakan untuk mengambil foto pada kategori client
function select_tb_foto_by_id_identifikasi_no_identifikasi_1($var_id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE id_identifikasi = '" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "' AND no_identifikasi = 1";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_id_identifikasi_no_identifikasi_1_publish($var_id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE id_identifikasi = '" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "' AND no_identifikasi = 1 AND status_publish_foto = 1 AND status_delete_foto = 0 AND id_kategori = 2";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}
function select_tb_client_by_id_kategori_publish($var_id_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_client WHERE id_kategori = '" .mysqli_real_escape_string($connection, trim($var_id_kategori)). "' AND status_publish_client = 1 AND status_delete_client = 0 GROUP BY id_client DESC";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_kategori_show_client(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_kategori WHERE id_identifikasi = 2 AND status_publish_kategori = 1 AND status_delete_kategori = 0" ;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_client_by_id_kategori_show_client($var_id_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_client WHERE id_kategori = '" .mysqli_real_escape_string($connection, trim($var_id_kategori)). "' AND status_publish_client = 1 AND status_delete_client = 0";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_id_identifikasi_no_identifikasi_3($var_id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE id_kategori = 2 AND id_identifikasi = '" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "' AND no_identifikasi = 3 AND status_publish_foto = 1 AND status_delete_foto = 0";
	//echo "SQL :".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_id_identifikasi_no_identifikasi_3_work($var_id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE id_kategori = 1 AND id_identifikasi = '" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "' AND no_identifikasi = 3 AND status_publish_foto = 1 AND status_delete_foto = 0";
	//echo "SQL :".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_id_identifikasi_no_identifikasi_2($var_id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE id_identifikasi = '" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "' AND no_identifikasi = 2 AND status_publish_foto = 1 AND status_delete_foto = 0 and id_kategori = 2";
	//echo "SQL :".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_id_identifikasi_no_identifikasi_2_work($var_id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE id_identifikasi = '" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "' AND no_identifikasi = 2 AND status_publish_foto = 1 AND status_delete_foto = 0 and id_kategori = 1";
	//echo "SQL :".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_kategori_by_id_kategori_publish($var_id_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_kategori WHERE id_kategori = '" .mysqli_real_escape_string($connection, trim($var_id_kategori)). "' AND status_publish_kategori = 1 AND status_delete_kategori = 0";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_kategori_work_status_publish(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_kategori WHERE id_identifikasi = 1 AND status_publish_kategori =1
AND status_delete_kategori = 0" ;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_work_by_id_kategori_publish($var_id_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_work WHERE id_kategori = '" .mysqli_real_escape_string($connection, trim($var_id_kategori)). "' AND status_publish_work = 1 AND status_delete_work = 0 GROUP BY id_work DESC";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_work_by_id_kategori_show_work($var_id_kategori){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_work WHERE id_kategori = '" .mysqli_real_escape_string($connection, trim($var_id_kategori)). "' AND status_publish_work = 1 AND status_delete_work = 0 ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

//dashboard
function get_all_komentar(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT *  FROM tb_kontak WHERE status_delete_kontak = 0";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function get_komentar_belum_dibalas(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT *  FROM tb_kontak WHERE status_replay_kontak = 0 and  status_delete_kontak= 0";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}


function get_pengunjung_hari_ini($tgl)
{
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT *  FROM info WHERE datetime LIKE '%".$tgl."%'";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function get_pengunjung_all()
{
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT ip_address FROM info group by ip_address";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_client_all_show(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_client WHERE status_publish_client = 1 AND status_delete_client = 0" ;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_work_all_show(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_work WHERE status_publish_work = 1 AND status_delete_work = 0" ;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

//login admin

function cek_admin($var_email,$var_password){
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql = "select * from tb_user where email_user = '".mysqli_real_escape_string($connection, trim($var_email))."' and password_user ='".mysqli_real_escape_string($connection, trim($var_password))."' ";
	//echo "sql".$sql;
	$result_login=mysqli_query($connection, $sql);
    	while($row=mysqli_fetch_row($result_login)){
            $data_login[] = $row;
        }        
        return $data_login;
}


function cek_email_lebih_dari_dua($email){
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT email_user FROM tb_user WHERE email_user LIKE '%".mysqli_real_escape_string($connection, trim($email))."%' ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function change_password($id_user,$password_baru){
	$connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="UPDATE tb_user SET password_user = '".$password_baru."' WHERE id_user =".$id_user." LIMIT 1 ";
	//echo $sql;
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_change_password=1; } else { $returnUpdate_change_password=0; }
	return $returnUpdate_change_password;
}

function cek_user($var_email,$var_password){
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql = "select * from tb_user where email_user = '".mysqli_real_escape_string($connection, trim($var_email))."' and password_user ='".mysqli_real_escape_string($connection, trim($var_password))."' ";
	//echo "sql".$sql;
	$result_login=mysqli_query($connection, $sql);
    	while($row=mysqli_fetch_row($result_login)){
            $data_login[] = $row;
        }        
        return $data_login;
}

function update_tanggal_log_history_login($tanggal,$id_log_history){
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="UPDATE tb_log_history SET tanggal_rilis_history ='".$tanggal."' WHERE id_log_history =".$id_log_history." ";	
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tanggal_log_history=1; } else { $returnUpdate_tanggal_log_history=0; }
	return $returnUpdate_tanggal_log_history;
}

function update_tanggal_log_history_logout($tanggal,$id_log_history){
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="UPDATE tb_log_history SET tanggal_delete_history ='".$tanggal."' WHERE id_log_history =".$id_log_history." ";	
	//echo "sql u".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tanggal_log_history=1; } else { $returnUpdate_tanggal_log_history=0; }
	return $returnUpdate_tanggal_log_history;
}

function cek_user_logout($id_log_history){
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql = "SELECT *  FROM tb_log_history WHERE  id_identifikasi_kategori = 2  AND id_user = ".$id_log_history." ";
	//echo "sql ck".$sql;
	$result_login=mysqli_query($connection, $sql);
    	while($row=mysqli_fetch_row($result_login)){
            $data_login[] = $row;
        }        
        return $data_login;
}


function project_terbanyak_limit_5()
{
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT *  FROM hits WHERE page LIKE '%projectdetail/%' order by count desc limit 5";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
} 

function klien_terbanyak_limit_5()
{
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT *  FROM hits WHERE page LIKE '%kliendetail/%' order by count desc limit 5";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_id_identifikasi_thumbnail_publish_work($var_id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE id_identifikasi = '" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "' AND id_kategori = 1 AND status_publish_foto = 1 AND status_delete_foto = 0 AND no_identifikasi = 1 ";
	//echo "SQL :".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function select_tb_foto_by_id_identifikasi_thumbnail_publish_klien($var_id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE id_identifikasi = '" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "' AND id_kategori = 2 AND status_publish_foto = 1 AND status_delete_foto = 0 AND no_identifikasi = 1 ";
	//echo "SQL :".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}
function update_pesan_sudah_dibaca($id_kontak){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql=" UPDATE tb_kontak SET status_replay_kontak = 1  WHERE id_kontak =  '".$id_kontak."'  ";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_media=1; } else { $returnUpdate_tb_media=0; }
	return $returnUpdate_tb_media;

}

function select_tb_foto_by_id_identifikasi_thumbnail_publish_client($var_id_identifikasi){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_foto WHERE id_identifikasi = '" .mysqli_real_escape_string($connection, trim($var_id_identifikasi)). "' AND id_kategori = 2 AND status_publish_foto = 1 AND status_delete_foto = 0 AND no_identifikasi = 1 ";
	//echo "SQL :".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

function update_upblish_foto_konten_client($status,$id_foto){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql=" UPDATE tb_foto SET status_publish_foto ='".$status."'  WHERE id_foto =  '".$id_foto."'  ";
	//echo "sql".$sql;
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_media=1; } else { $returnUpdate_tb_media=0; }
	return $returnUpdate_tb_media;

}


function select_tb_media_by_id_kategori_tampil_frontend($var_id_kategori){
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_media WHERE id_kategori = '" .mysqli_real_escape_string($connection, trim($var_id_kategori)). "' AND status_publish_media = '1' AND status_delete_media = '1' ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

?>