コード例 #1
0
function articles_all($link)
{
    //Запрос к базе
    $query = "SELECT * FROM articles ORDER BY id DESC";
    $result = mysqli_query($link, $query);
    if (!$result) {
        die(mysqli_error($link));
    }
    //извление из бд
    $n = mysqli_num_rows($result);
    $articles = array();
    for ($i = 0; $i < $n; $i++) {
        $row = mysqli_fetch_assoc($result);
        $src = image_get($link, $row['id']);
        $row['src'] = $src;
        $articles[] = $row;
    }
    return $articles;
}
コード例 #2
0
<?php

require_once "database.php";
require_once "models/articles.php";
$link = db_connect();
$article = articles_get($link, $_GET['id']);
//получаем иллюстрации к статье
$images = image_get($link, $_GET['id']);
//подключаем вид
require_once "views/article_view.php";