<?php
$limit = 10000;
$offset = 0;
do {
$data = $db->query("SELECT * FROM `tbl` ORDER BY `id` ASC LIMIT $limit OFFSET $offset")->fetchAll();
$offset += count($data);
}
while(count($data));
<?php
$text = <<<TEXT
<big class = "value">
<b>
текст
</b>
</big>
TEXT;
if (preg_match('~<big[^>]+>\s*<b>(.+)</b>\s*</big>~is', $text, $matches)) {
print_r($matches);
}
[mysqld]
max_connections = 300
log-slow-queries=/tmp/slow_queries.log
long_query_time=10
<?php
$db = new PDO('mysql:host=localhost;dbname=test', 'root', 'root', [PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"]);
$stmt = $db->prepare("INSERT IGNORE INTO page (url) VALUES (?)");
$stmt->bindParam(1, $url);
$links = [
'url1',
'url2',
'url3',
];
foreach ($links as $link) {
$url = "$link/add";
$stmt->execute();
}