iets toevoegen in een MYSQL database!
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
<?php
if($_SERVER['REQUEST_METHOD'] == "POST")
{
if(isset($_POST['Titel']) && isset($_POST['Categorie']) && isset($_POST['Bericht']) && isset($_POST['Auteur']))
{
$Titel = mysql_real_escape_string(htmlentities($_POST['Titel']));
$Categorie = mysql_real_escape_string(htmlentities($_POST['Categorie']));
$Bericht = ubb(mysql_real_escape_string(htmlentities($_POST['Bericht'])));
$Auteur = mysql_real_escape_string(htmlentities($_POST['Auteur']));
$query = "INSERT INTO nieuws (nieuwsID,nieuwsTitel,nieuwsBericht,nieuwsCategorie,nieuwsAuteur) VALUES ('', '" . $Titel . "', '" . $Categorie . "', '" . $Bericht . "', '" . $Auteur . "')";
$resultaat = mysql_query($query);
if($resultaat)
{
echo '<p>Dit nieuwsbericht is succesvol toegevoegd!</p>';
}else{
echo '<p>Sorry, er ging iets mis bij het updaten van de database!</p>';
}
}
}
?>
if($_SERVER['REQUEST_METHOD'] == "POST")
{
if(isset($_POST['Titel']) && isset($_POST['Categorie']) && isset($_POST['Bericht']) && isset($_POST['Auteur']))
{
$Titel = mysql_real_escape_string(htmlentities($_POST['Titel']));
$Categorie = mysql_real_escape_string(htmlentities($_POST['Categorie']));
$Bericht = ubb(mysql_real_escape_string(htmlentities($_POST['Bericht'])));
$Auteur = mysql_real_escape_string(htmlentities($_POST['Auteur']));
$query = "INSERT INTO nieuws (nieuwsID,nieuwsTitel,nieuwsBericht,nieuwsCategorie,nieuwsAuteur) VALUES ('', '" . $Titel . "', '" . $Categorie . "', '" . $Bericht . "', '" . $Auteur . "')";
$resultaat = mysql_query($query);
if($resultaat)
{
echo '<p>Dit nieuwsbericht is succesvol toegevoegd!</p>';
}else{
echo '<p>Sorry, er ging iets mis bij het updaten van de database!</p>';
}
}
}
?>
<form name="formulier" method="post" action="
Code (php)
1
<?php $_SERVER['PHP_SELF']; ?>
<table>
<tr>
<td>Auteur:</td>
<td><input type="text" name="Auteur" size="40" maxsize="100" /></td>
</tr>
<tr>
<td>Titel:</td>
<td><input type="text" name="Titel" size="40" maxsize="100" /></td>
</tr>
<tr>
<td>Categorie</td>
<td><select name="Categorie">
<option value="home">Home</option>
<option value="nieuws">Nieuws</option>
<option value="portfolio">Portfolio</option>
</select></td>
</tr>
<tr>
<td>Stijlen:</td>
<td>
<a href="javascript:wrapSelection(thisForm.Bericht,'','');"><img src="images/editor/dik.png" border=\"0\" /></a>
<a href="javascript:wrapSelection(thisForm.Bericht,'','');"><img src="images/editor/schuin.png" border=\"0\" /></a>
<a href="javascript:wrapSelection(thisForm.Bericht,'','');"><img src="images/editor/onderstreept.png" border=\"0\" /></a>
<a href="javascript:wrapSelectionWithLink(thisForm.Bericht);"><img src="images/editor/link.png" border=\"0\" /></a>
</td>
</tr>
<tr>
<td>Smilies:</td>
<td>
<a href="javascript:wrapSelection(thisForm.Bericht,':','D');"><img src="images/smilies/biggrin.gif" border=\"0\" /></a>
<a href="javascript:wrapSelection(thisForm.Bericht,':','+');"><img src="images/smilies/clown.gif" border=\"0\" /></a>
<a href="javascript:wrapSelection(thisForm.Bericht,':','(');"><img src="images/smilies/frown.gif" border=\"0\" /></a>
<a href="javascript:wrapSelection(thisForm.Bericht,':','O');"><img src="images/smilies/redface.gif" border=\"0\" /></a>
<a href="javascript:wrapSelection(thisForm.Bericht,':',')');"><img src="images/smilies/smile.gif" border=\"0\" /></a>
<a href="javascript:wrapSelection(thisForm.Bericht,';',')');"><img src="images/smilies/wink.gif" border=\"0\" /></a>
</td>
</tr>
<tr>
<td>Bericht:</td>
<td><textarea name="Bericht" cols="30" rows="3"></textarea></td>
</tr>
<tr>
<td><input type="submit" id="versturen" name="submit" value="Voeg Toe"></td>
</tr>
</table>
</form>
Gewijzigd op 01/01/1970 01:00:00 door Ni bot
Zet je query op je het scherm start je database beheer programma en voer de query uit.