回答編集履歴
1
プログラムを追加
test
CHANGED
@@ -79,3 +79,127 @@
|
|
79
79
|
?>
|
80
80
|
|
81
81
|
```
|
82
|
+
|
83
|
+
|
84
|
+
|
85
|
+
```整理版
|
86
|
+
|
87
|
+
<?php
|
88
|
+
|
89
|
+
function db_access($db){
|
90
|
+
|
91
|
+
try{
|
92
|
+
|
93
|
+
$dsn = 'mysql:dbname=example;host=localhost';
|
94
|
+
|
95
|
+
$user = 'root';
|
96
|
+
|
97
|
+
$password = 'shapshap';
|
98
|
+
|
99
|
+
$dbh = new PDO($dsn, $user, $password);
|
100
|
+
|
101
|
+
$dbh->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
|
102
|
+
|
103
|
+
switch($db){
|
104
|
+
|
105
|
+
case 'search':
|
106
|
+
|
107
|
+
echo '<select name="C_num">';
|
108
|
+
|
109
|
+
$query = $dbh->query('select C_nm from example');
|
110
|
+
|
111
|
+
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
|
112
|
+
|
113
|
+
echo '<option value="'.$row['C_nm'].'">'.$row['C_nm'].'</option>';
|
114
|
+
|
115
|
+
}
|
116
|
+
|
117
|
+
echo '</select>';
|
118
|
+
|
119
|
+
$result = $row;
|
120
|
+
|
121
|
+
break;
|
122
|
+
|
123
|
+
|
124
|
+
|
125
|
+
case 'search_ans';
|
126
|
+
|
127
|
+
if (isset($_POST['C_num'])){
|
128
|
+
|
129
|
+
$get_C_nam[] = $_POST['C_name'];
|
130
|
+
|
131
|
+
$get_C_nm[] = $_POST['C_num'];
|
132
|
+
|
133
|
+
$get_C_phn[] = $_POST['C_phon'];
|
134
|
+
|
135
|
+
$get_C_add[] = $_POSt['C_add'];
|
136
|
+
|
137
|
+
}
|
138
|
+
|
139
|
+
else
|
140
|
+
|
141
|
+
{
|
142
|
+
|
143
|
+
$C_nm = $_GET['C_num'];
|
144
|
+
|
145
|
+
$sql = 'select * from example where C_nm= '.$C_nm.'';
|
146
|
+
|
147
|
+
foreach ($dbh->query($sql) as $row) {
|
148
|
+
|
149
|
+
$get_C_nam[] = $row['C_nam'];
|
150
|
+
|
151
|
+
$get_C_nm[] = $row['C_nm'];
|
152
|
+
|
153
|
+
$get_C_phn[] = $row['C_phn'];
|
154
|
+
|
155
|
+
$get_C_add[] = $row['C_add'];
|
156
|
+
|
157
|
+
}
|
158
|
+
|
159
|
+
}
|
160
|
+
|
161
|
+
$result = [$get_C_nam, $get_C_nm, $get_C_phn, $get_C_add];
|
162
|
+
|
163
|
+
break;
|
164
|
+
|
165
|
+
|
166
|
+
|
167
|
+
case 'search_fix_a';
|
168
|
+
|
169
|
+
$stmt = $dbh->prepare('UPDATE example SET C_nam = :C_nam, C_nm = :C_nm, C_phn = :C_phn, C_add = :C_add WHERE example.C_nm = :C_nm');
|
170
|
+
|
171
|
+
$stmt->execute(array(':C_nam' => $_POST['C_name'], ':C_nm' => $_POST['C_num'], ':C_phn' => $_POST['C_phon'], ':C_add' => $_POST['C_sa']));
|
172
|
+
|
173
|
+
break;
|
174
|
+
|
175
|
+
|
176
|
+
|
177
|
+
default:
|
178
|
+
|
179
|
+
break;
|
180
|
+
|
181
|
+
}
|
182
|
+
|
183
|
+
}
|
184
|
+
|
185
|
+
catch (PDOException $e){
|
186
|
+
|
187
|
+
print('Error:'.$e->getMessage());
|
188
|
+
|
189
|
+
die();
|
190
|
+
|
191
|
+
}
|
192
|
+
|
193
|
+
if(isset($result)==true){
|
194
|
+
|
195
|
+
return $result;
|
196
|
+
|
197
|
+
}
|
198
|
+
|
199
|
+
$dbh = null;
|
200
|
+
|
201
|
+
}
|
202
|
+
|
203
|
+
?>
|
204
|
+
|
205
|
+
```
|