ΠΑΝΕΠΙΣΤΗΜΙΟ ΜΑΚΕΔΟΝΙΑΣ » Διαδικτυακή εφαρμογή για τη διαχείριση έργων μουσικής

<?php   

if(empty($problem))

{

        $day=date('d');

        $month=date('m');

          $query="SELECT id_art, name, photo FROM artists WHERE (day(birthdate)='$day' AND month(birthdate)='$month') ORDER BY name DESC LIMIT 5"; 

        $data=mysqli_query($con,$query);

        echo '<div class="fs1" style="position:relative;float:left;width:724px;min-height:150px;margin:0px 0px 10px 40px;padding-bottom:2px;">

    <div class="left stretchfont grad1" style="font-size:36px;color:#575757;margin-bottom:15px;width:722px;border:1px solid grey;padding:5px 0px;">

    <span class="left" style="margin-left:10px;">born today</span>

    </div>

        <div style="float:left;width:100%;border-bottom:1px dotted grey;padding:10px 0px 20px;">';

        if(mysqli_num_rows($data)>0)

        {

                while($row=mysqli_fetch_array($data))

                {

                        $filemtime = @filemtime($row['photo']);

                        $path=$row['photo'].'?'.$filemtime;

                        $path=preg_replace('/main/','small',$path);

                        echo '<div style="float:left;width:130px;margin-right:14px;">

                        <a href="artists.php?ida='.$row['id_art'].'"><img src="'.$path.'" draggable=false style="width:130px;border:1px solid grey;margin-bottom:5px;"/></a>

                        <div style="float:left;width:130px;font-size:12px;"><a class="myhover1" href="artists.php?ida='.$row['id_art'].'" style="padding:2px;text-align:center;color:black;">'.$row['name'].'</a></div></div>';

                }

        }

        else

        {

                echo '<h2 style="color:grey;">No birthday found for today.</h2>';

        }

        echo '</div><a class="myhover1" href="borntoday.php" style="float:left;padding:10px 0px 10px;text-align:left;">See more birthdays</a>

        </div>';

        mysqli_free_result($data);

}

?>