about uploading a file

natman3

I am wanting to upload a tab delimited file to mysql dba but when i upload the file i want it to create its self in a new table. Does anyone know where I might go for documentation on how to do this through the use of a form with a browse that i can upload a file to and submit to the dba. Thanks for your help

thorpe

why you would ever need to save these comma dilimetered text files to there own table is behond me.

but it would be as simple as;

upload file
read file
create table
insert into mysql
delete file

all of the above im sure you will find plenty of info on in the manual.

natman3

The reason is because the file i am uploading is a list of winners and times for a race event that occurs each year. I am wanting the dba to hold all the years in separate tables so that one can view the results from each year through the web site. by uploading a file through a form it would make it easy for me to add such large information without entering it all by hand and enable me to have it stored in the dba for future or past reference
I am trying to use this code to insert the file into my dba but am not sure if it works i get an error.

I am also looking to create a form that will create a table in my dba so that i can query it to put the file in. I know that this script does not creat the table so if anyone knows how i can create a form to do this or if anyone knows of documentation on how to do this i would be greatful

<?
if(isset($POST['upload']))
{
$fileName = $FILES['userfile']['name'];
$tmpName = $FILES['userfile']['tmp_name'];
$fileSize = $FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];

					$fp = fopen($tmpName, 'r'); 
					$content = fread($fp, $fileSize); 
					$content = addslashes($content); 
					fclose($fp); 

					if(!get_magic_quotes_gpc()) 
					{ 
						$fileName = addslashes($fileName); 
					} 


					include 'library/config.php'; 
					include 'library/opendb.php'; 

					$query = "INSERT INTO upload (name, size, type, content ) ". 
							 "VALUES ('$fileName', '$fileSize', '$fileType', '$content')"; 

					mysql_query($query) or die('Error, query failed');                     
					include 'library/closedb.php'; 

					echo "<br>File $fileName uploaded<br>"; 
			}         
			?>

below here is the form that i created.