<?php

$db = new mysqli("localhost", "root", "", "nauka");

function generateRandomString($length = 10)
{
    $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
    $charactersLength = strlen($characters);
    $randomString = '';
    for ($i = 0; $i < $length; $i++) {
        $randomString .= $characters[rand(0, $charactersLength - 1)];
    }
    return $randomString;
}

$query = "INSERT INTO posty (kategorie_id, posty_tytul) VALUES ";

$j = 0;
$i = 0;
while($j < 100)
{
    $query = "INSERT INTO posty (kategorie_id, posty_tytul) VALUES ";
    $i = 0;

    while($i < 10000) {

        $id = rand(0, 10000);
        if ($i == 0) {
            $query = $query . " ($id, '" . generateRandomString(100) . "' ) ";
        } else {
            $query = $query . ", ($id, '" . generateRandomString(100) . "' ) ";
        }
        $i++;

    }
    //$i = 0;
    $db->multi_query($query);
    echo "Dodalem 10 000 rekordow!".PHP_EOL;
    $j++;
}

echo "Skonczylem!".PHP_EOL;