$sql = "select nKBID,vKBTitle,tKBDesc from sptbl_kb where (vKBTitle like '%{$my_data}%') AND vStatus ='A'";
$result_kbtitle = executeSelect($sql, $conn);
if (mysql_num_rows($result_kbtitle) > 0) {
?>
<table cellpadding="0" cellspacing="0" border="0" class="">
<?php
while ($row = mysql_fetch_array($result_kbtitle)) {
$viewkbentry_seo_link = "viewuserkbsearchresult/" . stripslashes($row['vKBTitle']) . "/" . $row["nKBID"] . "/KNOWLEDGEBASE/threeminus/threeplus";
?>
<tr>
<td align="left">
<a href="<?php
echo $viewkbentry_seo_link;
?>
" class="listing"><?php
echo trimString(htmlentities($row["vKBTitle"]), 80);
?>
</a>
</td>
</tr>
<?php
}
}
}
//}
}
?>
</table>
</div>
</td></tr>
$rs = executeSelect($sql, $conn);
//Pagination
if (mysql_num_rows($rs) > 0) {
?>
<table cellpadding="5" cellspacing="1" border="0" class="" style="background-color:#cfcfcf;" width="100%">
<?php
while ($row = mysql_fetch_array($rs)) {
$viewkbentry_seo_link = SITE_URL . "viewuserkbsearchresult/" . str_replace(" ", "_", str_replace("?", "", stripslashes($row['vKBTitle']))) . "/" . $row["nKBID"] . "/KNOWLEDGEBASE/threeminus/threeplus";
?>
<tr>
<td align="left" style="background-color:#ffffff;">
<a href="<?php
echo $viewkbentry_seo_link;
?>
" class="listing"><?php
echo $row["vCatDesc"] . ' - ' . trimString(htmlentities($row["vKBTitle"]), 140);
?>
</a>
</td>
</tr>
<?php
}
?>
<tr align="left">
<td colspan="6">
<div class="pagination_container">
<div class="pagination_info">
<?php
echo $navigate[1] . " " . TEXT_OF . " " . $totalrows . " " . TEXT_RESULTS;
?>
</div>
function getReleatedResults($title, $kbid)
{
$kbkey = explode(' ', $title);
$keyCondition = "WHERE vStatus ='A' AND nKBID != '" . $kbid . "' ";
$ketCount1 = count($kbkey);
if ($ketCount1 > 0) {
$keyCondition .= " AND (vKBTitle like '%" . mysql_real_escape_string($kbkey[0]) . "%' ";
for ($kbc = 1; $kbc < $ketCount1; $kbc++) {
$keyCondition .= " OR vKBTitle like '%" . mysql_real_escape_string($kbkey[$kbc]) . "%'";
}
$keyCondition .= ")";
}
$sql = "SELECT DISTINCT kb.nKBID,kb.vKBTitle,kb.tKBDesc,c.vCatDesc from sptbl_kb kb\r\n INNER JOIN sptbl_categories c ON kb.nCatId = c.nCatId " . $keyCondition . " LIMIT 0, 10";
// $result_kbtitle = executeSelect($sql,$conn);
$result_kbtitle = mysql_query($sql);
$kbCount = mysql_num_rows($result_kbtitle);
if (mysql_num_rows($result_kbtitle) > 0) {
?>
<div class="content_section_title">
<h3><?php
echo TEXT_RELATED_RESULTS;
?>
</h3></div>
<table cellpadding="5" cellspacing="1" border="0" class="" style="background-color:#cfcfcf;" width="100%">
<div class="popular_kbs1">
<ul>
<?php
while ($row = mysql_fetch_array($result_kbtitle)) {
//echo '<pre>';print_r($row);echo '</pre>';
$seolink = str_replace(" ", "-", stripslashes($row['vKBTitle']));
$seolink = preg_replace('/[^a-zA-Z0-9__.-]/s', '', $seolink);
$seolink = strtolower($seolink);
$seolink = substr($seolink, 0, 100);
$viewkbentry_seo_link = SITE_URL . "kb/" . str_replace("?", "", $seolink) . "/" . $row["nKBID"];
?>
<li>
<a href="<?php
echo $viewkbentry_seo_link;
?>
" class="listing"><span><?php
echo $row["vCatDesc"];
?>
</span> - <?php
echo trimString(htmlentities($row["vKBTitle"]), 140);
?>
</a>
</li>
<?php
}
}
if ($kbCount > 10) {
?>
<tr>
<td align="left" style="background-color:#ffffff;">
<a href="<?php
echo $viewkbentry_seo_link;
?>
" class="listing"><?php
echo trimString(htmlentities($row["vKBTitle"]), 140);
?>
</a>
</td>
</tr>
<?php
}
?>
</ul>
</div>
</table>
<?php
}
if ($pagesnext < $pageend) {
echo "<a class='link' style='padding-right:5px' href='{$linktmp}/{$pageend}'>... {$pageend}</a>";
}
?>
</td>
</tr>
</thead>
<tfoot>
<tr id="tfoot_paging"></tr>
</tfoot>
<tbody>
<?php
foreach ($lstRaovat as $raovat) {
$alink = BASE_PATH . "/raovat/view/" . $raovat["raovat"]["id"] . "/" . $raovat["raovat"]["alias"];
$atitle = $raovat["raovat"]["tieude"];
$aintro = trimString(HTML2Text($raovat["raovat"]["noidung"]), 200);
?>
<tr>
<td align="left">
<a href="<?php
echo $alink;
?>
">
<div class="first_text" style="min-height: 60px;">
<span class="avata"><?php
echo $atitle;
?>
</span>
<div class="cat_intro" style="padding-left: 10px;color: gray;"><?php
echo $aintro;
?>
function getMagic($s, $length)
{
return trimString(strtolower(str_replace(" ", "_", trim($s))), $length);
}
if (mysql_num_rows($rs) > 0) {
while ($row = mysql_fetch_array($rs)) {
//echo '<pre>'; print_r($row); echo '</pre>';
$seolink = str_replace(" ", "-", stripslashes($row['vKBTitle']));
$seolink = preg_replace('/[^a-zA-Z0-9__.-]/s', '', $seolink);
$seolink = strtolower($seolink);
$seolink = substr($seolink, 0, 100);
$viewkbentry_seo_link = SITE_URL . "kb/" . str_replace("?", "", $seolink) . "/" . $row["nKBID"];
?>
<tr>
<td align="left">
<a href="<?php
echo $viewkbentry_seo_link;
?>
" class="listing"><?php
echo $row["vCatDesc"] . ' - ' . trimString($row["vKBTitle"], 80);
?>
</a>
</td>
</tr>
<?php
}
?>
<tr align="left">
<td colspan="6">
<div class="pagination_container">
<div class="pagination_info">
<?php
echo $navigate[1] . " " . TEXT_OF . " " . $totalrows . " " . TEXT_RESULTS;
?>
