Upload . txt to Mysql database

Question

Hello,

I would like to upload a file .txt which meets the layout as follows (following example of two lines of the file):

9787546;488464;2016-12-11;Carlos Fonseca;carlos.fonseca
9787547;464664;2016-12-11;Rogério Barros;rogerio.barros

The file maintains this layout and has more than 3 thousand lines.

I would like to know more or less a script that treats the lines, differentiating in columns each data.

What I have today is simple, but only matters the first column:

<?php
$file = fopen('../files/docs/libs/newUsers.txt', 'r');

while(!feof($file)){
    $data = fgets($file);
    $query = mysqli_query($con,"insert into users values '({$data})'");
}

I know there’s no separation of the columns being made, but it’s the most I could find at the moment.

I don’t code in OO yet.

Thank you!

Answer 1

Try this:

$file = fopen('../files/docs/libs/newUsers.txt', 'r');

while(!feof($file)){
    $data = explode(';', fgets($file)); // separar valores pelos ; que estão no ficheiro
    $query = mysqli_query($con, 'INSERT INTO users (COL1, COL2,COL3, COL4, COL5) VALUES (' .implode(', ', $data). ')');
}

It is not required, but I recommend to play it safe and specify the column name in the query as well.

You should replace the COL.. By the names of the respective columns you have in the table users, the first being (COL1) corresponds to the first value etc...