Input i databasen:
$headline = addslashes($headline);
$article = addslashes($article);
$admin = $userid;
if (!$id) $check_sql2 = sql(\"INSERT INTO articles (headline, article, articledate, adminid, picture1, link, linkname, typeid) VALUES (\'$headline\', \'$article\', \'$dato\', \'$admin\', \'$picture1\', \'$link\', \'$linkname\', \'3\')\") or die(mysql_error());
Udtræk af basebasen:
case \"edit\":
$row = mysql_fetch_array( mysql_query(\"SELECT * FROM articles WHERE id = \'$id\' AND typeid=\'3\'\"));
extract($row);
$headline = stripslashes($headline);
$article = stripslashes($article);
Formen:
<TR>
<TD VALIGN=\"top\">
<TABLE WIDTH=\"100%\" BORDER=\"0\" CELLPADDING=\"2\" CELLSPACING=\"0\">
<FORM ENCTYPE=\"multipart/form-data\" ACTION=\"/?action=news&options=preview\" METHOD=\"post\">
<TR>
<TD CLASS=\"mainSub\">Dato:</TD>
<TD CLASS=\"mainSub\"><?=$articledate?> (kan ikke rettes)</TD>
</TR>
<TR>
<TD CLASS=\"mainSub\">Overskrift<INPUT TYPE=\"hidden\" NAME=\"id\" VALUE=\"<?=$id?>\"></TD>
<TD CLASS=\"mainSub\"><INPUT TYPE=\"text\" NAME=\"headline\" SIZE=\"50\" MAXLENGTH=\"50\" CLASS=\"mainSub\" VALUE=\"<? echo htmlentities($headline); ?>\"></TD>
</TR>
<TR>
<TD CLASS=\"mainSub\">Nyhed</TD>
<TD CLASS=\"mainSub\"><TEXTAREA COLS=\"80\" ROWS=\"10\" NAME=\"article\" CLASS=\"mainSub\"><?=$article?></TEXTAREA></TD>
</TR>
<TR>
<TD ALIGN=\"left\" CLASS=\"mainSub\">Billede:</TD>
<TD CLASS=\"mainSub\">
<SELECT NAME=\"picture1\" CLASS=\"mainSub\">
<OPTION VALUE=\"\">Ingen billed</OPTION>
<? $rs_picture1 = sql(\"SELECT * FROM pictures\");
while ($row_picture1 = mysql_fetch_array($rs_picture1)) {
extract($row_picture1);?>
<OPTION VALUE=\"<?=$id?>\" <? if ($picture1 == $id) echo \"selected\";?>><?=$name?></OPTION>
<? }?>
</SELECT>
</TD>
</TR>
<TR>
<TD ALIGN=\"left\" CLASS=\"mainSub\">Link (url):</TD>
<TD CLASS=\"mainSub\"><INPUT TYPE=\"type\" NAME=\"link\" CLASS=\"mainSub\" VALUE=\"<?=$link?>\"></TD>
</TR>
<TR>
<TD ALIGN=\"left\" CLASS=\"mainSub\">Link (navn):</TD>
<TD CLASS=\"mainSub\"><INPUT TYPE=\"type\" NAME=\"linkname\" CLASS=\"mainSub\" VALUE=\"<?=$linkname?>\"></TD>
</TR>
<TR>
<TD ALIGN=\"right\" CLASS=\"mainSub\"><INPUT TYPE=\"submit\" NAME=\"preview\" VALUE=\" Gem \" CLASS=\"mainSub\"></TD>
<TD ALIGN=\"left\" CLASS=\"mainSub\"><INPUT TYPE=\"reset\" NAME=\"Reset\" VALUE=\" Reset \" CLASS=\"mainSub\"></TD>
</TR>
</FORM>
</TABLE>
</TD>
</TR>
Inden nyheden bliver gemt, så bliver den vist på en anden side, som er opstillet på samme måde og allerede der er det væk.
Det kan ses på
www.jlservice.dk/oversigt7.jpg