1#@!#!123s

https 1#@!#!123s
: / home2 / affluencebiotech / public_html / absolutoffice.com / ABS / admin /
Filename : add_product.php
back
<?php 
require_once 'config/db.php';
require_once 'config/database.class.php';
require_once 'config/functions.php';

$d = new database($db_config);

if (isset($_POST)) {
    $post = $_POST;
    $catid = $post['catid'];
    $product = str_replace("'", "\'", $post['product']);
    $description = str_replace("'", "\'", $post['description']);
    $slug = $post['slug'];
    $catslug = $post['catslug'];
    $file_urls = [];

    // If no ID and no images are uploaded, return error
    if (empty($post['id']) && empty($_FILES['images']['name'][0])) {
        echo getResponse('error', 'Please choose at least one image');
        die;
    }

    // Check if any images are uploaded
    if (!empty($_FILES['images']['name'][0])) {
        // Loop through each uploaded file
        foreach ($_FILES['images']['name'] as $key => $image_name) {
            $tmp_name = $_FILES['images']['tmp_name'][$key];
            $name = $_FILES['images']['name'][$key];

            // Path to store the image
            $path = 'uploads/';
            $file_url = $path . $name;

            // Ensure the uploads directory exists
            if (!is_dir($path)) {
                mkdir($path, 0777, true);  // Create the folder if it doesn't exist
            }

            // Check if the file was uploaded successfully
            if (move_uploaded_file($tmp_name, $file_url)) {
                // Add the file URL to the array
                $file_urls[] = $file_url;
            } else {
                echo getResponse('error', 'Error uploading file: ' . $image_name);
                die;
            }
        }
    } else {
        echo getResponse('error', 'No images uploaded');
        die;
    }

    // Convert the file URLs array into a comma-separated string
    $file_urls_str = implode(',', $file_urls);

    if ($post['id'] == '') {
        // Insert query for new product with multiple images
        $query = "INSERT INTO product (`catid`, `product`, `description`,`slug`, `catslug`,`image`) 
                  VALUES ('$catid', '$product', '$description','$slug', '$catslug', '$file_urls_str')";
        $executeQuery = $d->insertQuery($query);

        if ($executeQuery) {
            // echo getResponse('success', 'Data saved successfully');
             ?>
  <script>
 alert('Data saved successfully!');
	 document.location.href = "product.php"
   
    </script>
    <?php 
        } else {
             ?>
             <script>
 alert('Something went wrong, please try later!');
	 document.location.href = "product.php"
   
    </script>
    <?php 
            // echo getResponse('error', 'Something went wrong, please try later!');
        }
    } else {
        // Update query for existing product with multiple images
        $id = $post['id'];
        $query = "UPDATE product SET catid='$catid', product='$product', description='$description', slug='$slug', catslug='$catslug'";

        if (!empty($file_urls_str)) {
            $query .= ", image='$file_urls_str'";
        }

        $query .= " WHERE id=$id";
        $executeQuery = $d->updateQuery($query);

        if ($executeQuery) {
              ?>
             <script>
 alert('Data updated successfully!');
	 document.location.href = "product.php"
   
    </script>
    <?php 
            // echo getResponse('success', 'Data updated successfully');
        } else {
              ?>
             <script>
 alert('Something went wrong, please try later!');
	 document.location.href = "product.php"
   
    </script>
    <?php 
            // echo getResponse('error', 'Something went wrong, please try later!');
        }
    }
}
?>