How to upload CSV to wordpress custom table

Question

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

why not use LOAD DATA INFILE ?

splash58
– splash58

2016-06-06 09:00:33 +00:00
Commented Jun 6, 2016 at 9:00 — splash58
– splash58, Commented Jun 6, 2016 at 9:00
@splash58 can you please show me an example?

Firefog
– Firefog

2016-06-06 09:01:26 +00:00
Commented Jun 6, 2016 at 9:01 — Firefog
– Firefog, Commented Jun 6, 2016 at 9:01
i've written an example as an answer

splash58
– splash58

2016-06-06 09:05:06 +00:00
Commented Jun 6, 2016 at 9:05 — splash58
– splash58, Commented Jun 6, 2016 at 9:05

splash58 · Accepted Answer · 2016-06-06 09:04:37Z

3

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

answered Jun 6, 2016 at 9:04

splash58

26.2k3 gold badges25 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Firefog Over a year ago

can you please modify my code with your example. Thanks !

splash58 Over a year ago

unfortunately, i don't know wp db library. But i think it has method like query($string)

Jonathan Yaniv Ben Avraham Over a year ago

no offence @Firefog but if you don't understand his code, you should be reading up on SQL queries and learning what you need to pass through the values and work out which of your values fit in which parts of the SQL query statement

Firefog Over a year ago

I have update my question with this method but Failed to move uploaded file. error output

splash58 Over a year ago

I hope it's not due to the query :)

Collectives™ on Stack Overflow

How to upload CSV to wordpress custom table

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related