Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function editProduct($id){
- require "includes/db.php";
- $query ="SELECT * FROM product WHERE product_id='".$id."'";
- $result = mysqli_query($conn, $query) or die(mysqli_error($conn));
- if ($result){
- $row = $result->fetch_assoc();
- $p_name = $row['product_model'];
- $p_color = $row ['product_colour'];
- $p_mem = $row ['product_memory'];
- $p_desc = $row ['product_desc'];
- $p_price = $row ['product_price'];
- $p_stock = $row ['product_stock'];
- $p_current_img = $row['product_image'];
- $p_current_mem = explode (",",$p_mem);
- $p_current_color = explode (",",$p_color);
- }else { $fmsg ="Something has gone wrong. Please go back and try again."; }
- if(isset($_POST['submit'])){ //check if form is submitted
- $fmsg = "";
- if (isset($_POST['p_name'])) {
- $p_name = $_POST['p_name'];
- }else { $fmsg .= "*Please fill in the product name.<br/>";}
- if (isset($_POST['p_price'])) {
- $p_price = $_POST['p_price'];
- }else { $fmsg .= "*Please 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($_FILES['p_img']['size'] == 0){
- $p_img = $row['product_image'];
- }else{
- $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.";
- }
- }
- if (empty($fmsg)){
- $query = "UPDATE product SET product_model = '".$p_name."', product_price ='".$p_price."', product_colour ='".$p_color."' , product_stock ='".$p_stock."', product_desc ='".$p_desc."', product_memory ='".$p_mem."', product_image ='".$p_img."' WHERE product_id = ".$id;
- $result = mysqli_query($conn, $query) or die(mysqli_error($conn));
- if($result){
- header("location: manage_product.php?msg=1");
- }else{
- $fmsg ="Something has gone wrong. Please try again.";
- }
- }
- } // end form submitted
- ?>
- <form class="form-signin addNewAdminForm" method="POST" enctype="multipart/form-data">
- <h3>Edit Product Details</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-6 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;} ?>"/>
- </div>
- <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; } ?>"/>
- </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; } ?>"/>
- </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'])) || in_array($c, $p_current_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'])) || in_array($m, $p_current_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-6 col-m-6">
- <label for="currentImg">Current Image</label><br/>
- <img src="<?php echo "../product_img/".$p_current_img; ?>" width="300px"/>
- </div>
- <div class="col-6 col-m-6">
- <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">Update</button>
- <div></div>
- </form>
- <?php
- } // end edit product
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement