zend db 连接结果集

发布于 2024-11-15 02:01:54 字数 893 浏览 8 评论 0原文

我使用 zend_db_select 来连接 3 个表，并且在结果集数组中，当我期望看到带有别名的列名时，它返回一个带有没有别名的键的数组。

$dbSelect = $db->select()->from(array("pp"=>"products_photos"),array())
                         ->joinInner(array("ph"=>"photos"), "pp.photo_id=ph.photo_id","ph.photo_id")
                         ->joinInner(array('pr'=>'products'),"pr.product_id=pp.product_id","pr.product_id")
                         ->where("pr.product_id=$row->product_id");

$photoJoinRowSet = $db->fetchAll($dbSelect);
var_dump($photoJoinRowSet);die();

结果如下：

array(2) { [0]=> array(3) { ["product_id"]=> string(1) "1" ["photo_id"]=> string(1) "4" }}

当我期待时：

array(2) { [0]=>; array(3) { ["pr.product_id"]=>;字符串(1) "1" ["ph.photo_id"]=> string(1) "4" }}

......即带有列别名。

有谁知道为什么会发生这种情况？谢谢。

原文

I used zend_db_select for joining 3 tables, and in the result set array while I was expecting to see the column names with aliases, it returns an array with keys having no aliases.

$dbSelect = $db->select()->from(array("pp"=>"products_photos"),array())
                         ->joinInner(array("ph"=>"photos"), "pp.photo_id=ph.photo_id","ph.photo_id")
                         ->joinInner(array('pr'=>'products'),"pr.product_id=pp.product_id","pr.product_id")
                         ->where("pr.product_id=$row->product_id");

$photoJoinRowSet = $db->fetchAll($dbSelect);
var_dump($photoJoinRowSet);die();

RESULT LIKE :

array(2) { [0]=> array(3) { ["product_id"]=> string(1) "1" ["photo_id"]=> string(1) "4" }}

While I was expecting :

array(2) { [0]=> array(3) { ["pr.product_id"]=> string(1) "1" ["ph.photo_id"]=> string(1) "4" }}

......i.e with column aliases.

Does anyone know why this happens?? thanks.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

以酷 2024-11-22 02:01:54

您没有在此处指定任何别名，因此您的选择将转换为类似 SELECT ph.photo_id, pr.product_id 的内容，不带 AS，这将返回 photo_id 和 product_id 正如预期的那样。

如果您想要键中的点，您需要明确指定别名：

$dbSelect = $db->select()->from(array("pp"=>"products_photos"),array())
    ->joinInner(array("ph"=>"photos"), "pp.photo_id=ph.photo_id",
      array("ph.photo_id" => "ph.photo_id"))
    ->joinInner(array('pr'=>'products'), "pr.product_id=pp.product_id",
      array("pr.product_id" => "pr.product_id"))
    ->where("pr.product_id=$row->product_id");

有关 Zend_Db_Select 文档。

You didn't specify any aliases here, so your select will translate to something like SELECT ph.photo_id, pr.product_id, without AS, which will return photo_id and product_id as expected.

You need to specify explicitly your aliases if you want the dots in the keys:

$dbSelect = $db->select()->from(array("pp"=>"products_photos"),array())
    ->joinInner(array("ph"=>"photos"), "pp.photo_id=ph.photo_id",
      array("ph.photo_id" => "ph.photo_id"))
    ->joinInner(array('pr'=>'products'), "pr.product_id=pp.product_id",
      array("pr.product_id" => "pr.product_id"))
    ->where("pr.product_id=$row->product_id");

More information on the Zend_Db_Select documentation.

回复收藏 0 原文

~没有更多了~