Having the problem in importing excel/csv file into mysql

Question

0.00/5 (No votes)

See more:

I am getting problem in importing the .csv file.actually it is successfully imported but all field are come in only one column.
Here is the code:
On index.php

XML

<html>
<form action="load.php" method="post" enctype="multipart/form-data">
    <input  type="file" name="file" id="file" />
    <input type="submit" value="Load" name="load"/>
</body>
</form>
</html>

On load.php

PHP

function connect_db()
{
$con = mysql_connect("localhost","root","");
    if (!$con)
       {
                die('Could not connect: ' . mysql_error());
        }
  mysql_select_db("new_import", $con);
}
if (isset($_POST['load']))
{    
 
    echo "button on is pressed  <br />";
    if ($_FILES["file"]["error"] > 0)
    {
        echo "Error: " . $_FILES["file"]["error"] .
"You have not selected a file or some other error <br />";
    }
    else
    {       
        $file_name=$_FILES["file"]["name"];
        echo $file_name."<br />";
        $file_type=$_FILES["file"]["type"];
        echo $file_type."<br />";
      //  if($file_type!='text/csv')
        //{
          //  echo "Please the input file should be a .csv file";
        //}
       // else
        //{  
            echo "its correct";
            $location="C:\\xampp\\mysql\\data\\import\\";
            move_uploaded_file($_FILES["file"]["tmp_name"],$location . $_FILES["file"]["name"]);
//}
            connect_db();
            
          /* $q= "LOAD DATA LOCAL INFILE '$file_name' INTO TABLE import1
    	FIELDS TERMINATED BY ';'
	   LINES TERMINATED BY '\n'
	   IGNORE 1 LINES
	   (@name, mobno)
	   SET name = @name,mobno=mobno";*/
            $q="LOAD DATA INFILE '$file_name' INTO TABLE import1
                FIELDS TERMINATED BY '|'
                
                LINES TERMINATED BY '\n'
                (@name,mobno)
                SET name=@name,mobno=@mobno";
mysql_query($q) or die(mysql_error());
}
}

?>

and problem is as follows in mysql database
name|mob.no
neha|9561061902

name|mob.no
neha|9561061902

Posted 5-Jul-12 23:28pm

project virus

Updated 5-Jul-12 23:30pm

Prasad_Kulkarni

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sebastian T Xavier · Answer 1 · 2012-07-05T23:31:00

Solution 1

What is the separator used in csv. I think you need to split the string before saving to database.

Regards
Sebastian

Posted 5-Jul-12 23:31pm

Sebastian T Xavier

Comments

project virus 6-Jul-12 5:36am

Ya I thnk so but this not work...'|' seperator used in csv

project virus 6-Jul-12 5:39am

how to split the string before saving to database

Sebastian T Xavier 6-Jul-12 5:51am

using string.split

project virus 6-Jul-12 5:53am

sorry i dnt knw how to use it

Sebastian T Xavier 6-Jul-12 5:54am

just google it ....search for string.split using c#

project virus 6-Jul-12 5:54am

k thnks

project virus 6-Jul-12 5:56am

what i ve to do in above coding?

Sebastian T Xavier 6-Jul-12 5:55am

http://www.google.co.in/#hl=en&output=search&sclient=psy-ab&q=string.split+in+c%23&oq=string.split&gs_l=hp.1.1.0l4.2595.13999.0.16917.21.12.5.4.4.0.206.1887.0j11j1.12.0...0.0.Og7J9-Aj3Ys&pbx=1&bav=on.2,or.r_gc.r_pw.r_qf.,cf.osb&fp=d70cb7a1447ca32b&biw=1280&bih=923

rajife · Answer 2 · 2012-07-26T20:27:00

Solution 2

hey dude i think for CSV file u should use "," or "~" on the "FIELDS TERMINATED BY" field any way try it and let me know ...

Posted 26-Jul-12 20:27pm

rajife