Nyheds system
En der kan hjælpe mig med hvad jeg skal sætte ind i min mysQl database???jeg vil vise hvad der er i de forskellige filder:
Connecting.php:
<?
header("Location: index.php");
$dato = date('d/m/Y H:i:s');
$connection = mysql_connect("host","bruger","password");
mysql_select_db("db", $connection);
mysql_query("INSERT INTO news (overskrift, forfatter, dato, nyhed) VALUES ('$overskrift', '$forfatter', '$dato', '$nyhed')") OR DIE (mysql_error());
mysql_close;
?>
Index.php:
<?
$connection = mysql_connect("host","bruger","password");
mysql_select_db("db", $connection);
$query = mysql_query("SELECT * FROM news ORDER BY id DESC LIMIT 50");
while($row = mysql_fetch_array($query)) {
echo "
<table border='0' width='300' style='border-collapse: collapse; border: 1px double #000000' cellpadding='0' cellspacing='0' align='center' height='1'>
<tr>
<td width='300' bgcolor='#990000' height='15'>
<p align='center'><font size='1' face='Verdana'><b>$row[overskrift]</b></font></p>
</td>
</tr>
<tr>
<td width='300' bgcolor='#C0C0C0' height='1'>
<table border='0' width='300'>
<tr>
<td width='1'> </td>
<td width='300'><font size='1' face='Verdana'>$row[nyhed]</font>
<p><font size='1' face='Verdana'>$row[forfatter] - $row[dato]</font></p></td>
</tr>
</table>
</td>
</tr>
</table><br>
";
}
?>
admin.php:
<?
$realbruger = "bruger";
$realpw = "kode";
if($pz == "login"){
if(!$brugernavn) echo "Du har ikke indtastet et brugernavn!";
elseif(!$password) echo "Du har ikke indtastet en password!";
else{
if($brugernavn == $realbruger && $password == $realpw){
?>
<table border='0' width='152' style='border-collapse: collapse; border: 1px double #000000' cellpadding='0' cellspacing='0' align='center' height="121">
<tr>
<td width='152' bgcolor='#fffffff' height="15">
<p align='center'><b><font size='1' face='Verdana'>Logget-in</font></b></p>
</td>
</tr>
<tr>
<td width='152' bgcolor='#C0C0C0' height="101">
<form action="connecting.php" method="post">
<p align="center"><font size="1" face="Verdana">Forfatter<br>
<input name="forfatter" value="" size="15">
<br>Overskrift<br>
<input name="overskrift" value="" size="15">
<br>Nyhed<br>
<textarea name="nyhed" rows="1" cols="15"></textarea>
<br>
<input type="submit" name="Submit" value="Tryk Nyhed">
</font>
</form></td>
</tr>
</table>
<?
}
else echo "Der er fejl i enten brugernavn eller password!";
}
}
else{
?>
<table border='0' width='152' style='border-collapse: collapse; border: 1px double #000000' cellpadding='0' cellspacing='0' align='center' height="121">
<tr>
<td width='152' bgcolor='#ffffff' height='15'>
<p align='center'><b><font size='1' face='Verdana'>Login</font></b></p>
</td>
</tr>
<tr>
<td width='152' bgcolor='#C0C0C0' height="101">
<form action='<? echo $PHP_SELF; ?>?pz=login' method='post'>
<p align='center'>
<font size='1' face='Verdana'>Brugernavn:
<input type='text' name='brugernavn' size='15'>
Password:
<input type='password' name='password' size='15'><br><input type='submit' value='Login'>
</font>
</form></td>
</tr>
</table>
<?
}
?>
</body>
</html>
dump.txt:
CREATE TABLE news (
id int(3) NOT NULL auto_increment,
forfatter TINYTEXT NOT NULL,
dato TINYTEXT NOT NULL,
overskrift TEXT NOT NULL,
nyhed TEXT NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;
Tak på forhånd
