[MySQL][PHP]multiple files upload php mysql Opcje

[wlodek_789]

Mam skrypt odpowiedzialny za przesyłanie jednego pliku i opisów. Plik jest przesyłany na serwer a informacje o nim wraz z opisem do bazy mysql. Chciałbym zrobić przesyłanie wielu plików ale nie wiem jak.
Z góry dziękuję za pomoc.

form

[PHP] pobierz, plaintext 
<form enctype="multipart/form-data"
action="upload_image.php" method="post">
 <input type="hidden"
name="MAX_FILE_SIZE" value="524288">
 
 <fieldset><legend>Select a JPEG or PNG
image of 512KB or smaller to be
uploaded:</legend>
 
 <p><b>File:</b> <input type="file"
name="filename" /></p>
 <p>
   <label for="caption">Caption:</label>
   <input type="text" name="caption" id="caption">
 </p>
 
 <p><b>File2:</b> <input type="file"
name="filename2" /></p>
 <p>
   <label for="caption2">Caption2:</label>
   <input type="text" name="caption" id="caption">
 </p>
 
 </fieldset>
 <div align="center"><input type="submit"
name="submit" value="Submit" /></div>
 <input type="hidden" name="submitted"
value="TRUE" />
 </form>
[PHP] pobierz, plaintext 

-------------------------------------------------------------------------------------------

php

[PHP] pobierz, plaintext 
<?php # Upload image
 
// Check if the form has been submitted:
if (isset($_POST['submitted'])) {
 
// Check for an uploaded file:
    if (isset($_FILES['filename'])) {
 
// Validate the type. Should be JPEG or PNG.
        $allowed = array ('image/pjpeg', 'image/jpeg', 'image/JPEG', 'image/JPG', 'image/X-PNG', 'image/PNG', 'image/png', 'image/x-png');
        if (in_array($_FILES['filename']['type'], $allowed)) {
 
// Move the file over.
            if (move_uploaded_file ($_FILES['filename']['tmp_name'], "../images/{$_FILES['filename']['name']}")) {
                echo '<p><em>The file has been uploaded!</em></p>';
            } // End of move... IF.
 
        } else { // Invalid type.
            echo '<p class="error">Please upload a JPEG or PNG image.</p>';
        }
    } // End of isset($_FILES['upload']) IF.
 
 
    @$path = $_FILES["filename"]["name"];
    @$path = mysql_real_escape_string($path);
    @$type = $_FILES["filename"]["type"];
    @$size = $_FILES["filename"]["size"];
    @$nazwa = $_POST["caption"];
 
    $query  = "INSERT INTO photographs (";
    $query .= "  filename, type, size, caption,";
    $query .= ") VALUES (";
    $query .= "  '{$path}', '{$type}', '{$size}', '{$caption}'";
    $query .= ")";
    echo $query;
 
    $result = mysqli_query($connection, $query);
    if ($result) {
        // Success
        echo " Success. ";
    } else {
        // Failure
        die(" Failure. " . mysqli_error($connection));
 
 
 // Check for an error:
 
 
    if ($_FILES['filename']['error'] > 0) {
        echo '<p class="error">The file could not be uploaded because: <strong>';
 
// Print a message based upon the error.
        switch ($_FILES['filename']['error']) {
            case 1:
                print 'The file exceeds the upload_max_filesize setting in php.ini.';
                break;
            case 2:
                print 'The file exceeds the MAX_FILE_SIZE setting in the HTML form.';
                break;
            case 3:
                print 'The file was only partially uploaded.';
                break;
            case 4:
                print 'No file was uploaded.';
                break;
            case 6:
                print 'No temporary folder was available.';
                break;
            case 7:
                print 'Unable to write to the disk.';
                break;
            case 8:
                print 'File upload stopped.';
                break;
            default:
                print 'A system error occurred.';
                break;
        } // End of switch.
 
        print '</strong></p>';
 
    } // End of error IF.
 
    // Delete the file if it still exists:
 
    if (file_exists ($_FILES['filename']['tmp_name']) && is_file($_FILES['filename']['tmp_name']) ) {
        unlink ($_FILES['filename']['tmp_name']);
    }   // End of the submitted conditional.        
} 
}
 
?>
[PHP] pobierz, plaintext 

[wlodek_789]

proszę to cały kod a i jeszcze w mysql mam coś takiego id filename filename2 type size nazwa nazwa2

[PHP] pobierz, plaintext 
<?php require_once("../../includes/functions_2.php"); ?>
<?php require_once("../../includes/session.php"); ?>
<?php require_once("../../includes/validation_functions.php"); ?>
<?php confirm_logged_in(); ?>
<?php
//1. polaczenie z baza danych
//polaczenie z baza danych + ustawienie kodowania na utf8
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "3edcvfr4";
$dbname = "dw_bookstore";
$connection = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
 
//sprawdzenie polaczenia
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
    exit();
}
 
//zmaiana znako na utf8
if (!mysqli_set_charset($connection, "utf8")) {
    printf("Error loading character set utf8: %s\n", mysqli_error($connection));
} else {
    //printf("Kodowanie ustawione na: %s\n", mysqli_character_set_name($connection));
}
?>
 
 
 
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Upload</title>
<link href="../../stylesheets/main_2.css" rel="stylesheet" type="text/css" media="screen, projection" />
</head>
 
<body>
<div id="wrapper">
  <div id="header">
    <h2>Cennik: Panel Administracyjny</h2>
  </div>
  <div id="mainContent">
  <h1>Witaj w panelu administracyjnym: <?php echo htmlentities($_SESSION["username"]); ?></h1> 
 
 <?php # Upload image
 
 for($i=0; $i <= 5; $i++) {
 
// Check if the form has been submitted:
if (isset($_POST['submitted'])) {
 
// Check for an uploaded file:
	if (isset($_FILES['filename'])) {
 
// Validate the type. Should be JPEG or PNG.
		$allowed = array ('image/pjpeg', 'image/jpeg', 'image/JPEG', 'image/JPG', 'image/X-PNG', 'image/PNG', 'image/png', 'image/x-png');
		if (in_array($_FILES['filename']['type'], $allowed)) {
 
// Move the file over.
			if (move_uploaded_file ($_FILES['filename']['tmp_name'], "../images/{$_FILES['filename']['name']}")) {
				echo '<p><em>The file has been uploaded!</em></p>';
			} // End of move... IF.
 
		} else { // Invalid type.
			echo '<p class="error">Please upload a JPEG or PNG image.</p>';
		}
	} // End of isset($_FILES['upload']) IF.
 
 
	@$path = $_FILES["filename"]["name"][$i];
	@$path = mysql_real_escape_string($path);
	@$type = $_FILES["filename"]["type"][$i];
	@$size = $_FILES["filename"]["size"][$i];
	@$nazwa = $_POST["nazwa"];
	//@$seria = $_POST["seria"];
	//@$kod = $_POST["kod"];
	//@$txt = $_POST["txt"];
	//@$visible = (int) $_POST["visible"];
 
	// przyklad - by moc wpisac 'costam' - tylko txt, nie "file" i "int"
	$nazwa = mysqli_real_escape_string($connection, $nazwa);
	//$seria = mysqli_real_escape_string($connection, $seria);
	//$kod = mysqli_real_escape_string($connection, $kod);
	//$txt = mysqli_real_escape_string($connection, $txt);
 
    $query  = "INSERT INTO photographs (";
	$query .= "  filename, type, size, nazwa ";
	$query .= ") VALUES (";
	$query .= "  '{$path}', '{$type}', '{$size}', '{$nazwa}'";
	$query .= ")";
	echo $query;
 
    $result = mysqli_query($connection, $query);
	if ($result) {
		// Success
		echo " Success. ";
	} else {
		// Failure
		die(" Failure. " . mysqli_error($connection));
 
 
 // Check for an error:
 
 
	if ($_FILES['filename']['error'] > 0) {
		echo '<p class="error">The file could not be uploaded because: <strong>';
 
// Print a message based upon the error.
		switch ($_FILES['filename']['error']) {
			case 1:
				print 'The file exceeds the upload_max_filesize setting in php.ini.';
				break;
			case 2:
				print 'The file exceeds the MAX_FILE_SIZE setting in the HTML form.';
				break;
			case 3:
				print 'The file was only partially uploaded.';
				break;
			case 4:
				print 'No file was uploaded.';
				break;
			case 6:
				print 'No temporary folder was available.';
				break;
			case 7:
				print 'Unable to write to the disk.';
				break;
			case 8:
				print 'File upload stopped.';
				break;
			default:
				print 'A system error occurred.';
				break;
		} // End of switch.
 
		print '</strong></p>';
 
	} // End of error IF.
 
	// Delete the file if it still exists:
 
	if (file_exists ($_FILES['filename']['tmp_name']) && is_file($_FILES['filename']['tmp_name']) ) {
		unlink ($_FILES['filename']['tmp_name']);
	}	// End of the submitted conditional.		
} 
}
 }
 
?>
    <form enctype="multipart/form-data"
    action="photo_upload_x.php" method="post">
    <input type="hidden"
    name="MAX_FILE_SIZE" value="524288">
 
    <fieldset><legend>Select a JPEG or PNG
    image of 512KB or smaller to be
    uploaded:</legend>
 
    <p><b>File:</b> <input type="file"
    name="filename[]" /></p>
    <p>
    <label for="nazwa">nazwa:</label>
    <input type="text" name="nazwa[]" id="nazwa">
    </p>
 
    <p><b>File2:</b> <input type="file"
    name="filename[]" /></p>
    <p>
    <label for="nazwa2">Nazwa2:</label>
    <input type="text" name="nazwa[]" id="nazwa2">
    </p>
 
    </fieldset>
    <div align="center"><input type="submit"
    name="submit" value="Submit" /></div>
    <input type="hidden" name="submitted"
    value="TRUE" />
    </form>
 
<?php
  // 5. Zamkniecie polaczenia
  mysqli_close($connection);
?>
  </div>
 
  <div id="footer">
 
  </div>
 
</body>
</html>
<?php if(isset($database)) { $database->close_connection(); } ?>
[PHP] pobierz, plaintext