csv file not inserting in mysql database

Question

if(isset($_POST['submit']))
{

    $file=$_FILES['file']['tmp_name'];
    $handle=fopen($file,"r");

    while(($r=fgetcsv($handle,"500",",")) !==FALSE)
    {

    $sql=mysqli_query($con,"insert into `` values('" . implode("','",$r) . "')") or die(mysql_error()) ;

        //echo implode("','",$r); if i run this it shows the data of csv file
    }
}

Query is not working. It only shows blank page.

First of all you mix mysql_ API and mysqli_ API. Change: mysql_error() to mysqli_error(). Then you get the error message — Jens
– Jens, Commented Oct 13, 2016 at 7:39
Second one you have to add a tablename between yout backticks: insert into <table_name> — Jens
– Jens, Commented Oct 13, 2016 at 7:39

Danyal Sandeelo · Accepted Answer · 2016-10-13 07:39:17Z

1

insert into `` values

table name is missing, moreover parse the data, make sure the data that you insert is correct, this can lead to mysql injection as you are passing parameters in the sql statement directly.

answered Oct 13, 2016 at 7:39

Danyal Sandeelo

12.4k10 gold badges57 silver badges90 bronze badges

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

2 Comments

A.R Over a year ago

inserted the name of the table and fix the mysql_error() to mysqli_error().. Still no luck

Danyal Sandeelo Over a year ago

did you check the record? use try catch

Collectives™ on Stack Overflow

csv file not inserting in mysql database

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related