php数据查询的时候字符串变量要加引号

$updatesql = "update floors set room=room + '1' where buildings_id=$_GET[id] and floor_name='$str'";