Ik heb ergens een script opgeduikelt waarmee je naar een database schrijft. Ik heb het alleen een beetje aangepast maar krijg telkens een melding dat ik niet genoeg ingevult heb. Kan iemand me helpen?
Code:
<?
include "config.php";
if ($_POST[submit]) {
if ($_POST['auteur'] == "" || $_POST['email'] == "" || $_POST['titel'] == "" || $_POST['genre'] == "" || $_POST['jaartal'] == "" || $_POST['rating'] == "" || $_POST['review'] == "" )
{
echo "Je hebt niet alles ingevuld!<br><a href=\"javascript:history.go(-1)\">Klik hier om terug te gaan</a>";
}
else {
$insert = "INSERT INTO reviews (id, auteur, email, titel, genre, jaartal, rating, review, kliks) VALUES ('', '$_POST[auteur]', '$_POST[email]', '$_POST[titel]', '$_POST[genre]', '$_POST[jaartal]', '$_POST[rating]', '$_POST[review]')";
$query = mysql_query($insert);
echo "De review is succesvol toegevoegd!<br>Klik <a href=\"reviews.php\">hier</a> om naar de reviews te gaan";
}
}
else
{
echo "Voeg hier een review toe!";
echo "<form method=\"POST\" action=\"toevoegen.php\">";
echo "<table>";
echo "<tr><td>Je (nick)naam:</td><td><input type=\"text\" name=\"auteur\"></td></tr>";
echo "<tr><td>Email:</td><td><input type=\"text\" name=\"email\"></td></tr>";
echo "<tr><td>Titel van de film:</td><td><input type=\"text\" name=\"script\"></td></tr>";
echo "<tr><td>Genre:</td><td><Select name=\"genre\">
<option>Aktie/Avontuur</option>
<option>Animatie</option>
<option>Comedie</option>
<option>Horror/Thriller</option>
<option>Science Fiction</option>
<option>Anders</option></select></td></tr>";
echo "<tr><td>Jaartal:</td><td><Select name=\"jaartal\">
<option>1970</option>
<option>1971</option>
<option>1972</option>
<option>1973</option>
<option>1974</option>
<option>1975</option>
<option>1976</option>
<option>1977</option>
<option>1978</option>
<option>1979</option>
<option>1980</option>
<option>1981</option>
<option>1982</option>
<option>1983</option>
<option>1984</option>
<option>1985</option>
<option>1986</option>
<option>1987</option>
<option>1988</option>
<option>1989</option>
<option>1990</option>
<option>1991</option>
<option>1992</option>
<option>1993</option>
<option>1994</option>
<option>1995</option>
<option>1996</option>
<option>1997</option>
<option>1998</option>
<option>1999</option>
<option>2000</option>
<option>2001</option>
<option>2002</option>
<option>2003</option>
<option>2004</option>
</select></td></tr>";
echo "<tr><td>Rating:</td><td><input type=\"text\" name=\"rating\"></td></tr>";
echo "<tr><td>Review:</td><td><textarea name=\"review\" rows=\"7\" cols=\"50\"></textarea></td></tr>";
echo "<tr><td></td><td><input type=\"submit\" name=\"submit\" value=\"Voeg de review toe!\"></td></tr>";
echo "</table></form>";
}
?>
1.067 views
