为什么这样都可以
$province="guangdong";
$sql_select = "select city from city where province_name =$province ";
$fetchresult = $pdo->prepare ( $sql_select );
$fetchresult->execute();
而这样不可以?
$province="guangdong";
$sql_select = "select city from city where province_name = :province_name ";
$fetchresult = $pdo->prepare ( $sql_select );
$fetchresult = $pdo->bindParam ( ':province_name', $province,PDO::PARAM_STR, 12);
$fetchresult->execute();
第二种方法官方文档上都是这样的呢,但是我这样做没反应,浏览器里调试发现还有500错误,这是怎么回事请问,
我也试过这样:
$sql_select = "select city from city where province_name =? ";
$fetchresult = $pdo->prepare ( $sql_select );
$fetchresult = $pdo->bindParam ( 1, $province);
$fetchresult->execute();
依然是错的。
然而这样子又可以:$fetchresult->execute (array(':province_name'=>$province));
在线等