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

38 lines
1.0 KiB
PHP
Raw Permalink Normal View History

2024-03-04 16:07:16 +01:00
<?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');
$method = $_SERVER['REQUEST_METHOD'];
if ('POST' === $method) {
parse_str(file_get_contents('php://input'), $_POST);
}
$connection = connect();
$returnValue = array();
$querystr = "SELECT * FROM li_courses ORDER BY name";
$result = mysqli_query($connection, $querystr);
if($result->num_rows !== 0) {
while ($row = mysqli_fetch_object($result)) {
$student = (object) [
'cid' => $row->cid,
'name' => $row->name . ' ' . $row->description,
'diffname' => $row->diffname,
];
array_push($returnValue, $student);
}
}
mysqli_free_result($result);
echo json_encode($returnValue);
?>