MySQL insert data not working

Question

I have a file with 50000 rows. I make a code but it skips lots of row and pages.When i enter in phpmyadmin to look i have like so 1-10 then it start to skip 23-34 78 102 345 546 etc. i think i has something with the execution.

$contents = file_get_contents("testinsert.txt");
$data = explode(PHP_EOL, $contents);


$query = "INSERT INTO table (`name`) VALUES (?)";

$zz = $conn->prepare($query);

$zz ->bind_param("i", $bb);

$conn->query("START TRANSACTION");
foreach ($data as $bb) {
    $zz->execute();`
}

$zz->close();
$conn->query("COMMIT");

phpMyAdmin is a tool written in PHP, not a database into which you can insert data — RiggsFolly
– RiggsFolly, Commented Jul 28, 2017 at 17:01
Is the backtick really in your code, the one after $zz->execute();` — RiggsFolly
– RiggsFolly, Commented Jul 28, 2017 at 17:02
i know, it was just for explaing lol the data is worng phpmyadmin — Adrian Klark
– Adrian Klark, Commented Jul 28, 2017 at 17:02
It would be useful to see some of the input file as well as the code that is processing it — RiggsFolly
– RiggsFolly, Commented Jul 28, 2017 at 17:03

Norbert · Accepted Answer · 2017-07-28 17:07:43Z

1

I am amazed this code does anything: I would expect $zz ->bind_param("i", $bb); to be in the foreach loop. Also it would probably have to read:

foreach ($data as $bb) {
    $zz ->bind_param("s", $bb);
    $zz->execute();
}

(Notice the s for string data)

answered Jul 28, 2017 at 17:07

Norbert

6,0943 gold badges19 silver badges40 bronze badges

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

3 Comments

Professor Abronsius Over a year ago

You would call bind_param outside the loop as the @OP did

Norbert Over a year ago

@RamRaider That would only bind once and then on a not initialized variable (unless php has an unseen optimization for out of scope variables?)

happymacarts Over a year ago

do all of the "problem" rows have name field values?

Collectives™ on Stack Overflow

MySQL insert data not working

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related