Could you help me solve the problem
The code bellow locate the image path just in "image1"
Something like this
id image1 image2 image3 image4 image5 image6

1 pic1
2 pic2

but I need to get something like this

id image1 image2 image3 image4 image5 image6

1 pic1 pic2 pic2 pic2 pic2 pic2
2

foreach($active_keys as $key)
{
    @move_uploaded_file($_FILES[$fieldname]['tmp_name'][$key], $uploadFilename[$key])
        or error('receiving directory insuffiecient permission', $uploadForm);

        $query_part_1 = '';
$query_part_2 = '';
$i = 1;



   // add the comma AFTER you write the key/values to the strings
$query_part_1 .= " image" . $i++ . ",";
$query_part_2 .= " '" . $uploadFilename[$key]. "',";  

   $query_part_1 = preg_replace("/,$/","",$query_part_1); // remove the comma at the end of the string
$query_part_2 = preg_replace("/,$/","",$query_part_2); 

$query = "INSERT INTO `imloop` (" .$query_part_1. ") VALUES (" .$query_part_2. ")";

        mysql_query($query) or exit($query . '<br />' . mysql_error()); 


     }  

mysql_close($connection);

Recommended Answers

All 2 Replies

$i = 1;/// has to be outside the foreach loop
foreach($active_keys as $key)
{// rest of the script}

$i    = 1;
$cols = array();
$data = array();
// 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]);  //<-- note that I removed the quotes                         
    }   
$cols =  array_map ('mysql_real_escape_string', $cols);  
$data=  array_map ('mysql_real_escape_string', $data);
        $query = 'INSERT INTO `imloop` (' . implode(', ', $cols) . ') VALUES ("' . implode('", "', $data) . '")';

        mysql_query($query) or exit($query . '<br />' . mysql_error()); 

I have changed code as you told me but now it sends data as shown bellow

INSERT INTO `imloop` (`id`, `image1`, `image2`, `image3`, `image4`, `image5`, `image6`) VALUES
(1, '1352903903-1.jpg', 1352903903, 1352903903, 1352903903, 1352903903, 1352903903);

or

INSERT INTO `imloop` (`id`, `image1`, `image2`, `image3`, `image4`, `image5`, `image6`) VALUES
(1, '1352903903-1.jpg', 1352903903, 1352903903, 1352903903, 1352903903, 1352903903),       // here I tried to upload 6 different images
(2, '1352904073-6.jpg', 1352904073, 0, 0, 0, 0),                                 // here I tried to upload 2 different images
(3, '1352904279-1.jpg', 1352904279, 1352904279, 0, 0, 0),                 // here I tried to upload 3 different images
(4, '1352904587-1.jpg', 1352904587, 1352904587, 0, 0, 0);
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.