php+通过url保存图片路径,php – 在DB列中保存图像URL路径

我正在通过php格式更新名称,在注册用户的DB中发送电子邮件.它的工作正常.

class.usr.php

public function update($uname,$email, $tax)

{

try {

$stmt = $this->conn->prepare('UPDATE tbl_users SET userName = ?, userEmail = ? , tax = ? WHERE userID = ? ');

$stmt->execute(array($uname,$email, $tax , $_SESSION['userSession']));

return $stmt->fetch();

} catch(PDOException $e) {

echo '

'.$e->getMessage().'

';

}

形成

Name :

Email :

Image

表单相关代码保存在db中

$user_home = new USER();

if(!$user_home->is_logged_in())

{

header("Location: index.php");

die();

}

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

// new data

$uname = $_POST['txtuname'];

$email = $_POST['txtemail'];

$tax = trim($_POST['tax']); // image url path

$uid = (isset($_SESSION['userSession']) ? intval($_SESSION['userSession']) : 0);

if ($uid > 0 && $user_home->update($uname,$email, $tax, $uid))

{

header("Location: profile1.php");

die();

}

}

$stmt = $user_home->runQuery("SELECT * FROM tbl_users WHERE userID=:uid");

$stmt->execute(array(":uid"=>$_SESSION['userSession']));

$row = $stmt->fetch(PDO::FETCH_ASSOC);

?>

在此之后,现在我通过以下代码成功地通过相同的PHP表单将图像上传到文件夹.

if(isset($_FILES["photo"]["error"])){

if($_FILES["photo"]["error"] > 0){

echo "Error: " . $_FILES["photo"]["error"] . "
";

} else{

$allowed = array("jpg" => "image/jpg", "jpeg" => "image/jpeg", "gif" => "image/gif", "png" => "image/png");

$filename = $_FILES["photo"]["name"];

$filetype = $_FILES["photo"]["type"];

$filesize = $_FILES["photo"]["size"];

// Verify file extension

$ext = pathinfo($filename, PATHINFO_EXTENSION);

if(!array_key_exists($ext, $allowed)) die("Error: Please select a valid file format.");

// Verify file size - 5MB maximum

$maxsize = 5 * 1024 * 1024;

if($filesize > $maxsize) die("Error: File size is larger than the allowed limit.");

// Verify MYME type of the file

if(in_array($filetype, $allowed)){

// Check whether file exists before uploading it

if(file_exists("upload/" . $_FILES["photo"]["name"])){

echo $_FILES["photo"]["name"] . " is already exists.";

} else{

move_uploaded_file($_FILES["photo"]["tmp_name"], "upload/" . $_FILES["photo"]["name"]);

echo "Your file was uploaded successfully.";

}

} else{

echo "Error: There was a problem uploading your file - please try again.";

}

}

} else{

echo "";

}

?>

现在图像只是保存在文件夹中,我需要的是我希望该图像路径保存在数据库中并将该图像路径分配给数据库中的上传用户.这样一个注册用户就可以更新现有图像,但不能再上传一个图像.

我尝试下面的代码,但没有工作：

$folder = "upload/";

$file = basename( $_FILES['image']['name']);

$full_path = $folder.$file;

$tax= $full_path;

if(in_array($filetype, $allowed)){

// Check whether file exists before uploading it

if(file_exists("upload/" . $_FILES["photo"]["name"])){

echo $_FILES["photo"]["name"] . " is already exists.";

} else{

move_uploaded_file($_FILES["photo"]["tmp_name"], "upload/" . $_FILES["photo"]["name"]);

echo "Your file was uploaded successfully.";

}

} else{

echo "Error: There was a problem uploading your file - please try again.";

}

}

} else{

echo "";

}

?>

db列：userName,userEmail,tax,photo

在谷歌的帮助下,我完成了以上所有,我是新来的PHP,所以请帮助我.