Eco-$mart Products Currently Upgrading - DO NOT USE!
| Data Base Administration using CSV | Help | |
| Upload CSV to expircomma | ||
|
';
if (is_uploaded_file($_FILES['userfile']['tmp_name'])) {
echo " File ". $_FILES['userfile']['name'] ." uploaded successfully. "; } else { echo "Trouble Uploading: "; echo "filename '". $_FILES['userfile']['tmp_name'] . "'."; } print ""; $fileup = $_FILES['userfile']['tmp_name']; $dbcnx = @mysql_connect('mysql.plainhost.com', 'ecosmar_ecosmart', 'ecoman1'); mysql_select_db('ecosmar_products', $dbcnx); $sql = "LOAD DATA LOCAL INFILE '$fileup' REPLACE INTO TABLE expircomma FIELDS TERMINATED BY ',' LINES TERMINATED BY '\\r\\n'"; if(mysql_query($sql)){ echo("Data Base Updated ");} else{ echo("Trouble Updating Data Base" . mysql_error() . " "); } ?> | ||