$classe = $_POST["classe"]; print load($ecole, $classe); break; case 'migrate': $ids = $_POST["ids"]; $ecole = $_POST["ecole"]; $classe = $_POST["classe"]; $fecole = $_POST["fecole"]; $fclasse = $_POST["fclasse"]; //$ar_ids = explode(",",$ids); foreach ($ids as &$value) { $where .= "`enfantid`='{$value}' OR "; } $where = substr($where, 0, -4); print migrate($ecole, $classe, $where); update_history($fecole, $fclasse, $ecole, $classe); break; } ///////////////functions//////////////// function update_history($fecole, $fclasse, $tecole, $tclasse) { $mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB); $query = "INSERT INTO `migrate_history` (`idmigrate`,`from_ecole`,`from_classe`,`to_ecole`,`to_classe`,`date`) VALUES (NULL,'{$fecole}','{$fclasse}','{$tecole}','{$tclasse}',CURRENT_TIMESTAMP)"; $mysqli->query($query); $mysqli->close(); } function migrate($ecole, $classe, $where) { $mysqli = new mysqli(DBSERVER, DBUSER, DBPWD, DB); $query = "UPDATE `enfants` SET `ecole`='{$ecole}',`classe`='{$classe}' WHERE {$where}"; $mysqli->query($query);
function history_request($config, $uri) { switch ($_SERVER['REQUEST_METHOD']) { case 'GET': find_history($config); break; case 'PUT': //update update_history($config, $uri[3]); break; case 'DELETE': delete_history($config, $uri[3]); break; case 'POST': //create //create case 'HEAD': case 'OPTION': default: error_activity(); break; } }