I'm trying to edit images records from database. data fetching part is ok but my editing code not working. i modify this code using insert part. inserting to db is working but edit not working. i'm new to php. i want to add multiple images with form data for my Classified ads project.
on edit page...
<input type="file" name="upload[]" onchange="previewFiles()" multiple />
on edit processing page....
<?php
$file_dir = "../images/";
if (!file_exists($file_dir)) {
mkdir($file_dir, 0777, true);
}
if (isset($_POST["Input"])) {
function diverse_array($array) {
$result = [];
foreach($array as $key1 => $value1)
foreach($value1 as $key2 => $value2)
$result[$key2][$key1] = $value2;
return $result;
}
$file_multi = diverse_array($_FILES['upload']);
for ($y = 0; $y < 4; $y++) {
$image[$y] = '';
}
for ($x = 0; $x < count($file_multi); $x++) {
foreach ($file_multi[$x] as $key => $value) {
$file_name = $file_multi[$x]['name'];
$file_size = $file_multi[$x]['size'];
$file_tmp = $file_multi[$x]['tmp_name'];
$file_target = $file_dir . $file_name;
$errors = array();
$file_secure = array('jpg', 'jpeg', 'png', 'gif', 'bmp');
$file_current = strtolower(pathinfo($file_name, PATHINFO_EXTENSION)); /* (end(explode('.', $file_name) */
if (in_array($file_current, $file_secure) === false) {
$errors[] = "Sorry, <strong>{$file_current}</strong> extension not allowed";
}
}
if (!empty($errors)) {
foreach ($errors as $keyError => $valueError) {
echo "$keyError = $valueError <br />";
}
} else {
if (move_uploaded_file($file_tmp, $file_target)) {
$image[$x] = $file_target;
echo "<strong>{$file_name}</strong> has been uploaded." . "<br />";
} else {
echo "Sorry, there was an something wrong in <b>move_uploaded</b>.";
}
}
}
if (!empty($errors)) {
foreach ($errors as $keyError => $valueError) {
echo "$keyError = $valueError <br />";
}
} else {
$id = $_POST['id'];
$image1 = $image[0];
$image2 = $image[1];
require_once("koneksi.php");
$sql = "UPDATE post_gallery SET images1='$image1', images2='$image2' WHERE id='$id' ";
$parameter = array(
':image1' => $image1,
':image2' => $image2);
$query = $conn->prepare($sql);
$query->execute($parameter);
echo "Data succesfully inserted !!";
$conn = null;
header("Location:../view-post.php?id=4");
}
} else {
header("Location:../view-post.php?id=4");
}
?>
