Example #1
0
$database->bind(1, $id, PDO::PARAM_INT);
$database->executeHandle();
$result = $database->returnResult();
$database->clean();
// Set $topic to "none" if $result is empty
// If $result isn't empty, set $topic to $result[0]
$topic = empty($result) ? "none" : $result[0];
$comment = "none";
if ($topic != "none") {
    $database->makeQuery("SELECT * FROM users WHERE id = ?;");
    $database->bind(1, $topic["author_id"], PDO::PARAM_INT);
    $database->executeHandle();
    $result = $database->returnResult();
    $database->clean();
    $topic["author_name"] = $result[0]["name"];
    $topic["content_parsed"] = $bbcode->parse($topic["content"]);
    $database->makeQuery("SELECT * FROM comments WHERE topic_id = ?;");
    $database->bind(1, $id, PDO::PARAM_INT);
    $database->executeHandle();
    $result = $database->returnResult();
    $database->clean();
    $comment = empty($result) ? "none" : $result;
    if ($comment != "none") {
        foreach ($comment as &$cmnt) {
            $database->makeQuery("SELECT * FROM users WHERE id = ?;");
            $database->bind(1, $cmnt["author_id"], PDO::PARAM_INT);
            $database->executeHandle();
            $result = $database->returnResult();
            $database->clean();
            $cmnt["author_name"] = $result[0]["name"];
            $cmnt["content_parsed"] = $bbcode->parse($cmnt["content"]);