<?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);
<?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);