<?php
header('Content-type:application/json;charset=utf-8');
require 'database.php';
if (isset($_POST['save_neural_network'])) {
$json = json_decode($_POST['save_neural_network'], true);
foreach ($json as $key => $value) {
if ($key == 'rating') {
$rating = mysql_real_escape_string($value);
}
/*
* There is no way to escape symbols in Java serialized object safely.
*/
if ($key == 'object') {
$object = $value;
}
}
open_my_db();
query_my_db("INSERT INTO neural_networks (object, rating) VALUES ('" . $object . "', '" . $rating . "');");
close_my_db();
}
<?php
header('Content-type:application/json;charset=utf-8');
require 'database.php';
/*
* Load the best network.
*/
if (isset($_POST['load_neural_network'])) {
open_my_db();
$result = query_my_db("SELECT `object`, `rating`, `registered` FROM `neural_networks` ORDER BY `rating` ASC LIMIT 1;");
$response = "";
if ($result != false) {
$response = array('found' => 'true', 'object' => '' . $result[0][0], 'rating' => '' . $result[0][1], 'registered' => '' . $result[0][2]);
} else {
$response = array('found' => 'false');
}
close_my_db();
echo json_encode($response);
}
<?php
header('Content-type:application/json;charset=utf-8');
require 'database.php';
if (isset($_POST['best_rating'])) {
open_my_db();
$result = query_my_db("SELECT `rating` FROM `neural_networks` ORDER BY `rating` ASC LIMIT 1;");
$response = "";
if ($result != false) {
$response = array('rating' => '' . $result[0][0]);
} else {
//TODO Use named constant instead number.
$response = array('rating' => '' . PHP_INT_MAX);
}
close_my_db();
echo json_encode($response);
}
