indsætte flere entries i min DB på én gang
Jeg prøver at få min php fil til at indsætte tre forskellige entries i databasen på én gang med følgende script:Den kommer ikke med fejl, men den indsætter kun én entry og der kommer ikke nogen itemPrice, itemQty eller itemType ind i DB´en alt andet kommer fint ind.
Håber der er en venlig sjæl der kan hjælpe stakkels mig :P
<?php
// This page will list all of the items
// from the items table. Each item will have
// a link to add it to the cart
include("../db.php");
// Get a connection to the database
$cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);
?>
<!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
if($action=="ny"){
echo '<form action="admin_new_product.php?mainId=';
echo $_GET["mainId"];
echo '&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 1:</td><td><input name="itemPriceA" type="text" size="60"></td></tr>';
echo '<tr><td>Pris 2:</td><td><input name="itemPriceB" type="text" size="60"></td></tr>';
echo '<tr><td>Pris 3:</td><td><input name="itemPriceC" type="text" size="60"></td></tr>';
echo '<tr><td>Antal 1:</td><td><input name="itemQtyA" type="text" size="60"></td></tr>';
echo '<tr><td>Antal 2:</td><td><input name="itemQtyB" type="text" size="60"></td></tr>';
echo '<tr><td>Antal 3:</td><td><input name="itemQtyC" 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 1: </td><td><select name="itemTypeA" id="itemTypeA">';
echo '<option>Enkelt_mærke</option>';
echo '<option>5_stribe</option>';
echo '<option>25_stribe</option>';
echo '<option>Helark</option>';
echo '</select><td></tr>';
echo '<tr><td>Produkt type 2: </td><td><select name="itemTypeB" id="itemTypeB">';
echo '<option>Enkelt_mærke</option>';
echo '<option>5_stribe</option>';
echo '<option>25_stribe</option>';
echo '<option>Helark</option>';
echo '</select><td></tr>';
echo '<tr><td>Produkt type 3: </td><td><select name="itemTypeC" id="itemTypeC">';
echo '<option>Enkelt_mærke</option>';
echo '<option>5_stribe</option>';
echo '<option>25_stribe</option>';
echo '<option>Helark</option>';
echo '</select><td></tr>';
echo '<tr><td></td><td><input name="submit" 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'];
$priceA = $HTTP_POST_VARS['itemPriceA'];
$priceB = $HTTP_POST_VARS['itemPriceB'];
$priceC = $HTTP_POST_VARS['itemPriceC'];
$quantityA = $HTTP_POST_VARS['itemQtyA'];
$quantityB = $HTTP_POST_VARS['itemQtyB'];
$quantityC = $HTTP_POST_VARS['itemQtyC'];
$typeA = $HTTP_POST_VARS['itemTypeA'];
$typeB = $HTTP_POST_VARS['itemTypeB'];
$typeC = $HTTP_POST_VARS['itemTypeC'];
$mainId = $_GET["mainId"];
$sqla = "insert into items (itemName, itemDesc, itemPrice, itemQty, itemPhoto, itemThumb, itemType, mainId) values ('$name', '$desc', '$priceA', '$quantityA', '$billede', '$thumb', '$typeA', '$mainId')";
$sqlb = "insert into items (itemName, itemDesc, itemPrice, itemQty, itemPhoto, itemThumb, itemType, mainId) values ('$name', '$desc', '$priceB', '$quantityB', '$billede', '$thumb', '$typeB', '$mainId')";
$sqlc = "insert into items (itemName, itemDesc, itemPrice, itemQty, itemPhoto, itemThumb, itemType, mainId) values ('$name', '$desc', '$priceC', '$quantityC', '$billede', '$thumb', '$typeC', '$mainId')";
echo $sql;
$resulta = mysql_query($sqla) or die(mysql_error());
$resultb = mysql_query($sqlb) or die(mysql_error());
$resultc = mysql_query($sqlc) or die(mysql_error());
echo "<script>parent.location='index.php'</script>";
}
if($action=="edit"){
$sql = "select * from Artist where itemsId like ";
$sql .= $HTTP_POST_VARS['itemsId'];
$artist = mysql_query($sql);
while($row = mysql_fetch_array($artist)){
echo "<br>Editér kunsnter:";
echo "<form name=kuntner method=post action=admin_artist.php?action=update>";
echo "<table width=100% border=0 cellspacing=0 cellpadding=0><tr>";
echo "<td>Navn:</td>";
echo "<td><input type=text name=navn value='";
echo $row['itemName'];
echo "'>";
echo "<input type=hidden name=Id value=";
echo $row['itemId'];
echo ">";
echo "</td></tr>";
echo "<tr><td>Beskrivelse:</td><td><textarea name=desc>";
echo $row['itemDesc'];
echo "</textarea></td></tr>";
echo "<tr><td>menu-billede:</td><td>";
echo $row['menu_gfx'];
echo " <a href= java script:; onClick=MM_openBrWindow('Change_Menu.php?ID=";
echo $row["ID"];
echo "','Ændring','width=400,height=175')>ændr via popup</a></td></tr>";
echo "<tr><td>pic:</td><td>";
echo $row['Pic'];
echo " <a href= java script:; onClick=MM_openBrWindow('Change_Pic.php?ID=";
echo $row["ID"];
echo "','Ændring','width=400,height=175')>ændr via popup</a></td></tr>";
echo "<tr><td>Gallery-billede:</td><td>";
echo $row['Gallery_pic'];
echo " <a href= java script:; onClick=MM_openBrWindow('Change_Gallery.php?ID=";
echo $row["ID"];
echo "','Ændring','width=400,height=175')>ændr via popup</a></td></tr>";
echo "<tr><td> </td><td><input type=submit name=Submit value=gem></td></tr>";
echo "</table> </form>";
}
}
?></p></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
</body>
</html>
/Snig
