未定义的函数db_fetch_array()
问题描述:
当我尝试将drupal 6模块转换为drupal 7时,我收到了此错误..我了解到drupal 7在数据库中有一个新的api ..我希望有人可以给出一种方法解决这个问题。未定义的函数db_fetch_array()
db_set_active('data');
$ncoa=db_fetch_array(db_query("SELECT deskripsi FROM {coa} WHERE coaid = '$baris->coa'"));
$ukpengelola=db_fetch_array(db_query("SELECT lokasi FROM {costcenter} WHERE kodecost = '$baris->kodecost'"));
$ukpengguna=db_fetch_array(db_query("SELECT lokasi FROM {costcenter} WHERE kodecost = '$baris->kodecostpemakai'"));
$zstatus=db_fetch_array(db_query("SELECT status_deskripsi AS zket FROM {pengadaan_zstatus} WHERE status_id = '$baris->status_id'"));
db_set_active('default');
答
db_fetch_array()折旧在D7,用于参考如何修正,见http://drupal.org/update/modules/6/7#dbtng
实施例 - Drupal的6:
<?php
$result = db_fetch_array(db_query("SELECT * FROM {boxes} WHERE bid = %d", $bid));
?>
的Drupal 7:
<?php
$result = db_query("SELECT * FROM {block_custom} WHERE bid = :bid", array(':bid' => $bid))->fetchAssoc();
?>
感谢为我工作 –