php - Data in CSV file only being imported partially into phpMyAdmin database table -


i'm trying import csv file complete data phpmyadmin database table. however, part of data in csv file being imported. if import csv file @ phpmyadmin, data being imported. there no error show , i'm not sure problem occurs. i'm using load data infile load data database table.

here code:

<?php  session_start();  $host       = "localhost"; $user       = "root"; $password   = ""; $db         = "smposi";  $con        = mysqli_connect($host,$user,$password,$db);  $message = ""; $m_sfile    = $_session['sfile'];  if (isset($_post['submit']))  {       $allowed = array('csv');      $filename = $_files['file']['name'];      $ext = pathinfo($filename, pathinfo_extension);      if (!in_array($ext, $allowed))       {           // show error message           $message = 'invalid file type, please use .csv file!';      }       else       {            move_uploaded_file($_files["file"]["tmp_name"], "imported csv/" .            $_files['file']['name']);            $file = "imported csv/" . $_files['file']['name'];            $query = <<<eof           load data local infile '$file'           table $m_sfile           fields terminated ','            optionally  enclosed '"'           lines terminated '\n'           ignore 1 lines           (sdate2,sdate,location,pcode,code,custarea,            pdesc,packet,weight,max,ppacket,lqty,printed,            corder,luserid,ltime) eof;             $query2       = mysqli_query($con,"delete $m_sfile            location=''");           if (!$result = mysqli_query($con, $query))            {                exit(mysqli_error($con));           }           $message = "csv file imported!";      } } ?>

i have imported csv data below simple script. try out if helps. read complete article import/export csv data. 

if(isset($_post["import"])){          $filename=$_files["file"]["tmp_name"];                  if($_files["file"]["size"] > 0)          {             $file = fopen($filename, "r");             while (($getdata = fgetcsv($file, 10000, ",")) !== false)              {                  $sql = "insert employeeinfo (emp_id,firstname,lastname,email,reg_date)                     values ('".$getdata[0]."','".$getdata[1]."','".$getdata[2]."','".$getdata[3]."','".$getdata[4]."')";                    $result = mysqli_query($con, $sql);                 if(!isset($result))                 {                     echo "<script type=\"text/javascript\">                             alert(\"invalid file:please upload csv file.\");                             window.location = \"index.php\"                           </script>";                        }                 else {                       echo "<script type=\"text/javascript\">                         alert(\"csv file has been imported.\");                         window.location = \"index.php\"                     </script>";                 }              }               fclose($file);           }     }        ?>

Comments

Post a Comment

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

i've set bento/ubuntu-16.04 vagrant box using php 5.6, , getting following error quite few times when try , run shell script: "uncaught reflection exception: class domdocument not exist". i've tried adding following top of script (not together), each no success: "sudo apt-get install php5.6-xml", "sudo apt-get install php5-xml", "sudo apt-get install php-dom" i've tried resetting server "sudo service apache2 restart". does have suggestions?
Read more

vue.js - Create hooks for automated testing -

Image
qa guys complained can't automate frontend testing. because our html looks same outside. lazy hack did this <template> <div :role="$options.name"> ... </div> </template> <script> export default { name: 'vmcomponentname' } </script> which takes name script , applies html. in browser get: <div role="vmcomponentname"> ... </div> line :role="$options.name" goes in every component. is there dry er solutions? please share. additional details i'll explain in details looking for. imagine have vmusercreate form creates user. test case can create user . to automatically test without role, have use following selector: .wrapper > .wrapper > .wrapper > .submit-button the test extremely brittle (will break lot). if use roles can use [role="vmusercreateform"] .submit-button selector. many folds less brittle. so basically, i'm ...
Read more

Add new key value to json node in java -

i have json file : { "id":1, "name":"abc", "addressdetails": { "city":"newyork" } } i wanted add 1 more key-value ("pincode" : "414141") node 'addressdetails'. i tried using : objectmapper mapper = new objectmapper(); jsonnode root = mapper.readtree(new file("d://test.json")); objectnode node = mapper.createobjectnode(); node.with("addressdetails").put("pincode", "414141"); but it's not getting added, there way can ? you can try you should modify file path objectmapper mapper = new objectmapper(); objectnode nodes = mapper.readvalue(new file("d:\\test.txt"), objectnode.class); nodes.with("addressdetails").put("pincode", "414141"); mapper.writer().writevalue(new file("d:\\test.txt"), nodes);
Read more