include "header.php";
?>
<?php
require_once 'DBLogic.php';
$searchStr = isset($_POST['searchStr']) ? $_POST['searchStr'] : '';
//echo "<br/>";
//echo "searchStr =" . $searchStr;
$searchData = searchKeyword($searchStr, -1);
for ($i = 0; $i < count($searchData); $i++) {
$keywordId[$i] = $searchData[$i]['keyword_id'];
$keywordName[$i] = $searchData[$i]['keyword_name'];
$type[$i] = $searchData[0]['type'];
$relatedWord[$i] = $searchData[$i]['related_word'];
$keywordInfo[$i] = $searchData[$i]['keyword_info'];
$keywordDesc[$i] = $searchData[$i]['keyword_desc'];
$keywordAppMappingData = searchKeywordAppMapping($keywordId[$i]);
}
$max_count = count($searchData);
$max_per_page = 5;
if ($max_count < $max_per_page) {
$max_per_page = $max_count;
}
$start_index = isset($_POST['startIndex']) ? $_POST['startIndex'] : 0;
$start_index = ($start_index - 1) * 5;
if ($start_index + 5 > $max_count) {
$end_index = $start_index + $max_count % 5;
} else {
$end_index = $start_index + 5;
}
?>
<table width=100% border=0>
function updateKeywordForDiagram($keywordId, $fileName)
{
$queryString = "select keyword_diagram from keywords where keyword_id = " . $keywordId;
$result = mysql_query($queryString) or die(mysql_error());
$existingDiagrams = "";
while ($row = mysql_fetch_array($result)) {
$existingDiagrams = $row['keyword_diagram'];
}
if (strpos($existingDiagrams, "Default") === false) {
$fileName = $existingDiagrams . "," . $fileName;
}
$queryString = "update `keywords` set `keyword_diagram` = '{$fileName}' where `keyword_id` = " . $keywordId;
mysql_query($queryString) or die(mysql_error());
mysql_query("commit");
$keywordAppMappingData = searchKeywordAppMapping($keywordId);
$appId = $keywordAppMappingData[0]['app_id'];
$queryString = "update `app_name` set `app_intf_diagram` = '{$fileName}' where `app_id` = " . $appId;
mysql_query($queryString) or die(mysql_error());
mysql_query("commit");
logRequest("Keyword updated id = ", $keywordId . " with new file uploaded");
}
