用php上传mysql表文件路径_使用PHP上传文件并将路径添加到MySQL数据库

Upload.php：

//This is the directory where images will be saved

$target = "pics";

$target = $target . basename( $_FILES['Filename']['name']);

//This gets all the other information from the form

$Filename=$_POST['Filename'];

$Description=$_POST['Description'];

$pic=($_FILES['Filename']['name']);

// Connects to your Database

mysql_connect("localhost", "root", "") or die(mysql_error()) ;

mysql_select_db("altabotanikk") or die(mysql_error()) ;

//Writes the information to the database

mysql_query("INSERT INTO picture (Filename,Description)

VALUES ('$Filename', '$Description')") ;

//Writes the Filename to the server

if(move_uploaded_file($_FILES['Filename']['tmp_name'], $target)) {

//Tells you if its all ok

echo "The file ". basename( $_FILES['uploadedfile']['Filename']). " has been uploaded, and your information has been added to the directory";

} else {

//Gives and error if its not

echo "Sorry, there was a problem uploading your file.";

}

?>

这是表格(在单独的文件中)：

Photo:

Description

错误是

Undefined index: Filename on Line 17

($ Filename = $ _ POST [‘Filename’];)

和

Undefined index: uploadedfile on Line 35

(回显“文件“。basename($ _FILES [‘uploadedfile’]

[‘Filename’])。”已经上传，并且您的信息已添加到目录中“；)

echo"

".print_r($_FILES,true)."

";

给我：

Array

(

[Filename] => Array

(

[name] => Laserkanon.jpg

[type] => image/jpeg

[tmp_name] => C:\WampServer\tmp\php11D4.tmp

[error] => 0

[size] => 41813

)

)