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 );

		// display a message if connected to the PostgreSQL successfully
		if( !$conn ){
			test_function();
		}
		$query_string = "UPDATE race_program
			SET torn = TRUE
			WHERE race_date = %s
				AND venue = %s 
				AND start_time = %s;";
		for ($i = 0; $i < count( $races ); $i++ ) {
			$datetime = strtotime( $races[$i]['localtime'] );
			$date = date( 'Y-m-d', $datetime );
			$time = date( 'H:i', $datetime );
			$return[] = [$date, $time, $venue['name'], count( $races )];
			$query = sprintf( $query_string,
				$conn->quote( $date ),
				$conn->quote( $venue['name'] ),
				$conn->quote( $time ) );
			$conn->query($query);
		}
		$conn->commit();
		echo $_GET['callback'] . '(' . json_encode($return ). ')';
	}catch (PDOException $e){
		// report error message
		echo $_GET['callback'] . '(' . json_encode( $e->getMessage() ). ')';
	} catch(Exception $e)
	{
		echo $_GET['callback'] . '(' . json_encode( $e->getMessage() ). ')';
	}
}