$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;
}
}
