public static function getKategoriePN() { $kategorie = MassagesModel::getCategories(); $kat = array(); $i = 1; foreach ($kategorie as $ka) { $kat[$i] = MassagesModel::title2pagename($ka['nazev']); $i++; } return $kat; }
/** * vrati url k masazi */ public static function returnURL($id) { $pdo = Db_Data::getPDO(); $sqlMasaz = "SELECT * FROM masaze WHERE id_masaze = " . $id; $q = $pdo->prepare($sqlMasaz); $q->execute(); $masaz = $q->fetchAll(); $sqlKategorie = "SELECT * FROM kategorie_masazi WHERE id_kategorie = " . $masaz[0]['id_kategorie']; $r = $pdo->prepare($sqlKategorie); $r->execute(); $kategorie = $r->fetchAll(); return MassagesModel::title2pagename($kategorie[0]['nazev']) . '#idMasaze' . $masaz[0]['id_kategorie']; }