function filterUsers()
{
$query = 'SELECT username FROM users WHERE username LIKE :username';
$username = $_POST['username'];
$result = getDB()->prepare($query);
if ($username == "") {
$username = '******';
}
$result->bindParam(':username', $username);
$result->execute();
printUserFilterHeader();
while ($row = $result->fetch(PDO::FETCH_ASSOC)) {
$records = array();
echo '<tr>';
array_push($records, $row['username']);
printRecords($records);
echo '</tr>';
}
printFilterFooter();
}
#!/usr/bin/php
<?php
$arguments = getopt("f:t:");
if (false === $arguments || 0 === count($arguments)) {
echo "\nUsage:" . "\nphp " . $argv[0] . " -f filename";
}
$filename = $arguments['f'];
printRecords(readDiscogsCsv($filename));
/**
* Read $filename as Discogs CSV dump, return records by format
*
* @param string $filename
* @return array
*/
function readDiscogsCsv($filename)
{
$handle = fopen($filename, 'r');
if (false === $handle) {
die("Unable to open file " . $filename);
}
$columns = array_map('strtolower', fgetcsv($handle));
$records = array();
while (false !== ($record = fgetcsv($handle))) {
$records[mapFormat($record[array_search('format', $columns)])][] = array_combine($columns, $record);
}
fclose($handle);
return $records;
}
/**
* Echo records in desired format to stdout
