字符串没有以正确的格式组合



我有一个SQL字符串和两个具有字符串返回的函数。 我正在尝试将它们组合在一起:

echo "INSERT INTO product_cat( ".columnPrinter(getTables("product_cat"))." ) VALUES ( ".dataPrinter($_POST['addMenu'])." )";

但是函数没有打印在正确的位置,它们都只是转到第一个而不是括号中! 结果是这样的: 结果

我的函数是:

function dataPrinter($data){
foreach($data as $dt){
$names .= "'".$dt."',";
}
echo rtrim($names,",");
}
function columnPrinter($columns){
foreach($columns as $clm){
$names .= $clm['Field'].",";
}
echo rtrim($names,",");
}

我尝试使用变量,即使结果相同。

只返回结果,不要打印它:

function dataPrinter($data){
$names = '';    
foreach($data as $dt){
$names .= "'".$dt."',";
}
return rtrim($names,",");
}
function columnPrinter($columns){
$names = '';
foreach($columns as $clm){
$names .= $clm['Field'].",";
}
return rtrim($names,",");
}

最新更新