Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require __DIR__ . '/vendor/autoload.php';
- $filterQuery = 'SELECT * FROM Kategorien';
- $produkteQuery = 'SELECT m.ID AS MahlzeitID, m.`Name`, m.Vorrat, m.Verfügbar, b.Titel, b.`Alt-Text`, b.`Binärdaten`, k.ID, z.ID, z.`Name` AS Zutatenname, IF(COUNT(m.ID)=SUM(z.Vegetarisch),1,0) AS IstVegetarisch, IF(COUNT(m.ID)=SUM(z.Vegan),1,0) AS IstVegan FROM Mahlzeiten m
- LEFT JOIN MhatB mhb ON m.ID = mhb.MahlzeitID
- LEFT JOIN Bilder b ON m.ID = b.ID
- LEFT JOIN Kategorien k ON k.ID = m.KategorienID
- LEFT JOIN MenthältZ mhz ON m.ID = mhz.MahlzeitID
- LEFT JOIN Zutaten z ON z.ID = mhz.ZutatenID'; // Ihre SQL Query aus HeidiSQL
- $dotenv = Dotenv\Dotenv::create(__DIR__,'db_daten.env');
- $dotenv->load();
- $dotenv->required(['DB_HOST', 'DB_NAME', 'DB_USER', 'DB_PASS','DB_PORT']);
- $remoteConnection = mysqli_connect( getenv('DB_HOST'), getenv('DB_USER'), getenv('DB_PASS'), getenv('DB_NAME'), (int) getenv('DB_PORT'));
- if (mysqli_connect_errno()) {
- printf("Konnte nicht zur entfernten Datenbank verbinden: %s\n", mysqli_connect_error());
- exit();
- }
- if(isset($_GET['category']) && $_GET['category'] != 11) {
- $produkteQuery = $produkteQuery . " WHERE k.ID = " . '"' . $_GET['category'] . '"';
- if(isset($_GET['avail']) && $_GET['avail'] == 1)
- $produkteQuery = $produkteQuery . " AND m.Verfügbar = " . $_GET['avail'];
- } else {
- if(isset($_GET['avail']) && $_GET['avail'] == 1)
- $produkteQuery = $produkteQuery . " WHERE m.Verfügbar = " . $_GET['avail'];
- }
- $produkteQuery= $produkteQuery . " GROUP BY m.ID";
- if(isset($_GET['vegetarisch']) && $_GET['vegetarisch'] == 1) {
- $produkteQuery = $produkteQuery . " HAVING IstVegetarisch = " . $_GET['vegetarisch'];
- if(isset($_GET['vegan']) && $_GET['vegan'] == 1) {
- $produkteQuery = $produkteQuery . " AND IstVegan = " . $_GET['vegan'];
- }
- } else {
- if(isset($_GET['vegan']) && $_GET['vegan'] == 1) {
- $produkteQuery = $produkteQuery . " HAVING IstVegan = " . $_GET['vegan'];
- }
- }
- if(isset($_GET['limit']))
- $produkteQuery = $produkteQuery . " LIMIT " . $_GET['limit'];
- $filterResult = mysqli_query($remoteConnection, $filterQuery);
- $filterResult2 = mysqli_query($remoteConnection, $filterQuery);
- $produkteResult = mysqli_query($remoteConnection, $produkteQuery);
- mysqli_close($remoteConnection); // daran denken, die Verbindung wieder zu schließen wenn sie nicht mehr benötigt ist.
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement