Exemple #1
0
function articles_get($link, $id_article)
{
    $query = sprintf("SELECT * FROM articles WHERE id=%d", (int) $id_article);
    $result = mysqli_query($link, $query);
    if (!result) {
        die(mysgli_error($link));
    }
    $n = mysqli_num_rows($result);
    $articles = mysqli_fetch_assoc($result);
    return $articles;
}
Exemple #2
0
function articles_all($link)
{
    $query = "SELECT * FROM articles ORDER BY id DESC";
    $result = mysqli_query($link, $query);
    if (!result) {
        die(mysgli_error($link));
    }
    $n = mysqli_num_rows($result);
    $articles = array();
    for ($i = 0; $i < $n; $i++) {
        $row = mysqli_fetch_assoc($result);
        $articles[] = $row;
    }
    return $articles;
}
Exemple #3
0
function articles_of_category($link, $id_category)
{
    $query = sprintf("SELECT * FROM articles WHERE categories_id=%d", (int) $id_category);
    $result = mysqli_query($link, $query);
    if (!result) {
        die(mysgli_error($link));
    }
    $n = mysqli_num_rows($result);
    $articles = array();
    for ($i = 0; $i < $n; $i++) {
        $row = mysqli_fetch_assoc($result);
        $articles[] = $row;
    }
    return $articles;
}