import csv file to multiple tables at once

[webent]

Hi, I am trying to get my product inventory into my shopping cart, unfortunately there isn't a built in function for this, so I'm trying to build one... I've studied the table structure and built the queries according to its layout... Where I'm stumped though is when it comes to uploading the csv file, putting it into an array, and then having it loop through multiple different table inserts for each line in the csv file.

 

Here's what I have so far, I hope that its not too long...

 

<?php
if(!isset($_POST['import']))	{
?>
<form enctype="multipart/form-data" action="import.php" method="POST">
Please choose a file: <input name="uploaded" type="file" /><br />
<input type="submit" name="import" value="Import" />
</form>
<?php
							}
elseif(isset($_POST['import']))	{

$target = "/home/american/public_html/file_import/";
$target = $target . basename( $_FILES['uploaded']['name']) ;
$ok=1;
if(move_uploaded_file($_FILES['uploaded']['tmp_name'], $target))	{
$file_name = basename( $_FILES['uploaded']['name']);
																}

include_once "connection.php";

$date_time_stamp = date();
$language_id = 1;
$products_type = 1;

// Parse CSV file to get these fields...

// foreach(ROW IN THE CSV FILE)	{

$handle = fopen($file_name, "r");
$fields = fgetcsv($handle, 0, ",");

$category_name = $fields[0];
$category_description = $fields[1];
$manufacturer_name = $fields[2];
$products_quantity = $fields[3];
$products_model = $fields[4];
$products_image = $fields[5];
$products_price = $fields[6];
$products_weight = $fields[7];
$products_price_sorter = $fields[8];
$products_name = $fields[9];
$products_description = $fields[10];
$metatags_title = $fields[11];
$metatags_keywords = $fields[12];
$metatags_description = $fields[13];

$catgories_query = "INSERT INTO categories VALUES ('','','','','','$date_time_stamp','','1')";
$categories_query_results = mysql_query($catgories_query);
	$categories_unique_id = mysql_insert_id();

$catgories_description_query = "INSERT INTO categories_description VALUES ('$categories_unique_id','$language_id','$category_name','$category_description')";
$categories_description_query_results = mysql_query($catgories_description_query);

$manufacturers_query = "INSERT INTO manufacturers VALUES ('','$manufacturer_name','','$date_time_stamp','')";
$manufacturers_query_results = mysql_query($manufacturers_query);
	$manufacturers_unique_id = mysql_insert_id();

$manufacturers_info_query = "INSERT INTO manufacturers_info VALUES ('$manufacturers_unique_id','$language_id','','','')";
$manufacturers_info_query_results = mysql_query($manufacturers_info_query);

$products_query = "INSERT INTO products VALUES ('','$products_type','$products_quantity','$products_model','$products_image','$products_price','','$date_time_stamp','','','$products_weight','1','1','$manufacturers_unique_id','','1','1','','','','1','','1','','','','','$products_price_sorter','$categories_unique_id','1','1','1','1','1','1')";
$products_query_results = mysql_query($products_query);
	$products_unique_id = mysql_insert_id();

$products_description_query = "INSERT INTO products_description VALUES ('','$language_id','$products_name','$products_description','','')";
$products_description_query_results = mysql_query($products_description_query);

$products_to_categories_query = "INSERT INTO products_to_categories VALUES ('$products_unique_id','$categories_unique_id')";
$products_to_categories_query_results = mysql_query($products_to_categories_query);

$meta_tags_products_description_query = "INSERT INTO meta_tags_products_description VALUES ('$products_unique_id','$language_id','$metatags_title','$metatags_keywords','$metatags_description')";
$meta_tags_products_description_query_results = mysql_query($meta_tags_products_description_query);

//								}

fclose($handle);

    							}

?>

[webent]

Please close.