Error: Duplicate entry '' for Key 1
Posted: Mon Aug 13, 2007 12:55 pm
Here is my code
I'm not really sure whats causing it.
Code: Select all
<?php
include ('./header.html');
$con = mysql_connect("localhost","******","******");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("model", $con);
if (!isset($_POST['submiited'])) {
if ($_POST['gallery'] == 'fashion') {
$sql="INSERT INTO fashion (picname, style)
VALUES
('$_POST[picname]','$_POST[style]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 picture added";
if (($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
&& ($_FILES["file"]["size"] < 500000))
{
if ($_FILES["file"]["error"] > 0)
{
echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
}
else
{
echo "Upload: " . $_FILES["file"]["name"] . "<br />";
echo "Type: " . $_FILES["file"]["type"] . "<br />";
echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";
if (file_exists("upload/" . $_FILES["file"]["name"]))
{
echo $_FILES["file"]["name"] . " already exists. ";
}
else
{
move_uploaded_file($_FILES["file"]["tmp_name"],
"images/fashion/" . $_FILES["file"]["name"]);
echo "Stored in: " . "images/fashion/" . $_FILES["file"]["name"];
}
}
}
else
{
echo "Invalid file";
}
}
elseif ($_POST['gallery'] == 'glamour') {
$sql="INSERT INTO glamour (picname, style)
VALUES
('$_POST[picname]','$_POST[style]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 picture added";
if (($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
&& ($_FILES["file"]["size"] < 500000))
{
if ($_FILES["file"]["error"] > 0)
{
echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
}
else
{
echo "Upload: " . $_FILES["file"]["name"] . "<br />";
echo "Type: " . $_FILES["file"]["type"] . "<br />";
echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";
if (file_exists("upload/" . $_FILES["file"]["name"]))
{
echo $_FILES["file"]["name"] . " already exists. ";
}
else
{
move_uploaded_file($_FILES["file"]["tmp_name"],
"images/glamour/" . $_FILES["file"]["name"]);
echo "Stored in: " . "images/glamour/" . $_FILES["file"]["name"];
}
}
}
else
{
echo "Invalid file";
}
}
elseif($_POST['gallery'] == 'shows') {
$sql="INSERT INTO shows (picname, style)
VALUES
('$_POST[picname]','$_POST[style]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 picture added";
if (($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
&& ($_FILES["file"]["size"] < 500000))
{
if ($_FILES["file"]["error"] > 0)
{
echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
}
else
{
echo "Upload: " . $_FILES["file"]["name"] . "<br />";
echo "Type: " . $_FILES["file"]["type"] . "<br />";
echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";
if (file_exists("upload/" . $_FILES["file"]["name"]))
{
echo $_FILES["file"]["name"] . " already exists. ";
}
else
{
move_uploaded_file($_FILES["file"]["tmp_name"],
"images/shows/" . $_FILES["file"]["name"]);
echo "Stored in: " . "images/shows/" . $_FILES["file"]["name"];
}
}
}
else
{
echo "Invalid file";
}
}
elseif($_POST['gallery'] == 'tearsheets') {
$sql="INSERT INTO tearsheets (picname, style)
VALUES
('$_POST[picname]','$_POST[style]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 picture added";
if (($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
&& ($_FILES["file"]["size"] < 500000))
{
if ($_FILES["file"]["error"] > 0)
{
echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
}
else
{
echo "Upload: " . $_FILES["file"]["name"] . "<br />";
echo "Type: " . $_FILES["file"]["type"] . "<br />";
echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";
if (file_exists("upload/" . $_FILES["file"]["name"]))
{
echo $_FILES["file"]["name"] . " already exists. ";
}
else
{
move_uploaded_file($_FILES["file"]["tmp_name"],
"images/tearsheets/" . $_FILES["file"]["name"]);
echo "Stored in: " . "images/tearsheets/" . $_FILES["file"]["name"];
}
}
}
else
{
echo "Invalid file";
}
}else{ echo "Back to <a href='./index.php'>admin</a>";
}
}
mysql_close($con)
?>
<?php
include ('./footer.html');
?>