aswi2021mr-proper-gitlab/application/controller/TableController.php @ b9ed6a80

<?php
require "../model/DB.php";
require "../model/Tag.php";
require "../model/Word.php";
$DB = new DB();

// (B) SEARCH FOR USERS
$results = $DB->select(
    "SELECT w.id, w.context, w.date, w.description, w.description2, w.description3, w.ending, w.finished,
w.namedentity, w.position1, w.position2, w.positiondetail, w.word, w.tag_id, w.lemma_id, t.tag, l.lemma, l.pos FROM dd_wordform as w left join dd_tag as t on w.tag_id = t.id left join dd_lemma as l on w.lemma_id = l.id order by w.id LIMIT 100"
);

var_dump($results);

$output = Array();
foreach ($results as $res) {
    $tag = new Tag($res["tag_id"], $res["tag"]);
    $lemma = new Lemma($res["lemma_id"], $res["lemma"], $res["pos"]);
    $word = new Word($res["id"],  $res["context"], $res["date"], $res["description"], $res["description2"], $res["description3"], $res["ending"],
        $res["finished"], $res["namedentity"], $res["position1"], $res["position2"], $res["positiondetail"], $res["word"], $lemma, $tag);
    array_push($output, $word);
}

$result = json_encode(count($output)==0 ? null : $output);
echo $result;