質問編集履歴
2
PRIMARY KEYの指定
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -490,36 +490,36 @@
|
|
|
490
490
|
|
|
491
491
|
CREATE TABLE board (
|
|
492
492
|
|
|
493
|
+
`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
|
|
494
|
+
|
|
495
|
+
`user_icon` VARCHAR(50) NULL DEFAULT NULL,
|
|
496
|
+
|
|
497
|
+
`user_id` VARCHAR(50) NULL DEFAULT NULL,
|
|
498
|
+
|
|
499
|
+
`name` VARCHAR(50) NULL DEFAULT NULL,
|
|
500
|
+
|
|
501
|
+
`comment` TEXT NULL,
|
|
502
|
+
|
|
503
|
+
`time` TEXT NULL,
|
|
504
|
+
|
|
505
|
+
`type` DECIMAL(10,0) NULL DEFAULT NULL,
|
|
506
|
+
|
|
507
|
+
`link` TEXT NULL
|
|
508
|
+
|
|
509
|
+
)
|
|
510
|
+
|
|
511
|
+
|
|
512
|
+
|
|
513
|
+
CREATE TABLE userdata (
|
|
514
|
+
|
|
493
515
|
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
494
516
|
|
|
517
|
+
`name` VARCHAR(20) NULL DEFAULT NULL,
|
|
518
|
+
|
|
495
519
|
`user_icon` VARCHAR(50) NULL DEFAULT NULL,
|
|
496
520
|
|
|
497
|
-
`
|
|
521
|
+
`password` VARCHAR(100) NULL DEFAULT NULL
|
|
498
|
-
|
|
499
|
-
`name` VARCHAR(50) NULL DEFAULT NULL,
|
|
500
|
-
|
|
501
|
-
`comment` TEXT NULL,
|
|
502
|
-
|
|
503
|
-
`time` TEXT NULL,
|
|
504
|
-
|
|
505
|
-
`type` DECIMAL(10,0) NULL DEFAULT NULL,
|
|
506
|
-
|
|
507
|
-
`link` TEXT NULL
|
|
508
522
|
|
|
509
523
|
)
|
|
510
524
|
|
|
511
|
-
|
|
512
|
-
|
|
513
|
-
CREATE TABLE userdata (
|
|
514
|
-
|
|
515
|
-
`id` INT(11) NOT NULL AUTO_INCREMENT,
|
|
516
|
-
|
|
517
|
-
`name` VARCHAR(20) NULL DEFAULT NULL,
|
|
518
|
-
|
|
519
|
-
`user_icon` VARCHAR(50) NULL DEFAULT NULL,
|
|
520
|
-
|
|
521
|
-
`password` VARCHAR(100) NULL DEFAULT NULL
|
|
522
|
-
|
|
523
|
-
)
|
|
524
|
-
|
|
525
525
|
```
|
1
スペル修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -190,9 +190,9 @@
|
|
|
190
190
|
|
|
191
191
|
. " user_id , "
|
|
192
192
|
|
|
193
|
-
. "
|
|
193
|
+
. " link , "
|
|
194
|
-
|
|
194
|
+
|
|
195
|
-
. " t
|
|
195
|
+
. " type , "
|
|
196
196
|
|
|
197
197
|
. " time , "
|
|
198
198
|
|
|
@@ -244,7 +244,7 @@
|
|
|
244
244
|
|
|
245
245
|
|
|
246
246
|
|
|
247
|
-
$query = "SELECT id, name, comment, time,
|
|
247
|
+
$query = "SELECT id, name, comment, time, link, type, user_icon FROM board WHERE tipe=1";
|
|
248
248
|
|
|
249
249
|
$res = mysqli_query( $link,$query );
|
|
250
250
|
|
|
@@ -454,7 +454,7 @@
|
|
|
454
454
|
|
|
455
455
|
foreach( $data as $key => $val ){
|
|
456
456
|
|
|
457
|
-
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['
|
|
457
|
+
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>';
|
|
458
458
|
|
|
459
459
|
}
|
|
460
460
|
|
|
@@ -502,9 +502,9 @@
|
|
|
502
502
|
|
|
503
503
|
`time` TEXT NULL,
|
|
504
504
|
|
|
505
|
-
`t
|
|
505
|
+
`type` DECIMAL(10,0) NULL DEFAULT NULL,
|
|
506
|
-
|
|
506
|
+
|
|
507
|
-
`
|
|
507
|
+
`link` TEXT NULL
|
|
508
508
|
|
|
509
509
|
)
|
|
510
510
|
|