Hi bin neu und Anfänger.
Problem: bekomme bei Ausgabe von (mysql phpMyAdmin 2.6.3
Verbunden mit MySQL 4.0.18-nt auf localhost als root@localhost
unter php5) Bilder aus der Datenbank nur den Dateinamen des Bildes aber nicht das Bild.
Was muss ich noch machen?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Unbenanntes Dokument</title>
<style type="text/css">
<!--
.Stil1 {
font-family: "Copperplate Gothic Bold";
font-size: 24px;
color: #800000;
}
-->
</style>
<link href="but1.css" rel="stylesheet" type="text/css">
<link href="tex1.css" rel="stylesheet" type="text/css">
<link href="ausgabe1.css" rel="stylesheet" type="text/css">
<link href="ausgabe2.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#BFC2B5">
<?PHP
$teiler = 1;
$seitenzahlen = 19;
include_once("browser1.inc.php");
include_once("nav.inc.php");
include_once("db_verbindung.inc.php");
$arr_ergebnis = berechnung($teiler,"nummer","dvd");
$x = $arr_ergebnis[1];
$seiten = $arr_ergebnis[0];
$result = mysql_query("SELECT id,headl,text,foto FROM news ORDER BY id desc limit $x,$teiler")or die(mysql_error());
if(mysql_num_rows($result)>0){
while($arr_zeige = mysql_fetch_assoc($result)){
$id = $arr_zeige["id"];
$headl = $arr_zeige["headl"];
$text = $arr_zeige["text"];
$foto = $arr_zeige["foto"];
$id = htmlentities($id);
$headl = htmlentities($headl);
$text = nl2br(htmlentities($text));
$foto = htmlentities($foto);
?>
<table align="center" width="400" border="6">
<tr>
<th scope="col"><img src="img/logo.jpg" width="500" height="80"></th>
</tr>
</table>
<table align="center" width="400" border="6">
<tr>
<td><p> <object classid="clsid
27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="110" height="25">
<param name="movie" value="button1.swf">
<param name="quality" value="high">
<param name="bgcolor" value="#CCCCCC">
<embed src="button1.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="110" height="25" bgcolor="#CCCCCC"></embed>
</object>
</p></td>
<td><p> <object classid="clsid
27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="110" height="25">
<param name="movie" value="button2.swf">
<param name="quality" value="high">
<param name="bgcolor" value="#CCCCCC">
<embed src="button2.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="110" height="25" bgcolor="#CCCCCC"></embed>
</object>
</p></td>
<td><p> <object classid="clsid
27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="110" height="25">
<param name="movie" value="button3.swf">
<param name="quality" value="high">
<param name="bgcolor" value="#CCCCCC">
<embed src="button3.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="110" height="25" bgcolor="#CCCCCC"></embed>
</object>
</p></td>
<td><p> <object classid="clsid
27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="110" height="25">
<param name="movie" value="button4.swf">
<param name="quality" value="high">
<param name="bgcolor" value="#CCCCCC">
<embed src="button4.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="110" height="25" bgcolor="#CCCCCC"></embed>
</object>
</p></td>
<td><p>
<object classid="clsid
27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="110" height="25">
<param name="movie" value="button5.swf">
<param name="quality" value="high">
<param name="bgcolor" value="#CCCCCC">
<embed src="button5.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="110" height="25" bgcolor="#CCCCCC"></embed>
</object>
</p></td>
<td><p> <object classid="clsid
27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="110" height="25">
<param name="movie" value="button6.swf">
<param name="quality" value="high">
<param name="bgcolor" value="#CCCCCC">
<embed src="button6.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="110" height="25" bgcolor="#CCCCCC"></embed>
</object>
</p></td>
</tr>
</table>
<table align="left" width="4" border="6">
<tr>
<td align="center" bordercolor="#ECE9D8" bgcolor="#BFC2B5">
<p class="Stil1">F</p>
<p class="Stil1">i</p>
<p class="Stil1">l</p>
<p class="Stil1">m</p>
<p class="Stil1">a</p>
<p class="Stil1">u</p>
<p class="Stil1">s</p>
<p class="Stil1">g</p>
<p class="Stil1">a</p>
<p class="Stil1">b</p>
<p class="Stil1">e</p></td>
</tr>
</table>
<form name="form1" method="post" action="">
<table align="center" width="200" border="6" class="ausgabe1">
<tr>
<td>
<?PHP echo "<center><b>Nummer: </b>".$id."</center><br>";?>
</td>
<td>
<?PHP echo "<center><b>Name des Bildes: </b>".$headl."</center><br>";?>
</td>
<td>
<?PHP echo "<center><b>Bildbeschreibung: </b>".$text."</center><br>";?>
</td>
<td>
<!-- <input align="middle" value="Foto" size="30"> -->
<?PHP echo "<center><b>Bildbeschreibung: </b>".$foto."</center><br>";?>
<input align="middle" value="Foto" size="30" name="foto" type="image" scr="<?PHP //if(isset($foto)) echo stripslashes($foto); ?>">
<?PHP//echo "<center><b>Foto: </b>".$foto."</center><br>";?>
</td>
</tr>
</table>
<table align="center" width="200" border="6" class="ausgabe2">
<tr>
<td><?PHP echo "<br><center><a href='filmaendernnew.php?nummer=".$nummer."'target='_self'>ändern</a></center> "; ?></td>
<td><?PHP echo "<br><center><a href='".$_SERVER['PHP_SELF']."?nummer=".$nummer."'target='_self'>löschen</a></center> "; ?></td>
</tr>
</table>
<?PHP
}
}
else{
echo "leider keine Daten vorhanden";
}
if($seiten>1){
seitenzaehler($seitenzahlen,$seiten);
}
?>
</form>
</body>
</html>
hier mein Script.
Danke für eine Antwort
Erwin
Problem: bekomme bei Ausgabe von (mysql phpMyAdmin 2.6.3
Verbunden mit MySQL 4.0.18-nt auf localhost als root@localhost
unter php5) Bilder aus der Datenbank nur den Dateinamen des Bildes aber nicht das Bild.
Was muss ich noch machen?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Unbenanntes Dokument</title>
<style type="text/css">
<!--
.Stil1 {
font-family: "Copperplate Gothic Bold";
font-size: 24px;
color: #800000;
}
-->
</style>
<link href="but1.css" rel="stylesheet" type="text/css">
<link href="tex1.css" rel="stylesheet" type="text/css">
<link href="ausgabe1.css" rel="stylesheet" type="text/css">
<link href="ausgabe2.css" rel="stylesheet" type="text/css">
</head>
<body bgcolor="#BFC2B5">
<?PHP
$teiler = 1;
$seitenzahlen = 19;
include_once("browser1.inc.php");
include_once("nav.inc.php");
include_once("db_verbindung.inc.php");
$arr_ergebnis = berechnung($teiler,"nummer","dvd");
$x = $arr_ergebnis[1];
$seiten = $arr_ergebnis[0];
$result = mysql_query("SELECT id,headl,text,foto FROM news ORDER BY id desc limit $x,$teiler")or die(mysql_error());
if(mysql_num_rows($result)>0){
while($arr_zeige = mysql_fetch_assoc($result)){
$id = $arr_zeige["id"];
$headl = $arr_zeige["headl"];
$text = $arr_zeige["text"];
$foto = $arr_zeige["foto"];
$id = htmlentities($id);
$headl = htmlentities($headl);
$text = nl2br(htmlentities($text));
$foto = htmlentities($foto);
?>
<table align="center" width="400" border="6">
<tr>
<th scope="col"><img src="img/logo.jpg" width="500" height="80"></th>
</tr>
</table>
<table align="center" width="400" border="6">
<tr>
<td><p> <object classid="clsid
![Big Grin](https://www.php-resource.de/forum/core/images/smilies/biggrin.gif)
<param name="movie" value="button1.swf">
<param name="quality" value="high">
<param name="bgcolor" value="#CCCCCC">
<embed src="button1.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="110" height="25" bgcolor="#CCCCCC"></embed>
</object>
</p></td>
<td><p> <object classid="clsid
![Big Grin](https://www.php-resource.de/forum/core/images/smilies/biggrin.gif)
<param name="movie" value="button2.swf">
<param name="quality" value="high">
<param name="bgcolor" value="#CCCCCC">
<embed src="button2.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="110" height="25" bgcolor="#CCCCCC"></embed>
</object>
</p></td>
<td><p> <object classid="clsid
![Big Grin](https://www.php-resource.de/forum/core/images/smilies/biggrin.gif)
<param name="movie" value="button3.swf">
<param name="quality" value="high">
<param name="bgcolor" value="#CCCCCC">
<embed src="button3.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="110" height="25" bgcolor="#CCCCCC"></embed>
</object>
</p></td>
<td><p> <object classid="clsid
![Big Grin](https://www.php-resource.de/forum/core/images/smilies/biggrin.gif)
<param name="movie" value="button4.swf">
<param name="quality" value="high">
<param name="bgcolor" value="#CCCCCC">
<embed src="button4.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="110" height="25" bgcolor="#CCCCCC"></embed>
</object>
</p></td>
<td><p>
<object classid="clsid
![Big Grin](https://www.php-resource.de/forum/core/images/smilies/biggrin.gif)
<param name="movie" value="button5.swf">
<param name="quality" value="high">
<param name="bgcolor" value="#CCCCCC">
<embed src="button5.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="110" height="25" bgcolor="#CCCCCC"></embed>
</object>
</p></td>
<td><p> <object classid="clsid
![Big Grin](https://www.php-resource.de/forum/core/images/smilies/biggrin.gif)
<param name="movie" value="button6.swf">
<param name="quality" value="high">
<param name="bgcolor" value="#CCCCCC">
<embed src="button6.swf" quality="high" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="110" height="25" bgcolor="#CCCCCC"></embed>
</object>
</p></td>
</tr>
</table>
<table align="left" width="4" border="6">
<tr>
<td align="center" bordercolor="#ECE9D8" bgcolor="#BFC2B5">
<p class="Stil1">F</p>
<p class="Stil1">i</p>
<p class="Stil1">l</p>
<p class="Stil1">m</p>
<p class="Stil1">a</p>
<p class="Stil1">u</p>
<p class="Stil1">s</p>
<p class="Stil1">g</p>
<p class="Stil1">a</p>
<p class="Stil1">b</p>
<p class="Stil1">e</p></td>
</tr>
</table>
<form name="form1" method="post" action="">
<table align="center" width="200" border="6" class="ausgabe1">
<tr>
<td>
<?PHP echo "<center><b>Nummer: </b>".$id."</center><br>";?>
</td>
<td>
<?PHP echo "<center><b>Name des Bildes: </b>".$headl."</center><br>";?>
</td>
<td>
<?PHP echo "<center><b>Bildbeschreibung: </b>".$text."</center><br>";?>
</td>
<td>
<!-- <input align="middle" value="Foto" size="30"> -->
<?PHP echo "<center><b>Bildbeschreibung: </b>".$foto."</center><br>";?>
<input align="middle" value="Foto" size="30" name="foto" type="image" scr="<?PHP //if(isset($foto)) echo stripslashes($foto); ?>">
<?PHP//echo "<center><b>Foto: </b>".$foto."</center><br>";?>
</td>
</tr>
</table>
<table align="center" width="200" border="6" class="ausgabe2">
<tr>
<td><?PHP echo "<br><center><a href='filmaendernnew.php?nummer=".$nummer."'target='_self'>ändern</a></center> "; ?></td>
<td><?PHP echo "<br><center><a href='".$_SERVER['PHP_SELF']."?nummer=".$nummer."'target='_self'>löschen</a></center> "; ?></td>
</tr>
</table>
<?PHP
}
}
else{
echo "leider keine Daten vorhanden";
}
if($seiten>1){
seitenzaehler($seitenzahlen,$seiten);
}
?>
</form>
</body>
</html>
hier mein Script.
Danke für eine Antwort
Erwin
Kommentar