Har lige siddet og kodet lidt...
noget du kan bruge?
index.php
<?
include("/var/www/connect.inc.php");
# Indtast data
if($_GET[action] == "tilfoej"){
?>
<form method="post" action="index.php?action=send">
<table width="464" border="1">
<tr>
<td width="112">Titel</td>
<td width="336"><input name="titel" type="text" id="titel"></td>
</tr>
<tr>
<td>Genre</td>
<td><select name="genre" id="genre">
<option>Action</option>
<option>Adventure</option>
<option>Animation</option>
<option>Dokumentar</option>
<option>Drama</option>
<option>Erotik</option>
<option>Familie film</option>
<option>Gangsterfilm</option>
<option>Gyser</option>
<option>Komedie</option>
<option>Krig</option>
<option>Krimi</option>
<option>Musical</option>
<option>Romance</option>
<option>Scienfe Fiction</option>
<option>Thriller</option>
<option>Western</option>
</select></td>
</tr>
<tr>
<td>Lydformat</td>
<td><select name="lydformat" id="lydformat">
<option>AC-3 </option>
<option>Dolby Digital </option>
<option>Dolby Digital EX </option>
<option>Dolby Surround Pro Logic </option>
<option>DTS </option>
<option>DVD-audio </option>
<option>Mono </option>
<option>Stereo</option>
<option>THX </option>
<option>THX Surround EX </option>
</select></td>
</tr>
<tr>
<td>Årgang</td>
<td><input name="aargang" type="text" id="aargang"></td>
</tr>
<tr>
<td>Videoformat</td>
<td><select name="videoformat" id="videoformat">
<option>1.33:1</option>
<option>1.85:1 </option>
<option>16:9 </option>
<option>Anamorfisk DVD (16:9)</option>
</select></td>
</tr>
<tr>
<td>Region</td>
<td><select name="region">
<option>0</option>
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
<option>6</option>
<option>7</option>
<option>8</option>
</select></td>
</tr>
<tr>
<td>Filmselskab</td>
<td><input name="filmselskab" type="text" id="filmselskab"></td>
</tr>
<tr>
<td>IMDB link </td>
<td><input name="imdb" type="text" id="imdb"></td>
</tr>
<tr>
<td>Scope.dk link </td>
<td><input name="scope" type="text" id="scope"></td>
</tr>
<tr>
<td> </td>
<td><input name="action" type="submit" id="send" value="send">
<input type="reset" name="Reset" value="Reset"></td>
</tr>
</table>
</form>
<?
#Tilføj data til database
}elseif($_GET[action] == "send"){
echo "sender data";
echo $titel;
mysql_query("INSERT INTO dvddb (titel, genre, lydformat, aargang, videoformat, region, imdb, scope, filmselskab) VALUES ('$titel', '$genre', '$lydformat', '$aargang', '$videoformat', '$region', '$imdb', '$scope', '$filmselskab')") or die (mysql_error());
# Vis info for enkelt film
}elseif($_GET[action] == "info"){
$result = mysql_query("select * from dvddb where id='$id'");
while ($row = mysql_fetch_array($result)) {
echo "
<table>
<tr>
<td>Film ID</td> <td>".$row[id]."</td><tr>
<td>Titel</td> <td>".$row[titel]."</td></tr>
<td>Genre</td> <td>".$row[genre]."</td></tr>
<td>Lydformat</td> <td>".$row[genre]."</td></tr>
<td>Videoformat</td> <td>".$row[videoformat]."</td></tr>
<td>Årgang</td> <td>".$row[videoformat]."</td></tr>
<td>Region</td> <td>".$row[region]."</td></tr>
<td>Filmselskab</td> <td>".$row[filmselskab]."</td></tr>
<td>imdb link</td> <td>".$row[imdb]."</td></tr>
<td>scope link</td> <td>".$row[scope]."</td>
</tr>
</table>
";
}
# Vise liste over alle film
}else{
echo "<a href=\"index.php?action=tilfoej\">tilføj</a>";
echo "
<table>
<tr>
<td>
Titel
</td>
<td>
genre
</td>
<td>
info
</td>
</tr>
";
$result = mysql_query("select * from dvddb");
while ($row = mysql_fetch_array($result)) {
echo "<tr><td>".$row[titel]."</td><td>".$row[genre]."</td><td><a href=\"index.php?action=info&id=".$row[id]."\">info</a></td></tr>";
}
}
?>
Databsen:
CREATE TABLE `dvddb` (
`id` int(11) NOT NULL auto_increment,
`titel` varchar(100) NOT NULL default '',
`genre` varchar(20) NOT NULL default '',
`lydformat` varchar(20) NOT NULL default '',
`aargang` varchar(4) NOT NULL default '',
`videoformat` varchar(20) NOT NULL default '',
`region` varchar(20) NOT NULL default '',
`imdb` varchar(255) NOT NULL default '',
`scope` varchar(255) NOT NULL default '',
`filmselskab` varchar(100) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;
Du skal bare lave en fil der hedder connect.inc.php hvor du har dine oplysninger til din mysql server liggende, og så tilpasse include stien.
