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