我可以在php / postgres pg_escape_string中添加char限制吗? 如果是这样的话?
问题描述:
I've this php code:
$reg_number = strtoupper(pg_escape_string($_SESSION['regiter'][2]['serial']));
I need to set $reg_number field to max 10 char adding the limit to this string
Thank you if you provide me the code
EDIT
I need that $reg_number must equal to 10 or under 10 char. (in my postgres db the field is char limit to 10...sorry)
"cutted" results is ok
我有这个PHP代码: p>
$ reg_number = strtoupper(pg_escape_string($ _ SESSION ['regiter'] [2] ['serial']));
code> pre>
我需要将$ reg_number字段设置为max 10 char 为此字符串添加限制 p>
如果您向我提供代码 p>
编辑 strong> p>
,感谢您
我需要$ reg_number必须等于10或10 char。 (在我的postgres db中,字段是char限制为10 ...抱歉) p>
“cutted”结果没问题 p>
div>
答
$reg_number = $_SESSION['regiter'][2]['serial']);
if( strlen($reg_number)>10 ){
$reg_number = substr($reg_number, 0, 10);
}
$reg_number = pg_escape_string(strtoupper($reg_number));