01.<?php
02. require_once("config.php");
03. require_once("fn_pos.php");
04.
05. $fileType = $_POST['filetype'];
06. $db = dbCon();
07. $num = 1;
08. $sql = "SELECT * FROM word_pos WHERE category='$fileType' ORDER BY word_count DESC";
09. $result=mysql_query($sql, $db);
10. if (!$result) print ($sql." could not be processed.");
11. while($table = mysql_fetch_array($result)){
12. $word = $table['word'];
13. $word_count = $table['word_count'];
14. $num_file = $table['num_file'];
15. $category = $table['category'];
16. $pos = $table['pos'];
17. $noun1=ereg("^(noun)", "$pos");
18. $noun2=ereg("(,noun)$", "$pos");
19.
20.
21.
22.
23.
24.
25.
26. if(($noun1 == 1) || ($noun2 == 1)){
27. $sql = "SELECT * FROM stopword WHERE word='$word' AND category = '$category'";
28. $result2=mysql_query($sql, $db);
29. $row = mysql_num_rows($result2);
30. if($row == 0){
31. $sql = "INSERT INTO stopword(stopword_id, word, word_count, num_file, pos, category) values('','$word','$word_count','$num_file','$pos','$category')";
32. $result3=mysql_query($sql, $db);
33. }else{
34. $sql = "UPDATE stopword SET word_count='$word_count', num_file='$num_file' WHERE word = '$word' AND category = '$fileType'";
35. $result4=mysql_query($sql, $db);
36. }
37. ?>
