Mój index
<? ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <html> <head> <? include("config.php"); include("libs/db.class.php"); $db = new DB(); include("libs/core.class.php"); $c = new core($db); include("function.inc.php"); $f = new functions($db); ?> <base href="" /> <meta name="Keywords" content="" /> <meta name="description" content="" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="stylesheet" href="css/style.css" type="text/css"> <link rel="stylesheet" type="text/css" href="css/imageScroller.css"> <link rel="stylesheet" href="css/style_box.css" type="text/css" media="screen" charset="utf-8"> <script src="js/jquery-1.3.1.min.js" type="text/javascript" charset="utf-8"></script> <script src="js/slider.js" type="text/javascript" charset="utf-8"></script> </head> <title></title> <body> <div id="cont"> <div id="img2"></div> <div id="img4"> <div class="m_c"> <div class="chromestyle" id="chromemenu"> <ul> <li><a href="index">Strona główna</a></li> <li><a href="filmy">Filmy</a></li> <li><a href="seriale">Seriale</a></li> <li><a href="dodaj">Dodaj film</a></li> <li><a href="konto">Moje konto</a></li> </ul> </div> </div> </div> <? if($page == 'index' or $page == '') { ?> <div id="img5"></div> <div id="img6"></div> <div id="img7"> <div class="m_d"> <div id="outerContainer"> <div id="imageScroller"> <div id="viewer" class="js-disabled"> <? $f->movies(); ?> </div> </div> </div> </div> </div> <div id="img8"></div> <div id="img9"></div> <div id="img10"></div> <div id="img11"></div> <div id="img12"></div> <div id="img13" class="scrollButtons left"></div> <div id="img14"><? $f->show_las_movies(); ?></div> <div id="img15" class="scrollButtons right"></div> <div id="img16"></div> <div id="img17"></div> <div id="img21"></div> <div id="img22"></div> <div id="img23"></div> <div id="img24"></div> <div id="img26"></div> <div id="img25"></div> <div id="img27"></div> <? } else { ?> <div id="tlo"> <? $c->select_page($page); ?> </div> <? } ?> </div>
funkcje
<? class functions{ public function __construct($sql) { $this->sql = $sql; include('libs/DBManager.class.php'); $dbm = new DBManager($this->sql = $sql); //var_dump($dbm); } public function movies() { // $dbm->select("description","video")->from("videos")->where("id=1")->limit(1)->result(); $sql = $this->sql->query('select video, description, title, cover, data, category, id from videos'); while($row = $sql->fetch_array()) { ?> <a class="wrapper" href="http://www.apple.com" title="<?=$row[title];?>"> <img class="logo" id="<?=$row[title];?>" src="<?=$row[cover];?>" alt="<?=$row[title];?>"></a> <? } } public function show_las_movies() { $sql = $this->sql->query('select video, description, title, cover, data, category, id from videos'); ?> <div id="wrapper"> <div id="slider"> <div style="overflow: hidden;" class="scroll"> <div class="scrollContainer"> <? while($row = $sql->fetch_array()) { ?> <div class="panel"> <img class="logo" id="<?=$row[title];?>" src="<?=$row[cover];?>" alt="<?=$row[title];?>"></a> </div> <div class="panel" > <img class="logo" id="<?=$row[title];?>" src="<?=$row[cover];?>" alt="<?=$row[title];?>"></a> </div> <div class="panel" > <img class="logo" id="<?=$row[title];?>" src="<?=$row[cover];?>" alt="<?=$row[title];?>"></a> </div> <div class="panel" > <img class="logo" id="<?=$row[title];?>" src="<?=$row[cover];?>" alt="<?=$row[title];?>"></a> </div> <? } ?> </div> </div> </div> </div><? } }