Skrivning til databasen (MySQL/PHP)
Jeg har følgende felter i min database: photo_album- id
- ip
- year (f.eks. 2005, hvis det er året for albummet)
- date (den dag, billeder blev taget)
- upright (den dag (lige nu) hvor man opretter i databasen)
- title
- description
- author
- folder
Alle felter kommer fint med, dog IKKE "date". Denne bliver fortsat ved at være 0000-00-00 uanset hvad. Nogle der kan løse problemet, således at den angivet dato i "date" også kommer med ind i databasen?
photo.add.php -->
<?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"><input type="text" name="year" size="13">
(skriv årstal for billederne, f.eks. 2006, 2007)</td>
</tr>
<tr>
<td width="11%" height="21">Dato for billeder</td>
<td width="1%" height="21">:</td>
<td width="88%" height="21"><input type="text" name="date" size="13">
(skriv årår-dd-mm)</td>
</tr>
<tr>
<td width="11%" height="21">Mappens navn</td>
<td width="1%" height="21">:</td>
<td width="88%" height="21"><input type="text" name="folder" 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="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>
photo.config.php -->
<?php
include('../access/access_config.php');
if ($_POST['referer'] == 'photo.add') {
function add_slash($string)
{
if ($string[strlen($string)-1] != '/')
return $string.'/';
else return $string;
}
$root = add_slash($_SERVER['DOCUMENT_ROOT']);
$mappe_navn = $_POST['folder'];
$mappen = $root.'photoalbum/'.$mappe_navn;
echo 'Rel path: '.$mappen;
echo 'Abs path: '.realpath($mappen);
mkdir($mappen);
mysql_query("INSERT INTO photo_album (ip, year, date, upright, title, description, author, folder) VALUES ('".$_POST['ip']."','".$_POST['year']."','".$_POST['date']."',NOW(),'".$_POST['title']."','".$_POST['description']."','".$_POST['author']."','".$_POST['folder']."')") or die(mysql_error());
}
?>
