<?php
require_once __DIR__.'/auth_guard.php';
require_once "../config.php";
$sql = "
SELECT
scormpkg.id,
scormpkg.nombre,
scormpkg.idcategoria,
categoria.nombre as catname
FROM
scormpkg
INNER JOIN categoria ON scormpkg.idcategoria = categoria.id
";

global $link;
dbConnect();
$result = mysqli_query($link, $sql);
$return = new stdClass();
if ( mysqli_num_rows($result) <= 0 ) { 
	$return->code = "0";
	$return->msg="Sin recursos";
}else{
	$return->code = "1";
	$return->msg="recursos";
	$return->datos = [];
	while ($row = mysqli_fetch_array ($result)){
		$return->datos[] = $row;
	}
}
echo json_encode($return, JSON_UNESCAPED_UNICODE);
exit;
?>