Created
April 17, 2016 11:53
-
-
Save MahbbRah/45c25c76eb4f6b7f3a45de69b1d72f4a to your computer and use it in GitHub Desktop.
Check this
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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