add new product

function addNewProduct(){

    require "includes/db.php";

    if(isset($_POST['submit'])){ //check if form is submitted

    $fmsg = "";

    if (isset($_POST['p_name'])) {
        $p_name = $_POST['p_name'];
    }else { $fmsg = "*You need to specify Product Name.<br/>";}

    if (isset($_POST['p_price'])) {

        if (is_numeric($_POST['p_price'])) { $p_price = $_POST['p_price'];
        }else { $fmsg .= "*Price need to be in numbers.<br/>"; }
    }else { $fmsg .= "*You need to specify the price.<br/>";}

    if (isset($_POST['p_stock'])) {

        if (is_numeric($_POST['p_stock'])) { $p_stock = $_POST['p_stock'];
        }else { $fmsg .= "*Stock quantities need to be in numbers.<br/>"; }
    }else { $fmsg .= "*You need to specify the stock quantities.<br/>";}

    if (isset($_POST['p_desc'])) {
        $p_desc = $_POST['p_desc'];
    }

    if (isset($_POST['color'])) {

        $p_color = implode(",",$_POST['color']);

    }else { $fmsg .= "*Pick at least one color.<br/>"; }

    if (isset($_POST['mem'])) {

        $p_mem= implode(",",$_POST['mem']);

    }else { $fmsg .= "*Pick at least one color.<br/>"; }

    //-------for uploading image----------//

        if(file_exists($_FILES["p_img"]["tmp_name"])){


        $target_dir = "../product_img/";
        $target_file = $target_dir . basename($_FILES["p_img"]["name"]);
        $p_img = basename($_FILES["p_img"]["name"]);

        $uploadOk = 1;
        $imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);

        // Check if image file is a actual image or fake image
        $check = getimagesize($_FILES["p_img"]["tmp_name"]);
            if($check !== false) {
                $uploadOk = 1;
            } else {
                $fmsg .= "File is not an image.<br/>";
                $uploadOk = 0;
            }

        // Check if file already exists
        if (file_exists($target_file)) {
            $fmsg .= "Sorry, file already exists.<br/>";
            $uploadOk = 0;
        }
        // Check file size
        if ($_FILES["p_img"]["size"] > 1000000) {
            $fmsg .= "Sorry, your file is too large.<br/>";
            $uploadOk = 0;
        }

        // Allow certain file formats
        if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg"
        && $imageFileType != "gif" ) {
            $fmsg .= "Sorry, only JPG, JPEG, PNG & GIF files are allowed.<br/>";
            $uploadOk = 0;
        }

        if ($uploadOk == 0) {
        $fmsg .= "Sorry, your file was not uploaded.<br/>";
        }

        if (!move_uploaded_file($_FILES["p_img"]["tmp_name"], $target_file)) {
            $fmsg .= "Sorry, there was an error uploading your file.";
        }

        }else { $fmsg .= "Please choose a picture."; }




    if (empty($fmsg)){
    /*
        echo $p_name."<br />";
        echo $p_price."<br />";
        echo $p_stock."<br />";
        echo $p_color."<br />";
        echo $p_mem."<br />";
        echo $p_desc."<br />";
        echo $p_img;
    */

            $query = "INSERT INTO product (product_model, product_image, product_colour, product_memory, product_desc, product_price, product_stock)
                        VALUES ('$p_name', '$p_img', '$p_color', '$p_mem', '$p_desc', '$p_price', '$p_stock')";
            $result = mysqli_query($conn, $query) or die(mysqli_error($conn));
            if($result){
                header("location: manage_product.php?msg=3");
            }else{
                $fmsg ="Something has gone wrong. Please try again.";
            }


    }

} //end isset submit


    ?>

      <form class="form-signin addNewAdminForm" method="POST" enctype="multipart/form-data">
        <h3>Add New Product</h3>

        <div class="row">
            <div class="col-12 col-m-12">
                <?php if (!empty($fmsg)) {echo "<div class='msg'>".$fmsg."</div>";} ?>
            </div>
        </div>

        <div class="row">
            <div class="col-12 col-m-12">
                <label for="inputName">Product Name</label><br/>
                <input type="text" name="p_name" class="form-control" value="<?php if (isset($p_name)){ echo $p_name; }?>" size='35' required />

            </div>
        </div>

        <div class="row">

            <div class="col-6 col-m-12">
                <label for="inputPrice">Price</label><br/>
                <input type="text" name="p_price" id="inputPrice" class="form-control" value="<?php if (isset($p_price)){ echo $p_price;} ?>" required />

            </div>

            <div class="col-6 col-m-12">
                <label for="inputStock">Stock</label><br/>
                <input type="text" name="p_stock" id="inputStock" class="form-control" value="<?php if (isset($p_stock)){ echo $p_stock;} ?>"  required />

            </div>
        </div>

        <div class="row">
            <div class="col-6 col-m-12">
                <label for="inputColor">Colors</label><br/>

                <?php



                        $colors = array('JB','B','S','G','RG','SG');

                            foreach($colors as $c) {

                                if(isset($_POST['color']) && in_array($c, $_POST['color'])){ $checked = "checked";}else { $checked = "";}

                                  if($c == "JB"){ echo "<input type='checkbox' name='color[ ]' value='JB'".$checked.">Jet Black<br />";
                                  }else if($c == "B"){ echo "<input type='checkbox' name='color[ ]' value='B' ".$checked.">Black<br />";
                                  }else if($c == "S"){ echo "<input type='checkbox' name='color[ ]' value='S' ".$checked.">Silver<br />";
                                  }else if($c == "G"){ echo "<input type='checkbox' name='color[ ]' value='G' ".$checked.">Gold<br />";
                                  }else if($c == "RG"){ echo "<input type='checkbox' name='color[ ]' value='RG' ".$checked.">Rose Gold<br />";
                                  }else if($c == "SG"){ echo "<input type='checkbox' name='color[ ]' value='SG' ".$checked.">Space Grey<br />";
                                  }

                            }
                ?>

            </div>

            <div class="col-6 col-m-12">
                <label for="inputMemory">Memory</label><br/>

                <?php

                        $memory = array('32','64','128','256');

                            foreach($memory as $m) {

                                if(isset($_POST['mem']) && in_array($m, $_POST['mem'])){ $checked = "checked";}else { $checked = "";}

                                  if($m == "32"){ echo "<input type='checkbox' name='mem[ ]' value='32' ".$checked.">32 GB<br />";
                                  }else if($m == "64"){ echo "<input type='checkbox' name='mem[ ]' value='64' ".$checked.">64 GB<br />";
                                  }else if($m == "128"){ echo "<input type='checkbox' name='mem[ ]' value='128' ".$checked.">128 GB<br />";
                                  }else if($m == "256"){ echo "<input type='checkbox' name='mem[ ]' value='256' ".$checked.">256 GB<br />";
                                  }

                            }
                ?>

            </div>
        </div>

        <div class="row">
            <div class="col-12 col-m-12">
                <label for="inputImg">Upload Product Image</label><br/>
                 <input type="file" name="p_img" id="inputImg" class="form-control">
        <div></div>

        <div class="row">
            <div class="col-12 col-m-12">
                <label for="inputDesc">Product Descriptions</label><br/>
                <textarea rows="10" cols="50"  name="p_desc" id="inputDesc" class="form-control">
                <?php if (isset($p_desc)){ echo $p_desc;} ?>
                </textarea>

        <div></div>

        <div class="row">
            <div class="col-12 col-m-12">
        <button class="btn" type="submit" name="submit">Add New Product</button>
        <div></div>
      </form>

<?php
} //end add new product