Viewing File: /home/quiczmwg/public_html/admin/manage-plan-process.php

<?php
include 'head.php';

if($_SERVER['REQUEST_METHOD']=="POST"){
    $userid = md5(date("Ymdhis").rand(203991, 483678));
    $plan_title = $_POST['plan_title'];
    $minimum = $_POST['minimum'];
    $maximum = $_POST['maximum'];
    $profit = $_POST['profit'];
    $roi = $_POST['roi'];
    $days = $_POST['days'];

    if(isset($_POST['btnSave'])){
        $sql = $conn->query("SELECT plan_title FROM plans WHERE plan_title='$plan_title' AND minimum='$minimum' AND maximum='$maximum' AND profit='$profit' AND roi='$roi' AND days='$days'");

        if($sql->num_rows==0){
            $sql = $conn->query("INSERT INTO plans (plan_title, minimum, maximum, profit, roi, days) VALUES ('$plan_title', '$minimum', '$maximum', '$profit', '$roi', '$days')");
        }
    }
    if (isset($_POST['btnSaveUpdate'])){
        $id = $_POST['id'];
        $sql = $conn->query("UPDATE plans SET plan_title='$plan_title', minimum='$minimum', maximum='$maximum', profit='$profit', roi='$roi', days='$days' WHERE id='$id'");
    }
    
    header("Location: manage-plan.php");
}
?>