Foppe
/
scratchings-php


			
				
					
						
						
							1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889
							<!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>Racing Australia</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_head = <<<TABLEHEAD
    <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>
TABLEHEAD;
    echo( $table_head );
    $new_venue = '';
    $new_day = '';
    while($row = $stmt->fetch(PDO::FETCH_ASSOC)) : ?>
        <?php
            if ( $new_day != '' && $new_day != $row['race_date'] ) {
                echo $table_foot;
                echo '<h4>' . htmlspecialchars($row['race_date']) . '</h4>';
                echo $table_head;
            } else if ( $new_venue != '' && $new_venue != $row['venue'] ) {
                echo $table_foot;
                echo $table_head;
                $new_venue = $row['venue'];
            }
        ?>
    <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; ?>
    <?php
    $table_foot = <<<TABLEFOOT
        </tbody>
    </table>
TABLEFOOT;
    echo $table_foot;

    }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>