01.
$id_place
=
$_GET
[id];
02.
$name_place
=
$_POST
[txt_name_place];
03.
$location
=
$_POST
[txt_location];
04.
$officer
=
$_POST
[txt_officer];
05.
06.
$s
=
"SELECT id_place,place_photo FROM tb_place WHERE id_place = $id_place"
;
07.
$rs
= mysql_query(
$s
);
08.
$r
= mysql_fetch_assoc(
$rs
);
09.
10.
$delete
=
"path/$r[place_photo]"
;
11.
unlink(
$delete
);
12.
13.
$ext
=
pathinfo
(
basename
(
$_FILES
[filUpload][name]),PATHINFO_EXTENSION);
14.
$new
=
'img_'
.(uniqid()).
"."
.
$ext
;
15.
$image_path
=
"image/"
;
16.
$upload
=
$image_path
.
$new
;
17.
move_uploaded_file(
$_FILES
[filUpload][tmp_name],
$upload
);
18.
19.
$photo
=
$new
;
20.
21.
$sql
=
"UPDATE tb_place SET "
;
22.
$sql
.=
"id_place = '$id_place', "
;
23.
$sql
.=
"name_place = '$name_place', "
;
24.
$sql
.=
"location = '$location', "
;
25.
$sql
.=
"officer = '$officer', "
;
26.
$sql
.=
"place_photo = '$photo' "
;
27.
$sql
.=
"WHERE id_pace = $id_place"
;
28.
$result
= mysql_query(
$sql
);
29.
Header(
"Location: php-admin_page2.php"
);