Forum PHP.pl

<?php

        ob_start();
        
        include_once '../include/headers.php';
        include_once '../include/classes/mysql.class.php';
        include_once '../include/functions_de.php';
        
        print file_get_contents('../include/html/header.html');
        
        ?>

<?php
                        
                                $operation = new OperationsMySQL();
                                $operation->connect();
                                
                                if(!isset($_GET['id']))
                                
                                {
echo '<div class="small_news">';                
                $query = "SELECT id, regdate, title, info_small FROM newsesde WHERE visible = '1' AND (regdate >= '" . date('Y-m-d') . "'
OR regdate <= regdate_end AND regdate_end >= '" . date('Y-m-d') . "')  ORDER BY regdate ASC LIMIT 9";
                $operation->execute_query($query);
    
               while($row = $operation->fetch_object())                
                {
                print '<div class="top_news">' . "\n";
                        if(file_exists('../admin-news-de/news-images/' . $row->id . '.jpg'))
                        {
                        
                        print '
<div class="imgs" >
    <table height="161" align="center" width="100%">
        <tr>
            <td align="center" valign="middle" class="img_block"><img src="../admin-news-de/news-images/' . $row->id . '.jpg" alt="" /></td>
        </tr>
    </table>
</div>';
                        
                        }
                        
                        print '
                        <p class="news_date" style="margin-bottom: 10px; width: 250px;">
                        ' . date('d.m.Y', strtotime($row->regdate)) . '</p>' . "\n";
                        print '                                                
                        <p class="title_top">';
                      echo '  <a href="?id=' . $row->id . '">' . $row->title . '</a></p>';
                        
                        
                        print '                                        
                        </div>' . "\n";
                        
                        $last_date = $row -> regdate;
                }
                
             $operation->free_result();
    echo '</div>';
    
    if($last_date < date('Y-m-d')){$last_date = date('Y-m-d');}
    
                                                echo $output;
                                                print '                                        <hr id="news_line" />' . "\n";
                                                $query2 = "SELECT id, regdate, title, info_small FROM newsesde WHERE visible = '1'
AND (regdate >= '" . date('Y-m-d') . "' OR regdate <= regdate_end AND regdate_end >= '" . date('Y-m-d') . "')  ORDER BY regdate ASC LIMIT 9";
                                                $operation->execute_query($query2);
                                                
                                                print '<p style="clear: both;"></p>';
                                                print '                                        <ul class="ul_no_list ">' . "\n";
                                                $output="";
                                                $news = 0;
                                                while($row = $operation->fetch_array())
                                                {
                                                    if($news > 9){
                                                    extract($row);
                                                        $output .= '                                                        <li class="regdate">' . date('d.m.Y', strtotime($regdate)) . '</li>                                                        
<li class="title"><a href="?id=' . $id . '">' . $title . '</a></li>                                                        <li class="info_small">' . $info_small . '</li>';
                                                    }
                                                    $news++;
                                                }
                                                echo $output;
                                                print '                                                </ul>' . "\n";
                                                }
                                        else
                                        {
                                        $query = sprintf("SELECT id, regdate, title, info_small, info FROM newsesde WHERE id = '%d' AND visible = '1' LIMIT 1", mysql_real_escape_string($_GET['id']));
                                                $operation->execute_query($query);
                                                $row = $operation->fetch_object();
                                                
                                                print '<p id="news_date_p"><span class="news_date">' . date('d.m.Y', strtotime($row->regdate)) . '</span></p>' . "\n";
                                                print '                                        <p class="text_link">' . $row->title . '</p>' . "\n";
                                                print '                                        <p class="text_normal">' . nl2br($row->info) . '</p>';
                                                print '                                        <p class="back"><a href="index.php">&lt;&lt; zurück</a></p>' . "\n";
                                        }
                        
                                        ?>