Ip Logger
Omg last question idag :)Jeg har en tagwall... som er baseret på MysQL
koden til sql ser sådan her ud...
Går nu udfra der skal være et felt i sqlen som hedder IP or some...hf. :P 70 point på spil :P
CREATE TABLE tagwall (
id int(4) unsigned NOT NULL auto_increment,
fra varchar(20) NOT NULL default '',
emne varchar(20) NOT NULL default '',
besked longtext NOT NULL,
PRIMARY KEY (id,id)
) TYPE=MyISAM;
Og min tagwall...
:KODE:
<?
$visfra = $_GET[visfra];
if(!$_GET[visfra])
{
$visfra = 0;
}
$res_tagwall = mysql_query("SELECT * FROM tagwall order by id DESC LIMIT $visfra, 10");
while ($row_tagwall = mysql_fetch_array($res_tagwall)){
?>
<div align="left">
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="left"><font size="1"><b>
<?=$row_tagwall[emne]?>
</b> </font> </div>
</td>
<td><div align="right"></div>
</td>
</tr>
</table>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" style="FONT-SIZE: 8pt">
<tr>
<td width="78%">
</td>
<td width="22%"> </td>
</tr>
<tr>
<td colspan="2"><?=$row_tagwall[besked]?>
</td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
<table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><div align="left"><font size="1">Tagged by:
<?=$row_tagwall[fra]?>
</font> </div></td>
<td><div align="right"><font size="1">IP: Logged</font> </div></td>
</tr>
</table>
<div align="center"><img src="images/separator.gif" width="500" height="11"> <br>
<?
}
?>
</div>
<center><?php
$antal = mysql_num_rows(mysql_query("select * from tagwall"));
if($visfra>0)
{
$bagud = $visfra-10;
echo "<a href='$PHP_SELF?visfra=$bagud'>Previous</a> ";
}
$page = 1;
for($start=0; $antal > $start; $start=$start+10){
if($visfra != $page*10-10)
{
echo "<a href='$PHP_SELF?visfra=$start'>$page</a> ";
}else{
echo $page." ";
}
$page = $page+1;
}
if($visfra< $antal-10)
{
$naeste = $visfra+10;
echo " <a href='$PHP_SELF?visfra=$naeste'>Next</a>";
}
?></center>
</div>
<form method="post" action="tag_add.php">
<input type="hidden" name="action" value="update">
<div align="left">
<table width="317" height="223" border="0" align="center" cellpadding="0" cellspacing="0" style="FONT-SIZE: 8pt">
<tr>
<td height="24">Name</td>
<td height="24">
<input type="text" name="fra" size="20" style="width: 115; color: #949CA5; background-image:url(images/form.gif); font-size: 7pt; font-family: Verdana; background-color: #454D59; border-width: 0">
</td>
</tr>
<tr>
<td height="24">Subject</td>
<td height="24">
<input type="text" name="emne" size="20" style="width: 115; color: #949CA5; background-image:url(images/form.gif); font-size: 7pt; font-family: Verdana; background-color: #454D59; border-width: 0">
</td>
</tr>
<tr>
<td width="102" height="104" valign="top">Message</td>
<td width="215" height="104" align="left" valign="top">
<textarea rows="7" name="besked" cols="30"></textarea>
</td>
</tr>
<tr>
<td width="102" height="1"></td>
<td width="215" height="1">
<input type="submit" name="update" value="Tag it!">
</td>
</tr>
</table>
</div>
</form>
:KODE SLUT:
