insert data from text file into mysql db white php

Question

i tried this code but i dont work

    <?php

$con=mysqli_connect("localhost","root","","db_insert_txt");

// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
else{
echo "rak connecté";
}
$lines = file('test.txt');  
$test = "";  
$insert_string = "INSERT INTO `test_txt`(`test`) VALUES"; 
$counter = 0; 
$maxsize = count($lines); 
foreach($lines as $line => $company) { 
$insert_string .= "('".$company."')"; 
$counter++; 
if($counter < $maxsize){ 
$insert_string .= ","; 
}//if 
}//foreach 
mysqli_query($insert_string) or die(mysqli_error());
mysqli_close($con);
?>

It gives me the following warning:

Warning: mysqli_query() expects parameter 1 to be mysqli, string given

Funk Forty Niner · Accepted Answer · 2014-10-12 17:09:06Z

1

The error message describes pretty well what's wrong.

You need to pass the DB connection parameter to the query:

mysqli_query($con, $insert_string);

Use it for the following also:

mysqli_error($con);

edited Oct 12, 2014 at 17:09

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered Oct 12, 2014 at 17:06

php_nub_qq

16.1k25 gold badges84 silver badges150 bronze badges

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

4 Comments

Hamane el Mehdi Over a year ago

it says no Warning: mysqli_error() expects exactly 1 parameter, 0 given in C:\wamp\www\update-from-txt\index.php on line 26

php_nub_qq Over a year ago

@HamaneelMehdi you refuse to do any thinking of your own, that's not nice.

Hamane el Mehdi Over a year ago

sorry i wont do it agan :/

php_nub_qq Over a year ago

@HamaneelMehdi you don't need to apologize to me, it's bad for you not me.

Collectives™ on Stack Overflow

insert data from text file into mysql db white php

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related