Php Fill Db3

From Fxp Wiki

Jump to: navigation, search
 
<html>
<body>
<?php
$filePathIn = "C:/p/web/www-data/Copiedejspwiki/";
$dh = opendir($filePathIn) or die("couldn't open directory");
 
#test reading file 
/*
DELETE FROM `tiki_pages` WHERE hits IS NULL;
$file = "C:/p/web/www-data/jspwiki/Accessibility.txt";
$baseName = basename($file);
$fp = fopen($file, "r");
$strFile = file_get_contents($file);
$strFile = mysql_escape_string($strFile);
*/
$version = 1;
 
    while (!(($file = readdir($dh)) === false)) {
        if (is_dir("$filePathIn/$file")) {
        }
        else {
         $fileName = "$file";
         //$filePathIn = "./Copiedejspwiki/";
         $filePathIn = "C:/p/web/www-data/Copiedejspwiki/";
         $file = "$filePathIn$file";
            if ($fp = fopen($file, "r")) {
            $count++;
            $baseName = basename($file);
            $baseName = str_replace(".txt","", $baseName);
            $strFile = file_get_contents($file);
            $strFile = mysql_escape_string($strFile);
 
 
    // process form
    
    $db = mysql_connect("localhost", "user", "pwd");
    $creator = "admin";
    mysql_select_db("vendo",$db);
    $sql = "INSERT INTO tiki_pages (pageName,hits,data,description,lastModif,comment,version,user,ip,creator) VALUES('$baseName','1','$strFile','','1094083448','','$version','admin','127.0.0.1','$creator')";
    //echo = "Query: 
    $result = mysql_query($sql);
    //$result = mysql_query($sql)or die(mysql_error());
    $err = mysql_error();
    printf("$count: $baseName...$err<br />\n");
    /*
    echo "Result: $result $err<br/>";
    echo "Thank you! Information entered.<br />\n";
    echo "File: $file<br />";
    echo "BaseName: $baseName<br />";
*/
/*
    $result = mysql_query("SELECT pageName,lastModif FROM tiki_pages",$db);
    while ($myrow = mysql_fetch_row($result)) {
    printf("$count : %s<br />\n", $myrow[1]);
        }
        */
    }
}
}?>
</body>
</html>
 
TikiWiki
Retrieved from "http://www.fxparlant.net/Php_Fill_Db3"
Personal tools