mzeem
Erfahrenes Mitglied
Hi Leute ich mal wieder *GRRIIIINS*
Könnt Ihr mir sagen wie ich ein Bild-Upload in mein GB einplanzen kann so sieht mein GB aus:
<?
//SQL-Einstellungen
mysql_pconnect("blabla.de","www.blabla.de","94741111224");
mysql_select_db("DBBLABLA");
if (($submit) AND ($name!="") AND ($eintrag!="")) {
$date = date("d/m/y");
$result=MYSQL_QUERY("INSERT INTO gaestebuchmzeem (id,name,email,homepage,eintrag,date)".
"VALUES ('NULL', '$name', '$email', '$homepage', '$eintrag', '$date')");
};
$result = mysql_query("select * from gaestebuchmzeem order by id desc");
if(!$rowstart) $rowstart=0;
$result = mysql_query("select * from gaestebuchmzeem order by id desc limit $rowstart,100");
$result2 = mysql_query("select * from gaestebuchmzeem");
?>
<table width="469" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="367" valign="top" rowspan="2">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="365" height="10" valign="top">
<p><b><img src="gfx/pfeil2.gif" width="10" height="10"> Gaestebuch::.</b>
<table border="0" cellspacing="0" cellpadding="0" height="10">
<tr>
<form method="post" action="<? echo $php_self ?>">
<td valign="top" width="367" align="right" height="10">
<p>
<input type="text" name="name" size="10" value="name">
<input type="text" name="email" size="10" value="email">
<input type="text" name="homepage" size="10" value="homepage">
<br>
<textarea name="eintrag" cols="57" rows="2"></textarea>
<br>
<input type="submit" name="submit" value="sag es">
<br>
<br>
</p>
</td>
</form>
</tr>
</table>
</td>
</tr>
<tr>
<td height="1"></td>
</tr>
<tr>
<td height="1" valign="top">
<?
while($r=mysql_fetch_array($result))
{
$name=$r["name"];
$name=wordwrap($name, 13, "<br>", 1); // 1)
$name=strip_tags($name,"<br>");
$email=$r["email"];
$homepage=$r["homepage"];
$eintrag=$r["eintrag"];
$eintrag=wordwrap($eintrag, 60, "<br>", 1); // 1)
$eintrag=strip_tags($eintrag,"<br>");
$id=$r["id"];
?>
</td>
</tr>
<tr>
<td height="36" valign="top">
<table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#000000">
<tr>
<td height="5" width="363" valign="top" bgcolor="#E7E6C7">
<p><img src="gfx/pfeil.gif" width="10" height="10">
<? echo" $id.$name"; ?>
<a href="<? echo "mailto:$email"; ?>">E-Mail </a><a href="http://<? echo"$homepage"; ?>" target="_blank">HP</a></p>
</td>
</tr>
<tr>
<td height="10" valign="top" bgcolor="#D3D2B3"><font face="verdana" size="1">
<? echo " $eintrag"; ?>
</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="10" valign="top"> <br>
<br>
<? }
?>
<?
echo " $id";
if ($rowstart>$numrows)
{?>
<a href="<? $php_self ?>?rowstart=<? echo $rowstart-100;?>"><font face="verdana"><
Neue Einträge</font></a><font face="verdana">
<?}?>
<br>
</font>
<?
$numrows=mysql_num_rows($result2);
if($rowstart+100<$numrows)
{?>
<a href="<? $php_self?>?rowstart=<?echo $rowstart+100 ;?>"><font face="verdana">Ältere
Einträge></font></a>
<? } ?>
</td>
</tr>
</table>
</td>
<td width="7" height="18"></td>
<td width="95" valign="top">
<?
include("box.php");
?>
</td>
</tr>
<tr>
<td height="246"></td>
<td></td>
</tr>
</table>
DANKE ) cu Sascha M.
Könnt Ihr mir sagen wie ich ein Bild-Upload in mein GB einplanzen kann so sieht mein GB aus:
<?
//SQL-Einstellungen
mysql_pconnect("blabla.de","www.blabla.de","94741111224");
mysql_select_db("DBBLABLA");
if (($submit) AND ($name!="") AND ($eintrag!="")) {
$date = date("d/m/y");
$result=MYSQL_QUERY("INSERT INTO gaestebuchmzeem (id,name,email,homepage,eintrag,date)".
"VALUES ('NULL', '$name', '$email', '$homepage', '$eintrag', '$date')");
};
$result = mysql_query("select * from gaestebuchmzeem order by id desc");
if(!$rowstart) $rowstart=0;
$result = mysql_query("select * from gaestebuchmzeem order by id desc limit $rowstart,100");
$result2 = mysql_query("select * from gaestebuchmzeem");
?>
<table width="469" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="367" valign="top" rowspan="2">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="365" height="10" valign="top">
<p><b><img src="gfx/pfeil2.gif" width="10" height="10"> Gaestebuch::.</b>
<table border="0" cellspacing="0" cellpadding="0" height="10">
<tr>
<form method="post" action="<? echo $php_self ?>">
<td valign="top" width="367" align="right" height="10">
<p>
<input type="text" name="name" size="10" value="name">
<input type="text" name="email" size="10" value="email">
<input type="text" name="homepage" size="10" value="homepage">
<br>
<textarea name="eintrag" cols="57" rows="2"></textarea>
<br>
<input type="submit" name="submit" value="sag es">
<br>
<br>
</p>
</td>
</form>
</tr>
</table>
</td>
</tr>
<tr>
<td height="1"></td>
</tr>
<tr>
<td height="1" valign="top">
<?
while($r=mysql_fetch_array($result))
{
$name=$r["name"];
$name=wordwrap($name, 13, "<br>", 1); // 1)
$name=strip_tags($name,"<br>");
$email=$r["email"];
$homepage=$r["homepage"];
$eintrag=$r["eintrag"];
$eintrag=wordwrap($eintrag, 60, "<br>", 1); // 1)
$eintrag=strip_tags($eintrag,"<br>");
$id=$r["id"];
?>
</td>
</tr>
<tr>
<td height="36" valign="top">
<table width="100%" border="0" cellpadding="1" cellspacing="1" bgcolor="#000000">
<tr>
<td height="5" width="363" valign="top" bgcolor="#E7E6C7">
<p><img src="gfx/pfeil.gif" width="10" height="10">
<? echo" $id.$name"; ?>
<a href="<? echo "mailto:$email"; ?>">E-Mail </a><a href="http://<? echo"$homepage"; ?>" target="_blank">HP</a></p>
</td>
</tr>
<tr>
<td height="10" valign="top" bgcolor="#D3D2B3"><font face="verdana" size="1">
<? echo " $eintrag"; ?>
</font></td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="10" valign="top"> <br>
<br>
<? }
?>
<?
echo " $id";
if ($rowstart>$numrows)
{?>
<a href="<? $php_self ?>?rowstart=<? echo $rowstart-100;?>"><font face="verdana"><
Neue Einträge</font></a><font face="verdana">
<?}?>
<br>
</font>
<?
$numrows=mysql_num_rows($result2);
if($rowstart+100<$numrows)
{?>
<a href="<? $php_self?>?rowstart=<?echo $rowstart+100 ;?>"><font face="verdana">Ältere
Einträge></font></a>
<? } ?>
</td>
</tr>
</table>
</td>
<td width="7" height="18"></td>
<td width="95" valign="top">
<?
include("box.php");
?>
</td>
</tr>
<tr>
<td height="246"></td>
<td></td>
</tr>
</table>
DANKE ) cu Sascha M.