sendLightShow2mysql.php

<?php
/*
	Copyright 2014 Mark Briggs

	This file is part of ColorRing.

	ColorRing is free software: you can redistribute it and/or modify
	it under the terms of the GNU General Public License as published by
	the Free Software Foundation, either version 3 of the License, or
	any later version.

	ColorRing is distributed in the hope that it will be useful,
	but WITHOUT ANY WARRANTY; without even the implied warranty of
	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
	GNU General Public License for more details.

	There is a copy of the GNU General Public License in the
	accompanying COPYING file
*/

require_once("appInit.php");
require_once("siteGenFunctions.php");
require_once("siteDbFunctions.php");

if (isset($_GET['lightShowName']) && isset($_GET['singleCmdIdxStr'])) {
	$lightShowName = $_GET['lightShowName'];
	$singleCmdIdxStr = $_GET['singleCmdIdxStr']; // Should start with the first byte of the packet. 
	
	$conn = connect_to_DB();
	
	// If exists, update record. If not, Insert new record.
	$whereCondArrArr = array(array("lightShowName", "=", $lightShowName));
	$result = dbSelect("LightShow", $whereCondArrArr);
	$numRecords = mysql_num_rows($result);
	if ($numRecords > 0) {
		// Update the record
		$row = mysql_fetch_assoc($result);
		$idx = $row['idx'];
		
		//$setArr = array("lightShowName" => $lightShowName, "singleCmdIdxStr" => $singleCmdIdxStr);
		$setArr = array("singleCmdIdxStr" => $singleCmdIdxStr);
		$whereCondArrArr = array(array("idx", "=", $idx));
		$result = dbUpdate("LightShow", $setArr, $whereCondArrArr);
		if ($result) {
			echo '{"result": "1", ';
			echo '"statusMsg": "Updated!", ';
			echo '"idx": "' . $idx . '"}';
		} else {
			echo '{"result": "-1", ';
			echo '"statusMsg": "Not Updated!"}';
		}
	} else {
		// Insert new record
		$result = dbInsert("LightShow", array("lightShowName" => $lightShowName, "singleCmdIdxStr" => $singleCmdIdxStr));
		$idx = mysql_insert_id();
		if ($result) {
			echo '{"result": "1", ';
			echo '"statusMsg": "Saved!", ';
			echo '"idx": "' . $idx . '"}';
		} else {
			echo '{"result": "-1", ';
			echo '"statusMsg": "Not Saved!"}';
		}
	}
	
} else {
	echo '{"result": "-1", ';
	echo '"statusMsg": "Both \'lightShowName\' and \'singleCmdIdxStr\' must be passed.<br />"}';
}



// echo "...";

?>