ik wil graag dat members moeten inloggen en dat ik smileys kan gebruiken
database:
config.php
nieuws.php
toevoegen.php
database:
code:
1
2
3
4
5
6
7
8
9
10
11
12
| CREATE TABLE nieuws ( id int(11) NOT NULL auto_increment, onderwerp varchar(40) NOT NULL, bericht longtext NOT NULL, auteur varchar(20) NOT NULL, tijd varchar(8) NOT NULL, datum varchar(10) NOT NULL, email varchar(40) NOT NULL, PRIMARY KEY (id), KEY id (id), UNIQUE id_2 (id) ); |
config.php
code:
1
2
3
4
5
6
| <? $host = "localHOST"; $db = "nieuws"; $user = "root"; $pass = ""; ?> |
nieuws.php
code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| <?
include("config.php");
mysql_connect("$host","$user","$pass");
mysql_select_db("$db");
$select="SELECT * FROM nieuws ORDER BY id DESC limit 15";
$query = mysql_query($select);
echo "<p><b>• Nieuws</b></p>";
while ($list = mysql_fetch_object($query)) {
echo "<p><b>$list->onderwerp </b> door <a href=\"mailto:$list->email\">$list->auteur</a> <font color=#000000>@ $list->datum, $list->tijd</font><br>";
echo "$list->bericht</p>";
echo "<p><b>$ipadres->onderwerp </b>;
}
?> |
toevoegen.php
code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
| <?
include("config.php");
if ($submit) {
mysql_connect("$host","$user","$pass");
mysql_select_db("$db");
$bericht = htmlspecialchars($bericht);
$bericht = eregi_replace("\\[b\]","<b>",$bericht);
$bericht = eregi_replace("\\[/b\]","</b>",$bericht);
$bericht = eregi_replace("\\[a\]","<a href=\"",$bericht);
$bericht = eregi_replace("\\[/a\]","</a>",$bericht);
$bericht = eregi_replace("\\[aa\]","\" target=\"_blank\">",$bericht);
$bericht = eregi_replace("\\[i\]","<i>",$bericht);
$bericht = eregi_replace("\\[/i\]","</i>",$bericht);
$bericht = eregi_replace("\\[u\]","<u>",$bericht);
$bericht = eregi_replace("\\[/u\]","</u>",$bericht);
$bericht = eregi_replace("\\[p\]","<p>",$bericht);
$bericht = eregi_replace("\\[/p\]","</p>",$bericht);
$bericht = eregi_replace("\\[br\]","<br>",$bericht);
$bericht = eregi_replace("\\[font\]","<font color=\"#FF0000\" size=\"1\">",$bericht);
$bericht = eregi_replace("\\[/font\]","</font>",$bericht);
$datum = date("d/m/Y");
$tijd = date("H:i");
$insert = "INSERT INTO nieuws (auteur,onderwerp,bericht,tijd,datum,email) VALUES ('$auteur','$onderwerp','$bericht','$tijd','$datum','$email')";
$query = mysql_query($insert)or die(mysql_error());
echo "Je Nieuws Item is succesvol geplaatst!";
}
else {
echo "<form method=post>";
echo "<table cellspacing=0 border=0>";
echo "<tr><td>Auteur: </td><td><input type=text name=auteur></td></tr>";
echo "<tr><td>E-mail adres: </td><td><input type=text name=email></td></tr>";
echo "<tr><td>Ipadres: </td><td><input type=text name=ipadres></td></tr>";
echo "<tr><td>Onderwerp: </td><td><input type=text name=onderwerp></td></tr>";
echo "<tr><td>Bericht: </td><td><textarea name=bericht cols=100 rows=10></textarea></td></tr>";
echo "<tr><td colspan=2><input type=submit value=Toevoegen name=submit style=width:99%></td></tr>";
echo "</table></form>";
}
?> |