$title\n";
$sql1 = 'SELECT * FROM '.db('booklets').' ORDER BY filename';
$req1 = $mysqli->query($sql1) or die('Erreur SQL !
'.$sql1.'
'.$mysqli->error);
echo "\n";
while($b = $req1->fetch_assoc()) {
echo '- '.$b['title']; //'.$b['id'].'
echo ' ('.$b['filename'].")
";
$c = json_decode($b['content'],true);
foreach($c as $l) {
if($l[0] == 'score') {
if(is_int($l[1])) {
$t = chant_from_id($l[1]);
$e = array($t[0],''.format_incipit($t[1]).' ('.$t[3].')');
if(array_key_exists("annotation_prefix",$l[2])) {
$e[1] = $l[2]["annotation_prefix"].' '.$e[1];
}
} elseif(is_string($l[1])) {
$e = $l[1];
} elseif(is_array($l[1])) {
}
} elseif($l[0] == 'tex') {
$e = ''.$l[1].'';
}
if(is_array($e)) {
echo '- '.$e[1]."
\n";
} else {
echo "- $e
\n";
}
}
echo "
\n";
}
echo "
\n";
include('include/footer.php');
?>