Foppe
/
scratchings-php


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
							<!doctype html>
<html lang="en">
<head>
	<!-- Required meta tags -->
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

	<!-- Bootstrap CSS -->
	<link rel="stylesheet" href="//stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">

	<title>Hello, world!</title>
</head>
<body>
<div class="container">
    <h1>Racing Australia</h1>
    <?php
    require_once 'dbconfig.php';
	$dsn = "pgsql:host=$host;port=5432;dbname=$db;user=$username;password=$password";
	try{
		// create a PostgreSQL database connection
		$conn = new PDO($dsn);

		// display a message if connected to the PostgreSQL successfully
		if($conn){
			echo "Connected to the <strong>$db</strong> database successfully!";
		}

		$query = sprintf("SELECT * FROM horses 
            WHERE race_date >= %s
            ORDER BY race_date, venue, race;", $conn->quote(date("Y-m-d")));
		$stmt = $conn->query($query);
		// $r = $stmt->fetch(PDO::FETCH_ASSOC);
    ?>
    <table class="table table-striped table-bordered">
        <thead>
        <tr>
            <th>id</th>
            <th>venue</th>
            <th>race_date</th>
            <th>race</th>
            <th>horse</th>
        </tr>
        </thead>
        <tbody>
    <?php while($row = $stmt->fetch(PDO::FETCH_ASSOC)) : ?>
    <tr>
        <td><?php echo htmlspecialchars($row['id']); ?></td>
        <td><?php echo htmlspecialchars($row['venue']); ?></td>
        <td><?php echo htmlspecialchars($row['race_date']); ?></td>
        <td><?php echo htmlspecialchars($row['race']); ?></td>
        <td><?php echo htmlspecialchars($row['horse']); ?></td>
    </tr>
	<?php endwhile; ?>
        </tbody>
    </table>
    <?php
    }catch (PDOException $e){
		// report error message
		echo $e->getMessage();
	}
    ?>
</div>
<!-- Optional JavaScript -->
<!-- jQuery first, then Popper.js, then Bootstrap JS -->
<script src="//code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
<script src="//stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
</body>
</html>