hye,我有一个代码,我尝试将其输入数据库
/*example data
$areaSes = Area 1
$row['area'] = Area 2;
*/
$area = $areaSes . ',' . $row['area'] ;
echo 'output :' . $area;
//output
//output : Area 1 , Area 2
但是,在数据库中,只输入值区域 1,但值 2 没有为什么会变成这样?
代码
$plugins1 = '';
if(!empty($_POST['checkboxvar'])) {
foreach($_POST['checkboxvar'] as $plugins) {
$plugins;
$sql="SELECT * FROM reportevidence where id='$plugins'";
$result_set=mysql_query($sql);
while($row=mysql_fetch_array($result_set))
{
//$area = $areaSes . ',' . $row['area'] ;
$area = "".$areaSes.",".$row['area']."";
}
echo "output:".$area.""; // output: Area 1, Area 2
$queryPass = mysql_query("update reportevidence set usedByArea='$area' where id = '$plugins' ",$conn);
//$plugins1 .= $plugins.":";
}}
数据库我的数据库的图像
我希望它是区域 1、区域 2
如果你正在循环一行,你是否在尝试连接字符串?
尝试
$area .= $areaSes . ',' . $row['area'] ;
echo 'output :' . $area;
试试这个。
$area = "".$areaSes.",".$row['area']."";
echo "output:".$area."";