Lidt rod med mySQL
Jeg har en side der skal lægge en nyhed når man har skrevet den ind, men kun hvis adminkodeordet passer sammen med adminbrugerneavnet. Jeg har lavet selve programmeringen, men der er nogle galt. Jeg tror det er i mysql delen... Men hvad:--------------
<head>
<title>Add News</title>
</head>
<body>
<form action="<?=$PHP_SELF;?>">
<table width="868">
<tr>
<td width"50" width="91">Adminuser:</td>
<td width"100" width="765"><input type="text" name="adminuser" size="20"></td>
</tr>
<tr>
<td width"50" width="91">Adminpass:</td>
<td width"100" width="765"><input type="password" name="adminpass" size="20"></td>
</tr>
<tr>
<td width"50" width="91">Name:</td>
<td width"100" width="765"><input type="text" name="name" value"<? echo $name ?> size="20"></td>
</tr>
<tr>
<td width"50" width="91">Dato:</td>
<td width"100" width="765"><input type="text" name="date" value"<? echo $date ?> size="20"></td>
</tr>
<tr>
<td width"50" width="91">Head Line:</td>
<td width"100" width="765"><input type="text" name="headline" value"<? echo $headline ?> size="20"></td>
</tr>
<tr>
<td width"50" width="91">Text:</td>
<td width"100" width="765"><textarea rows="10" name="news" value"<? echo $text ?> cols="80"></textarea></td>
</tr>
</table>
<input type="SUBMIT" value="submit" name="submit">
</form>
</body>
</html>
<?
if($submit)
{
if(!$name)
{
echo "Dummy - Write your freaking name";
}
else if(!$headline)
{
echo "Oops - Dont you think it would be easier if the news had a head line?!?";
}
else if(!$news)
{
echo "ehheem - A news with no text? Are you insane!?";
}
else
{
$db = mysql_connect("localhost","evil","fish1");
mysql_select_db("db", $db);
mysql_query("SELECT user, pass FROM admin WHERE user = '$adminuser'") or die(mysql_error());
if($adminpass == $pass)
{
$db = mysql_connect("localhost","evil","fish1");
mysql_select_db("db", $db);
mysql_query("INSERT INTO news (name, headline, news, date) VALUES('$name','$headline','$news','$date')") or die(mysql_error());
echo "The news is added to database \"news\"";
}
else if($adminpass != $pass)
{
echo "Password incorrect";
}
}
}
?>
-----------------
Evilfish
