request script :
<form name="form1" method="post" action="">
<p>
Naam :
<input type="text" name="naam">
</p>
<p>
Request :
<input type="text" name="aanvraag">
</p>
<p>
<input type="submit" name="Submit" value="Verzend">
</p>
</form>
[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #FF8000]/*
###########################################################################
#Alle gebruikte gegevens in deze script mogen niet worden doorverkocht, #
#maar ook niet op uw site aangeboden worder zonder toestemming van qago.nl#
#Copyrigth 2010-2011 : Qago Media #
#Open-source : GNU/GPL #
###########################################################################
*/[/COLOR]
[COLOR= #0000BB]$server[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"localhost"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$wachtwoord[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"wachtwoord"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$gebruikersnaam[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"gebruikersnaam"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$database[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"database"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$mysql_conn[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_connect"]mysql_connect[/URL] [COLOR= #007700]([/COLOR][COLOR= #DD0000]"$server"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"$gebruikersnaam"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"$wachtwoord"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"$database"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$_POST[/COLOR] [COLOR= #007700]&&[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]] !=[/COLOR] [COLOR= #DD0000][/COLOR] [COLOR= #007700]&&[/COLOR] [COLOR= #0000BB]$_POST[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]aanvraag[/COLOR][COLOR= #007700]] !=[/COLOR] [COLOR= #DD0000][/COLOR][COLOR= #007700]) {[/COLOR]
date_default_timezone_set[COLOR= #007700]([/COLOR][COLOR= #DD0000]Europe/Amsterdam[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$tijd[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/date"]date[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"d-m-Y H:i:s"[/COLOR][COLOR= #007700],[/COLOR] [URL="http://www.php.net/time"]time[/URL][COLOR= #007700]());[/COLOR]
[COLOR= #0000BB]$daiman[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"INSERT INTO berichten (naam, aanvraag, ip, datum) VALUES ($_POST[naam],$_POST[aanvraag],$_SERVER[REMOTE_ADDR],$tijd)"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/die"]die[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
[URL="http://www.php.net/if"]if[/URL] [COLOR= #007700]([/COLOR][COLOR= #0000BB]$daiman[/COLOR][COLOR= #007700]) {[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Bericht is succesvol verzonden![/COLOR][COLOR= #007700];
}
}[/COLOR]
?>
admin script :
<table width="324" border="1">
<tr>
<td>Naam</td>
<td>Request</td>
<td>Ip</td>
<td>Datum + tijd </td>
</tr>
[COLOR= #0000BB]<?php[/COLOR]
[COLOR= #FF8000]/*
###########################################################################
#Alle gebruikte gegevens in deze script mogen niet worden doorverkocht, #
#maar ook niet op uw site aangeboden worder zonder toestemming van qago.nl#
#Copyrigth 2010-2011 : Qago Media #
#Open-source : GNU/GPL #
###########################################################################
*/[/COLOR]
[COLOR= #0000BB]$server[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"localhost"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$wachtwoord[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"wachtwoord"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$gebruikersnaam[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"gebruikersnaam"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$database[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #DD0000]"database"[/COLOR][COLOR= #007700];[/COLOR]
[COLOR= #0000BB]$mysql_conn[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_connect"]mysql_connect[/URL] [COLOR= #007700]([/COLOR][COLOR= #DD0000]"$server"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"$gebruikersnaam"[/COLOR][COLOR= #007700],[/COLOR] [COLOR= #DD0000]"$wachtwoord"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/mysql_select_db"]mysql_select_db[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"$database"[/COLOR][COLOR= #007700]);[/COLOR]
[COLOR= #0000BB]$result[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM berichten ORDER BY id DESC"[/COLOR][COLOR= #007700]);[/COLOR]
[URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$row[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_array"]mysql_fetch_array[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$result[/COLOR][COLOR= #007700]))
{[/COLOR]
[URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<tr>
<td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]naam[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</td>
<td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]aanvraag[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</td>
<td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]ip[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</td>
<td>[/COLOR][COLOR= #007700].[/COLOR][COLOR= #0000BB]$row[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]datum[/COLOR][COLOR= #007700]].[/COLOR][COLOR= #DD0000]</td>
</tr>[/COLOR][COLOR= #007700];
}[/COLOR]
?>
</table>
sql :
CREATE TABLE IF NOT EXISTS `berichten` (
`id` int(6) NOT NULL AUTO_INCREMENT,
`naam` varchar(255) NOT NULL,
`aanvraag` varchar(255) NOT NULL,
`ip` varchar(255) NOT NULL,
`datum` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
dit script mag alleen gebruikt worden
niet verkocht of aanbieden op je eigen site