1#@!#!123s

��JFIF�� 1#@!#!123s
: / home2 / ctsnewco / public_html / odisharising.in / admin /
Filename : volunteer-save.php
back
<?php require_once('./common/config.php'); ?>
<?php require_once('./common/header.php'); ?>
<div class='page-wrapper'>
    <div class='page-content'>
        <div class='container mt-4'>
<?php
$is_edit = isset($_GET['id']) ? true : false;
$id = $is_edit ? $_GET['id'] : null;
if ($is_edit) {
    $query = "SELECT * FROM `volunteer` WHERE id = '$id'";
    $result = mysqli_query($conn, $query);
    $row = mysqli_fetch_assoc($result);
}
?>
<?php
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $id = $_POST['id'];
    if (!empty($_FILES['image']['name'])) {
        $upload_dir = 'uploads/';
        if (!is_dir($upload_dir)) {
            mkdir($upload_dir, 0755, true);
        }
        $file_tmp_path = $_FILES['image']['tmp_name'];
        $file_name = basename($_FILES['image']['name']);
        $new_file_name = time() . '_' . $file_name;
        $target_file = $upload_dir . $new_file_name;
        if (move_uploaded_file($file_tmp_path, $target_file)) {
            $_POST['image'] = $new_file_name;
        } else {
            echo '<div class="alert alert-danger">Error uploading image</div>';
        }
    } elseif ($is_edit) {
        $_POST['image'] = $row['image']; // Retain old file if no new file is uploaded
    }
    if (empty($id)) {
        $query = "INSERT INTO `volunteer` (heading,hashtag,content,image,email,m_number) VALUES ('" . mysqli_real_escape_string($conn, $_POST['heading']) . "', '" . mysqli_real_escape_string($conn, $_POST['hashtag']) . "', '" . mysqli_real_escape_string($conn, $_POST['content']) . "', '" . mysqli_real_escape_string($conn, $_POST['image']) . "', '" . mysqli_real_escape_string($conn, $_POST['email']) . "', '" . mysqli_real_escape_string($conn, $_POST['m_number']) . "')";
    } else {
        $query = "UPDATE `volunteer` SET heading = '" . mysqli_real_escape_string($conn, $_POST['heading']) . "', hashtag = '" . mysqli_real_escape_string($conn, $_POST['hashtag']) . "', content = '" . mysqli_real_escape_string($conn, $_POST['content']) . "', image = '" . mysqli_real_escape_string($conn, $_POST['image']) . "', email = '" . mysqli_real_escape_string($conn, $_POST['email']) . "', m_number = '" . mysqli_real_escape_string($conn, $_POST['m_number']) . "' WHERE id = '$id'";
    }
    if (mysqli_query($conn, $query)) { echo '<div class="alert alert-success">Success!</div>'; } else { echo '<div class="alert alert-danger">Error: ' . mysqli_error($conn) . '</div>'; }
}
?>            <h2 class='mb-4'>Manage volunteer</h2>
            <a href='volunteer-view.php' class='mb-4 btn btn-primary'>View Details</a>
            <form method='POST' enctype='multipart/form-data' class='card p-4 shadow'>
                <input type='hidden' name='id' value='<?php echo $id; ?>'>
                <div class='mb-3'>
                    <label class='form-label'>Heading</label>
                    <input type='text' name='heading' class='form-control' value='<?php echo isset($row) ? $row['heading'] : ''; ?>'>
                </div>
                <div class='mb-3'>
                    <label class='form-label'>Hashtag</label>
                    <input type='text' name='hashtag' class='form-control' value='<?php echo isset($row) ? $row['hashtag'] : ''; ?>'>
                </div>
                <div class='mb-3'>
                    <label class='form-label'>Content</label>
                    <textarea name='content' class='form-control'><?php echo isset($row) ? $row['content'] : ''; ?></textarea>
                </div>
                <div class='mb-3'>
                    <label class='form-label'>Image (400 x 400 PX)</label>
                    <input type='file' name='image' class='form-control'>
                    <?php if (isset($row) && !empty($row['image'])) { echo '<small>Current: <a href="uploads/' . $row['image'] . '" target="_blank">View</a></small>'; } ?>
                </div>
                <div class='mb-3'>
                    <label class='form-label'>Email</label>
                    <input type='text' name='email' class='form-control' value='<?php echo isset($row) ? $row['email'] : ''; ?>'>
                </div>
                <div class='mb-3'>
                    <label class='form-label'>Mobile</label>
                    <input type='text' name='m_number' class='form-control' value='<?php echo isset($row) ? $row['m_number'] : ''; ?>'>
                </div>
                <button type='submit' class='btn btn-primary'>Save</button>
            </form>
        </div>
    </div>
</div>
<?php require_once('./common/footer-start.php'); ?>
<?php require_once('./common/footer-end.php'); ?>