Public feed
#532216
<?php
include("../include/session.php");
function populateKeywords(){
$time = microtime();
$f = array('\\', '\'','\"','.',',','!','?',':','(',')','*');
$r = array('\\\\', '\\\'','\\\"','','','','','','','','');
$query = mysql_query("select aid,title,summary,body from articles");
while($article = mysql_fetch_array($query)){
$exists = FALSE;
$words = array();
$words = explode(" ",$article['title']);
$words += explode(" ",$article['summary']);
$words += explode(" ",$article['body']);
for($i=0;$i<count($words);$i++){ //start for loop
if(strlen($words[$i])>3){
$word = strtolower($words[$i]);
$words = str_replace($f,$r,$words);
$query2 = mysql_query("select word from searchWords where articleIds=".(int)$article['aid']);
while($word_check = mysql_fetch_array($query2)){ //start while loop
if($word_check['word']==$word){
$exists = TRUE;
} //end check duplicates
} //end while loop
if(!$exists){ //check if exists
mysql_query("INSERT INTO searchWords VALUES (0, '".$word."',".(int)$article['aid'].")") or die(mysql_error());
}
} //end check if exists
} //end for loop
unset($words);
unset($article);
}
print "Successful!";
print microtime() - $time;
}
populateKeywords();
?>