Opret mappe på serveren
Jeg vil via en formular oprette en ny mappe på serveren, med et vilkårligt nummer som den også gemmer i databasen sammen med resten af de indtastet informationer.Nuværende tidspunkt henter den kun nedenstående felter ind i databasen. I databasen er der et felt der hedder "folder" som jeg gerne vil havde det vilkårlige nummer til at stå, således at den ved hvilken mappe der er tale om.
photo.add.php -->
<?php
require('../access/access_config.php');
// Creating option tags with year data
$Res = mysql_query("SELECT id, year FROM photo_year ORDER BY year");
$CategoryOptions = "";
while (list($CategoryId,$CategoryTitle) = mysql_fetch_row($Res))
{
$CategoryOptions .= "<option value=\"$CategoryId\">".stripslashes($CategoryTitle)."</option>\n";
}
?>
<html>
<head>
<title></title>
</head>
<body>
<?php include ('../includes/menu.php'); ?>
<form action="photo.config.php" method="post" enctype="multipart/form-data">
<input type="hidden" name="referer" value="photo.add">
<table border="0" width="100%" height="204">
<tr>
<td width="11%" height="25">Overskrift</td>
<td width="1%" height="25">:</td>
<td width="88%" height="25"><input type="text" name="title" size="42"></td>
</tr>
<tr>
<td width="11%" height="81">Beskrivelse</td>
<td width="1%" height="81">:</td>
<td width="88%" height="81"><textarea rows="3" name="description" cols="35"></textarea></td>
</tr>
<tr>
<td width="11%" height="21"> </td>
<td width="1%" height="21"></td>
<td width="88%" height="21"></td>
</tr>
<tr>
<td width="11%" height="25">Årstal</td>
<td width="1%" height="25">:</td>
<td width="88%" height="25"><select name="year"><?php echo $CategoryOptions; ?></select></td>
</tr>
<tr>
<td width="11%" height="21"> </td>
<td width="1%" height="21"></td>
<td width="88%" height="21"></td>
</tr>
<tr>
<td width="11%" height="25">Fotograf/oprettet af</td>
<td width="1%" height="25">:</td>
<td width="88%" height="25"><input type="text" name="author" size="42"></td>
</tr>
<tr>
<td width="11%" height="21"> </td>
<td width="1%" height="21"></td>
<td width="88%" height="21"></td>
</tr>
<tr>
<td width="11%" height="1"></td>
<td width="1%" height="1"></td>
<td width="88%" height="1"><input type="submit" value="Opret fotoalbum" name="B1">
<input type="reset" value="Slet alt" name="B2">
<input type="hidden" name="ip" value="<?php print $_SERVER['REMOTE_ADDR']; ?>"></td>
</tr>
</table>
</form>
</body>
</html>
photo.config.php -->
<?php
include('../access/access_config.php');
if ($_POST['referer'] == 'photo.add') {
mysql_query("INSERT INTO photo_album (ip, year, date, title, description, author, folder) VALUES ('".$_POST['ip']."','".$_POST['year']."',NOW(),'".$_POST['title']."','".$_POST['description']."','".$_POST['author']."','".$_POST['folder']."')") or die(mysql_error());
header("Location: photo.add.php");
}
?>
