Php > Databases

Load delimited textfile into MySql table.

Load delimited textfile into MySql table.

<? 
# declare some variables 
$ServerName=''; 
$UserName=''; 
$Password=''; 
$filename=''; # Text file to read 
$TableName=''; # Table to be filled. 

mysql_connect("$ServerName", "$UserName", "$Password"); 

$fd = fopen($filename, "r"); 
while ($record = fgets($fd, 4096)) { 

$field = explode("|", $record); # '|' is the character which seperates the 
fields. 

$query = "INSERT INTO $TableName VALUES ($field[0], '$field[1]')"; #Use as many fields as you need. 
        $result = mysql_db_query("$ServerName", $query); 

    if ($result) { 
        echo "<p>$field[0] was added to the database</p>"; # Use any field you need. 
    } 

} 

fclose($fd); 

?>