cannot import excell table in mysql

kkshansid

cannot import table in mysql
1i saved my excell file in csv formate
2i made a data base in mysql
3i made a table with 5 fields
4i run this file

error
Parse error: syntax error, unexpected T_STRING in C:\wamp\www\test\hi.php on line 16

Expand|Select|Wrap|Line Numbers

 <?php

echo"hi";

 $conn=mysql_connect("localhost","root","");

             if(!($conn)) die("could not connect");
 
            $db=mysql_select_db("asdf");

            if(!($db)) die("database not found");

LOAD DATA INFILE 'D:\backup\institutes.csv' INTO TABLE 'inst'; 

?>

wizardry

here is a link for what your trying to acomplish
http://blog.tjitjing.com/index.php/2...in-5-easy.html

Canabeez

Quote:

Originally Posted by kkshansid

cannot import table in mysql
1i saved my excell file in csv formate
2i made a data base in mysql
3i made a table with 5 fields
4i run this file

error
Parse error: syntax error, unexpected T_STRING in C:\wamp\www\test\hi.php on line 16

Expand|Select|Wrap|Line Numbers

 <?php

echo"hi";

 $conn=mysql_connect("localhost","root","");

             if(!($conn)) die("could not connect");
 
            $db=mysql_select_db("asdf");

            if(!($db)) die("database not found");

LOAD DATA INFILE 'D:\backup\institutes.csv' INTO TABLE 'inst'; 

?>

I think you missed, mysql_query() part, and BTW this (Parse error: syntax error, unexpected T_STRING in C:\wamp\www\test\hi.php on line 16) is PHP error, not mySQL. Your code should look like:

Expand|Select|Wrap|Line Numbers

 
            $conn=mysql_connect("localhost","root","");

            if(!($conn)) die("could not connect");
 
            $db=mysql_select_db("asdf");

            if(!($db)) die("database not found");

            mysql_query("LOAD DATA INFILE 'D:\backup\institutes.csv' INTO TABLE 'inst';", $conn);

cannot import excell table in mysql

re: cannot import excell table in mysql

re: cannot import excell table in mysql

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about