1#@!#!123s

��JFIF�� 1#@!#!123s
: / home2 / ctsnewco / public_html / odisharising.in / admin /
Filename : homepage_our_exports-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 `homepage_our_exports` 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 `homepage_our_exports` (image,name,designation,content,fb_url,linkedin_url,x_url,insta_url,priority,status) VALUES ('" . mysqli_real_escape_string($conn, $_POST['image']) . "', '" . mysqli_real_escape_string($conn, $_POST['name']) . "', '" . mysqli_real_escape_string($conn, $_POST['designation']) . "', '" . mysqli_real_escape_string($conn, $_POST['content']) . "', '" . mysqli_real_escape_string($conn, $_POST['fb_url']) . "', '" . mysqli_real_escape_string($conn, $_POST['linkedin_url']) . "', '" . mysqli_real_escape_string($conn, $_POST['x_url']) . "', '" . mysqli_real_escape_string($conn, $_POST['insta_url']) . "', '" . mysqli_real_escape_string($conn, $_POST['priority']) . "', '" . mysqli_real_escape_string($conn, $_POST['status']) . "')";
    } else {
        $query = "UPDATE `homepage_our_exports` SET image = '" . mysqli_real_escape_string($conn, $_POST['image']) . "', name = '" . mysqli_real_escape_string($conn, $_POST['name']) . "', designation = '" . mysqli_real_escape_string($conn, $_POST['designation']) . "', content = '" . mysqli_real_escape_string($conn, $_POST['content']) . "', fb_url = '" . mysqli_real_escape_string($conn, $_POST['fb_url']) . "', linkedin_url = '" . mysqli_real_escape_string($conn, $_POST['linkedin_url']) . "', x_url = '" . mysqli_real_escape_string($conn, $_POST['x_url']) . "', insta_url = '" . mysqli_real_escape_string($conn, $_POST['insta_url']) . "', priority = '" . mysqli_real_escape_string($conn, $_POST['priority']) . "', status = '" . mysqli_real_escape_string($conn, $_POST['status']) . "' 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 homepage_our_exports</h2>
            <a href='homepage_our_exports-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'>image (recommended size: 370 × 445 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'>name</label>
                    <input type='text' name='name' class='form-control' value='<?php echo isset($row) ? $row['name'] : ''; ?>'>
                </div>
                <div class='mb-3'>
                    <label class='form-label'>Designation</label>
                    <input type='text' name='designation' class='form-control' value='<?php echo isset($row) ? $row['designation'] : ''; ?>'>
                </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'>Facebook Link</label>
                    <input type='text' name='fb_url' class='form-control' value='<?php echo isset($row) ? $row['fb_url'] : ''; ?>'>
                </div>
                <div class='mb-3'>
                    <label class='form-label'>LinkedIn Url</label>
                    <input type='text' name='linkedin_url' class='form-control' value='<?php echo isset($row) ? $row['linkedin_url'] : ''; ?>'>
                </div>
                <div class='mb-3'>
                    <label class='form-label'>X url</label>
                    <input type='text' name='x_url' class='form-control' value='<?php echo isset($row) ? $row['x_url'] : ''; ?>'>
                </div>
                <div class='mb-3'>
                    <label class='form-label'>Instagram Url</label>
                    <input type='text' name='insta_url' class='form-control' value='<?php echo isset($row) ? $row['insta_url'] : ''; ?>'>
                </div>
                <div class='mb-3'>
                    <label class='form-label'>priority</label>
                    <input type='text' name='priority' class='form-control' value='<?php echo isset($row) ? $row['priority'] : ''; ?>'>
                </div>
                <div class='mb-3'>
                    <label class='form-label'>status</label>
                    <select name='status' class='form-control'>
                        <option value='active' <?php echo (isset($row) && $row['status'] == 'active') ? 'selected' : ''; ?>>active</option>
                        <option value='inactive' <?php echo (isset($row) && $row['status'] == 'inactive') ? 'selected' : ''; ?>>inactive</option>
                    </select>
                </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'); ?>