Example #1
0
<?php

include "config.php";
function getArticle($id, $connect)
{
    $sql = "SELECT * FROM articles WHERE articles_id={$id}";
    $sth = $connect->prepare($sql);
    $sth->execute();
    $row = $sth->fetch(PDO::FETCH_ASSOC);
    return $row;
}
function getAllArticles($connect)
{
    $sql = "SELECT * FROM articles";
    $sth = $connect->prepare($sql);
    $sth->execute();
    $result = $sth->fetchAll();
    return $result;
}
$all_articles = getAllArticles($connect);
?>

 
Example #2
0
<?php

include "includes/header.php";
$allArticles = getAllArticles();
$categories = getCategorie();
?>

    <div class="container">

        <section>

            <div class="row">
                <div class="col-xs-12 col-md-12">

                    <h1>Tous les articles</h1>

                </div>
            </div>

			<div class="row">
			
				<div class="article_filter">

					<a href="#" data-filter="*" class="current">Tous</a>
					
					<?php 
foreach ($categories as $cat) {
    ?>
						<a href="#" data-filter=".<?php 
    echo $cat['nom'];
    ?>