質問編集履歴
5
取得したデータを画面に表示するを追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -159,3 +159,47 @@
|
|
159
159
|
));
|
160
160
|
|
161
161
|
```
|
162
|
+
|
163
|
+
/Users/■■■■/Desktop/fuelphp/fuel/app/views/welcome/index.twig
|
164
|
+
|
165
|
+
(取得したデータを画面に表示する)
|
166
|
+
|
167
|
+
```
|
168
|
+
|
169
|
+
<DOCTYPE html>
|
170
|
+
|
171
|
+
<html>
|
172
|
+
|
173
|
+
<head>
|
174
|
+
|
175
|
+
<meta charset="utf-8">
|
176
|
+
|
177
|
+
<title>FuelPHP Framework</title>
|
178
|
+
|
179
|
+
{{ asset_css('bootstrap.css') }}
|
180
|
+
|
181
|
+
</head>
|
182
|
+
|
183
|
+
<body>
|
184
|
+
|
185
|
+
personal_infoテーブル内のデータ</br>
|
186
|
+
|
187
|
+
{% for result in results %}
|
188
|
+
|
189
|
+
{{loop.index}}件目</br>
|
190
|
+
|
191
|
+
"id" : {{result.id}}</br>
|
192
|
+
|
193
|
+
"name" : {{result.name}}</br>
|
194
|
+
|
195
|
+
"age" : {{result.age}}</br>
|
196
|
+
|
197
|
+
"sex" : {{result.sex}}</br>
|
198
|
+
|
199
|
+
{% endfor %}
|
200
|
+
|
201
|
+
</body>
|
202
|
+
|
203
|
+
<html>
|
204
|
+
|
205
|
+
```
|
4
本文を少し変更
test
CHANGED
File without changes
|
test
CHANGED
@@ -4,7 +4,7 @@
|
|
4
4
|
|
5
5
|
(3)/Users/■■■■/Desktop/fuelphp/fuel/core/classes/database/mysqli/connection.php
|
6
6
|
|
7
|
-
で
|
7
|
+
でFuelPHP側のDB設定ファイルに接続情報を定義して、
|
8
8
|
|
9
9
|
(4)applications/classes/model/friend.phpに
|
10
10
|
|
3
少しだけ見やすくしました。
test
CHANGED
File without changes
|
test
CHANGED
@@ -1,12 +1,12 @@
|
|
1
|
-
fuelphpのapp/config/db.php
|
1
|
+
(1)fuelphpのapp/config/db.php
|
2
2
|
|
3
|
-
fuelphpのapp/config/development/db.php
|
3
|
+
(2)fuelphpのapp/config/development/db.php
|
4
4
|
|
5
|
-
/Users/■■■■/Desktop/fuelphp/fuel/core/classes/database/mysqli/connection.php
|
5
|
+
(3)/Users/■■■■/Desktop/fuelphp/fuel/core/classes/database/mysqli/connection.php
|
6
6
|
|
7
7
|
でデータベース接続の設定をして、
|
8
8
|
|
9
|
-
applications/classes/model/friend.phpに
|
9
|
+
(4)applications/classes/model/friend.phpに
|
10
10
|
|
11
11
|
データベースにレコードを挿入する文を書き、
|
12
12
|
|
2
プライベート情報にモザイク処理
test
CHANGED
File without changes
|
test
CHANGED
@@ -2,7 +2,7 @@
|
|
2
2
|
|
3
3
|
fuelphpのapp/config/development/db.php
|
4
4
|
|
5
|
-
/Users/
|
5
|
+
/Users/■■■■/Desktop/fuelphp/fuel/core/classes/database/mysqli/connection.php
|
6
6
|
|
7
7
|
でデータベース接続の設定をして、
|
8
8
|
|
@@ -132,7 +132,7 @@
|
|
132
132
|
|
133
133
|
```
|
134
134
|
|
135
|
-
/Users/
|
135
|
+
/Users/■■■■/Desktop/fuelphp/fuel/core/classes/database/mysqli/connection.php
|
136
136
|
|
137
137
|
```
|
138
138
|
|
1
db接続情報の追記
test
CHANGED
File without changes
|
test
CHANGED
@@ -1,6 +1,8 @@
|
|
1
1
|
fuelphpのapp/config/db.php
|
2
2
|
|
3
3
|
fuelphpのapp/config/development/db.php
|
4
|
+
|
5
|
+
/Users/tanakaakio/Desktop/fuelphp/fuel/core/classes/database/mysqli/connection.php
|
4
6
|
|
5
7
|
でデータベース接続の設定をして、
|
6
8
|
|
@@ -129,3 +131,31 @@
|
|
129
131
|
);
|
130
132
|
|
131
133
|
```
|
134
|
+
|
135
|
+
/Users/tanakaakio/Desktop/fuelphp/fuel/core/classes/database/mysqli/connection.php
|
136
|
+
|
137
|
+
```
|
138
|
+
|
139
|
+
// Extract the connection parameters, adding required variables
|
140
|
+
|
141
|
+
extract($this->_config['connection'] + array(
|
142
|
+
|
143
|
+
'database' => 'personal',
|
144
|
+
|
145
|
+
'hostname' => 'localhost',
|
146
|
+
|
147
|
+
'port' => '3306',
|
148
|
+
|
149
|
+
'socket' => '/tmp/mysql.sock',
|
150
|
+
|
151
|
+
'username' => 'root',
|
152
|
+
|
153
|
+
'password' => 'root',
|
154
|
+
|
155
|
+
'persistent' => false,
|
156
|
+
|
157
|
+
'compress' => true,
|
158
|
+
|
159
|
+
));
|
160
|
+
|
161
|
+
```
|