$query = "INSERT INTO {$table}(" . $data_row . ",score) VALUES ('{$name}', '{$score}')";
if (!$mysqli->query($query)) {
echo "Table creation failed: (" . $mysqli->errno . ") " . $mysqli->error;
}
// show some info about records being added.
if ($time < time() - 10) {
echo "{$i} records created.\n";
$time = time();
}
}
} elseif ($number == 2) {
require_once 'SimpleRanking.php';
try {
SimpleRanking::setMySqlConnection($mysqli);
$simple_ranking = new SimpleRanking($table, $row_score, $rank_row);
$simple_ranking->run();
} catch (Exception $e) {
print $e->getMessage() . "\n";
die;
}
} elseif ($number == 3) {
require_once 'SimpleRanking.php';
$stdin = fopen('php://stdin', 'r');
print "Which name to search?\n";
fscanf($stdin, "%s\n", $name);
// reads number from STDIN
$total_time = microtime(true);
try {
SimpleRanking::setMySqlConnection($mysqli);
$simple_ranking = new SimpleRanking($table, $row_score, $rank_row);
// get rank for the given value.
