Firefog Firefog - 6 months ago 13
SQL Question

How to upload CSV to wordpress custom table

How to upload CSV data to wordpress custom table wp_sonali_data. Bellow is the code what I'm trying. But no luck please help

Here is my custom table column

id
brcode
brname
dist


Here is my uploader

<form method="post" action="">
<p>Choose your CSV file</p><br />
<input type="file" name="file" />
<input type="submit" name="submit" value="submit"/>

</form>


<?php

//Upload CSV File
if (isset($_POST['submit'])) {

global $wordpress,$wpdb;
$datafile= $_FILES['file']['tmp_name'];
$file=$upload_dir['basedir'].'/'.$_FILES['file']['name'];
$fileurl=$upload_dir['baseurl'].'/'.$_FILES['file']['name'];
if (!move_uploaded_file($_FILES['file']['tmp_name'],$file)){
print_r('Failed to move uploaded file.');
}
$sql="
LOAD DATA LOCAL INFILE '".$fileurl."' INTO TABLE wp_sonali_data
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'
(id,brcode,brname,dist);
";
$query = $wpdb->query($sql);
}


Error

Output: 'Failed to move uploaded file.'

Answer
LOAD DATA INFILE "$_FILES['upload_csv']['tmp_name']"
INTO TABLE wp_sonali_data
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS
("id", "brname", "brcode", "dist")