在php中,拼接mysql的语句时,通常情况下,会使用点操作符,如下:
$user_id = 1;
$subject = '哲学';
$sql = "select * from scores where `user_id`=".$user_id." and `subject`='".$subject."'";
以这种方式来拼接sql,会比较繁琐,尤其是当参数比较多的时候,下面,利用php的sprintf函数,来优化上面的写法:
$user_id = 1;
$subject = '哲学';
$sql = sprintf("select * from scores where `user_id`=%d and `subject`=&#