<?php
 
$server = 'localhost';
$user = 'username';
$password = 'password';
 
// open connection to MySQL server
$connection = mysql_connect($server,$user,$password)
or die ('Unable to connect!');
 
//select database
mysql_select_db('table_name') or die ('Unable to select database!');
 
// clear the table down
$sql = "TRUNCATE TABLE table_name";
 
// run the first query to clear table
mysql_query($sql) or die(mysql_error());
 
// set up query to import data, assuming the
// csv file is at the top level of the C drive
$sql = "LOAD DATA INFILE 'users.txt'
        INTO TABLE table_name
        FIELDS TERMINATED BY ','
        OPTIONALLY ENCLOSED BY '\"'
        LINES TERMINATED BY '\r\n'";
 
// run the query to load the data
mysql_query($sql) or die(mysql_error());
 
?>