Code Snippets

PHP Source Code

Welcome to Dream.In.Code
	Become a PHP Expert! Join 300,371 PHP Programmers for FREE! Get instant access to thousands of PHP experts, tutorials, code snippets, and more! There are 1,455 people online right now. Registration is fast and FREE... Join Now! Chat LIVE With a PHP Expert

CSV to MySql

Snippet to take the contents from a CSV file and insert it into a MySQL database table.

Submitted By: PsychoCoder

Actions:

Rating:

Views: 373

Language: PHP

Last Modified: July 7, 2009

Instructions: Instructions are in the comments header of the snippet

Snippet

/********************************************************
** function to import a CSV file into a MySql table. The
** function expects 7 parameters:
**
** $file = The file to open
** $delimiter = What the file is delimited with
** $host = Host of the database
** $dbname = Name of the database we're using
** $username = The databases username
** $password = Users password
** $table = Name of the table we're inserting into
**
*********************************************************/
function CsvToSql($file, $delimiter, $host, $dbname, $username, $password, $table)
{
//first connection to our database
$conn = mysql_connect($host, $username, $password) or die();
//select our database
mysql_select_db($dbname);
//make sure the file exists
if(!file_exist($file)
{
echo 'The file name '.$file.' does not exist';
}
else
{
$data = fopen($file, "r");
//now make sure the open worked
if(!$data)
{
'The file was empty';
}
//read the contents of the file int the $contents variable
$contents = file($file, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
//now close the file since we have it's contents
fclose($file);
//start a loop
for($i = 0 ; $i < $size; i++)
{
//get the current line
$line = trim($contents[$i], $delimiter);
$split = explode($delimiter, $line);
$import = "INSERT INTO ". $table . " values('" . implode("','", $split) . "')";
if(!mysql_query($import))
echo_mysql_error();
}
}
mysql_close($conn);
}

Copy & Paste

/********************************************************
** function to import a CSV file into a MySql table. The
** function expects 7 parameters:
**
** $file = The file to open
** $delimiter = What the file is delimited with
** $host = Host of the database
** $dbname = Name of the database we're using
** $username = The databases username
** $password = Users password
** $table = Name of the table we're inserting into
**
*********************************************************/
function CsvToSql($file, $delimiter, $host, $dbname, $username, $password, $table)
{
	//first connection to our database
	$conn = mysql_connect($host, $username, $password) or die();
	//select our database
	mysql_select_db($dbname);
	
	//make sure the file exists
	if(!file_exist($file)
	{
		echo 'The file name '.$file.' does not exist';
	}
	else
	{
		$data = fopen($file, "r");
		
		//now make sure the open worked
		if(!$data)
		{
			'The file was empty';
		}
		
		//read the contents of the file int the $contents variable
		$contents = file($file, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
		
		//now close the file since we have it's contents
		fclose($file);
		
		
		//start a loop
		for($i = 0 ; $i < $size; i++)
		{
			//get the current line
			$line = trim($contents[$i], $delimiter);
			
			$split = explode($delimiter, $line);
			
			$import = "INSERT INTO ". $table . " values('" . implode("','", $split) . "')";

if(!mysql_query($import))
				echo_mysql_error();			
		}
		
	}
	
	mysql_close($conn);
}