Public feed #603676

CSV Database in php

public php v1 · immutable
Raw Edit
·published 2007-07-05 00:02 UTC
rendered paste body
<?php$db = mysql_connect("localhost", "", "");echo mysql_error();$f = fopen("dove.csv", "r");while (($data = fgetcsv($f, 0)) !== false) {	echo 'hi';	for ($i = 1;$i < count($data);$i++) {		echo 'for1';		$sql = "INSERT INTO cubecartstore_inventoryXX VALUES(";		for ($j = 0;$j < count($data[$i]);$j++) {			if ($j != 0) {				$sql .= ", ";			}						$sql .= "'";			$sql .= mysql_real_escape_string($data[$j]);			$sql .= "'";		}		$sql .= ")";		mysql_query($sql, $db);		echo mysql_error();	}	}fclose($f);mysql_close($db);echo "Done";?>