Public feed #533023

PapaBear

public php v1 · immutable
Raw Edit
·published 2007-06-03 10:00 UTC
rendered paste body
function insertCSV($file,$table){	$handle = file($file);	$value_str = '';	foreach($handle as $line){		$temp_field = explode(',',$line);		foreach($temp_field as $field){			$value_str .= "'".$field."',";		}		$value_str = substr($value_str, 0, (strlen($value_str)-1));		$qry = "INSERT INTO ".$table." values('".$value_str."')";		if(mysql_query($sql)){			return true;		}else{			echo mysql_error();			return false;		}	}}