multiple file import

phpss

Hi everybody,

I'm basically trying to upload multiple files into their respective tables. I'm also trying to name the tables based on the filename minus the extension. But so far, I've been unsuccessful at getting the script to work. Any suggestions would be very helpful!
Thanks in advance.

Here is the code snippet:

$array = array ("file1.dat","file2.dat");

foreach($array as $val){

$test_table = basename($val, ".dat");
mysql_query($test_table);

$query = 'CREATE TABLE $test_table,'.
'field1 INT, '.
'field2 CHAR(20) NOT NULL, '.
'field3 CHAR(50) NOT NULL)';
mysql_query($query);

$loadsql = "LOAD DATA INFILE '$val' INTO table '$test_table' FIELDS TERMINATED BY ' ' LINES TERMINATED BY '\n' ";
mysql_query($loadsql) or die(mysql_error());
}

  if(mysql_error()) {
     echo mysql_error() ."<br>\n";
  }

PartDigital

I'm not sure I understand, are you trying to upload the content in the files to the database?

phpss

Exactly!

PartDigital

try something like this

$array = array ("file1.dat","file2.dat");
for($i=0; $i<count($array); $i++)
{
   //getting the db name
   $test_table = basename($val, ".dat");


   //creating the db table
   $query = 'CREATE TABLE `$test_table`,'.
   'field1 INT, '.
   'field2 CHAR(20) NOT NULL, '.
   'field3 CHAR(50) NOT NULL)';
    mysql_query($query);

  //uploading the content
  //note: I don't know how you want to handle the fields so I simply uploaded the content to field 2. 
   $content = file_get_contents($array[$i]); 
   $sql = "INSERT INTO `$test_table` SET field2 = '$content'"; 
   mysql_query($query);

}

bradgrafelman

Note that you should first sanitize $content with [man]mysql_real_escape_string/man before you place it in the SQL query!

phpss

I've tried the code you suggested with some changes but I keep getting a syntax error.

for($i=0; $i<count($array); $i++)
{
//getting the db name
$test_table = basename($array[$i], ".dat");
mysql_query($test_table);

//creating the db table
$query = 'CREATE TABLE $test_table,'.
'field1 INT, '.
'field2 CHAR(20) NOT NULL, '.
'field3 CHAR(50) NOT NULL)';
mysql_query($query);

//I've tried both ways with load data infile and insert into.
$loadsql = "LOAD DATA INFILE '$array[$i]' INTO table '$test_table' FIELDS TERMINATED BY ' ' LINES TERMINATED BY '\n' ";
mysql_query($loadsql);

$content = file_get_contents($val);
list($field1, $field2, $field3) = split(' ', $content);

$sql = "INSERT INTO '$test_table' VALUES field1 = $field1, field2=$field2, field3=$field3)";
mysql_query($sql);