how to insert in database....plz help..me

Discussion in 'PHP' started by madristaa, Nov 3, 2007.

0
  1. #1
    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 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&nbsp;&nbsp;:";
    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>";

    ?>
     
    madristaa, Nov 3, 2007 IP