masz kod do wpisania do bazy:
<?php
if ($_POST["wyslane"]) {
echo '<table class="forumline" width="100%" cellspacing="1" cellpadding="4" border="0"> <tr>
<td><table width="100%" cellspacing="0" cellpadding="1" border="0">
<tr>
<td> </td>
</tr>
<tr><td align="center"><span class="error">';
$blad++;
echo 'Musisz wpisac temat jesli wysylasz nowy watek (od 5 do 100)<br>'; }
$blad++;
echo 'Musisz wpisac tresc jesli wysylasz nowy watek (od 5 do 3000)<br>'; }
</tr>
<tr>
<td> </td>
</tr>
</table>
</td>
</tr>
</table>';
if ($blad == 0) {
$wynik = mysql_query("INSERT INTO promocje VALUES('', '$temat', '$tresc')"); if ($wynik) {
echo "<script>window.location.href='index.php';</script>"; }
}
}
<form method="post" name="form">
<input type="hidden" name="wyslane" value="TRUE">
<table border="1" cellpadding="3" cellspacing="1" width="100%">
<tr>
<td class="row1" width="22%">
<table width="100%" border="0">
<tr>
<td align="left"><span class="gen"><b>Temat</b></span></td>
<td align="right">
</td>
</tr>
</table>
</td>
<td class="row2" width="78%">
<input type="text" name="temat" size="45" maxlength="60" style="width:550px" tabindex="2" value="" />
</td>
</tr>
<tr>
<td class="row1" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td><b>Tresc wiadomosci</b></td>
</tr>
</table>
</td>
<td valign="top">
<table width="550" border="0" cellspacing="0" cellpadding="2">
<tr>
<td><textarea name="tresc" rows="15" cols="35" style="width:550px" tabindex="3" class="post"></textarea></td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" align="center" height="28"><input accesskey="s" tabindex="6" name="post" class="mainoption" value="Wyslij" type="submit"></td>
</tr>
</table>
</form>';
?>
a tu tabele w bazie danych:
CREATE TABLE `promocje` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`temat` VARCHAR(100) NOT NULL,
`tresc` VARCHAR(3000) NOT NULL,
PRIMARY KEY (`id`)
)
ENGINE=MyISAM DEFAULT CHARACTER SET latin1
COLLATE latin1_general_cs AUTO_INCREMENT=0;
a jak zrobić kod do wyświetlenia z bazy to masz wszystko. daj + (IMG:
style_emoticons/default/smile.gif)