Advertisement
Guest User

Untitled

a guest
Jan 13th, 2016
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.06 KB | None | 0 0
  1. <html>
  2.     <head>
  3.     </head>
  4.     <body>
  5.         <?php
  6.             $host = 'ra-ms.ru';
  7.             $user = 'u0018_me';
  8.             $pass = '545537';
  9.             $db = 'u0018154_my_db';
  10.  
  11.             include 'safemysql.class.php';
  12.  
  13.             $db = new SafeMysql(array('host' => $host, 'user' => $user, 'pass' => $pass, 'db' => $db, 'charset' => 'UTF8'));
  14.  
  15.             $events = $db -> getAll("SELECT * FROM events ORDER BY event_date");
  16.            
  17.             for($i = 0; $i < count($events); $i++){
  18.                 $curr_date = $events[$i]["event_date"];
  19.                 $dj = ($db -> getCol("SELECT `dj_alias` FROM `djs` WHERE `date` = ?s", $curr_date));
  20.                 $dj = $dj[0];
  21.                 echo    '<div style="font-size: 50px">' . $events[$i]["title"] . '</div>'.
  22.                         '<div style="font-size: 50px">' . $curr_date . '</div>'.
  23.                         '<div style="font-size: 40px">' . (count($dj) > 0 ? "Диджей: ".$dj : "") . '</div>'.
  24.                         '<div style="font-size: 30px">' . $events[$i]["description"] . '</div>';
  25.                 echo '<hr>';   
  26.             }
  27.        
  28.             $djs = $db -> getCol("SELECT * FROM djs WHERE date = ?s", $curr_date);
  29.             echo('<div style="font-size: 50px">' . $djs[0] . '</div>');
  30.         ?>
  31.     </body>
  32. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement