<?php
require_once __DIR__.'/auth_guard.php';
require_once "../config.php";
$sql="SELECT
scormpkg.id as id,
scormpkg.clave as Clave,
scormpkg.nombre as Nombre,
scormpkg.url as URL,
scormpkg.habilitado as Habilitado,
scormpkg.descripcion as 'Descripción',
scormpkg.imagen as 'Imagen',
scormpkg.creacion as 'Creación',
	scormpkg.Actualizacion as 'Actualizacion',
	categoria.nombre as 'Categoría',
	scormpkg.idcategoria as 'idcategoria'
FROM
scormpkg
INNER JOIN categoria ON scormpkg.idcategoria = categoria.id
ORDER BY categoria.id ASC";
global $link;
dbConnect();
$result = mysqli_query($link, $sql);
$return = new stdClass();
if ( mysqli_num_rows($result) <= 0 ) { 
	$return->code = "0";
	$return->msg="Sin recursos";
	$return->columns = ["id","Clave","Nombre","URL","Habilitado","Descripción","Imagen","Creación","Actualización","Categoría","idcategoria"];
	
}else{
	$return->code = "1";
	$return->msg="recursos";
	$return->datos = [];
	$return->columns = [];
	while ($row = mysqli_fetch_assoc ($result)){
		$return->columns = array_keys($row);
	}
	mysqli_data_seek($result, 0);
	while ($row = mysqli_fetch_row ($result)){
		$return->datos[] = $row;
	}

}

echo json_encode($return, JSON_UNESCAPED_UNICODE);
?>