質問編集履歴
3
git
test
CHANGED
File without changes
|
test
CHANGED
File without changes
|
2
aaa
test
CHANGED
@@ -1 +1 @@
|
|
1
|
-
c
|
1
|
+
git clone をsshで行ったほうがいい理由
|
test
CHANGED
@@ -1,23 +1 @@
|
|
1
|
-
自分のid(usersテーブル)をAuthで取得して、自分の投稿したコンテンツ(postsテーブル)のuser_idを一致したものをcart_itemsからpost_idで引っ張り、
|
2
|
-
|
3
|
-
|
1
|
+
`git clone `をsshでおこなったほうがいいのはなぜですか?
|
4
|
-
|
5
|
-
|
6
|
-
|
7
|
-
```
|
8
|
-
|
9
|
-
$userId = $this->Auth->user('id');
|
10
|
-
|
11
|
-
$query = "SELECT SUM( price ) FROM CartItem
|
12
|
-
|
13
|
-
LEFT JOIN carts ON (carts.id = cart_items.cart_id)
|
14
|
-
|
15
|
-
LEFT JOIN posts ON (cart_items.post_id = posts.id)
|
16
|
-
|
17
|
-
LEFT JOIN users ON (posts.user_id = users.id) WHERE posts.user_id = ". $userId;
|
18
|
-
|
19
|
-
$abc = $this->query($query);
|
20
|
-
|
21
|
-
$this->set('abc', $abc);
|
22
|
-
|
23
|
-
```
|
1
テーブル名修正
test
CHANGED
File without changes
|
test
CHANGED
@@ -12,9 +12,9 @@
|
|
12
12
|
|
13
13
|
LEFT JOIN carts ON (carts.id = cart_items.cart_id)
|
14
14
|
|
15
|
-
LEFT JOIN posts ON (cart_items.post_id = post.id)
|
15
|
+
LEFT JOIN posts ON (cart_items.post_id = posts.id)
|
16
16
|
|
17
|
-
LEFT JOIN users ON (post.user_id = users.id) WHERE post.user_id = ". $userId;
|
17
|
+
LEFT JOIN users ON (posts.user_id = users.id) WHERE posts.user_id = ". $userId;
|
18
18
|
|
19
19
|
$abc = $this->query($query);
|
20
20
|
|