01.
if
(
is_uploaded_file
(
$_FILES
[
'file'
][
'tmp_name'
])) {
02.
if
(
$_FILES
[
'file'
][
'tmp_name'
] == 0) {
03.
include
"lib/IMager/imager.php"
;
04.
$img
= image_upload(
'file'
);
05.
$img
= image_to_jpg(
$img
);
06.
$img
= image_resize_max(
$img
, 600, 300);
07.
$f
= image_store_db(
$img
,
"image/jpeg"
);
08.
$sql
=
"REPLACE INTO image VALUES('$image_id', '$f')"
;
09.
mysqli_query(
$mysqli
,
$sql
);
10.
$image_id
= mysqli_insert_id(
$mysqli
);
11.
}
else
{
12.
include
"lib/IMager/imager.php"
;
13.
$img
= image_upload(
'file'
);
14.
$img
= image_to_jpg(
$img
);
15.
$img
= image_resize_max(
$img
, 600, 300);
16.
$f
= image_store_db(
$img
,
"image/jpeg"
);
17.
$sql
=
"REPLACE INTO image VALUES('$image_id', '$f')"
;
18.
mysqli_query(
$mysqli
,
$sql
);
19.
$image_id
= mysqli_insert_id(
$mysqli
);
20.
}
21.
}
22.
23.
$t
=
$_POST
[
'topic'
];
24.
$c
=
$_POST
[
'content'
];
25.
$w
=
$_POST
[
'writer'
];
26.
$article_id
=
$_POST
[
'article_id'
];
27.
$sql
=
"REPLACE INTO article VALUES('$article_id', '$t', '$c', '$w', NOW(), 0, '$image_id)"
;
28.
if
(@mysqli_query(
$mysqli
,
$sql
)) {
29.
$msg
= "<div
class
=
'alert alert-success'
>
30.
<span
class
=
'glyphicon glyphicon-info-sign'
></span> ประกาศข่าวสารเรียบร้อยแล้ว<p/>
31.
ระบบ\'จะนำคุณกำลับไปยังหน้าล็อคอินในอีก 5 วินาที.</p>
32.
</div>";
33.
34.
header (
"refresh:5; url=data_content.php"
);
35.
36.
}
37.
else
{
38.
echo
'<h3 class="waringing">เกิดข้อผิดพลาดในการบันทึกข้อมูล กรุณาลองใหม่</h3>'
;
39.
40.
}
41.
endif
;
42.
endif
;
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
$sql
= "SELECT article.*, image.image_content
53.
FROM article LEFT JOIN image
54.
on article.image_id = image.image_id
55.
WHERE article_id =".
$_GET
[
'u'
];
56.
$result
=
$mysqli
->query(
$sql
);
57.
?>