| 1234567891011121314151617181920212223242526272829 |
- <?php
- $HOST = 'nordh.xyz';
- $USERNAME = 'narKampen';
- $PASSWORD = '9Bq.6[AcTc2ADwN-';
- $DATABASE = 'narKampen';
- $PORT = '3306';
- $secretKey = 'TheNarKampenSecretKey';
- try {
- $dbh = new PDO(
- 'mysql:host=' . $HOST . ';dbname=' . $DATABASE,
- $USERNAME,
- $PASSWORD
- );
- } catch (PDOException $e) {
- echo '<h1>An error har occured. </h1><pre>', $e->getMessage(), '</pre>';
- }
- $sth = $dbh->query('SELECT * FROM questions LIMIT 5');
- $sth->setFetchMode(PDO::FETCH_ASSOC);
- $result = $sth->fetchAll();
- if (count($result) > 0) {
- foreach ($result as $r) {
- echo $r['name'], "\t", $r['score'], "\n";
- }
- }
|