Deathnerd/get.php

## get.php
<?php
/**
 * Created by PhpStorm.
 * User: Deathnerd
 * Date: 4/12/14
 * Time: 9:16 PM
 */

	function get_key_values_from_database($key){
		$db = mysqli_connect('localhost', 'root', 'root', 'db');
		$table = 'keysToValues';
		//check if table exists
		if(!(mysqli_num_rows(mysql_query($db, "SHOW TABLES LIKE '$table'")) > 0)){
			die(mysqli_error($db));
		}

		$query = mysqli_query($db, "SELECT * FROM `$table` WHERE keys='$key';");

		if(mysql_num_rows($query) === 0){ //no rows match
			return false;
		}
		return mysqli_fetch_array($query);
	}

	if(isset($_GET['key'])){
		header('Content-type: application/json');
		echo json_encode(get_key_values_from_database($_GET['key']));
		exit("Success");
	}
	exit("Key not set");

## get_set_test.html
<!DOCTYPE html>
<html>
<head>
	<title></title>
	<script src="http://code.jquery.com/jquery-latest.min.js" type="text/javascript"></script>
</head>
<body>
	<label for="value">Value: </label>
	<input type="text" name="value" id="value"/>
	<br/>
	<label for="key">Key: </label>
	<input type="text" name="key" id="key"/>
	<br/>
	<input value="set" id="setButton" type="button" onclick="actions.set()"/>
	<br/>
	<label for="get_key">Key to get: </label>
	<input type="text" name="get_key" id="get_key"/>
	<br/>
	<input id="getButton" type="button" value="get" onclick="actions.get()"/>
</body>
<script type="text/javascript">
	actions = {
		set: function(){
			var v = $("#value").val();
			var k = $("#key").val();
			$.ajax({
				url: "set.php",
				data: {
				      key: k,
				      value: v
				},
				success: function(response){
					alert(response);
				}
			})
		},
		get: function(){
			var k = $("#get_key").val();
			$.ajax({
				url: "get.php",
				success: function(response){
					alert("Key = "+ response.key);
					alert("Value = "+ response.value);
				},
				data: {
				      key: k
				}
			})
		}
	}
</script>
</html>

## set.php
<?php
/**
 * Created by PhpStorm.
 * User: Deathnerd
 * Date: 4/12/14
 * Time: 9:19 PM
 */

	function key_value_to_database($array){
		if(!is_array($array)){
			trigger_error("key_value_to_database requires the argument to be an array", E_USER_ERROR);
		}

		$db = mysqli_connect('localhost', 'root', 'root', 'db') or die(mysqli_error($db));
		$key = mysqli_real_escape_string($db, $_GET['key']);
		$val = mysqli_real_escape_string($db, $_GET['value']);

		$table = "keysAndValues";
		//if the table doesn't exist, create it
		if(!(mysqli_num_rows(mysqli_query($db, "SHOW TABLES LIKE `$table`")) > 0)){
			mysqli_query($db, "CREATE TABLE `$table` (keys VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci, vals VARCHAR(255)) COLLATE utf8_general_ci CHARACTER SET utf8;") or die(mysqli_error($db));
		}

		//if the key already exists, update it
		if(mysqli_num_rows(mysqli_query($db, "SELECT * FROM `$table` WHERE keys='$key'")) > 0){
			$query = mysqli_query($db, "UPDATE `$table` SET vals='$val' WHERE keys='$key';") or die(mysqli_error($db));
		}

		mysqli_query($db, "INSERT INTO `$table` (keys, vals) VALUES ('$key', '$val');") or die(mysqli_error($db));
	}

	if(isset($_GET)){
		key_value_to_database($_GET);
		exit("Success");
	}
	exit("GET not set");
	<?php
	/**
	* Created by PhpStorm.
	* User: Deathnerd
	* Date: 4/12/14
	* Time: 9:16 PM
	*/

	function get_key_values_from_database($key){
	$db = mysqli_connect('localhost', 'root', 'root', 'db');
	$table = 'keysToValues';
	//check if table exists
	if(!(mysqli_num_rows(mysql_query($db, "SHOW TABLES LIKE '$table'")) > 0)){
	die(mysqli_error($db));
	}

	$query = mysqli_query($db, "SELECT * FROM `$table` WHERE keys='$key';");

	if(mysql_num_rows($query) === 0){ //no rows match
	return false;
	}
	return mysqli_fetch_array($query);
	}

	if(isset($_GET['key'])){
	header('Content-type: application/json');
	echo json_encode(get_key_values_from_database($_GET['key']));
	exit("Success");
	}
	exit("Key not set");
	<!DOCTYPE html>
	<html>
	<head>
	<title></title>
	<script src="http://code.jquery.com/jquery-latest.min.js" type="text/javascript"></script>
	</head>
	<body>
	<label for="value">Value: </label>
	<input type="text" name="value" id="value"/>
	<br/>
	<label for="key">Key: </label>
	<input type="text" name="key" id="key"/>
	<br/>
	<input value="set" id="setButton" type="button" onclick="actions.set()"/>
	<br/>
	<label for="get_key">Key to get: </label>
	<input type="text" name="get_key" id="get_key"/>
	<br/>
	<input id="getButton" type="button" value="get" onclick="actions.get()"/>
	</body>
	<script type="text/javascript">
	actions = {
	set: function(){
	var v = $("#value").val();
	var k = $("#key").val();
	$.ajax({
	url: "set.php",
	data: {
	key: k,
	value: v
	},
	success: function(response){
	alert(response);
	}
	})
	},
	get: function(){
	var k = $("#get_key").val();
	$.ajax({
	url: "get.php",
	success: function(response){
	alert("Key = "+ response.key);
	alert("Value = "+ response.value);
	},
	data: {
	key: k
	}
	})
	}
	}
	</script>
	</html>