Question

我的法典存在一个小问题,如果我手工地将价值观引入,那么问询就会被罚款。但是,如果我使用我的变量,失败了。守则如下:

my $get_meter_id = $dbh->prepare("SELECT * from t_readings where meter_serial =  21001652  AND ...");
$get_meter_id->execute() or die "Couldn t execute statement: ".$get_meter_id->errstr;
my $meter_reg_id = $get_meter_id->fetchrow_array();

以上著作

where meter_serial = 21001652 AND ...")

以上著作.

where meter_serial =  ".$variable."  AND ...")

以上工作

where meter_serial = ".$variable." AND ...")

以上工作

许多感谢。

Answer 1

使用地人。靠扼杀 con。

my $get_meter_id = $dbh->prepare("SELECT * from t_readings where meter_serial=? AND ...");
my $foo = 21001652;
$get_meter_id->execute($foo) or die "Couldn t execute statement: ".$get_meter_id->errstr;

Answer 2

什么是:

my $get_meter_id = $dbh->prepare("SELECT * from t_readings where" .
     "meter_serial = ? AND ...");
$get_meter_id->execute($variable) or die "Couldn t execute statement: " . 
     $get_meter_id->errstr;
my $meter_reg_id = $get_meter_id->fetchrow_array();

rel=“nofollow noreferer”>reading

友情链接