Beispiel #1
0
}
?>
</ul>
</div>
</div>
<div class="row">
<div class="h3"></div>

    <div class="left col-md-6">
    <h3 class="h3">От блога</h3>
    <?php 
$select_last_article = "SELECT * FROM articles WHERE date_deleteed IS NULL ORDER BY id_article DESC LIMIT 1";
$query_last_article = mysqli_query($connect, $select_last_article) or die(mysqli_error());
$row_last_article = mysqli_fetch_assoc($query_last_article);
echo '<h3><a href="blog.php?category=' . $row_last_article['id_category'] . '&article=' . $row_last_article['id_article'] . '">' . $row_last_article['title_article'] . '</a></h3>';
echo shorter($row_last_article['text_article'], 1500);
?>

    <p><a type="button" class="btn btn-primary btn-xs" class="btn btn-primary btn-lg active" role="button" href="blog.php?category=<?php 
echo $row_last_article['id_category'];
?>
&article=<?php 
echo $row_last_article['id_article'];
?>
">Прочети повече</a></p>
    
    </div>
    <div class="left col-md-6">
        <h3 class="h3">Последни продукти</h3>
        <?php 
$select_last_added_product = "SELECT * FROM products WHERE content_photo IS NOT NULL AND date_deleted IS NULL ORDER BY id DESC LIMIT 6";
Beispiel #2
0
            echo '<div class="h3">Рецепти</div>';
            while ($r = mysqli_fetch_assoc($query_search)) {
                ?>
				
					<a class="rp" href="recipies.php?recipie=<?php 
                echo $r['id_food_type'];
                ?>
&view=<?php 
                echo $r['recp'];
                ?>
">
				    			<div class="rowps">
							    <table>
							    	<tr>
							    		<td><h4><?php 
                echo shorter($r['name'], 40);
                ?>
</h4></td>
							    	</tr>
							    	<tr>
								    	<td>
								    	<div class="hidps">
								    	<?php 
                if ($r['rcp']) {
                    echo '<img height="250" src="data:image/jpeg;base64,' . base64_encode($r['rcp']) . '"/> ';
                } else {
                    ?>
								    		<img width="250" src="images/default-placeholder.png" />	
								    	<?php 
                }
                ?>
Beispiel #3
0
            ?>



					<a class="rp" href="recipies.php?recipie=<?php 
            echo $row['rp_id_ft'];
            ?>
&view=<?php 
            echo $row['rp_id'];
            ?>
">
		    			<div class="rowps">
						    <table>
						    	<tr>
						    		<td><h4><?php 
            echo shorter($row['rp_name'], 40);
            ?>
</h4></td>
						    	</tr>
						    	<tr>
							    	<td>
							    	<div class="hidps">
							    	<?php 
            if ($row['rp_cp']) {
                echo '<img title="' . $row['rp_name'] . '" height="250" src="data:image/jpeg;base64,' . base64_encode($row['rp_cp']) . '"/> ';
            } else {
                ?>
							    		<img  title="<?php 
                echo $row['rp_name'];
                ?>
" width="250" src="images/default-placeholder.png" />	
Beispiel #4
0
            while ($r = mysqli_fetch_assoc($sql_article)) {
                ?>
			<div class="categories_article">
			
			        <h3><a href="?category=<?php 
                echo $_GET['category'];
                ?>
&article=<?php 
                echo $r['id_article'];
                ?>
"><?php 
                echo $r['title_article'];
                ?>
</a></h3>
			       <?php 
                echo shorter($r['text_article'], 150);
                ?>
			</div>


			<?php 
            }
        } else {
            echo 'Вижте другите категории';
        }
    }
    //echo '<div style="clear: both;"></div>';
    // опит за изкарване на статия
    if (isset($_GET['article'])) {
        $article_id = $_GET['article'];
        $select_one_article = "SELECT * FROM articles WHERE id_article = '{$article_id}'";