Insert data from textfile to a database table

Question

I would like to ask some help in inserting data from texfile to a database table....i created a php code to execute in inserting the files to the table but i have no luck in importing it...can anyone know to do this?help me please.

enter image description here

current php code:

<?php
$host= "localhost";
$user= "root";
$pass= "";
$db="klayton";

$connect= mysql_connect($host,$user,$pass);
if (!$connect)die ("Cannot connect!");
mysql_select_db($db, $connect);

$file = fopen("tblApplicants.txt","r");  

while( $applicants = fgets($file) )
{
  $sql = "INSERT INTO tb_applicants( aic,name ) VALUES ('$applicants')"; 
  mysql_query($sql);
}    
?>

Why not use LOAD DATA INFILE or mysqlimport?

eggyal
– eggyal

2014-02-17 22:27:50 +00:00
Commented Feb 17, 2014 at 22:27 — eggyal
– eggyal, Commented Feb 17, 2014 at 22:27

Preslav Panayotov · Accepted Answer · 2014-02-17 22:40:48Z

1

Read each line from this file,skip every second line $i%2 == 0 do break; explode it at " | " and get second ( $row[1] ) and nextone ( $row[2] ), then trim it, and make sql insert. Try to do at this way

answered Feb 17, 2014 at 22:40

Preslav Panayotov

3125 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Insert data from textfile to a database table

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