infile help plz.

Mark_Nordstrom

Ok I got this to work its been a month but finally after searching this forum for help i got it to work. What i got to work is this

<?php include(config.php); ?>
<?
$result = mysql_db_query('all-nba_net' ,"LOAD DATA LOCAL INFILE '$form_data' INTO TABLE stats FIELDS TERMINATED BY ','") or die(mysql_error()); 
?>

<form method="post" action="result.php" enctype="multipart/form-data"> 
<input type="file" name="form_data" size="40"> 
<p><input type="submit" name="submit" value="submit"> 
</form>

Ok now the file i wanna upload is attached to this post. Every file uploaded would be like that. I need help having the script convert them to csv or just upload to database like they are. The database has every field the file does. ANY Help would be nice thanks.

netmastan

How did u generated the text file ?
How many records do u have ?

can u make ur text file this way

SF|    31|    B. Barry|             10 | 
SG|    13|    D. Christie|          14 |

so u can tell the script '|' is the field terminator and \n is the line terminator.
SF will be in field1,31 wil be in field 2, B. Barry will be in field 3,10 will be in field4

second line will also follow this way....

This way i have loaded 7000 lines

Mark_Nordstrom

the text file is generated from NBA Live 2003. Every file generated bye it is the same. I need help converting it to csv in this script or just having it work how the file is.

Mark_Nordstrom

it can also upload if its tab Delimited but i dont know how to get it to convert it to a tab delimited file.

netmastan

i think there is option in NBA Live to export data..

maybe for xl,microsoft access or other format.You can convert them to mysql easily as well.

Anyway, here is one sample code i used for my text file.You can get some idea.



<?php

require_once("mainfile.php");
global $dbi;

#echo "<input type=\"hidden\" name=\"file\" value=\"C:\\hadith.txt\">";

if(!empty($submit))  {

$count=0;
$sql=" LOAD DATA LOCAL INFILE '$form_data'  INTO TABLE hadith FIELDS TERMINATED BY '@'
 LINES TERMINATED BY '|'(volume, book, number, hadith)";

$result=mysql_query($sql,$dbi);

if( !$result)

die("Something wrong:".mysql_error());

echo " I have inserted records : $counts <br> Upload again ?? >>> <a href=http://localhost/load.php>[url]http://localhost/load.php[/url]</a>";



} else {

echo "<form method=\"post\" action=\"load.php\" enctype=\"multipart/form-data\">
<input type=\"file\" name=\"form_data\" size=\"40\">
<p><input type=\"submit\" name=\"submit\" value=\"submit\">
</form>" ;

}


?>

Mark_Nordstrom

No it will only export txt files. My script works just need it to convert the files uploaded to csv or tab delimited.

netmastan

Sorry, I don't know but this way also works perfect. I just tested on ur text file.

Delete first few lines from the text file..just keep the records.

1)Create Blank DB in MS Access
2)File>Get External Data>Import>Files of Types> Textfiles
3)Follow the step.. you will get clean database..

Then just convert access to mysql in less than a min.

thanks