//$baza = new SQLiteDatabase("/sqlite/ukulele");//sqlite_open("sqlite/ukulele");
include_once "/includes/autoload.inc.php";
//
$db = new Connect();
$conn = $db->polacz();
$wyc = $conn->query("SELECT genre, COUNT(*) tyle FROM spiewnik GROUP BY genre Order By genre Asc");//sqlite_query($baza,"SELECT genre,COUNT(*) FROM spiewnik GROUP BY genre Order By genre Asc");
$dane = $wyc->fetchAll();//sqlite_fetch_all($wyc);
foreach($dane as $wynik){
?>
[]
}
//
//sqlite_close($baza);
?>
Pojedyńcze utwory:
//$baza = new SQLiteDatabase("/sqlite/ukulele");//sqlite_open("sqlite/ukulele"); $wyc = $conn->query("SELECT * FROM spiewnik WHERE plik_type = 'pdf' ORDER BY title ASC");//sqlite_query($baza,"SELECT * FROM spiewnik WHERE plik_type = 'pdf' ORDER BY title ASC"); //sqlite_close($baza); $dane = $wyc->fetchAll();//sqlite_fetch_all($wyc); foreach($dane as $wynik){ ?>
//$baza = new SQLiteDatabase("/sqlite/ukulele");//sqlite_open("sqlite/ukulele"); $wyc = $conn->query("SELECT * FROM spiewnik WHERE plik_type = 'pdf' ORDER BY title ASC");//sqlite_query($baza,"SELECT * FROM spiewnik WHERE plik_type = 'pdf' ORDER BY title ASC"); //sqlite_close($baza); $dane = $wyc->fetchAll();//sqlite_fetch_all($wyc); foreach($dane as $wynik){ ?>
if(!file_exists("spiewnik/".$wynik["link"])){
echo " ×";
}
?>
-
}
//
?>
![](/images/.gif)
Songbooki, kradzione:
//$baza = sqlite_open("sqlite/ukulele"); $wyc = $conn->query("SELECT * FROM spiewnik WHERE plik_type = 'songbook' ORDER BY title ASC"); $dane = $wyc->fetchAll(); //sqlite_close($baza); foreach($dane as $wynik){ ?> } // ?>
//$baza = sqlite_open("sqlite/ukulele"); $wyc = $conn->query("SELECT * FROM spiewnik WHERE plik_type = 'songbook' ORDER BY title ASC"); $dane = $wyc->fetchAll(); //sqlite_close($baza); foreach($dane as $wynik){ ?> } // ?>
Linki zewnetrzne:
// $baza = new SQLiteDatabase("sqlite/ukulele"); $wyc = $conn->query("SELECT * FROM spiewnik WHERE plik_type = 'www' ORDER BY title ASC");//sqlite_query($baza,"SELECT * FROM spiewnik WHERE plik_type = 'www' ORDER BY title ASC"); //sqlite_close($baza); $dane = $wyc->fetchAll();//sqlite_fetch_all($wyc); foreach($dane as $wynik){ echo "
" . $wynik["title"] . " - " . $wynik["band"] . " - " . $wynik["genre"] . "";
}
//
?>
// $baza = new SQLiteDatabase("sqlite/ukulele"); $wyc = $conn->query("SELECT * FROM spiewnik WHERE plik_type = 'www' ORDER BY title ASC");//sqlite_query($baza,"SELECT * FROM spiewnik WHERE plik_type = 'www' ORDER BY title ASC"); //sqlite_close($baza); $dane = $wyc->fetchAll();//sqlite_fetch_all($wyc); foreach($dane as $wynik){ echo "
![\""](images/" . $wynik["plik_type"] . ".gif)