kan ikke skrive til database
hej.Jeg har en kode som skriver til en database, eller burde gøre. Når jeg udfører koden herunder kommer der intet til databasen ??
Kan ikke se hvorfor.
<?php
$IPnr = getenv('REMOTE_ADDR'); # Henter brugerens aktuelle IP
echo "$IPnr";
if($_POST['up']){
$files = $_FILES['upfil']['name'];
$file = $_FILES['upfil']['tmp_name'];
$fil_stoerrelse = filesize($file)/1024;
if($fil_stoerrelse > "1000") {
echo "Det billede du prøver at uploade er <b>ikke</b> gyldigt - max 1000 kb
<a href=java script:history.back(-1)>Tilbage</a>";
exit;
}
$sti = "/test/";
$dist = $_SERVER["DOCUMENT_ROOT"] ."$sti";
$temparr = explode(".", $files);
$temparr[count($temparr)-2] = time();
$files = implode(".", $temparr);
move_uploaded_file($_FILES['upfil']['tmp_name'], $dist . $files);
$connection = mysql_pconnect("localhost","root");
mysql_select_db("annonce");
mysql_query("insert into indryk (adresse, postnr, by, nr, tlfnr, email, type, kate, annoncetekst, pris, filnavn, tekst, dato) values ('$_POST[adresse]', '$_POST[postnr]', '$_POST[by]', '$_POST[nr]', '$_POST[tlfnr]', '$_POST[email]', '$_POST[type]', '$_POST[kate]', '$_POST[annoncetekst]', '$_POST[pris]', '$files','$_POST[tekst]', now())");
echo "Din fil er nu uploadet<br><br>";
}
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" enctype="multipart/form-data">
<BODY><table bgcolor="#FFFFFF" width="500" align="center">
<tr>
<td width="120"><b>Adresse:</b></td>
<td><input type="text" name="adresse"></td>
</tr>
<tr>
<td width="120"><b>Post nr.:</b></td>
<td><input type="text" name="postnr" value="<?php echo "$postnr"; ?>"></td>
</tr>
<tr>
<td width="120"><b>By:</b></td>
<td><input type="text" name="by" value="<?php echo "$by"; ?>"></td>
</tr>
<tr>
<td width="120"><b>nr.:</b></td>
<td><input type="text" name="nr" value="<?php echo "$nr"; ?>"></td>
</tr>
<tr>
<td width="120"><b>Telefon nr.:</b></td>
<td><input type="text" name="tlfnr" value="<?php echo "$tlfnr"; ?>"></td>
</tr>
<tr>
<td width="120"><b>Email.:</b></td>
<td><input type="text" name="email" value="<?php echo "$email"; ?>"></td>
</tr>
<tr>
<td><br></td>
<td><br></td>
</tr>
<tr>
<td width="120"><b>Type:</b></td>
<td><select name="type">
<option value="salg">Salg</option>
<option value="koeb">Koeb</option>
</select></td>
</tr>
<tr>
<td width="180"><b>Kategori:</b></td>
<td><select name="kate" value="<?php echo "$kate"; ?>">>
<option value="book"> Boeger</option>
<option value="cd">CD'er</option>
<option value="computer">Computer</option>
<option value="diverse">Diverse</option>
<option value="film">DVD- og videofilm</option>
<option value="lommeregner">Lommeregner</option>
<option value="mobil">Mobiltelefoner</option>
</select></td>
</tr>
<tr>
<td width="120"><b>Annoncetekst:</b></td>
<td><textarea cols="35" rows="7" name="annoncetekst" maxlength="400"></textarea></td>
</tr>
<tr>
<td width="120"></td>
<td>Max 400 tegn</td>
</tr>
<tr>
<td width="120"><input type="hidden" name="user"></td><br></td>
<td><br></td>
</tr>
<tr>
<td width="120"><b>Pris:</b></td>
<td><input type="text" name="pris"></td>
</tr>
<tr>
<td width="120"></td>
<td>Pris i hele kroner</td>
</tr>
<tr>
<td width="120"><br></td>
<td><br></td>
</tr>
<tr>
<td width="120"><b>Upload billede:</b></td>
<td><input type="file" name="upfil"></td>
</tr>
<tr>
<td width="120"><b>Tekst til billede:</b></td>
<td><input type="text" name="tekst"></td>
</tr>
<tr>
<td width="120"></td>
<td align="center"><input type="submit" value="send" name="up"></td>
</tr>
</table>
</form>
