include_once "./common/common.php";
include_once $ROOT_DIR."/inc/inc_header.html";
?>
include_once $ROOT_DIR."/inc/inc_top.html"; ?>
//include_once $ROOT_DIR."/inc/inc_menu.php"; ?>
$no = ifilter($_REQUEST["no"],"NUMBER");
//$search_str = ifilter($_REQUEST["search_str"],"STRING");
$sql = "SELECT a.*, b.category_name
FROM case_study a,
case_category b
WHERE a.no='$no'
AND a.category=b.no
";
$row = $db->fetch_object($sql);
$no = $row->no;
$title=$row->title;
$descrip = $row->descrip;
$mission = str_replace("\n","
",$row->mission);
$solutions = str_replace("\n","
",$row->solutions);
$theresult = str_replace("\n","
",$row->theresult);
$mission_title = $row->mission_title;
$solutions_title = $row->solutions_title;
$theresult_title = $row->theresult_title;
$category_name = $row->category_name;
$category = $row->category;
$reg_date = $row->reg_date;
$img_folder_1 = $row->img_folder_1;
$img_name_1 = $row->img_name_1;
$img_folder_2 = $row->img_folder_2;
$img_name_2 = $row->img_name_2;
$img_folder_3 = $row->img_folder_3;
$img_name_3 = $row->img_name_3;
$img_folder_4 = $row->img_folder_4;
$img_name_4 = $row->img_name_4;
$img_folder_5 = $row->img_folder_5;
$img_name_5 = $row->img_name_5;
$img_folder_6 = $row->img_folder_6;
$img_name_6 = $row->img_name_6;
$img_folder_7 = $row->img_folder_7;
$img_name_7 = $row->img_name_7;
$video_url = $row->video_url;
$attach_str = "";
if($img_name_1) $attach_str_1= '

';
/*
if($img_name_2) $attach_str_2= $img_folder_2."/".makeThumbCrop($img_name_2,$CASE_MISSION_CROP);
if($img_name_3) $attach_str_3= $img_folder_3."/".makeThumbCrop($img_name_3,$CASE_MISSION_CROP);
if($img_name_4) $attach_str_4= $img_folder_4."/".makeThumbCrop($img_name_4,$CASE_MISSION_CROP);
*/
if($img_name_2) $attach_str_2= $img_folder_2."/".$img_name_2;
if($img_name_3) $attach_str_3= $img_folder_3."/".$img_name_3;
if($img_name_4) $attach_str_4= $img_folder_4."/".$img_name_4;
if($img_name_5) $attach_str_5= '
';
if($img_name_6) $attach_str_6= '
';
if($img_name_7) $attach_str_7= '
';
if($video_url) {
$tmp_url = explode("https://www.youtube.com", $video_url);
$conv_url = "https://www.youtube.com/embed/".$tmp_url[1];
$video_str = '
';
}
?>
CATEGORIES
$sql = "SELECT *
FROM case_category
WHERE 1=1
ORDER BY no DESC
";
$result = $db->query($sql);
while($row = mysqli_fetch_object($result)) {
$c_no = $row->no;
$left_category_name=$row->category_name;
if($c_no == $category) {
$chk = "active";
$display = "block";
}else {
$chk = "";
$display = "none";
}
?>
-
$s_sql = " SELECT *
FROM case_study
WHERE category like '%".$c_no."%'
ORDER BY sort_no
";
//echo $s_sql;
$s_result = $db->query($s_sql);
while($s_row = mysqli_fetch_object($s_result)) {
$cs_no = $s_row->no;
$cs_title=$s_row->title;
if($cs_no==$no) $cs_active = "active";
else $cs_active = "";
echo '- '.$cs_title.'
';
}
?>
//echo '- '.$category_name.'
';
}
?>
if($video_str) { ?>
}else { ?>
![]()
} ?>
include_once $ROOT_DIR."/inc/inc_footer.html"; ?>