How can I save CSV file into a mysql table column using php?

Question

Hi I would like to know if there is a way to save a CSV file into a mysql table column using php? Please see that I am not seeking answers for importing/export data to & from table to csv file, I need to save the entire file after exporting from somewhere into a table. say for example:

id date       file
1 8/16/2022   abc.csv
2 7/16/2022   xyz.csv

I have everything till the point of data insertion. Just need someone to guide me on how to insert the file into table column using php, am using codeigniter.

You mean put the entire contents of the CSV into a database field? Yes, that's possible, just make sure that the field is large enough to hold the data. — Honk der Hase
– Honk der Hase, Commented Aug 16, 2022 at 15:04
Yes entire contents of the CSV into a database field, I am planning to use text as datatype for the file size isn't too large @HonkderHase — Just_Do_It
– Just_Do_It, Commented Aug 16, 2022 at 15:09
It's not going to be usable in database but file_get_contents should allow you to do it. — user3783243
– user3783243, Commented Aug 16, 2022 at 15:25

Mayor of the Plattenbaus · Accepted Answer · 2022-08-16 16:09:27Z

2

If I understand your question correctly, it should be fairly simple. Assuming you already have a PDO object called $dbh, something similar to this should work (not verified):

$myStringContainingTheWholeFirstCsv = file_get_contents('abc.csv');
$sth = $dbh->prepare('INSERT INTO `my_table_name` (`my_column_name`) VALUES (:csv)');
$sth->bindParam(':csv', $myStringContainingTheWholeFirstCsv, PDO::PARAM_STR);
$sth->execute();

edited Aug 16, 2022 at 16:09

answered Aug 16, 2022 at 16:04

Mayor of the Plattenbaus

1,2135 gold badges40 silver badges83 bronze badges

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

2 Comments

Bill Karwin Over a year ago

Note that the size of the CSV file must be smaller than the max_allowed_packet MySQL option, and that option is effectively the lesser value set by the client and the MySQL Server.

Mayor of the Plattenbaus Over a year ago

Good point. file_get_contents() always holds the possibility of danger.

Collectives™ on Stack Overflow

How can I save CSV file into a mysql table column using php?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related