Добавить array в SQL
У меня есть этот код:
$name = $_POST['game'];
$gameid = $_POST['gameid'];
$topshiriqid = $_POST['topshiriqid'];
$top1 = $_POST['top1']; if(empty($top1)){$top1 = 0;}
$top2 = $_POST['top2']; if(empty($top2)){$top2 = 0;}
$top3 = $_POST['top3']; if(empty($top3)){$top3 = 0;}
$top4 = $_POST['top4']; if(empty($top4)){$top4 = 0;}
$top5 = $_POST['top5']; if(empty($top5)){$top5 = 0;}
$top6 = $_POST['top6']; if(empty($top6)){$top6 = 0;}
$top7 = $_POST['top7']; if(empty($top7)){$top7 = 0;}
$top8 = $_POST['top8']; if(empty($top8)){$top8 = 0;}
$top9 = $_POST['top9']; if(empty($top9)){$top9 = 0;}
$top10 = $_POST['top10']; if(empty($top10)){$top10 = 0;}
$array = array($top1,$top2,$top3,$top4,$top5,$top6,$top7,$top8,$top9,$top10);
?>
<pre><? print_r($arr) ?></pre>
$result = mysqli_query($db, "INSERT INTO table (gameid,topshiriqid,`1`,`2`,`3`,`4`,`5`,`6`,`7`,`8`,`9`,`10`,date) VALUES ('$gameid','$topshiriqid','$value1','$value2','$value3','$value4','$value5','$value6','$value7','$value8','$value9','$value10','NOW()')");
и HTML код :
<form action="actions/addgame" method='post'>
<input type="hidden" name="game" value="mental">
<input type="hidden" name="gameid" value="<?=$_GET['id']?>">
<div class="table-responsive">
<table class="table mental" id="myTable">
<thead class="thead-light">
<tr>
<th><a href="javascript://" onclick="addRow('myTable');return false;"><i class="fas fa-plus"></i></a></th>
<th>1</th>
<th>2</th>
<th>3</th>
<th>4</th>
<th>5</th>
<th>6</th>
<th>7</th>
<th>8</th>
<th>9</th>
<th>10</th>
<th></th>
</tr>
</thead>
<tbody>
<tr>
<td colspan="12"><input type="text" name="name" placeholder="<?=$words['topshiriqnomi']?>"></td>
</tr>
<tr>
<td><?=$n++?></td>
<input type="hidden" name="idrow" value="<?=$nn++?>">
<td><input type="number" step="any" name='top1[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top2[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top3[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top4[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top5[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top6[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top7[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top8[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top9[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top10[]' placeholder="<?=$words['sonkiriting']?>"></td>
</tr>
<tr>
<td><?=$n++?></td>
<input type="hidden" name="idrow" value="<?=$nn++?>">
<td><input type="number" step="any" name='top1[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top2[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top3[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top4[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top5[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top6[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top7[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top8[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top9[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top10[]' placeholder="<?=$words['sonkiriting']?>"></td>
</tr>
<tr>
<td><?=$n++?></td>
<input type="hidden" name="idrow" value="<?=$nn++?>">
<td><input type="number" step="any" name='top1[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top2[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top3[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top4[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top5[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top6[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top7[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top8[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top9[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top10[]' placeholder="<?=$words['sonkiriting']?>"></td>
</tr>
<tr>
<td><?=$n++?></td>
<input type="hidden" name="idrow" value="<?=$nn++?>">
<td><input type="number" step="any" name='top1[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top2[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top3[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top4[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top5[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top6[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top7[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top8[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top9[]' placeholder="<?=$words['sonkiriting']?>"></td>
<td><input type="number" step="any" name='top10[]' placeholder="<?=$words['sonkiriting']?>"></td>
</tr>
</tbody>
</table>
</div>
<div class="additional">
<div></div>
<button type="submit"><?=$words['save']?></button>
</div>
</div>
</form>
и результат этот код :
Array
(
[0] => Array
(
[0] => 1
[1] => 5
[2] => 5
[3] => 6
)
[1] => Array
(
[0] => 2
[1] => 8
[2] => 4
[3] => 4
)
[2] => Array
(
[0] => 5
[1] => 4
[2] => 1
[3] => 8
)
[3] => Array
(
[0] => 4
[1] => 4
[2] => 2
[3] => 6
)
[4] => Array
(
[0] => 8
[1] => 5
[2] => 5
[3] => 4
)
[5] => Array
(
[0] => 52
[1] => 8
[2] => 3
[3] => 9
)
[6] => Array
(
[0] => 6
[1] => 8
[2] => 3
[3] =>
)
[7] => Array
(
[0] => 8
[1] => 5
[2] => 1
[3] => 4
)
[8] => Array
(
[0] => 5
[1] => 6
[2] => 65
[3] => 1
)
[9] => Array
(
[0] => 4
[1] => 8
[2] => 8
[3] => 4
)
)
теперь таким образом, он должен добавится в SQL базу:
id | gameid | taskid | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | date
1 | 1 | 1 | 1 | 2 | 5 | 4 | 8 |52 | 6 | 8 | 5 | 4 | today
1 | 1 | 1 | 5 | 8 | 4 | 4 | 5 | 8 | 8 | 5 | 6 | 8 | today
1 | 1 | 1 | 6 | 4 | 1 | 2 | 5 | 3 | 3 | 1 |65 | 8 | today
1 | 1 | 1 | 6 | 4 | 8 | 6 | 4 | 9 | 0 | 4 | 1 | 4 | today
строки могут быть больше или меньше. Спасибо за ранее