1#@!#!123s

: / var / www / vhosts / sarainternational.ae / httpdocs / admin /
Filename : product-form.php
back
<?php 
include('include/header.php');

    if(isset($_POST['add'])){
        $category =$_POST['addcategory'];
        $sku = $_POST['sku'];
        $title =$_POST['title'];  
        $desc =$_POST['desc'];
        $additional = $_POST['additional'];
        $date = date('Y/m/d'); 
        
        $filename = $_FILES['image']['name'];
    	$tmpname = $_FILES['image']['tmp_name'];
    	$unique = uniqid()." ".$filename;
    	$store = "images/subproduct/".$unique;
    	move_uploaded_file($tmpname,$store);
        
        $meta_title = $_POST['metatitle'];
        $meta_desc = $_POST['metadesc'];
        $meta_key = $_POST['metakey'];
        // $canonicalurl = $_POST['canonicalurl'];
        
      $modifiedText0 = str_replace("&", "and", $title); 
    $text = strtolower($modifiedText0);
    
    
         $desc = $_POST['desc'];            
        $replaceArray1 = array(
             '"' => "&#34;",
            "'" => "&#39;",
           
        );
        
        $modifiedText1 = str_replace(array_keys($replaceArray1), array_values($replaceArray1), $desc);
      
    
    $additional = $_POST['additional'];            
        $replaceArray2 = array(
             '"' => "&#34;",
            "'" => "&#39;",
           
        );
        
        $modifiedText2 = str_replace(array_keys($replaceArray2), array_values($replaceArray2), $additional);
        
    
    	$data= mysqli_query($conn,"insert into products (id,category,sku,title,description,additional_info,image,createDate,meta_title,meta_description,meta_keywords) values(' ','$category','$sku','$text','$modifiedText1','$modifiedText2','$store','$date','$meta_title','$meta_desc','$meta_key')");
    
    	if($data){
    		echo "<script> alert('Product Added');window.location.href='products.php'</script>";
    	}
    	else{
    		echo "<script> alert('Please try again')</script>";
    	}
    }

    







?>
  
  <!-- Content Wrapper. Contains page content -->
  <div class="content-wrapper">
	  <div class="container-full">
		<!-- Content Header (Page header) -->	  
		<div class="content-header">
			<div class="d-flex align-items-center">
				<div class="me-auto">
					<h4 class="page-title">Add Products</h4>
					<!--<div class="d-inline-block align-items-center">-->
					<!--	<nav>-->
					<!--		<ol class="breadcrumb">-->
					<!--			<li class="breadcrumb-item"><a href="#"><i class="mdi mdi-home-outline"></i></a></li>-->
					<!--			<li class="breadcrumb-item" aria-current="page">Products</li>-->
					<!--			<li class="breadcrumb-item active" aria-current="page">Add Products</li>-->
					<!--		</ol>-->
					<!--	</nav>-->
					<!--</div>-->
				</div>
				
			</div>
		</div>

		<!-- Main content -->
		<section class="content">
		<div class="box">
				<div class="box-header with-border">
				  <h4 class="box-title">Add New Product</h4>
				</div>
				<!-- /.box-header -->
				<div class="box-body">
				  <form role="form" method="POST" enctype="multipart/form-data">
					<!-- text input -->
					
					<div class="form-group">
					  <label class="form-label">Meta Title</label>
					  <input type="text" class="form-control" placeholder="Enter ..." name="metatitle" required>
					</div>
					
					<div class="form-group">
					  <label class="form-label">Meta Description</label>
					  <input type="text" class="form-control" placeholder="Enter ..." name="metadesc" required maxlength="180">
					</div>
					
					<div class="form-group">
					  <label class="form-label">Meta Keywords</label>
					  <input type="text" class="form-control" placeholder="Enter ..." name="metakey" required>
					</div>
					
					<!--<div class="form-group">-->
					<!--  <label class="form-label">Canonical URL</label>-->
					<!--  <input type="text" class="form-control" placeholder="Enter ..." name="canonicalurl" required>-->
					<!--</div>-->
					
						<div class="form-group">
					  <label class="form-label">Category</label>
					  <select class="form-control" name="addcategory" required>
                            <option>--- Select category ---</option>
                                    <?php 
                                        $sql = "select * from category";
                                        $query = mysqli_query($conn, $sql);
                                    while ($row1 = mysqli_fetch_assoc($query)) {
                                            echo "<option value='".$row1['id']."'>".$row1['categoryName']."</option>";
                    
                                    }?>
                            
					  </select>
					  
					</div>
					
					
					<div class="form-group">
					  <label class="form-label">SKU</label>
					  <input type="text" class="form-control" placeholder="Enter ..." name="sku" required>
					</div>
					
					<div class="form-group">
					  <label class="form-label">Product Name/Title</label>
					  <input type="text" class="form-control" placeholder="Enter ..." name="title" required>
					</div>
					
					<div class="form-group">
					  <label class="form-label">Product Description</label>
					  <textarea name="desc" id="editor" required></textarea>
					</div>
					
					<div class="form-group">
					  <label class="form-label">Product's Additional Information</label>
					  <textarea name="additional" id="editor2"></textarea>
					</div>
					
					<div class="form-group">
					  <label class="form-label">Image</label>
					  <input type="file" class="form-control" accept="image/png, image/jpeg, image/jpg" name="image" onchange="ShowImage(event)" required>
					   <img src="" width="200" id="image" />
					</div>
					
		           <div class="box-footer">
					<button type="submit" class="btn btn-success" name="add">Add</button>
					</div>
				  </form>
				  
				</div>
				<!-- /.box-body -->
				
				
			  </div>
		</section>
		<!-- /.content -->
		
	  
	  </div>
  </div>
  <!-- /.content-wrapper -->

	<script src="//cdn.ckeditor.com/4.22.1/standard/ckeditor.js"></script>

  <script>
  
  CKEDITOR.replace( 'editor');
  

 </script>

  <script>
  
  CKEDITOR.replace( 'editor2');

</script>
<?php include('include/footer.php') ?>