質問編集履歴
2
PRIMARY KEYの指定
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -244,7 +244,7 @@
|
|
|
244
244
|
)
|
|
245
245
|
|
|
246
246
|
CREATE TABLE board (
|
|
247
|
-
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
247
|
+
`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
|
|
248
248
|
`user_icon` VARCHAR(50) NULL DEFAULT NULL,
|
|
249
249
|
`user_id` VARCHAR(50) NULL DEFAULT NULL,
|
|
250
250
|
`name` VARCHAR(50) NULL DEFAULT NULL,
|
1
スペル修正
title
CHANGED
|
File without changes
|
body
CHANGED
|
@@ -94,8 +94,8 @@
|
|
|
94
94
|
|
|
95
95
|
$query = " INSERT INTO board ( "
|
|
96
96
|
. " user_id , "
|
|
97
|
-
. "
|
|
97
|
+
. " link , "
|
|
98
|
-
. "
|
|
98
|
+
. " type , "
|
|
99
99
|
. " time , "
|
|
100
100
|
. " name , "
|
|
101
101
|
. " comment "
|
|
@@ -121,7 +121,7 @@
|
|
|
121
121
|
}
|
|
122
122
|
|
|
123
123
|
|
|
124
|
-
$query = "SELECT id, name, comment, time,
|
|
124
|
+
$query = "SELECT id, name, comment, time, link, type, user_icon FROM board WHERE tipe=1";
|
|
125
125
|
$res = mysqli_query( $link,$query );
|
|
126
126
|
$data = array();
|
|
127
127
|
while( $row = mysqli_fetch_assoc( $res ) ) {
|
|
@@ -226,7 +226,7 @@
|
|
|
226
226
|
if ( $msg !== '' ) echo '<p>' . $msg . '</p>';
|
|
227
227
|
if ( $err_msg !== '' ) echo '<p style="color:#f00;">' . $err_msg . '</p>';
|
|
228
228
|
foreach( $data as $key => $val ){
|
|
229
|
-
echo '<fieldset style="background:#add6ff; padding:10px; border:none;"><img src="' . $val['user_icon'] . '" alt="50" width="" height="50"><font size="6">' . $val['name'] . '</font><br>' . $val['comment'] . '<br><br><font size="2">' . $val['time'] . '</font>' . '<br><a href="' . $val['
|
|
229
|
+
echo '<fieldset style="background:#add6ff; padding:10px; border:none;"><img src="' . $val['user_icon'] . '" alt="50" width="" height="50"><font size="6">' . $val['name'] . '</font><br>' . $val['comment'] . '<br><br><font size="2">' . $val['time'] . '</font>' . '<br><a href="' . $val['link'] . '" target=_blank">返信</a>' . '</fieldset><br>';
|
|
230
230
|
}
|
|
231
231
|
?>
|
|
232
232
|
|
|
@@ -250,8 +250,8 @@
|
|
|
250
250
|
`name` VARCHAR(50) NULL DEFAULT NULL,
|
|
251
251
|
`comment` TEXT NULL,
|
|
252
252
|
`time` TEXT NULL,
|
|
253
|
-
`
|
|
253
|
+
`type` DECIMAL(10,0) NULL DEFAULT NULL,
|
|
254
|
-
`
|
|
254
|
+
`link` TEXT NULL
|
|
255
255
|
)
|
|
256
256
|
|
|
257
257
|
CREATE TABLE userdata (
|