在同一数据库字段中插入多个图像名称，用逗号分隔 - Insert multiple image names into same database field, separated by comma

Insert multiple image names into same database field, separated by comma

我有这个脚本：

上传多个文件-一段代码

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++;   
        }
    }
}

请告诉我如何在我的mysql数据库中插入照片字段中的所有照片名称，用逗号分隔。

当我写2行代码时：

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

它为上传的每张照片插入一行表格，我不希望这样。

$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);
}