Question

php拼接字符串

$str = "select sum(nvl(month_1,0)) as M1,sum(nvl(month_2,0)) as M2,sum(nvl(month_3,0)) as M3,sum(nvl(month_4,0)) as M4,sum(nvl(month_5,0)) as M5,sum(nvl(month_6,0)) as M6,
sum(nvl(month_7,0)) as M7,sum(nvl(month_8,0)) as M8,sum(nvl(month_9,0)) as M9,sum(nvl(month_10,0)) as M10,sum(nvl(month_11,0)) as M11,sum(nvl(month_12,0)) as M12,
sum(nvl(meter_total,0)) as total
from ".$y_table." a,".$device_info." b where a.year = '".$valuey."' and a.meter_id = b.meter_id and b.purpose != '007'";
if($priv_role->check('catid', $campusid, 'view', 0, false, 'E')){
if(!isset($campusid)){
showmessage("error: campusid is null",'?file=electricline&action=all');
}else{
str+="and b.MANUFACTURER_CODE = "'.$campusid.';
}
}

str+=怎么加标点sql语句可以执行？

Answer 1

php 拼接字符串用的 是 . 而不是+号, +号是js里的.
php 拼接SQL 语句 可以 双引号 里面写 $符号的php ,但是最好 加{} 包裹着php的变量这样 php解析的时候不会出错的 特别是 数组!!! 这个一定的! 不然就错了.
例如 $t = " select * from table where t = '{$t}' or p={$p['dsd']} ";
这样就行了!.
如果是常量老实点 用 . 拼接