Пример #1
0
<?php

include 'includes/connect.inc.php';
include 'includes/functions.inc.php';
$sql = "SELECT * FROM exercises";
$result = $db->query($sql);
$groups = getAllExercises($result, 'muscleGroup');
$result = array();
foreach ($groups as $key => $value) {
    $result[] = array('name' => $key, 'exercises' => $value);
}
echo json_encode($result);
Пример #2
0
<?php

include 'includes/connect.inc.php';
include 'includes/functions.inc.php';
$sql = "SELECT \n\t\t\tday_exercises.day,\n\t\t\texercises.id AS id,\n\t\t\texercises.name,\n\t\t\texercises.reps,\n\t\t\texercises.sets,\n\t\t\texercises.description,\n\t\t\texercises.muscleGroup\n\t\tFROM day_exercises\n\t\tINNER JOIN exercises ON day_exercises.exercise_id = exercises.id";
$result = $db->query($sql);
$groups = getAllExercises($result, 'day');
$exercises = $groups;
echo json_encode($exercises);