Skip to content

Instantly share code, notes, and snippets.

@MahbbRah
Created April 17, 2016 11:53
Show Gist options
  • Save MahbbRah/45c25c76eb4f6b7f3a45de69b1d72f4a to your computer and use it in GitHub Desktop.
Save MahbbRah/45c25c76eb4f6b7f3a45de69b1d72f4a to your computer and use it in GitHub Desktop.
Check this
<?php foreach ($result as $row) {
$value1 = strpos($row['c_main_title'], $searchValue) !== FALSE;
$value2 = strpos($row['c_main_body'], $searchValue) !== FALSE;
$value3 = strpos($row['cmt_dept_title'], $searchValue) !== FALSE;
$value4 = strpos($row['cmt_dept_body'], $searchValue) !== FALSE;
$value5 = strpos($row['aidt_dept_title'], $searchValue) !== FALSE;
$value6 = strpos($row['aidt_dept_body'], $searchValue) !== FALSE;
$value7 = strpos($row['food_dept_title'], $searchValue) !== FALSE;
$value8 = strpos($row['food_dept_body'], $searchValue) !== FALSE;
$value9 = strpos($row['rac_dept_title'], $searchValue) !== FALSE;
$value10 = strpos($row['rac_dept_body'], $searchValue) !== FALSE;
$value11 = strpos($row['p_message_title'], $searchValue) !== FALSE;
$value12 = strpos($row['p_message_body'], $searchValue) !== FALSE;
$value13 = strpos($row['vp_message_title'], $searchValue) !== FALSE;
$value14 = strpos($row['vp_message_body'], $searchValue) !== FALSE;
$value15 = strpos($row['about_college_title'], $searchValue) !== FALSE;
$value16 = strpos($row['about_college_body'], $searchValue) !== FALSE;
$value17 = strpos($row['mission_message'], $searchValue) !== FALSE;
$value18 = strpos($row['vision_message'], $searchValue) !== FALSE;
if ( $value1 || $value2) {
echo "<h2 class='all-header'>".$row['c_main_title']."</h2>";
echo "<p class='department'>".$row['c_main_body']."</p>";
}
elseif ($value3 || $value4){
echo "<h2 class='all-header'>".$row['cmt_dept_title']."</h2>";
echo "<p class='department'>".$row['cmt_dept_body']."</p>";
}
elseif ( $value5 || $value6){
echo "<h2 class='all-header'>".$row['cmt_dept_title']."</h2>";
echo "<p class='department'>".$row['cmt_dept_body']."</p>";
}
elseif ( $value7 || $value8){
echo "<h2 class='all-header'>".$row['food_dept_title']."</h2>";
echo "<p class='department'>".$row['food_dept_body']."</p>";
}
elseif ( $value9 || $value10){
echo "<h2 class='all-header'>".$row['rac_dept_title']."</h2>";
echo "<p class='department'>".$row['rac_dept_body']."</p>";
}
elseif ( $value11 || $value12){
echo "<h2 class='all-header'>".$row['p_message_title']."</h2>";
echo "<p class='department'>".$row['p_message_body']."</p>";
}
elseif ( $value13 || $value14){
echo "<h2 class='all-header'>".$row['vp_message_title']."</h2>";
echo "<p class='department'>".$row['vp_message_body']."</p>";
}
elseif ( $value15 || $value16){
echo "<h2 class='all-header'>".$row['about_college_title']."</h2>";
echo "<p class='department'>".$row['about_college_body']."</p>";
}
elseif ( $value17 || $value18){
echo "<h2 class='all-header'>".$row['mission_message']."</h2>";
echo "<p class='department'>".$row['vision_message']."</p>";
}
else { echo "<h2 class='not-found'>Your search result did not match</h2>";}
}
// and my all data are static on fields so i think i don't need to use loop for this. please tell me the efficient way for PDO db connection. ?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment