$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.