<?php
$pivot = [];
$n = 0;
for ($i = 1; $i <= 100; $i++) {
$pivot[$i] = [];
}
for($i = 1; $i <= 100; $n++) {
$user = &$pivot[rand($i, 100)];
$rand = rand(0, 100);
$random = $rand != $user ? $rand : $rand + 1;
while(array_key_exists($random, $user)) {
$random++;
}
$user[] = $random;
if($n == 100) {
$i++;
$n = 0;
}
}
foreach($pivot as $key => $piv) {
echo "INSERT INTO `following_pivot` (`uid`, `fid`) VALUES ";
foreach($piv as $pi) {
echo "(", $key, ", ", $pi, ")";
if($pi !== end($piv)) {
echo ",";
}
}
echo ";";
}
//print_r($pivot);
preferences:
28.05 ms | 402 KiB | 5 Q