1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
|
<?php
require_once('webadmin/basic_info.php');
if(empty($_POST["keywords"])){
$message = "Please enter a keyword to search.";
echo "<script>alert('".$message."'); history.back();</script>";
exit;
}
unset($_SESSION["search_result"]);
unset($_SESSION["search_keywords"]);
$search_result = array();
$count = 0;
if(isset($_POST["type"]) && $_POST["type"] == "industry_news"){
//search news
$sql = "select * from news where (title_en like ? or desc_en like ? or short_desc_en like ? or posted_date like ?) and deleted = ? and status = ? and typeid = ?";
$parameters = array('%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', 0, 1, "INDUSTRY_NEWS");
$news_result = bind_pdo($sql, $parameters, "selectall");
foreach($news_result as $result){
$search_result[$count]["title"] = $result["title_en"];
$search_result[$count]["content"] = strip_tags($result["desc_en"]);
$search_result[$count]["link"] = "news_detail.php?id=".$result["id"];
$count++;
}
}else{
//search menu
$sql = "select * from menu where (name_en like ? or title_en like ? or desc_en like ? or short_desc1_en like ? or short_desc2_en like ? ) and deleted = ?";
$parameters = array('%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', 0);
$menu_result = bind_pdo($sql, $parameters, "selectall");
if(!empty($menu_result)){
foreach($menu_result as $result){
$link = "";
if($result["level_num"] == 1){
$link = $result["link_to"];
}else if($result["level_num"] == 2){
if($result["id"] == 7 || $result["id"] == 8 || $result["id"] == 9){
$link = $result["link_to"];
}
if($result["parent_id"] == 1){
$link = "consulting_services_detail.php?id=".$result["id"];
}
if($result["parent_id"] == 2){
$link = "training_services_detail.php?id=".$result["id"];
}
}else if($result["level_num"] == 3){
//check level 2 menu info
$sql = "select * from menu where deleted = ? and level_num = ? and id = ? order by sort ASC";
$parameters = array(0, 2, $result["parent_id"]);
$menu2_info = bind_pdo($sql, $parameters, "selectone");
if($menu2_info["parent_id"] == 1){
$link = "consulting_services_detail.php?id=".$result["id"];
}
if($menu2_info["parent_id"] == 2){
$link = "training_services_detail.php?id=".$result["id"];
}
}else{}
$search_result[$count]["title"] = $result["title_en"];
$search_result[$count]["content"] = strip_tags($result["desc_en"]);
$search_result[$count]["link"] = $link;
$count++;
}
}
//search news
$sql = "select * from news where (title_en like ? or desc_en like ? or short_desc_en like ? or posted_date like ?) and deleted = ? and status = ?";
$parameters = array('%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', 0, 1);
$news_result = bind_pdo($sql, $parameters, "selectall");
foreach($news_result as $result){
$search_result[$count]["title"] = $result["title_en"];
$search_result[$count]["content"] = strip_tags($result["desc_en"]);
$search_result[$count]["link"] = "news_detail.php?id=".$result["id"];
$count++;
}
//search course
$sql = "select * from course where (code like ? or fee like ? or `start_date` like ? or `end_date` like ? ) and deleted = ? and status = ?";
$parameters = array('%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', 0, 1);
$course_result = bind_pdo($sql, $parameters, "selectall");
foreach($course_result as $result){
$course_date = new DateTime($result["date"]);
$venue_list = "";
$selected_training_center = explode(",",$result["training_center_id"]);
foreach($selected_training_center as $selected_center){
$sql = "select * from training_center where id = ? and deleted = ?";
$parameters = array($selected_center, 0);
$training_center_info = bind_pdo($sql, $parameters, "selectone");
$venue_list .= $training_center_info["name_".$langcode]." / ";
}
$venue_list = substr_replace($venue_list, "", -3);
$search_result[$count]["title"] = $result["code"];
$search_result[$count]["content"] = "Course Code: ".$result["code"].", Date: ".$course_date->format("d M Y").", Venue: ".$venue_list.", Time: ".$result["time"].", Medium of Instruction: ".$result["medium_of_instruction_".$langcode];
$search_result[$count]["link"] = "training_services_detail.php?id=".$result["id"];
$count++;
}
//search course cate
$sql = "select * from course_category where (name_en like ? or desc1_en like ? or desc2_en like ? ) and deleted = ? and status = ?";
$parameters = array('%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', 0, 1);
$course_cate_result = bind_pdo($sql, $parameters, "selectall");
foreach($course_cate_result as $result){
$search_result[$count]["title"] = $result["name_en"];
$search_result[$count]["content"] = strip_tags($result["desc1_en"]);
$search_result[$count]["link"] = "training_services_detail.php?id=".$result["menu_id"];
$count++;
}
//search training center
/*$sql = "select * from training_course where (code like ? or name_en like ? or address like ? or tel like ? or fax like ? or email like ? or desc_en like ? ) and deleted = ? and status = ?";
$parameters = array('%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', 0, 1);
$training_center_result = bind_pdo($sql, $parameters, "selectall");*/
//search static page
$sql = "select * from static_page where (title_en like ? or desc_en like ? ) and deleted = ? and status = ? and id != ?";
$parameters = array('%' . $_POST["keywords"] . '%', '%' . $_POST["keywords"] . '%', 0, 1, 3);
$static_page_result = bind_pdo($sql, $parameters, "selectall");
foreach($course_cate_result as $result){
$search_result[$count]["title"] = $result["title_en"];
$search_result[$count]["content"] = strip_tags($result["desc_en"]);
$search_result[$count]["link"] = $result["link_to"];
$count++;
}
}
$_SESSION["search_result"] = $search_result;
$_SESSION["search_keywords"] = $_POST["keywords"];
header("Location: search_results.php");
exit;
|