[wd_asp elements=’search’ ratio=’100%’ id=1]

Write many Arrays to a Database in one insert

15th November 2020

Php - Arrays

php codehaven

This should really use foreach instead of counting the array, but it could come in handy!

Inserted".$i;
$query = "INSERT INTO list1 (todo_id,todo_item) VALUES ('$todo_id[$i]', '$todo_item[$i]')";
if ($mysqli->query($query) === TRUE) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "
" . $sql->error;
}
}
$rowcount=mysqli_num_rows($query);
printf("Result set has %d rows.\n",$rowcount);
?>