upload.php:
<?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."; } ?> А вот форма (в отдельном файле):
<form method="post" action="upload.php" enctype="multipart/form-data"> <p>Photo:</p> <input type="file" name="Filename"> <p>Description</p> <textarea rows="10" cols="35" name="Description"></textarea> <br/> <input TYPE="submit" name="upload" value="Add"/> </form>
Ошибки
Undefined index: Filename on Line 17
($ Filename = $ _ POST ['Filename'];)
а также
Undefined index: uploadedfile on Line 35
(echo «Файл». basename ($ _FILES ['uploadedfile'] ['Filename']). "был загружен, и ваша информация была добавлена в каталог";)
echo"<pre>".print_r($_FILES,true)."</pre>";
дает мне:
Array ( [Filename] => Array ( [name] => Laserkanon.jpg [type] => image/jpeg [tmp_name] => C:\WampServer\tmp\php11D4.tmp [error] => 0 [size] => 41813 ) )
Сначала вы должны использовать print_r($_FILES) для отладки и посмотреть, что он содержит. :
ваш uploads.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=basename( $_FILES['Filename']['name']); $Description=$_POST['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['Filename']['name']). " has been uploaded, and your information has been added to the directory"; // 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')") ; } else { //Gives and error if its not echo "Sorry, there was a problem uploading your file."; } ?>
mysql_connect("localhost", "root", "") or die(mysql_error()) ; mysql_select_db("altabotanikk") or die(mysql_error()) ;
Эти устаревшие используют следующее.
// Connects to your Database $link = mysqli_connect("localhost", "root", "", "");
и для вставки данных используйте следующие
$sql = "INSERT INTO Table-Name (Column-Name) VALUES ('$filename')" ;