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

<?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;
  }
 
	$connection = connect();

    $returnValue = array();
    $querystr = "SELECT * FROM li_registrations WHERE deleted=0 and imported=0";
        
    $result = mysqli_query($connection, $querystr);
    if($result->num_rows !== 0) {
        while ($row = mysqli_fetch_object($result)) {
            $registration = (object) [
                'rid' => $row->rid,
                'firstname' => $row->firstname,
                'lastname' => $row->lastname,
                'birthday' => $row->birthday,
                'gender' => $row->gender,
                'street' => $row->street,
                'house' => $row->house,
                'zip' => $row->zip,
                'city' => $row->city,
                'phone' => $row->phone,
                'email' => $row->email,
                'accountholder' => $row->accountholder,
                'iban' => $row->iban,
                'bic' => $row->bic,
                'bank' => $row->bank,
                'applicationconsent' => $row->applicationconsent,
                'datachangeconsent' => $row->datachangeconsent,
                'privacypolicyconsent' => $row->privacypolicyconsent,
                'directdebitconsent' => $row->directdebitconsent,
                'returndebitconsent' => $row->returndebitconsent,
                'datastorageconsent' => $row->datastorageconsent,
                'multimediaconsent' => $row->multimediaconsent,
                'registrationfrom' => $row->registrationfrom
                ];      
    
            array_push($returnValue, $registration);
        }
    }

    mysqli_free_result($result);

    echo json_encode($returnValue);
?>