<?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($pi !== end($piv) && $piv !== end($pivot)) {
echo ",";
} else { echo "god damn"; }
}
echo ";";
//print_r($pivot);
preferences:
31.17 ms | 402 KiB | 5 Q