teratail
回答率
85.48%
質問するログイン新規登録
トップに関する質問Zend FremeworkでZend_Db_SelectのSQL文のコードについて

編集履歴

質問編集履歴

8

2016/10/22 08:14

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -112,6 +112,6 @@
112
112
 
113
113
  ```
114
114
 
115
- >where('Hoge4.item_id_wsorder = item.seq OR sales.sales_id_wsorder = sales.id;
115
+ >where('sales.item_id_wsorder = item.seq OR sales.sales_id_wsorder = sales.id;
116
116
 
117
117
  ```

7

2016/10/22 08:14

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -112,6 +112,6 @@
112
112
 
113
113
  ```
114
114
 
115
- >where('Hoge4.item_id_wsorder = item.seq OR sales.sales_id_wsorder = sales。id;
115
+ >where('Hoge4.item_id_wsorder = item.seq OR sales.sales_id_wsorder = sales.id;
116
116
 
117
117
  ```

6

2016/10/22 08:12

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -44,7 +44,11 @@
44
44
 
45
45
 
46
46
 
47
+ ```
48
+
47
- ```$table = new Db_HallItemNumber_Table;```
49
+ $table = new Db_HallItemNumber_Table;
50
+
51
+ ```
48
52
 
49
53
 
50
54
 
@@ -52,7 +56,11 @@
52
56
 
53
57
 
54
58
 
59
+ ```
60
+
55
- ```$db = $table->getAdapter();```
61
+ $db = $table->getAdapter();
62
+
63
+ ```
56
64
 
57
65
 
58
66
 
@@ -60,7 +68,11 @@
60
68
 
61
69
 
62
70
 
71
+ ```
72
+
63
- ```$select = $db->select()->setIntegrityCheck(false);```
73
+ $select = $db->select()->setIntegrityCheck(false);
74
+
75
+ ```
64
76
 
65
77
 
66
78
 
@@ -68,22 +80,38 @@
68
80
 
69
81
 
70
82
 
83
+ ```
84
+
71
- ```$select ->from(array('hall_item_number'))```
85
+ $select ->from(array('hall_item_number'))
86
+
87
+ ```
72
88
 
73
89
 
74
90
 
75
91
 
76
92
 
93
+ ```
94
+
77
- ```>joinInner(array('item'),'hall_item_number.hall_item_id = item.seq'array())```
95
+ >joinInner(array('item'),'hall_item_number.hall_item_id = item.seq'array())
96
+
97
+ ```
78
98
 
79
99
 
80
100
 
81
101
 
82
102
 
103
+ ```
104
+
83
- ```>joinInner(array(''),'item.seq = sales.item_id'array())```
105
+ >joinInner(array(''),'item.seq = sales.item_id'array())
106
+
107
+ ```
84
108
 
85
109
 
86
110
 
87
111
 
88
112
 
113
+ ```
114
+
89
- ```>where('Hoge4.item_id_wsorder = item.seq OR sales.sales_id_wsorder = sales。id;```
115
+ >where('Hoge4.item_id_wsorder = item.seq OR sales.sales_id_wsorder = sales。id;
116
+
117
+ ```

5

2016/10/22 08:11

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -46,11 +46,15 @@
46
46
 
47
47
  ```$table = new Db_HallItemNumber_Table;```
48
48
 
49
+
50
+
49
51
 
50
52
 
51
53
 
52
54
 
53
55
  ```$db = $table->getAdapter();```
56
+
57
+
54
58
 
55
59
 
56
60
 
@@ -58,20 +62,28 @@
58
62
 
59
63
  ```$select = $db->select()->setIntegrityCheck(false);```
60
64
 
65
+
66
+
61
67
 
62
68
 
63
69
 
64
70
 
65
71
  ```$select ->from(array('hall_item_number'))```
66
72
 
73
+
74
+
67
75
 
68
76
 
69
77
  ```>joinInner(array('item'),'hall_item_number.hall_item_id = item.seq'array())```
78
+
79
+
70
80
 
71
81
 
72
82
 
73
83
  ```>joinInner(array(''),'item.seq = sales.item_id'array())```
74
84
 
85
+
86
+
75
87
 
76
88
 
77
89
  ```>where('Hoge4.item_id_wsorder = item.seq OR sales.sales_id_wsorder = sales。id;```

4

2016/10/22 08:09

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -42,6 +42,8 @@
42
42
 
43
43
 
44
44
 
45
+
46
+
45
47
  ```$table = new Db_HallItemNumber_Table;```
46
48
 
47
49
 

3

2016/10/22 08:08

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -46,18 +46,30 @@
46
46
 
47
47
 
48
48
 
49
+
50
+
49
51
  ```$db = $table->getAdapter();```
50
52
 
51
53
 
54
+
55
+
52
56
 
53
57
  ```$select = $db->select()->setIntegrityCheck(false);```
54
58
 
55
59
 
56
60
 
61
+
62
+
57
63
  ```$select ->from(array('hall_item_number'))```
58
64
 
59
- ```>joinInner(array('item'),'hall_item_number.hall_item_id = item.seq'array())```
65
+
60
66
 
61
- ```>joinInner(array(''),'item.seq = sales.item_id'array())```
67
+ ```>joinInner(array('item'),'hall_item_number.hall_item_id = item.seq'array())```
62
68
 
69
+
70
+
71
+ ```>joinInner(array(''),'item.seq = sales.item_id'array())```
72
+
73
+
74
+
63
- ```>where('Hoge4.item_id_wsorder = item.seq OR sales.sales_id_wsorder = sales。id;```
75
+ ```>where('Hoge4.item_id_wsorder = item.seq OR sales.sales_id_wsorder = sales。id;```

2

2016/10/22 08:07

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -42,22 +42,22 @@
42
42
 
43
43
 
44
44
 
45
- ’’$table = new Db_HallItemNumber_Table;’’
45
+ ```$table = new Db_HallItemNumber_Table;```
46
46
 
47
47
 
48
48
 
49
- ’’$db = $table->getAdapter();’’
49
+ ```$db = $table->getAdapter();```
50
50
 
51
51
 
52
52
 
53
- ’’$select = $db->select()->setIntegrityCheck(false);’’
53
+ ```$select = $db->select()->setIntegrityCheck(false);```
54
54
 
55
55
 
56
56
 
57
- ’’$select ->from(array('hall_item_number'))’’
57
+ ```$select ->from(array('hall_item_number'))```
58
58
 
59
- ’’>joinInner(array('item'),'hall_item_number.hall_item_id = item.seq'array())’’
59
+ ```>joinInner(array('item'),'hall_item_number.hall_item_id = item.seq'array())```
60
60
 
61
- ’’>joinInner(array(''),'item.seq = sales.item_id'array())’’
61
+ ```>joinInner(array(''),'item.seq = sales.item_id'array())```
62
62
 
63
- ’’>where('Hoge4.item_id_wsorder = item.seq OR sales.sales_id_wsorder = sales。id;’’
63
+ ```>where('Hoge4.item_id_wsorder = item.seq OR sales.sales_id_wsorder = sales。id;```

1

2016/10/22 08:01

投稿

退会済みユーザー
test CHANGED
File without changes
test CHANGED
@@ -30,30 +30,34 @@
30
30
 
31
31
 
32
32
 
33
+ //追記です。
33
34
 
35
+ DBはPostgreSQLです。
34
36
 
35
- 自分で作成したコード-------------------------------------------
37
+ SQLサーバーは使っておらず、A5SQLのソフトを使っています。
36
38
 
37
39
 
38
40
 
41
+ //自分で作成したコード
42
+
43
+
44
+
39
- $table = new Db_HallItemNumber_Table;
45
+ ’’$table = new Db_HallItemNumber_Table;’’
40
46
 
41
47
 
42
48
 
43
- $db = $table->getAdapter();
49
+ ’’$db = $table->getAdapter();’’
44
50
 
45
51
 
46
52
 
47
- $select = $db->select()->setIntegrityCheck(false);
53
+ ’’$select = $db->select()->setIntegrityCheck(false);’’
48
54
 
49
55
 
50
56
 
51
- $select ->from(array('hall_item_number'))
57
+ ’’$select ->from(array('hall_item_number'))’’
52
58
 
53
- ->joinInner(array('item'),'hall_item_number.hall_item_id = item.seq'array())
59
+ ’’>joinInner(array('item'),'hall_item_number.hall_item_id = item.seq'array())’’
54
60
 
55
- ->joinInner(array(''),'item.seq = sales.item_id'array())
61
+ ’’>joinInner(array(''),'item.seq = sales.item_id'array())’’
56
62
 
57
- ->where('Hoge4.item_id_wsorder = item.seq OR sales.sales_id_wsorder = sales。id;
63
+ ’’>where('Hoge4.item_id_wsorder = item.seq OR sales.sales_id_wsorder = sales。id;’’
58
-
59
- -------------------------------------------