How to pull data from joined tables when they are linked in phpAdmin?

Question

PHP

The crux of the matter is that I want to make categories. They are on a Pink background over the image. But id_category is displayed instead of category itself . I don't know how to fix it.
Here is a screenshot of how it is now.

Here is the code that calls $post['id_category'] , which I understand is not needed through the $post variable ? Potmou what is it in another table? (screenshots of the function below). Well, there is also a correctly working $post['image'] .

<div class="categor">
<?=$post['id_category']?>
</div>
<img src="<?=$post['image']?>" alt="">

Here are my non-working functions

function get_categories(){   
    global $link; // глобальная переменная из глобальной области видимости
    $sql = "SELECT * FROM category";
    $result = mysqli_query($link, $sql);
    $categories = mysqli_fetch_all($result, MYSQLI_ASSOC);
    return $categories;     
}

function get_categories_by_id($category) { 
    global $link; 
    $sql = "SELECT * FROM category WHERE category=".$category;
    $result = mysqli_query($link, $sql);
    $categories = mysqli_fetch_all($result, MYSQLI_ASSOC);
    return $categories;      
}

function det_posts() { 
    global $link; 
    $sql = "SELECT * FROM posts";
    $result = mysqli_query($link, $sql);
    $posts = mysqli_fetch_all($result, MYSQLI_ASSOC);
    return $posts;      
}

and screenshots of the database:

That is, I'm trying to ensure that the word is displayed like this:

If anything, then for the output I go through the elements through

<?php $posts = det_posts(); ?>
<?php foreach($posts as $post): ?>
<?php endforeach; ?>

Please, help! I just started to figure it out and have been stuck on this for several hours :C

Answer 1

Try to change

<div class="categor">
<?=$post['category']?>
</div>
<img src="<?=$post['image']?>" alt="">