problemer med upload til database
Mit upload script ser ud som herunder,.. den uploader fint billederne til serveren de rigtige steder, men den smider ikke noget i databasen, hvordan kan det være?<?php require_once('../Connections/jernbanemaerker.php'); ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Jernbanemaerker</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="../css/styles.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style2 {color: #89744B}
-->
</style>
</head>
<body bgcolor="#D8C5A3">
<table width="900" border="0" align="center" cellpadding="0" cellspacing="0">
<tr align="right" valign="top">
<td width="900" height="143"><img src="../gfx/top_gfx_admin.jpg" width="900" height="143"></td>
</tr>
<tr>
<td height="503" valign="top" class="body" bgcolor="#F2E3C8"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr class="style2">
<td width="245" height="379" align="center" valign="top" class="left"><p> </p>
<h1><strong>Tilføj nyt produkt </strong></h1>
<p><a href="index.php">Til admin forside</a> </p></td>
<td width="655" align="center" valign="top" class="middle"><table width="90%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" align="left" valign="top"><p> </p>
<h1>Tilføj nyt produkt </h1>
<p><?php
echo '<form action="admin_new_product.php?action=gem" method="post" enctype="multipart/form-data" name="form1">';
echo '<table width="100%" border="0" cellspacing="0" cellpadding="0">';
echo '<tr><td width="23%">Navn:</td><td width="77%"><input name="itemName" type="text" size="60"></td></tr>';
echo '<tr><td valign="top">Beskrivelse:</td><td><textarea name="itemDesc" cols="50" rows="6"></textarea></td></tr>';
echo '<tr><td>Pris:</td><td><input name="itemPrice" type="text" size="60"></td></tr>';
echo '<tr><td>Billede: </td><td><input type="file" name="filnavnB" size="48"></td></tr>';
echo '<tr><td>Thumbnail: </td><td><input type="file" name="filnavnT" size="48"></td></tr>';
echo '<tr><td>Produkt type: </td><td><select name="itemType" id="itemType">';
echo '<option>Enkelt_mærke</option>';
echo '<option>5_stribe</option>';
echo '<option>Helark</option>';
echo '<option>Rulle</option>';
echo '</select><td></tr>';
echo '<tr><td></td><td><input name="" type="submit" value="Gem"></td></tr>';
echo '<td></td><td></td></tr></table></form>';
if($action=="gem"){
$tempfile = $_FILES['filnavnB']['tmp_name'];
$destination = "../gallery/billeder/{$_FILES['filnavnB']['name']}";
move_uploaded_file($tempfile, $destination);
$tempfile = $_FILES['filnavnT']['tmp_name'];
$destination = "../gallery/thumbs/{$_FILES['filnavnT']['name']}";
move_uploaded_file($tempfile, $destination);
$name = $HTTP_POST_VARS['itemName'];
global $billede;
global $thumb;
$billede = $_FILES['filnavnB']['name'];
$thumb = $_FILES['filnavnT']['name'];
$desc = $HTTP_POST_VARS['itemDesc'];
$price = $HTTP_POST_VARS['itemPrice'];
$type = $HTTP_POST_VARS['itemType'];
$mainId = $HTTP_POST_VARS['mainId'];
$sql = "insert into items (itemName, itemDesc, itemPrice, itemPhoto, itemThumb, itemType, mainId) values ('$name', '$desc', '$price', '$billede', '$thumb', '$type', '$mainId')";
echo $sql;
$result = mysql_query($sql);
//echo "<script>parent.location='index.php';</script>";
?>
}
</p></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
