CODEWITHSUNDEEP
phpmysqlwordpresscsv
Firefog
Firefog

Reputation: 3174

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.'

Upvotes: 1

Views: 2218

Answers (1)

splash58
splash58

Reputation: 26153

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")

Upvotes: 3

Related Questions