Import file.csv to MySQL

rdztech

Hi,

What is the code to use to upload file.csv into mysql databasa...it is for user interface.. I don't want to use phpmyadmin. thanks 🙂

bradgrafelman

One option would be to use a LOAD DATA INFILE query.

rdztech

bradgrafelman;10991269 wrote:
One option would be to use a LOAD DATA INFILE query.

yes, I think this is the best, but I dont know how to write the full script. I already done in php but it doesnt work.. 🆒 but I use TRUNCATE it work...🙂.. I'm sorry I'm very new and I learn by myself... below is my script:

<?php
mysql_connect("localhost", "warisanm_hrs", "warisan11") or die(mysql_error());
echo "Connected to MySQL<br />";
mysql_select_db("warisanm_hrs") or die(mysql_error());
echo "Connected to Database";

?>

<?php




mysql_query(" LOAD DATA INFILE 'staff_info.csv' INTO TABLE hrs ");

?>

hoanglam_nhatle

bradgrafelman;10991269 wrote:
One option would be to use a LOAD DATA INFILE query.

I'm biginning to learn PHP, but I feel very difficul.I hope so evrybody help me.
I don't know all backgroud in PHP and simple source code .