数据不能进入数据库(PHP,SQL)


data can't enter database (php, sql)

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."";