File Manager

✏️ Edit File: /home/rla105zs937x/public_html/mayonartandstudio.com/admin/collection_qry.php

<?php
session_start();
include('config.php');
// Resize image function (must be defined before it's called)
function resize_image($file, $w, $h) {
    list($width, $height, $type) = getimagesize($file);
    $r = $width / $height;

// Calculate new dimensions while maintaining the aspect ratio
    if ($w / $h > $r) {
        $newwidth = $h * $r;
        $newheight = $h;
    } else {
        $newheight = $w / $r;
        $newwidth = $w;
    }

$dst = imagecreatetruecolor($newwidth, $newheight);

// Load the original image based on its type
    switch ($type) {
        case IMAGETYPE_JPEG:
            $src = imagecreatefromjpeg($file);
            break;
        case IMAGETYPE_PNG:
            // Maintain transparency for PNG
            $src = imagecreatefrompng($file);
            imagealphablending($dst, false);
            imagesavealpha($dst, true);
            break;
        case IMAGETYPE_GIF:
            // Maintain transparency for GIF
            $src = imagecreatefromgif($file);
            $transparent = imagecolorallocatealpha($dst, 0, 0, 0, 127);
            imagefill($dst, 0, 0, $transparent);
            imagecolortransparent($dst, $transparent);
            break;
        default:
            die('Unsupported image type.');
    }

// Resample the image
    imagecopyresampled($dst, $src, 0, 0, 0, 0, $newwidth, $newheight, $width, $height);
    imagedestroy($src);

return $dst;
}

// Insert Collection Logic
if (isset($_POST['insert_collection']) && $_POST['insert_collection'] == 'insert') {
    $group_name = $_POST['group_name'];
    $title = $_POST['title'];
    $description = $_POST['description'];

$folder = "uploads/";
    $original_photo = $_FILES['photo']["tmp_name"];
    $photo_name = basename($_FILES['photo']["name"]);
    $photo_path = $folder . $photo_name;

// Resize and save the image
    $resized_image = resize_image($original_photo, 600, 800);

// Get file extension
    $ext = pathinfo($photo_name, PATHINFO_EXTENSION);
    $saved_photo_path = $folder . 'resized_' . $photo_name;

// Save the resized image to disk based on file extension
    switch (strtolower($ext)) {
        case 'jpg':
        case 'jpeg':
            imagejpeg($resized_image, $saved_photo_path);
            break;
        case 'png':
            imagepng($resized_image, $saved_photo_path);
            break;
        case 'gif':
            imagegif($resized_image, $saved_photo_path);
            break;
        default:
            die('Unsupported file extension.');
    }

// Free memory
    imagedestroy($resized_image);

// Insert record into database
    $insert_qry = mysqli_query(
        $conn,
        "INSERT INTO collect (`group_name`, `title`, `photo`, `description`) VALUES ('$group_name', '$title', '$saved_photo_path', '$description')"
    );

if ($insert_qry) {
        header('Location: collection.php?message=' . urlencode('Inserted Successfully'));
        exit;
    }
}

if (isset($_GET['action']) && $_GET['action'] == 'delete' && isset($_GET['id'])) {
    $id = intval($_GET['id']); 
    $query = "DELETE FROM collect WHERE id = $id";
    if (mysqli_query($conn, $query)) {
        header('Location: view_collection.php?message=' . urlencode('Record deleted successfully'));
        exit;
    } else {
        echo "Error: " . mysqli_error($conn);
    }
}
if (isset($_POST['update_collection']) && $_POST['update_collection'] == 'update') {
    $id = $_POST['id'];
    $group_name = $_POST['group_name'];
    $title = $_POST['title'];
    $description = $_POST['description'];
    $folder = "uploads/";
    
    $photo_name = basename($_FILES['photo']["name"]);
    $photo_path = $folder . $photo_name;

// Check if a new photo is uploaded
    if (!empty($_FILES['photo']['name'])) {
        $original_photo = $_FILES['photo']["tmp_name"];

// Resize and save the image
        $resized_image = resize_image($original_photo, 600, 800);

// Get file extension
        $ext = pathinfo($photo_name, PATHINFO_EXTENSION);
        $saved_photo_path = $folder . 'resized_' . $photo_name;

// Save the resized image to disk based on file extension
        switch (strtolower($ext)) {
            case 'jpg':
            case 'jpeg':
                imagejpeg($resized_image, $saved_photo_path);
                break;
            case 'png':
                imagepng($resized_image, $saved_photo_path);
                break;
            case 'gif':
                imagegif($resized_image, $saved_photo_path);
                break;
            default:
                die('Unsupported file extension.');
        }

// Free memory
        imagedestroy($resized_image);

// Update query with photo
        $update_qry = mysqli_query(
            $conn,
            "UPDATE collect SET 
                `group_name` = '$group_name', 
                `title` = '$title', 
                `photo` = '$saved_photo_path', 
                `description` = '$description' 
            WHERE `id` = '$id'"
        );
    } else {
        // Update query without photo
        $update_qry = mysqli_query(
            $conn,
            "UPDATE collect SET 
                `group_name` = '$group_name', 
                `title` = '$title', 
                `description` = '$description' 
            WHERE `id` = '$id'"
        );
    }

if ($update_qry) {
        header('Location: view_collection.php?message=' . urlencode('Updated Successfully'));
        exit;
    } else {
        echo "Error: " . mysqli_error($conn);
    }
}

if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['login']) ) {
   
    $username = $_POST['user_name']; 
    $password = $_POST['pswd'];

$select = mysqli_query($conn,"SELECT * FROM user_tbl WHERE user_name = '$username' AND pswd ='$password'");
     if (mysqli_num_rows($select) > 0 ) 
        {

echo $username;
            $user = mysqli_fetch_assoc($select);
            $_SESSION["user_name"] = $user['user_name'];
            $_SESSION["pswd"] = $user['pswd'];
            $qry = "UPDATE user_tbl SET status = 1 WHERE user_name = '$user[user_name]' AND pswd = '$user[pswd]'";
            $s1 = mysqli_query($conn,$qry);
            if($s1)
            {
               //echo "<script>window.location.href='collection.php' </script>";
              header("Location: collection.php");
                exit; 
            } 
        }
        else{
            echo "<script>
            alert('wrong username or password');
            window.location.href='login.php' </script>";
        }  
        
        
        }
        if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['logout']) ) {
            $username = $_SESSION["user_name"]; 
            $password = $_SESSION["pswd"]; 
            $qry = "UPDATE user_tbl SET status = 0 WHERE user_name = '$username' AND pswd = '$password'";
            echo "<script>  alert($_SESSION[user_name]);       </script>";
            $s1 = mysqli_query($conn,$qry);
            session_unset();
            session_destroy();
            header("Location: login.php");
         }

if(isset($_POST['add_group']) && $_POST['add_group'] == 'insert_group')
        {
            $gname= $_POST['group_name'];
          
            $insert_qry= mysqli_query($conn,"INSERT into groupname (`group_name`,`created_on`) value ('$gname',now())");
            if($insert_qry)
            {
                header('Location: group.php?message=' . urlencode('Added Successfully'));
         exit;
            }

}
        if(isset($_GET['delete_action']) && $_GET['delete_action'] == 'delete')
        {
            $id=$_GET['id'];
            echo $id;
            $delete_qry=mysqli_query($conn,"DELETE FROM groupname WHERE id = $id");
            if($delete_qry)
            {
                header('Location: group.php?message=' . urlencode('Deleted Successfully'));
                exit;
            }

}
        if(isset($_POST['update_group']) && $_POST['update_group'] == 'update')
{
    
    $gid= $_POST['gid'];
    $group_name= $_POST['group_name'];
   
        $update_qry = mysqli_query($conn, "UPDATE groupname SET  `group_name` = '$group_name' WHERE `id` = '$gid'"); 
   
    
     if($update_qry)
     {
         header('Location: group.php?message=' . urlencode('Updated Successfully'));
         exit;
        
     }
}
?>

Batal

⬅ Naik ke mayonartandstudio.com 19 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁css	dir	—	2024-12-27 03:58	📂 Buka
📁db	dir	—	2024-12-25 05:55	📂 Buka
📁font	dir	—	2024-12-27 03:51	📂 Buka
📁img	dir	—	2024-12-27 04:14	📂 Buka
📁uploads	dir	—	2025-06-14 08:11	📂 Buka
🐘collection.php	php	4.7 KB	2025-01-03 05:27	✏️ Edit 👁️ View
🐘collection_qry.php	php	8.5 KB	2025-01-03 05:28	✏️ Edit 👁️ View
🐘config.php	php	86 B	2025-01-03 05:26	✏️ Edit 👁️ View
🐘dashboard.php	php	609 B	2024-12-17 07:34	✏️ Edit 👁️ View
🐘display.php	php	3.9 KB	2025-01-03 05:28	✏️ Edit 👁️ View
📄error_log	file	736.9 KB	2025-11-10 18:10	✏️ Edit 👁️ View
🐘group.php	php	4.5 KB	2025-01-03 05:28	✏️ Edit 👁️ View
🐘log_qry.php	php	1.2 KB	2025-01-03 05:29	✏️ Edit 👁️ View
🐘login.php	php	2 KB	2024-12-31 04:35	✏️ Edit 👁️ View
🗜️login.rar	rar	863 B	2024-12-26 06:32	✏️ Edit 👁️ View
🌐man.html	html	267 B	2024-12-27 06:08	✏️ Edit 👁️ View
🐘navbar.php	php	1.3 KB	2025-01-03 03:55	✏️ Edit 👁️ View
🐘text.php	php	2.9 KB	2025-01-01 09:13	✏️ Edit 👁️ View
🐘view_collection.php	php	4.2 KB	2025-01-03 05:26	✏️ Edit 👁️ View