我有一个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,",");
}