Question

我的发言如下:

$stmt = $db->prepare("SELECT MAX(RID) FROM TEMP_ROUTE");
                                 $stmt->execute();
                                 $rid = $stmt->fetch(PDO::FETCH_ASSOC);
                                 $rid = (int) $rid["MAX(RID)"];

是否有任何办法使我不必作最后发言。换言之,在填写时,我想取一下$[“%(RID)”。

Answer 1

Have a look at http://www.php.net/manual/en/pdostatement.bindcolumn.php and try using PDO::FETCH_BOUND instead perhaps? This won t make it shorter though. Or try something like this, from http://www.php.net/manual/en/pdostatement.fetch.php:

$stmt = $db->prepare("SELEXT MAX(RID) AS max FROM TEMP_ROUTE");
$stmt->execute();
$rid = $stmt->fetch(PDO::FETCH_OBJ)->MAX;

友情链接