scratchings-php/ajax.php

<?php

if ( isset( $_GET["venue"] ) && !empty( $_GET["venue"] ) ) {
	parse_data();
}

function test_function()
{
	$return = $_GET;

	//Do what you need to do with the info. The following are some examples.
	//if ($return["favorite_beverage"] == ""){
	//  $return["favorite_beverage"] = "Coke";
	//}
	$return["favorite_restaurant"] = "McDonald's";

	$return["json"] = json_encode($return);
	echo $_GET['callback'] . '(' . json_encode($return ). ')';
}

function parse_data()
{
	$return = [];
	$data = $_GET;
	if ( empty( $data ) ) {
		test_function();
	}
	$venue = $data['venue'];
	$races = $data['races'];
	if ( empty( $venue ) || empty( $races ) ) {
		test_function();
	}

	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 );
		$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

		$query_string = "UPDATE race_program
			SET torn = TRUE
			WHERE race_date = :race_date
				AND venue = :venue 
				AND start_time = :start_time;";
		$sth = $conn->prepare( $query_string );
		for ($i = 0; $i < count( $races ); $i++ ) {
			// $datetime = strtotime( $races[$i]['localtime'] );
			$datetime_object = new DateTime( $races[$i]['localtime'] );
			// $datetime_object->setTimestamp( $datetime );
			$datetime_object->setTimezone( new DateTimeZone( $venue['localTimezone'] ) );
			$date = $datetime_object->format( 'Y-m-d' );
			$time = $datetime_object->format( 'H:i:s' );
			$return[] = [$date, $time, $venue['name'], $venue['localTimezone'], $date . 'T' . $time];
			$sth->bindParam( ':race_date', $date );
			$sth->bindParam( ':venue', $venue['name'] );
			$sth->bindParam( ':start_time', $time );
			$sth->execute();
		}
		$conn->commit();
		echo $_GET['callback'] . '(' . json_encode($return ). ')';
		$conn = null;
	}catch (PDOException $e){
		// report error message
		echo $_GET['callback'] . '(' . json_encode( $e->getMessage() ). ')';
	} catch(Exception $e)
	{
		echo $_GET['callback'] . '(' . json_encode( $e->getMessage() ). ')';
	}
}