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; }
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; }
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; }