Multiply uploading images problem...

images php coding issues or problems here.

Moderators: macek, egami, gesf

mbmkd
New php-forum User
New php-forum User
Posts: 1
Joined: Thu Sep 27, 2012 3:44 am

Multiply uploading images problem...

Postby mbmkd » Thu Sep 27, 2012 3:50 am

Hello. I have a problem with uploading images name in my sql table.

here is the all code:

Code: Select all

<?php
$photo0=($_FILES['photo']['name']);
$photo1=($_FILES['photo1']['name']);
$photo2=($_FILES['photo2']['name']);
$photo3=($_FILES['photo3']['name']);
$photo4=($_FILES['photo4']['name']);
$photo5=($_FILES['photo5']['name']);

//This is the directory where images will be saved
$target = "images/upload/";
$targetx = $target . basename( $_FILES['photo']['name']);

//Writes the photo to the server
if(move_uploaded_file($_FILES['photo']['tmp_name'], $targetx))
{

//Tells you if its all ok
}
else {
//Gives and error if its not
}

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

//Writes the photo to the server
if(move_uploaded_file($_FILES['photo1']['tmp_name'], $targetx))
{

//Tells you if its all ok
}
else {
//Gives and error if its not
}
$targetx = $target . basename( $_FILES['photo2']['name']);

//Writes the photo to the server
if(move_uploaded_file($_FILES['photo2']['tmp_name'], $targetx))
{

//Tells you if its all ok
}
else {
//Gives and error if its not
}

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

//Writes the photo to the server
if(move_uploaded_file($_FILES['photo3']['tmp_name'], $targetx))
{

//Tells you if its all ok
}
else {
//Gives and error if its not
}

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

//Writes the photo to the server
if(move_uploaded_file($_FILES['photo4']['tmp_name'], $targetx))
{

//Tells you if its all ok
}
else {
//Gives and error if its not
}

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

//Writes the photo to the server
if(move_uploaded_file($_FILES['photo5']['tmp_name'], $targetx))
{

//Tells you if its all ok
}
else {
//Gives and error if its not
}

include "phpscripts/connect_to_mysql.php";

foreach(array($photo0, $photo1, $photo2, $photo3, $photo4, $photo5) as $value){
$sql="INSERT INTO `images` (`photo`,`ime`) VALUES('".$value."', 'spain')";

}
$result=mysql_query($sql);




I think that i have mistake in this code:

Code: Select all

foreach(array($photo0, $photo1, $photo2, $photo3, $photo4, $photo5) as $value){
$sql="INSERT INTO `images` (`photo`,`ime`) VALUES('".$value."', 'spain')";

}


Thanks

alfaperk
New php-forum User
New php-forum User
Posts: 1
Joined: Mon Nov 26, 2012 12:45 pm

Re: Multiply uploading images problem...

Postby alfaperk » Mon Nov 26, 2012 12:51 pm

You can use the code like bellow

Code: Select all

<?php 

// filename: upload.processor.php

// first let's set some variables

include("conf.php");

  // open database connection
      $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
      //$db = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
      
  // select database
      mysql_select_db($db) or die ("Unable to select database!");


// make a note of the current working directory, relative to root.
$directory_self = str_replace(basename($_SERVER['PHP_SELF']), '', $_SERVER['PHP_SELF']);

// make a note of the directory that will recieve the uploaded files
$uploadsDirectory = $_SERVER['DOCUMENT_ROOT'] . $directory_self . 'uploaded_files/';

// make a note of the location of the upload form in case we need it
$uploadForm = 'http://' . $_SERVER['HTTP_HOST'] . $directory_self . 'multiple.upload.form.php';

// make a note of the location of the success page
$uploadSuccess = 'http://' . $_SERVER['HTTP_HOST'] . $directory_self . 'multiple.upload.success.php';

// name of the fieldname used for the file in the HTML form
$fieldname = 'file';

//echo'<pre>';print_r($_FILES);exit;



// Now let's deal with the uploaded files

// possible PHP upload errors
$errors = array(1 => 'php.ini max file size exceeded',
                2 => 'html form max file size exceeded',
                3 => 'file upload was only partial',
                4 => 'no file was attached');

// check the upload form was actually submitted else print form
isset($_POST['submit'])
   or error('the upload form is neaded', $uploadForm);
   
// check if any files were uploaded and if
// so store the active $_FILES array keys
$active_keys = array();
foreach($_FILES[$fieldname]['name'] as $key => $filename)
{
   if(!empty($filename))
   {
      $active_keys[] = $key;
   }
}

// check at least one file was uploaded
count($active_keys)
   or error('No files were uploaded', $uploadForm);
      
// check for standard uploading errors
foreach($active_keys as $key)
{
   ($_FILES[$fieldname]['error'][$key] == 0)
      or error($_FILES[$fieldname]['tmp_name'][$key].': '.$errors[$_FILES[$fieldname]['error'][$key]], $uploadForm);
}
   
// check that the file we are working on really was an HTTP upload
foreach($active_keys as $key)
{
   @is_uploaded_file($_FILES[$fieldname]['tmp_name'][$key])
      or error($_FILES[$fieldname]['tmp_name'][$key].' not an HTTP upload', $uploadForm);
}
   
// validation... since this is an image upload script we
// should run a check to make sure the upload is an image
foreach($active_keys as $key)
{
   @getimagesize($_FILES[$fieldname]['tmp_name'][$key])
      or error($_FILES[$fieldname]['tmp_name'][$key].' not an image', $uploadForm);
}
   
// make a unique filename for the uploaded file and check it is
// not taken... if it is keep trying until we find a vacant one
foreach($active_keys as $key)
{
   $now = time();
   while(file_exists($uploadFilename[$key] = $uploadsDirectory.$now.'-'.$_FILES[$fieldname]['name'][$key]))
   {
      $now++;
      
   }
}
//$key$key = 0;
 
$i    = 1;

// now let's move the file to its final and allocate it with the new filename

foreach($active_keys as $key)

{

   @move_uploaded_file($_FILES[$fieldname]['tmp_name'][$key],$uploadFilename[$key])
      or error('receiving directory insuffiecient permission', $uploadForm);
                
$cols[] = "image" . $i++;  //<-- note that I removed the comma
     
      $data[] = "'" . basename($uploadFilename[$key]) . "'";
            
         

   }    
      
   
      $query = 'INSERT INTO `imloop` (' . implode(', ', $cols) . ') VALUES (' . implode(', ', $data) . ')';
      
      
      mysql_query($query) or exit($query . '<br />' . mysql_error());
            



mysql_close($connection);
   
// If you got this far, everything has worked and the file has been successfully saved.
// We are now going to redirect the client to the success page.
header('Location: ' . $uploadSuccess);


// make an error handler which will be used if the upload fails
function error($error, $location, $seconds = 5)
{
   header("Refresh: $seconds; URL=\"$location\"");
   echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"'."\n".
   '"http://www.w3.org/TR/html4/strict.dtd">'."\n\n".
   '<html lang="en">'."\n".
   '   <head>'."\n".
   '      <meta http-equiv="content-type" content="text/html; charset=iso-8859-1">'."\n\n".
   '      <link rel="stylesheet" type="text/css" href="stylesheet.css">'."\n\n".
   '   <title>Upload error</title>'."\n\n".
   '   </head>'."\n\n".
   '   <body>'."\n\n".
   '   <div id="Upload">'."\n\n".
   '      <h1>Upload failure</h1>'."\n\n".
   '      <p>An error has occured: '."\n\n".
   '      <span class="red">' . $error . '...</span>'."\n\n".
   '       The upload form is reloading</p>'."\n\n".
   '    </div>'."\n\n".
   '</html>';
   exit;
} // end error handler

?>


Return to “PHP coding => Images”

Who is online

Users browsing this forum: No registered users and 0 guests