将文件路径保存到数据库/SQL [英] Saving file path to Database / SQL

问题描述

INTRO:我正在创建一个社交网络"网站.它更像是学习活动，而不是商业活动. 我创建了登录和注册的简单版本(不加密)，它们使用PHPMyadmin进行工作.

INTRO: I'm creating a 'Social network' site. It's more of a learning exercise than a business venture. I have created the simple version of login and registration (without encryption) they use PHPMyadmin and work.

我已经创建了一个上传图片的表单(稍后显示).图片保存到服务器，然后我需要存储db的路径...但是多数民众赞成在哪里哪里错了！

I've created a form to upload a picture (to later be displayed). The picture saves to the server, then i need to store the path to the db... but thats the bit where is all going wrong!!

每个页面都包含"session_start();"

Every page includes "session_start();"

表格:

<form action="upload_ppl.php" method="post"
enctype="multipart/form-data">
<label for="file">Filename:</label>
<input type="file" name="file" id="file"><br>
<input type="submit" name="submit" value="Submit">
</form>

upload_ppl.php:

upload_ppl.php:

<?php
session_start();

$allowedExts = array("gif", "jpeg", "jpg", "png");
$temp = explode(".", $_FILES["file"]["name"]);
$extension = end($temp);
if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/jpg")
|| ($_FILES["file"]["type"] == "image/pjpeg")
|| ($_FILES["file"]["type"] == "image/x-png")
|| ($_FILES["file"]["type"] == "image/png"))
&& ($_FILES["file"]["size"] > 2000)
&& 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
      {
          $image_name= $FILES["file"]["name"];
          $path=move_uploaded_file($_FILES["file"]["tmp_name"],
      "upload/" . rand().$_FILES["file"]["name"]);
      echo "Stored in: " . "upload/" . $_FILES["file"]["name"];

      if(mysql_query("INSERT INTO *table* (*column*) VALUES ('$path')")){
          echo "Successfull!!";} else {
            echo 'fail';}
      }
    } 
  }
else
  {
  echo "Invalid file";
  }
?>

请注意，登录后在"connection.page"上已建立数据库连接！ 我是否需要使用会话变量来继续前进，只是一起创建一个新的连接? 我试过吨.所有建议表示赞赏.谢谢大家！

Please note that on the 'connection.page' upon login the db connection is established! Do I need to carry this forward with a session variable, just create a new connection all together? I've tried tons. All suggestions appreciated. Thanks guys!

推荐答案

您的$ path都是错误的. 用这个来纠正你的其他情况

your $path is all wrong. Correct your else with this

  else
     {
      $image_name = rand().$_FILES["file"]["name"];
      $path = "upload/" . $imagename;
      move_uploaded_file($_FILES["file"]["tmp_name"],$path);

  echo "Stored in: " . $path;

  if(mysql_query("INSERT INTO *table* (*column*) VALUES ('$path')")){
      echo "Successfull!!";} else {
        echo 'fail';}
  }

这篇关于将文件路径保存到数据库/SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！