PHP Code:
<?php include('./inc/header.php'); ?>
<?php
if(!isset($_POST['news'])) $_POST['news'] = '';
odbc_exec($mssql, 'USE [WEBSITE_DBF]');
if(isset($_POST['news_submit'])) {
echo '</div>';
} else {
odbc_exec($mssql, 'INSERT INTO [dbo].[web_news] (nid, title, text, category, author, datetime, views) VALUES (0, 0, 0, 1, 0, 0, 0)');
}
?>
<form method="post">
<table>
<tr>
<td>Titel:</td>
<td><input type="varchar(50)" name="news_title" maxlength="10" /></td>
</tr>
<tr>
<td>Text:</td>
<td><input type="text" name="news_text" maxlength="11" /></td>
</tr>
<tr>
<td>Cagegory (bitte 1 eintragen):</td>
<td><input type="int" name="news_category" maxlength="10" /></td>
</tr>
<tr>
<td>Author:</td>
<td><input type="varchar(50)" name="news_author" /></td>
</tr>
<tr>
<td>Datetime:</td>
<td><input type="datetime" name="news_datetime" /></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name="news_submit" value="Absenden" /></td>
</tr>
</table>
</form>
</div>
auszug der admin.php
[Only registered and activated users can see links. Click Here To Register...] meine admin php mit dme fehler
Kopie aus der DB
PHP Code:
INSERT INTO [WEBSITE_DBF].[dbo].[web_news]
([title]
,[text]
,[category]
,[author]
,[datetime]
,[views])
VALUES
(<title, varchar(50),>
,<text, text,>
,<category, int,>
,<author, varchar(50),>
,<datetime, datetime,>
,<views, int,>)
GO
<text, text,>