file upload problems

hammerklavier

well I give up....... been all day trying to make this work out......... it's a simple upload function............. when I upload the file it goes runs the DIE function......... no idea why..... I've tried everything ......thanks in advance.....

oh when I run the is_uploaded function it executes the else "echo "All is ok so far ...... ";......... so at that point it seems everything is fine.......

even ran a bunch of echoes to see if there was a problem...... folder is 777 btw.....

thanks in advance

//phpinfo();

echo getcwd();

if (!$question || !$answer)
{
echo "Fill all fields";
echo "<a href='creategallery.php'>Go back</a>";
}

$db = @mysql_pconnect("localhost", "login", "password");
if (!$db)
{
echo "Error";
exit;
}

if (mysql_select_db("database_com"))
{
echo "Connection successful ";
}

$sql = "insert into test_questions (question, answer, imagefile) values ('$question', '$answer', '$filename')";

$estado = mysql_query($sql, $db);

$qry = mysql_fetch_array($estado);

if (!$estado)
{
print "Problem while executing .......<PRE>$sql</PRE>";
print mysql_error();
exit;
}

echo " ".$filename;
echo " ".$question." ";

if (!is_uploaded_file($filename))
{
echo "Problem uploading the file";
} else {
echo "All is ok so far ...... ";
}

if ($poster_name != "")
{

move_uploaded_file("$filename", "/store/home/site/html/qa/$poster_name") or die("Couldn't Upload Your File.");

} else {

  die("YOU HAVEN'T UPLOADED ANYTHING!");

}

if (!$total)
{
$total = mysql_insert_id();

  $sql = "update test_questions set imagefile = '$poster_name' where id = $total";
  $result = mysql_query($sql,$conn);


  echo $qry[question];           
  echo "<center><font face='arial' size='2'><b>Cool addition man !</b></font></center><br><br><br>";
  echo "<center><font face='arial' size='2'><b><a href='add.html'>Add another question</a></b></font></center><br>";

}

djjjozsi

Hello,

have you heard register globals=OFF? If not, lets search on google about that 'problem'.
and when you post to this forum, please use the

[/php ]  tags around your code.

here is ideas about how you could make this upload better.
(and i change your p connect into normal connect)

[code=php]<?php

//phpinfo();

echo getcwd();
extract($_POST);

if (!$question || !$answer)
{
echo "Fill all fields";
echo "<a href='creategallery.php'>Go back</a>";
}

$db = mysql_connect("localhost", "login", "password") or die(mysql_error());
if (!$db)
{
echo "Error";
exit;
}

if (mysql_select_db("test"))
{
echo "<font face=Arial, Helvetica, sans-serif size=2>Connection successful </font><br><br>";
}

$_POST=array_map("mysql_real_escape_string",$_POST);
$filename=mysql_real_escape_string(basename($_FILES["filename"]["name"]));

$sql = "insert into test_questions (question, answer, imagefile) values ('$question', '$answer', '$filename')";

$estado = mysql_query($sql, $db) or die(mysql_error().$sql);
/*$qry = mysql_fetch_array($estado) or dir(mysql_error());*/

/*after insert into database you cant get that insert with mysql_fetch (if i'm not mistaken*/


echo "<br><br>".$filename;
echo "<br><br>".$question."<br><br>";

if (!is_uploaded_file($_FILES["filename"]["tmp_name"]))
{
echo "Problem uploading the file";
} else {
echo "All is ok so far ......<br><br>";
}

/* WHERE THIS $poster_name comes from ????   */

if (!empty($poster_name))
{
move_uploaded_file($_FILES["filename"]["tmp_name"], "/store/home/site/html/qa/".$poster_name) or die("Couldn't Upload Your File.");

} else {

die("YOU HAVEN'T ADD UPLOADED FILENAME");
}

//how you get this total ???
if (empty($total))
{
$total = mysql_insert_id();

/*
$sql = "update test_questions set imagefile = '$poster_name' where id = $total";
$result = mysql_query($sql,$conn);
*/

echo $qry[question];  // <---- WHAT IS THIS??
echo "<center><font face='arial' size='2'><b>Cool addition man !</b></font></center><br><br><br>";
echo "<center><font face='arial' size='2'><b><a href='add.html'>Add another question</a></b></font></center><br>";

}
?>