php - 如何使用php将照片上传到数据库和文件夹中

Question

<小时/>

你好，我是这个论坛的新人，也是 php 的新人。我正在创建一个项目，我想将照片上传到数据库中，并将该照片存储在另一个文件夹中。我找到了一个教程，但它仅讨论他输入的用户名，而不是数据库中的用户名，例如下面所示的“member.php”中的用户名。有人可以帮助我纠正我的 PHP 代码并使其适用于我的数据库吗？请有人帮助我，我立即需要它......

以这种方式创建我的数据库

<小时/>

id |全名 |用户名 |密码 |文件位置 |

<小时/>

1 |无名|马利泰特 | 3423@!#4 | |

<小时/>

我想要数据库中存在的用户，例如该用户“malitet”已登录并且该用户上传头像...

这是我的 php 代码

文件名为upload.php

<?php

include ("connect.php");

$_SESSION['username']=malitet   ;

$username = $_SESSION['username'];


if (isset($_POST['submit']))
{

//get file attributes
$name = $_FILES['myfile']['name'];
$tmp_name = $_FILES['myfile']['tmp_name'];

if ($name)
{

//start upload process

$location = "avatars/$name";
move_uploaded_file($tmp_name,$location);

$query = mysql_query("UPDATE users1 SET imagelocation='$location' WHERE username='$username'");

die ("Your avatar has been uploaded!<a href='view.php'>Home</a>");


}
else
die ("Please select a file!");


}


echo "Welcome, ".$username."!<p>";

echo "Upload your image

<form action='upload.php' method='POST' enctype='multipart/form-data'>
File: <input type='file' name='myfile'><input type='submit' name='submit' value='Upload'>

</form>

";

?>

这是我的 connect.php

<?php
$error = "Unable to connect";
$connect = mysql_connect("localhost","root","") or die($error);
mysql_select_db('phplogin') or die ($error);
?>

这是我的 view.php

<?php

include ("connect.php");

$username = $_SESSION['username'];

$query = mysql_query("SELECT * FROM users1 WHERE username='$username'");
if (mysql_num_rows('$query')==1)
die ("User not found!");
else
{

$row = mysql_fetch_assoc($query);
$location = $row['imagelocation'];

echo "<img src='$location' width='100' height='100'>";

}   

?>

这是我想上传文件的成员(member)页面...或者如果存在任何其他方式，但我知道它很简单，如果有人可以帮助我----member.php

<?php

session_start();

if (isset($_SESSION['username']))
echo "Welcome, ".$_SESSION['username']."!<br><a href='logout.php'>Log out</a><br><a href='changepassword.php'>Change password</a>";
else
die ("You must be logged in! <a href='index.php'>Click here</a> to return to login page");

?>

我希望你能帮助我...我正在等待答案...:):):)

Answer 1

嗨，有一些错误。始终在使用之前启动 session 。好的使用此代码:

这是upload.php文件

<?php

session_start();
include ("connect.php");

$_SESSION['username'] = 'malitet';

$username = $_SESSION['username'];


if (isset($_POST['submit']))
{

//get file attributes
    $name = $_FILES['myfile']['name'];
    $tmp_name = $_FILES['myfile']['tmp_name'];

    if ($name)
    {
        //start upload process
        $location = "avatars/" . $name;
        move_uploaded_file($tmp_name, $location);
        $sql = "UPDATE users1 SET imagelocation='$location' WHERE username='$username'";
        $query = mysql_query($sql);
        echo "Your avatar has been uploaded!<a href='view.php'>Home</a>";
    }
    else die("Please select a file!");
}
echo "Welcome, " . $username . "!<p>";

echo "Upload your image

<form action='upload.php' method='POST' enctype='multipart/form-data'>
File: <input type='file' name='myfile'><input type='submit' name='submit' value='Upload'>

</form>

";
?>

================================================== =

这是view.php文件

<?php

include ("connect.php");
session_start();
$username = $_SESSION['username'];


$sql = "SELECT * FROM users1 WHERE username='$username'";
$query = mysql_query($sql);
if (mysql_num_rows($query) == 1)
{
    $row = mysql_fetch_assoc($query);
    $location = $row['imagelocation'];
    echo "<h1>Welcome</h1><br/>";
    echo "<img src='$location' width='100' height='100'>";
}
else
{
    echo "User Not found";
}
?>

==================================================

并且 connect.php 文件没问题，因此您可以使用之前的文件