How to read a text file and insert those values into database using php

Question

I have a text file like this names ernakulam.txt which has content like this:

name1
name2
name3
name4
name5

I want to insert this value into my Mysql database table named places. Mysql table has fields like this:

dist_id  |  name
_________|______
         |
         |

In this table field1 (dist_id) should be same for all rows. The dist_id value is 6. How to read those names from text file and insert to Mysql table using php?

You can use file(), then loop over the array with lines, trim them and insert them into the database using PDO — towr
– towr, Commented Dec 31, 2013 at 9:28

Microbe · Accepted Answer · 2013-12-31 09:30:38Z

2

<?php

$file = '/path/to/ernakulam.txt';
$file_content = file_get_contents($file);
$names = explode("\n", $file_content);

and so on

answered Dec 31, 2013 at 9:30

Microbe

4653 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

How to read a text file and insert those values into database using php

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related