Success: A proper connection to MySQL was made! The my_db database is great.
Success: A proper connection to MySQL was made! The my_db database is great.
<?

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_client(){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="SELECT * FROM tb_client" ;
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

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

function select_tb_client_by_id_kategori($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)). "'  ";
	$resultQuery=mysqli_query($connection, $sql);
	while ($rows=mysqli_fetch_row($resultQuery)){ 
		$data[] = $rows;
	}
	return $data;
}

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

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

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

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

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

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

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

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

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

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

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



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

function insert_tb_client($var_id_kategori,$var_nama_client,$var_profile_client,$var_alamat_client,$var_no_telepon_client,$var_email_client,$var_tanggal_rilis_client,$var_tanggal_delete_client,$var_status_publish_client,$var_status_delete_client,$var_informasi_client_satu,$var_informasi_client_dua){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="INSERT INTO tb_client (id_client,id_kategori,nama_client,profile_client,alamat_client,no_telepon_client,email_client,tanggal_rilis_client,tanggal_delete_client,status_publish_client,status_delete_client,informasi_client_satu,informasi_client_dua) VALUES (NULL,'" .mysqli_real_escape_string($connection, trim($var_id_kategori)). "','" .mysqli_real_escape_string($connection, trim($var_nama_client)). "','" .mysqli_real_escape_string($connection, trim($var_profile_client)). "','" .mysqli_real_escape_string($connection, trim($var_alamat_client)). "','" .mysqli_real_escape_string($connection, trim($var_no_telepon_client)). "','" .mysqli_real_escape_string($connection, trim($var_email_client)). "','" .mysqli_real_escape_string($connection, trim($var_tanggal_rilis_client)). "','" .mysqli_real_escape_string($connection, trim($var_tanggal_delete_client)). "','" .mysqli_real_escape_string($connection, trim($var_status_publish_client)). "','" .mysqli_real_escape_string($connection, trim($var_status_delete_client)). "','" .mysqli_real_escape_string($connection, trim($var_informasi_client_satu)). "','" .mysqli_real_escape_string($connection, trim($var_informasi_client_dua)). "')";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnInsert_tb_client=1; } else { $returnInsert_tb_client=0; }
	return $returnInsert_tb_client;
}

function update_tb_client($var_id_client,$var_id_kategori,$var_nama_client,$var_profile_client,$var_alamat_client,$var_no_telepon_client,$var_email_client,$var_tanggal_rilis_client,$var_tanggal_delete_client,$var_status_publish_client,$var_status_delete_client,$var_informasi_client_satu,$var_informasi_client_dua){ 
    $connection = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
	$sql="UPDATE tb_client SET id_kategori = '" .mysqli_real_escape_string($connection, trim($var_id_kategori)). "', nama_client = '" .mysqli_real_escape_string($connection, trim($var_nama_client)). "', profile_client = '" .mysqli_real_escape_string($connection, trim($var_profile_client)). "', alamat_client = '" .mysqli_real_escape_string($connection, trim($var_alamat_client)). "', no_telepon_client = '" .mysqli_real_escape_string($connection, trim($var_no_telepon_client)). "', email_client = '" .mysqli_real_escape_string($connection, trim($var_email_client)). "', tanggal_rilis_client = '" .mysqli_real_escape_string($connection, trim($var_tanggal_rilis_client)). "', tanggal_delete_client = '" .mysqli_real_escape_string($connection, trim($var_tanggal_delete_client)). "', status_publish_client = '" .mysqli_real_escape_string($connection, trim($var_status_publish_client)). "', status_delete_client = '" .mysqli_real_escape_string($connection, trim($var_status_delete_client)). "', informasi_client_satu = '" .mysqli_real_escape_string($connection, trim($var_informasi_client_satu)). "', informasi_client_dua = '" .mysqli_real_escape_string($connection, trim($var_informasi_client_dua)). "' WHERE id_client = '" .mysqli_real_escape_string($connection, trim($var_id_client)). "' LIMIT 1";
	$resultQuery=mysqli_query($connection, $sql);
	if($resultQuery){ $returnUpdate_tb_client=1; } else { $returnUpdate_tb_client=0; }
	return $returnUpdate_tb_client;
}

?><?
//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;
}

?>