Hello friends i have created a indexer using form. It will accept .htm and .html or actual folders. It will display all the information of the .htm and .html files i.e. metatags and it will count the occurence of the words repeating in that file.
i will be very thankful if you help me
I want you to help me those information to put in database.
The database should contain four tables
1)files containing id_file,name,url -->2 columns
2)file_word containing id_file,id_word-->2 columns
3)words containing id_word,word --->2 columns
4)meta_info containing id_fil e,type,content-->3 columns
I am attaching my code for further queries.
<?PHP
function recursive_directory($dir)
{
$arr = array();
if ($hld = opendir($dir))
{
while (false !== ($file = readdir($hld)))
{
if ($file != "." && $file != "..")
{
if (is_dir($dir. "/" . $file))
{
$arr = array_merge($arr, recursive_directory($dir. "/" . $file));
}
else
{
if((ereg(".html" , $file)) || (ereg(".htm",$file)))
{
$path = $dir . "/" . $file;
$arr[] = realpath($path);
}
}
}
}
closedir($hld);
}
return $arr;
}
function superExplode($string,$st)
{
$i=0;
$arr[$i++]= strtok($string,$st);
while($tok = strtok($st))
$arr[$i++] = $tok;
return $arr;
}
function count_word($url)
{
if($file=file($url))
{
$tags = get_meta_tags($url);
echo "<h1>Meta Information</h1> ";
if(count($tags)!=0)
{
echo "Description: ".$tags['description']."<br>";
echo "Author: ".$tags['author']."<br>";
echo "Keywords: ".$tags['keywords']."<br>";
echo "Generator: ".$tags['generator']."<br>";
}
else
{
echo "No Meta Data<br>";
}
$fetch = implode('',$file);
$fetch = strtolower(strip_tags($fetch));
$arr_tok = superExplode($fetch,"\" ' : , ( ) { } [ ] ; # ? . ! \n -");
sort($arr_tok);
$temp = (array_count_values($arr_tok));
echo"<br>";
echo "<table border='0'><tr><th>Word</th><th>Count</th></tr>";
foreach($temp as $s => $r)
{
if($s!="")
echo "<tr><td>$s</td><td>$r</td></tr>";
}
echo "</table>";
}
else
{
echo "Try Again";
}
}
if(isset($_GET['path']))
{
$path=$_GET['path'];
$array = recursive_directory($path);
for($i=0;$i<count($array);$i++)
{
echo "</br>";
echo"Path :";
echo $array[$i]."<br>";
count_word($array[$i]);
}
}
echo "<html>";
echo "<body>";
echo "<form action=\"test.php\" method=\"get\">";
echo "</br>";
echo "Path of: <input type=\"text\" name=\"path\"/>";
echo "<input type=\"submit\" value=\"Enter\"/>";
echo " </form>";
echo "</body>";
echo "</html>";
?>
Problem in inserting in database......Plz help me Plz......
Linear Mode
