A mysql query is grabbing data from my database and posts it into input fields in a table via while-loop. This works fine, all 252 expected table rows are shown. Pushing the submit button on the respective PHP page shall send the data to a calculation script and (re-) write data into the db.
Problem: Only 200 rows are coming through to the processing page. I.e. 52 lines do not come through. I have set up a quick script to check the output and this also shows that only 200 rows come through.
What I found out already: As soon as I reduce the table row by row the number of data put through is increasing. With only 3 rows (tipp_id, tipp_heim, tipp_gast) all 252 rows come through.
Is there a limit of throughput I'm not aware of? Or any ideas how to solve that problem?
Query & table (table includes 252 rows):
$records = mysqli_query($conn, "
SELECT
sp.spiel_id,
sp.tore_heimteam,
sp.tore_gastteam,
t.match_id,
t.tipp_heim,
t.tipp_gast,
t.tipp_id
FROM
spielplan sp
LEFT JOIN tipps t
ON sp.spiel_id = t.match_id
");
while($fields = mysqli_fetch_assoc($records)) {
?>
<tr>
<td><input type="text" name="tipp_ids[]" value="<?php echo fields["tipp_id"] ?>"></td>
<td><input type="text" name="goals_hometeams[]" value="<?php echo $fields["tore_heimteam"] ?>"></td>
<td><input type="text" name="goals_guestteams[]" value="<?php echo $fields["tore_gastteam"] ?>"></td>
<td><input type="text" name="tipp_guestteams[]" value="<?php echo $fields["tipp_gast"] ?>"></td>
<td><input type="text" name="tipp_hometeams[]" value="<?php echo $fields["tipp_heim"] ?>"></td>
</tr>
Script to check POST output (output = 200 rows):
$goalsHome = $_POST['goals_hometeams'];
$goalsGuest = $_POST['goals_guestteams'];
$tippHomes = $_POST['tipp_hometeams'];
$tippGuests = $_POST['tipp_guestteams'];
$tipp_id = $_POST['tipp_ids'];
$i=0;
foreach($goalsHome as $key => $ghome) {
$i++;
echo $ghome.";";
echo $goalsGuest[$key].";";
echo $tippHomes[$key].";";
echo $tippGuests[$key].";";
echo $tipp_id[$key].";";
echo "<br>";
}
echo $i;