将多个图像名称插入到相同的数据库字段中，以逗号分隔

Question

I have this script:

UPLOAD MULTIPLE FILES - PIECE OF CODE

foreach ($_FILES['files']['name'] as $f => $name) {    

    if ($_FILES['files']['error'][$f] == 0) {              
    } 

    else{ // No error found! Move uploaded files 
        $ext = pathinfo($_FILES['files']['name'][$f], PATHINFO_EXTENSION);
        $uniq_name = uniqid() . '.' .$ext;
        $dest = $path . $uniq_name; //FULL DESTINATION
        if(move_uploaded_file($_FILES["files"]["tmp_name"][$f], $dest)) {
            $count++;   
        }
    }
}

Please tell me how to insert into my mysql database all the photo names, in the PHOTOS field, separated by a comma.

When I'm writing the 2 lines code:

$a = "INSERT INTO dbu.dbu_data(photos) VALUES ('$uniq_name')";
mysql_query($a);

IT INSERTS A TABLE ROW FOR EACH PHOTO THAT WAS UPLOADED AND I DON'T WANT THAT.

Answer 1

$delimiter = ",";
$str = '';

foreach ($_FILES['files']['name'] as $f => $name) {

    if ($_FILES['files']['error'][$f] == 0) {

        // surely your move logic needs to go here

    } else{ // No error found! Move uploaded files
        $ext = pathinfo($_FILES['files']['name'][$f], PATHINFO_EXTENSION);
        $uniq_name = uniqid() . '.' .$ext;
        $dest = $path . $uniq_name; //FULL DESTINATION
        if(move_uploaded_file($_FILES["files"]["tmp_name"][$f], $dest)) {
            $count++;

            if (strlen($str)) {
                $str .= $delimiter;
            }

            $str .= $dest;

        }
    }

}

if (strlen($str)){

    $a = "INSERT INTO dbu.dbu_data(photos) VALUES ('" . mysql_real_escape_string($str) . "')";
    mysql_query($a);

}