Snippet of PHP I wrote to generate list of urls for each year, separated by new line. called on command line, 'php filename > 2001urls.txt'

gistfile1.txt

<?php

$mysqli = new mysqli('localhost', 'root', '', 'syllabi_scraper');


if ($mysqli->connect_error) {
    die('Connect Error (' . $mysqli->connect_errno . ') '
            . $mysqli->connect_error);
}

if ($result = $mysqli->query("SELECT url FROM syllabi WHERE url LIKE '%2001%'")) {
        while($obj = $result->fetch_object()){
                echo ($obj->url . "\n");
        }

    /* free result set */
    $result->close();
}