ich möchte Daten aus den 4 Reihen der Tabelle. While Hilft da nicht wirklich da immer ein etwas anderer HTML-Code die Daten umgibt.
Der Code sieht wie folgt aus
- Code: Select all
<nav id="navigation" class="navigation">
<div>
<a href="index.html">Home</a>
<a href="Anime.html">Animes</a>
<a href="">Anime Scenes</a>
<a href="">AMV</a>
<a href="">Previews</a>
</div>
</nav>
<div class="outer">
<h1>Last uploaded:</h1>
<div class="content">
<div class="container-fluid">
<div class="row justify-content-center">
<?php include ("data_con.php");
$conn = new mysqli($servername, $username, $password, $db);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT `Dateipfad`, `Titel` FROM last_upload WHERE `ID` = 1 ";
$result = $conn->query($sql)
or die ("MySQL-Error: " . $conn->error);
if ($result->num_rows >0) {
while ($row = mysqli_fetch_assoc($result)){ ?>
<div class="col-xs-5 col-sm-5 col-md-5 col-lg-5 no-gutter">
<div class="rahmen"> <img src="<?php echo $row['Dateipfad']; ?>" class="img-fluid" alt="Responsive image" width="100%";>
<p><?php echo $row['Titel']?></p>
</div>
</div>
<?php }
} else {
echo "Scheiße";
}
$conn->close();
echo "Connected successfully"; ?>
<div class="col-xs-5 col-xs-offset-2 col-sm-5 col-sm-offset-2 col-md-5 col-md-offset-2 col-lg-5 col-lg-offset-2 no-gutter" >
<div class="rahmen"> <img src="Pic/Op.jpg" class="img-fluid" alt="Responsive image" width="100%;">
<p>Manga Episode 2</p></div>
</div>
</div>
</div>
<br>
<div class="container-fluid">
<div class="row justify-content-center">
<div class="col-xs-5 col-sm-5 col-md-5 col-lg-5 no-gutter">
<div class="rahmen"> <img src="Pic/Background.jpg" class="img-fluid" alt="Responsive image" width="100%;">
<p>Manga Episode 3</p> </div>
</div>
<div class="col-xs-5 col-xs-offset-2 col-sm-5 col-sm-offset-2 col-md-5 col-md-offset-2 col-lg-5 col-lg-offset-2 no-gutter">
<div class="rahmen"><img src="Background.jpg" class="img-fluid" alt="Responsive image" width="100%;">
<p>Manga Episode 4</p></div>
</div>
</div>
</div>
</div>
</div>
Ich kann es leider nicht 4 mal wiederholen lassen, da der Code sich immer leicht unterscheidet: Mal offset und dann mal ohne.
Es würde wie folgt funktionieren:
- Code: Select all
<nav id="navigation" class="navigation">
<div>
<a href="index.html">Home</a>
<a href="Anime.html">Animes</a>
<a href="">Anime Scenes</a>
<a href="">AMV</a>
<a href="">Previews</a>
</div>
</nav>
<div class="outer">
<h1>Last uploaded:</h1>
<div class="content">
<div class="container-fluid">
<div class="row justify-content-center">
<?php include ("data_con.php");
$conn = new mysqli($servername, $username, $password, $db);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT `Dateipfad`, `Titel` FROM last_upload WHERE `ID` = 1 ";
$result = $conn->query($sql)
or die ("MySQL-Error: " . $conn->error);
if ($result->num_rows >0) {
while ($row = mysqli_fetch_assoc($result)){ ?>
<div class="col-xs-5 col-sm-5 col-md-5 col-lg-5 no-gutter">
<div class="rahmen"> <img src="<?php echo $row['Dateipfad']; ?>" class="img-fluid" alt="Responsive image" width="100%";>
<p><?php echo $row['Titel'] ?></p>
</div>
</div>
<?php }
} else {
echo "Scheiße";
}
$conn->close();
echo "Connected successfully"; ?>
<?php include ("data_con.php");
$conn = new mysqli($servername, $username, $password, $db);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT `Dateipfad`, `Titel` FROM last_upload WHERE `ID` = 2 ";
$result = $conn->query($sql)
or die ("MySQL-Error: " . $conn->error);
if ($result->num_rows >0) {
while ($row = mysqli_fetch_assoc($result)){ ?>
<div class="col-xs-5 col-xs-offset-2 col-sm-5 col-sm-offset-2 col-md-5 col-md-offset-2 col-lg-5 col-lg-offset-2 no-gutter" >
<div class="rahmen"> <img src="<?php echo $row['Dateipfad']; ?>" class="img-fluid" alt="Responsive image" width="100%;">
<p><?php echo $row['Titel']?></p></div>
</div>
</div>
</div>
<?php }
} else {
echo "Scheiße";
}
$conn->close();
echo "Connected successfully"; ?>
<br>
<div class="container-fluid">
<div class="row justify-content-center">
<div class="col-xs-5 col-sm-5 col-md-5 col-lg-5 no-gutter">
<?php include ("data_con.php");
$conn = new mysqli($servername, $username, $password, $db);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT `Dateipfad`, `Titel` FROM last_upload WHERE `ID` = 3 ";
$result = $conn->query($sql)
or die ("MySQL-Error: " . $conn->error);
if ($result->num_rows >0) {
while ($row = mysqli_fetch_assoc($result)){ ?>
<div class="rahmen"> <img src="<?php echo $row['Dateipfad']; ?>" class="img-fluid" alt="Responsive image" width="100%;">
<p><?php echo $row['Titel'] ?></p> </div>
</div>
<?php }
} else {
echo "Scheiße";
}
$conn->close();
echo "Connected successfully"; ?>
<?php include ("data_con.php");
$conn = new mysqli($servername, $username, $password, $db);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT `Dateipfad`, `Titel` FROM last_upload WHERE `ID` = 4 ";
$result = $conn->query($sql)
or die ("MySQL-Error: " . $conn->error);
if ($result->num_rows >0) {
while ($row = mysqli_fetch_assoc($result)){ ?>
<div class="col-xs-5 col-xs-offset-2 col-sm-5 col-sm-offset-2 col-md-5 col-md-offset-2 col-lg-5 col-lg-offset-2 no-gutter">
<div class="rahmen"><img src="<?php echo $row['Dateipfad']; ?>" class="img-fluid" alt="Responsive image" width="100%;">
<p><?php echo $row['Titel'] ?></p></div>
</div>
</div>
</div>
<?php }
} else {
echo "Scheiße";
}
$conn->close();
echo "Connected successfully"; ?>
Aber 4x eine Verbindung mit der Datenbank aufzubauen ist schon heftig. Habt ihr eine Idee oder geht es nicht anders?