li-dance-backoffice/backend/api/registrations/import.php

41 lines
1.4 KiB
PHP
Raw Permalink Normal View History

<?php
header("Access-Control-Allow-Origin: *");
header("Content-Type: application/json; charset=UTF-8");
header("Access-Control-Allow-Methods: POST");
header("Access-Control-Allow-Headers: Content-Type, Access-Control-Allow-Headers, Authorization, X-Requested-With");
require_once('../../utils/config.php');
require_once('../../utils/db.php');
require_once('../../utils/strings.php');
$authorization = $_SERVER["HTTP_AUTHORIZATION"];
if(strcmp($authorization, INTERNAL_API_KEY) !== 0) {
echo 'STOP TRYING TO STEAL MY DATA!';
exit;
}
$method = $_SERVER['REQUEST_METHOD'];
if ('POST' === $method) {
parse_str(file_get_contents('php://input'), $_POST);
}
$connection = connect();
$rid = intval($_POST["rid"]);
$querystr = "INSERT INTO li_students (firstname, lastname, birthday, gender, street, house, house_suffix, zip, city, phone, email)
SELECT firstname, lastname, birthday, gender, street, house, '', zip, city, phone, email FROM li_registrations WHERE rid=${rid}";
if (mysqli_query($connection, $querystr)) {
$result = mysqli_query($connection, "SELECT MAX(sid) as maxid FROM li_students");
if($result->num_rows !== 0) {
$row = mysqli_fetch_object($result);
$sid = $row->maxid;
$querystr = "UPDATE li_registrations SET imported={$sid} WHERE rid={$rid}";
mysqli_query($connection, $querystr);
}
}
echo json_encode('{ "result": "true" }');
?>