Code Examples -> Convert a File database into MySQL

	Join us on FaceBook
	Submit Your Code
	Poker Tournaments
	Poker Guide for Developers
	SEO Monitor
	UpTime Monitor
	My Favorite Examples
	My Favorite Articles
	Update Your Profile

More Weber Sites
	PHP Code Search
	Web Development Forums
	Learn MySQL Playing Trivia
	PHPBB2 Templates
	Web Development Resources
	Web Development Content
	Internet Security Software

Recommended Links
	PHPClasses
	PHP Editor
	PHP Jobs
	Vision.To Design
	Ajax Tutorials
	PHP Programming Help
	PHP/MySQL Programming
	Webmaster Resources
	Webmaster Forum
	XML meta language
	website builder

Recommended
	פרייסז - הכח לקנות עובר לידיים שלך
	Texas Holdem Poker Evangelists


BACK		ADD A COMMENT		SEND TO A FRIEND		ADD TO MY FAVORITES		ADD CODE EXAMPLES		PRINT

PHP Code Examples

Title :	Convert a File database into MySQL
Categories :	PHP, Filesystem, Databases, MySQL, Beginner Guides	leaping langoor
Date :	Apr 27th 2005
Grade :	2 of 5 (graded 11 times)
Viewed :	22199
File :	No file for this code example.
Images :	No Images for this code example.

Search :	More code by leaping langoor
Action :	Grade This Code Example
Tools :	My Examples List

Code

<?php

/***************************************************************
** Delimeted file to SQL conversion method
**
** Author...: leapinglangoor [ leapinglangoor@yahoo.co.in ]
** Updated..: 19 Apr 2005
** Version..: v 1
**
** Usernotes: To use this script, you must have a table that
** has as many fields as in the text file which
** needs to be pass with the arguments (See below)
**
** Example Text file:
**
** leapinglangoor leapinglangoor@gmail.com
** name myname@myemail.com
**
** Now the database table should have two fields one
** for the name i.e. leapinglangoor or name
** and another for the email!
**
***************************************************************/

function convert( $delimeter = '\t', $filename, $db['host'], $sb['user'], $db['passwd'], $dv['database'], $db['table'] )
{

//
//Lets get the databse up and working
//

$cid = mysql_connect( $db['host'], $db['user'], $db['pass'] ) or die( 'Cant connect to mysql' );
mysql_select_db( $db['database'], $cid ) or die( 'Cant find database' );

ini_set('MAX_EXECUTION_TIME', 900); // Nessecary as the values may be too much for the server

$file = file( $filename );

foreach ($file as $line)
{
$array = explode($delemeter, $line);
$count = count($array);

for ($x=0; $x<$count; $x++)
{

$array[$x] = trim( addslashes( str_replace( '|', '', $array[$x] ) ) ); //clean up crew

if( ( $x+1 )!= $count )
{
$comma = ',';
}

$values = "'".$array[$x]."'".$comma;

}

$result = mysql_query( insert into ' . $db['table'] . ' values ( ' . $values . ' );', $cid);
}

}
?>

Examples:

Sample Text file delemeted byt a tab:
text.txt

leapinglangoor leapinglangoor@yahoo.co.in leapinglangoor@gmail.com
someone someone@somewhere.com someonw@somewhereelse.com

The above lines may appear to be in seperate lines but they form a single line.

In this case the table should have three fields.
sample php file for the above example:

<?php
include( 'convert.php' );
convert( '\t', 'text.txt', 'localhost', 'root', 'passwd', 'database_name', 'the_table_in_the_database' );
?>

Related Code Examples

	Add, Edit /Update & Delete all in one Contact Management Form Categories : PHP, MySQL, Databases, Beginner Guides
	Cut your MySQL Connections to 1 line of code Categories : PHP, Beginner Guides, Databases, MySQL
	Specify your connection settings and create a link to a MySQL database. Categories : PHP, PHP Classes, Databases, MySQL, Beginner Guides
	for each record, do this to the first record, and do that to any subsequent record Categories : PHP, Databases, MySQL, Beginner Guides
	bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager Categories : MySQL, PHP, MySQL, Complete Programs, Databases
	Newbie Notes #4 - Trapping dumb MySQL query errors Categories : PHP, Databases, MySQL, Debugging, Beginner Guides
	Download manager - A PHP script for adding a download page to any site.It also enables you track the no. of downloads. Categories : PHP, Content Management, Filesystem, Databases, MySQL
	mySQL/PHP/search with multientry form and table output with colored rows Categories : PHP, Beginner Guides, MySQL, HTML and PHP, Databases
	email new items in db Categories : PHP, Email, Databases, MySQL, Beginner Guides
	This program allows you to upload an ODBC ressource - i.e. an MS-Access database to a MySQL server. Categories : Databases, MySQL, Complete Programs, PHP, Databases
	PHP Transfer data from text file to Mysql Table Categories : PHP, PHP Classes, Filesystem, Databases, MySQL
	Simple pipe delimited file export program that downloads to a local machine Categories : PHP, Filesystem, Databases, MySQL, HTTP
	How to Insert a Date Format Into MySQL from PHP Categories : PHP, Databases, MySQL, Date Time, Beginner Guides
	Making a simple Hit-Log using PHP and MySql Categories : PHP, Log Files, Beginner Guides, Databases, MySQL
	Newbie Notes #10 - Generating drop downs Categories : PHP, MySQL, HTML, Beginner Guides, Databases

User Comments

	James Salinas wrote : 1316 In the function declaration, you have typo`s: function convert( $delimeter = `\t`, $filename, $db[`host`], $sb[`user`], $db[`passwd`], $dv[`database`], $db[`table`] ) { should be: $db[`host`], $db[`user`], $db[`passwd`], $db[`database`], $db[`table`]
	leapinglangoor wrote : 1317 `Uhmmm.... I see no diffrence. Can you be more clear :?`
	James Salinas wrote :1318 look at variable names $db[`host`], <-ok $sb[`user`], <-wrong $db[`passwd`], <-ok $dv[`database`], <-wrong $db[`table`] <-ok should be $db for all, not $sb or $dv