//connect.php
<?php
$connect=mysql_connect('hostname','gebruikersnaam','wachtwoord');
$select=mysql_select_db('database');
if(!$connect || !$select) {
die(mysql_error());
}
?>
//data.sql
CREATE TABLE `script` (
`id` INT DEFAULT '0' NOT NULL AUTO_INCREMENT ,
`naam` VARCHAR( 50 ) NOT NULL ,
`scriptnaam` VARCHAR( 50 ) NOT NULL ,
`uitleg` TEXT NOT NULL ,
`source` TEXT NOT NULL ,
PRIMARY KEY ( `id` )
);
//index.php
<TABLE BORDER=0><TR><TD>Script Titel:</TD><TD>Door:</TD></TR>
<?
include "connect.php";
$resultaat=mysql_query("SELECT * FROM script");
while($rij=mysql_fetch_object($resultaat)){
$titel=stripslashes($rij->scriptnaam);
?>
<TR><TD><a href="script.php?id=<? echo $rij->id; ?>"><? echo $titel; ?></a></TD><TD><? echo $rij->naam; ?></TD></TR>
<?
}
?>
</TABLE>
<br><BR><a href="schrijven.php">Script Schrijven</a>
//schrijven.php
<?php
include "connect.php";
if(!empty($_POST)) {
$sql="INSERT INTO script(naam,scriptnaam,uitleg,source) VALUES(`";
$sql.=$_POST["naam"]."`,";
$sql.=$_POST["scriptnaam"]."`,";
$sql.=$_POST["uitleg"]."`,";
$sql.=$_POST["source"]."`);";
$resultaat=mysql_query($sql);
if(!$resultaat) {
die(mysql_error());
}
print "Klik <a href=\"index.php\">hier</a> om naar de Script Library te gaan";
}else{
?>
<form method="post" action="<? echo $_SERVER['PHP_SELF']; ?>">
<h2>Script toevoegen</h2>
<TABLE BORDER=0>
<TR><TD>Je naam:</TD><TD><input type=text name=naam size=20></TD></TR>
<TR><TD>De scriptnaam:</TD><TD><input type=text name=scriptnaam size=20></TD></TR>
<TR><TD>Uitleg:</TD><TD><textarea name=uitleg cols=50 rows=7>Post hier de uitleg van het script.</textarea></TD></TR>
<TR><TD>Sourcecode:</TD><TD><textarea name=source cols=50 rows=11>Post hier de code van het script.</textarea></TD></TR>
<TR><TD><input type=reset value="Wissen"></TD><TD><input type=submit value="Post mijn script!"></TD></TR>
</TABLE>
<a href="index.php">Naar de script library</a>
<?php
}
?>
//script.php
<?
include "connect.php";
$resultaat=mysql_query("SELECT * FROM script WHERE id='".$_GET['id']."'");
while($rij=mysql_fetch_object($resultaat)){
?>
<html>
<head>
<title>Bekijk script</title>
</head>
<body>
<h2>Bekijk het script:</h2>
Dit script is geschreven door: <? echo $rij->naam; ?><br>
<TABLE BORDER=0>
<TR style="background-color: darkred"><TD><font color=white>Beschrijving:</font></TD></TR>
<TR><TD><? echo $rij->uitleg; ?></TD></TR>
<TR style="background-color: darkred"><TD><font color=white>Sourcecode:</font></TD></TR>
<TR><TD><? highlight_string($rij->source); ?></TD></TR>
</TABLE>
<a href="index.php">Naar de Script Library</a>
</body>
</html>
<?php
}
?>