如何在 zend 框架中使用 join 查询获取选定的用户详细信息

发布于 2024-11-29 04:08:25 字数 447 浏览 3 评论 0原文

嗨，我是 zend 和 mysql 的新手，所以如果这是一个愚蠢的问题，请忽略。我有两个表：users 和 user_cars。现在 user_cars 表包含拥有多辆汽车的同一用户。即，如果用户拥有三辆不同的汽车，则 user_cars 表包含该用户的三个条目。现在我想从 user_cars 表中选择一个特定用户。 userid 是给我的。谁能告诉我该怎么做。

    users: 
    userid, username, password, fname, lname               // columns

    user_cars:
    id, userid, car_name, purchase_date                    // columns

所以我有一个用户 ID，并希望从 user_cars 中选择具有给定用户 ID 的所有行。谁能告诉我该怎么做。

原文

Hi i am new to zend and mysql so please ignore if this is a silly ques. i have two tabels: users and user_cars. Now the user_cars table contains same user with multiple cars. i.e. if a user has three different cars, then the user_cars table contains three entries for that user. Now i want to select a particular user from user_cars table. The userid is given to me. can anyone please tell me how to do that.

    users: 
    userid, username, password, fname, lname               // columns

    user_cars:
    id, userid, car_name, purchase_date                    // columns

so i have a userid and want to select all the rows from user_cars with the given userid. can anyone please tell me how to do this.

分享到QQ

分享到微博

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

发布评论

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

自由如风 2024-12-06 04:08:25

$db     = Zend_Db_Table::getDefaultAdapter();
$query  = "SELECtT * FROM user_cars WHERE userid = " . (int)$userId;

$cars   $db->fetchAll($query);
// You have all the user's cars in the $cars var

但你问的实在不清楚，所以也许不是这个

$db     = Zend_Db_Table::getDefaultAdapter();
$query  = "SELECtT * FROM user_cars WHERE userid = " . (int)$userId;

$cars   $db->fetchAll($query);
// You have all the user's cars in the $cars var

But what you're asking is really not clear so maybe it's not this

回复收藏 0 原文