PDO usage

revision d7b69af5a042bd2d7c94f95b0192a0304d862484

raw

phork0.txt

$db = new PDO(
    'mysql:dbname=' . $cfg['DB']['database'] . ';host=' . $cfg['DB']['host'],
    $cfg['DB']['username'], $cfg['DB']['password']
);

$categories = [];
$stmt = $db->query('SELECT uid, title, parent FROM sys_category WHERE deleted = 0');
foreach ($stmt as $row) {
    if (isset($categories[$row['title']])) {
        die("Double title\n");
    }
    $categories[$row['title']] = $row['uid'];
}

History