Move a file's contents into mysql

nca

<?
if ($handle = opendir('../counters')) {
    while (false !== ($file = readdir($handle))) { 
        if ($file != "." && $file != "..") { 
$count="../counters/$file";
include("logininfo.txt");
mysql_connect($SERVER,$USER,$PASSWORD);
mysql_selectdb($DATABASE);
$QUERY = mysql_query("INSERT INTO countertable SET ID=$file COUNT=$count");
echo "$file has been inserted!<br>";
        } 
    }
    closedir($handle); 
}
?>

I am trying to make a script that will open a text file in a directory, then insert it's name (the id) and then the contents into a mysql database. The above script will not work. Can anyone tell me why? 😕

BTW: The counters are named like this: 0328.txt I would need the script to remove the ".txt" from the end of the file before it inserts the info.

nca

ANYONE???

suntra

Check these files... maybe will it give you some help...

Tilemachos

If you want to seperate the filename from the extension you should use eregi_replace():

$filename = eregi_replace('.txt', '', $file);

As for insert data from text files check mysqlimport command of mySQL

nca

So now I have this piece of code...
Can someone tell me why this code will not work? I have to do this through a php script, not a mysql import.

<?
if ($handle = opendir('../counters')) {
    while (false !== ($file = readdir($handle))) { 
        if ($file != "." && $file != "..") { 
$count="../counters/$file";
include("logininfo.txt");
mysql_connect($SERVER,$USER,$PASSWORD);
mysql_selectdb($DATABASE);
$filename = eregi_replace('.txt', '', $file);
$QUERY = mysql_query("INSERT INTO countertable SET ID=$filename COUNT=$count");
echo "$file has been inserted!<br>";
        } 
    }
    closedir($handle); 
}
?>

suntra

If you can use str_replace() instead of ereg*_replace(), use it !

Don't use eregi_relace(".txt", "", $string) but str_replace(".txt", "", $string).

But if you want to remove any extension, use the following :

<?
 $fch = "photo of java.lang error";		// the filename
 $lim = 5;						// the maximum length of extension
 $pnt = strrpos($fch, ".");			// finds the last point
 if((strlen($fch) - $pnt - 1) <= $lim) {		// checks if the extension is lower or egual to the limit
 	$fch =  substr($fch, 0, $lim);	// if true, removes the extension
 }
 echo $fch;				// echoes the filename
?>

nca

Ok, maybe I should have said this earlier. The problem I am having is that it will not get the contents of the file it opens.

suntra

You have to open the file with fopen and fread and then send this contents to mysql...

Example (like I sent you) :
$data = addslashes(fread(fopen($FILE, "rb"), filesize($FILE)));

Then you put your MySQL query and the contents of the file is $data.

Example :

$result=MYSQL_QUERY("INSERT INTO bin (description,bin_data,filename,filesize,filetype) ".
"VALUES ('$form_description','$data','$form_data_name','$form_data_size','$form_data_type')");

altexis

A while ago I had almost the same question... how do I put a file into a DB table.

The question is do you really want to that???
The file system is practicaly a dedicated database for files... it manages files far quicker and more efficient than any database.
Why not keeping just a file name in your database and keep the files in wisely organized directories?

nca

altexis, because recently the counter files have messed up from time to time and just reset their contents to 0. I think having them in a mysql table, they will be more reliable.