<?php
    $local = "localhost";
    $login = "root";
    $pass = "root";
    $name = "market";
    $link = mysqli_connect($local,$login,$pass,$name);

    $catSlug = $params['catSlug'];
    $query = mysqli_query($link,"SELECT * FROM pages
        LEFT JOIN categories  ON categories.id = pages.category_id
        WHERE categories.slug = '$catSlug'
    ") or die(mysqli_error($link));
    $data = [];
    while($row = mysqli_fetch_array($query)){
        $data[] = $row.'</br>';
    }
    $content = "";
    foreach($data as $value){
        $content .= $value['slug'].'</br>';
    }
    $page = [
        'title' => "All page",
        'content' => $content
    ];
    return $page;
?>