|
|
|
|
|
|
| |
| <?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' );
?> | |
|
|
| email new items in db
Categories : PHP, Email, Databases, MySQL, Beginner Guides | | | Simple pipe delimited file export program that downloads to a local machine
Categories : PHP, Filesystem, Databases, MySQL, HTTP | | | Specify your connection settings and create a link to a MySQL database.
Categories : PHP, PHP Classes, Databases, MySQL, Beginner Guides | | | Newbie Notes #4 - Trapping dumb MySQL query errors
Categories : PHP, Databases, MySQL, Debugging, Beginner Guides | | | mySQL/PHP/search with multientry
form and table output with colored rows
Categories : PHP, Beginner Guides, MySQL, HTML and PHP, Databases | | | 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 | | | for each record, do this to the first record, and do that to any subsequent record
Categories : PHP, Databases, MySQL, Beginner Guides | | | How to Insert a Date Format Into MySQL from PHP
Categories : PHP, Databases, MySQL, Date Time, Beginner Guides | | | bookmarker - PHP, PHPLIB, MySQL WWW based bookmark manager
Categories : MySQL, PHP, MySQL, Complete Programs, Databases | | | Newbie Notes #10 - Generating drop downs
Categories : PHP, MySQL, HTML, Beginner Guides, Databases | | | Making a simple Hit-Log using PHP and MySql
Categories : PHP, Log Files, Beginner Guides, Databases, MySQL | | | Cut your MySQL Connections to 1 line of code
Categories : PHP, Beginner Guides, Databases, MySQL | | | PHP Transfer data from text file to Mysql Table
Categories : PHP, PHP Classes, Filesystem, Databases, MySQL | | | Accepts a database & hostname from a user and then HTTP username and password. Uses this to connect to a MySQL database. Produces a form based on the tables it finds there to allow the user to do SELECTs, INSERTs, and DELETEs.
Categories : Databases, PHP, MySQL, Complete Programs | | | phpAds, a complete banner and ad management system with detailled tracking and stats.
Categories : MySQL, Complete Programs, Ecommerce, PHP, Databases | |
| | | | 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
| |
|
|
|
