Jump to content


Photo

Cannot run php upload file code. MySQL/PHP


  • Please log in to reply
No replies to this topic

#1 denismm778

denismm778

    Newbie

  • New Members
  • Pip
  • 2 posts

Posted 23 February 2013 - 12:39 PM

This is my HTML code:

<form class="stdform" action="php/sp1img.php" method="post">




<p name="title">
<label>Image:</label>
<span class="field">
<input type="file" name="sponsupload1" />
</span>








<p class="stdformbutton"><button class="btn btn-primary">Save!</button></p>
</p></form>
And here is my PHP script called "sp1img.php" :
<?php
session_start();
$con = mysql_connect("localhost","***","***");
mysql_query("SET NAMES UTF8");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("***", $con);


$allowedExts = array("jpg", "jpeg", "gif", "png");
$extension = end(explode(".", $_FILES["file"]["name"]));
if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/png")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 20000)
&& in_array($extension, $allowedExts))
  {
  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"],
      "upload/" . $_FILES["file"]["name"]);
      $sql = mysql_query("TRUNCATE TABLE sp1img");
      $qry= "INSERT INTO `sp1img` (`ImgCode`) VALUES ('". www.dsaidov.com/velto/admin/upload/$_FILES["file"]["name"] ."')";


      header("location: ../sponsors.php");
      exit();
      }
    }
  }
else
  {
  echo "Invalid file";
  }


  mysql_close($con);
?>
And when I choose file and click Save! it is always giving me Invalid File!, I really can't understand what is wrong. I hope you can help me.
Kind Regards, Denis Saidov

Edited by denismm778, 23 February 2013 - 12:40 PM.





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com