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"); }