prepare("SELECT * FROM products WHERE product_id = ?");
$stmt->bind_param("i", $id);
$stmt->execute();
$result = $stmt->get_result();
$row = $result->fetch_assoc();
$images = $_FILES['images'] ?? [];
$targetDirectory = "./UPLOADED_IMAGES/";
$images_array[] = [];
if (!empty($images)) {
foreach ($_FILES['images']['name'] as $key => $file_name) {
$tmpName = $_FILES['images']['tmp_name'][$key];
$fileName = basename($file_name);
$targetFilePath = $targetDirectory.$fileName;
if (move_uploaded_file($tmpName, $targetFilePath)) {
echo "File $fileName uploaded successfully.
";
$images_array[] = $targetFilePath;
} else {
$images_array[] = null;
echo "Failed to upload $fileName.
";
}
}
}
echo "
";
print_r($images_array);
echo "
";
$brand = $_POST['brand-value'];
$series = $_POST['series-value'];
$modelNumber = $_POST['modelnumber-value'];
$weight = $_POST['weight-value'];
$dimensions = $_POST['dimensions-value'];
$color = $_POST['color-value'];
$manufactuer = $_POST['manufactuer-value'];
$origin = $_POST['origin-value'];
$firstDate = $_POST['firstDate-value'];
$energy = $_POST['energy-value'] ?? '';
$volts = $_POST['volts-value'] ?? '';
$memorySpeed = $_POST['memorySpeed-value'] ?? '';
$usb3 = $_POST['usb3-value'] ?? '';
$usb2 = $_POST['usb2-value'] ?? '';
$processorBrand = $_POST['processorBrand-value'] ?? '';
$numProcess = $_POST['numProcess-value'] ?? NULL;
$typeMem = $_POST['typeMem-value'] ?? '';
$HardDD = $_POST['HardDD-value'] ?? '';
$HardPlat = $_POST['HardPlat-value'] ?? '';
$HardFlash = $_POST['HardFlash-value'] ?? '';
$HardInterface = $_POST['HardInterface-value'] ?? NULL;
$gpuRAM = $_POST['gpuRAM-value'] ?? NULL;
$motherboardRAM = $_POST['motherboardRAM-value'] ?? NULL;
$motherboardTYPE = $_POST['motherboardTYPE-value'] ?? NULL;
$screenSize = $_POST['screenSize-value'] ?? '';
$screenRes = $_POST['screenRes-value'] ?? '';
$screenMax = $_POST['screenMax-value'] ?? '';
if(empty($gpuRAM)) {
$gpuRAM = NULL;
}
if(empty($motherboardRAM)) {
$motherboardRAM = NULL;
}
if(empty($numProcess)) {
$numProcess = NULL;
}
if(empty($memorySpeed)) {
$memorySpeed = NULL;
}
$image1 = isset($images_array[1]) ? $images_array[1] : $row['image1'];
$image2 = isset($images_array[2]) ? $images_array[2] : $row['image2'];
$image3 = isset($images_array[3]) ? $images_array[3] : $row['image3'];
$image4 = isset($images_array[4]) ? $images_array[4] : $row['image4'];
if (empty($name) || empty($price) || empty($discount)) {
if (empty($name)) {
echo "name field is empty.
";
}
if (empty($price)) {
echo "price field is empty.
";
}
if (empty($discount)) {
echo "discount field is empty.
";
}
}
else {
$stmt = $conn->prepare("UPDATE products SET
name = ?,
price = ?,
discount = ?,
in_stock = ?,
category = ?,
description = ?,
image1 = ?,
image2 = ?,
image3 = ?,
image4 = ?,
brand = ?,
series = ?,
model_number = ?,
weight = ?,
dimensions = ?,
color = ?,
manufactuer = ?,
origin = ?,
firstDate = ?,
energy = ?,
volts = ?,
memorySpeed = ?,
usb3 = ?,
usb2 = ?,
processorBrand = ?,
numProcess = ?,
typeMem = ?,
HardDD = ?,
HardPlat = ?,
HardFlash = ?,
HardInterface = ?,
gpuRAM = ?,
motherboardRAM = ?,
motherboardTYPE = ?,
screenSize = ?,
screenRes = ?,
screenMax = ?
WHERE product_id = ?;"
);
echo $images_array[1];
if($instock == "true") {
$instock = 1;
}
else {
$instock = 0;
}
$stmt->bind_param(
"ssdissssssssssssssssiiiisisssssiissssi",
$name, $price, $discount, $instock, $category, $description, $image1, $image2,
$image3, $image4, $brand, $series,
$modelNumber, $weight, $dimensions, $color, $manufactuer, $origin, $firstDate,
$energy, $volts, $memorySpeed, $usb3, $usb2, $processorBrand, $numProcess,
$typeMem, $HardDD, $HardPlat, $HardFlash, $HardInterface, $gpuRAM,
$motherboardRAM, $motherboardTYPE, $screenSize, $screenRes, $screenMax, $id);
if ($stmt->execute()) {
echo "Data updated successfully!
";
} else {
echo "Error updating data: " . $conn->error . "
";
}
$stmt->close();
}
}
else {
}
?>
View Updated Data