<?php
$pivot = [];
$n = 0;
for ($i = 1; $i <= 20; $i++) {
$pivot[$i] = [];
}
for($i = 1; $i <= 20; $n++) {
$user = &$pivot[$i];
$rand = rand(0, 20);
while(in_array($rand, $user) || $rand == $i) {
$rand = rand(0, 20);
}
$user[] = $rand;
if($n == 10) {
$i++;
$n = 0;
}
}
for($i = 1; $i <= 20; $i++) {
natsort($pivot[$i]);
}
echo "INSERT INTO `following_pivot` (`uid`, `fid`) VALUES ";
foreach($pivot as $key => $piv) {
foreach($piv as $pi) {
echo "(", $key, ",", $pi, ")";
if($piv === end($pivot) && $pi === end($piv)) { } else {
echo ",";
}
}
}
echo ";";
preferences:
50.52 ms | 402 KiB | 5 Q