Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- </head>
- <body>
- <?php
- $host = 'ra-ms.ru';
- $user = 'u0018_me';
- $pass = '545537';
- $db = 'u0018154_my_db';
- include 'safemysql.class.php';
- $db = new SafeMysql(array('host' => $host, 'user' => $user, 'pass' => $pass, 'db' => $db, 'charset' => 'UTF8'));
- $events = $db -> getAll("SELECT * FROM events ORDER BY event_date");
- for($i = 0; $i < count($events); $i++){
- $curr_date = $events[$i]["event_date"];
- $dj = ($db -> getCol("SELECT `dj_alias` FROM `djs` WHERE `date` = ?s", $curr_date));
- $dj = $dj[0];
- echo '<div style="font-size: 50px">' . $events[$i]["title"] . '</div>'.
- '<div style="font-size: 50px">' . $curr_date . '</div>'.
- '<div style="font-size: 40px">' . (count($dj) > 0 ? "Диджей: ".$dj : "") . '</div>'.
- '<div style="font-size: 30px">' . $events[$i]["description"] . '</div>';
- echo '<hr>';
- }
- $djs = $db -> getCol("SELECT * FROM djs WHERE date = ?s", $curr_date);
- echo('<div style="font-size: 50px">' . $djs[0] . '</div>');
- ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement