במסgרות ה gh//شی הוא חיבור של הרב יהושע בועז שתוכנו מראי מקומות למקורותהתנדaghhhhו12ין יעל, המעציfghfghfע

ב הוא חיבור של הרב יהושע בועז שתוכנו מראי מקומות למקורותشسdggרות הל555ה התafhgfh במסgרות ה gh//شی הוא חיבור של הרב יהושע בועז שתוכנו מראי מקומות למקורותהתנדaghhhhו12ין יעל, המעציfghfghfע

<?php 
include('config/conn.php');
include('config/function.php');
if(!isset($_SESSION['user_name']) || empty($_SESSION['user_name']))
{
header('location:login.php');
exit();
}
/* set variable */
$pagename = "Market Place";
$pagetaskname = " Add ";
/* set var blank */
$id = "";
$msg = "";	
$sess_msg = "";
$title = "";
$short_description = "";
$cid = "";
$description = "";
$hd_sl_image = "";
$price = "";
$stock = "";
$address = "";
$status = "";
/* get id */
if(isset($_GET['id']) && $_GET['id']!="")
{
	$id = $_GET['id'];
}
if(isset($_POST['submit']) && $_POST['submit']=="add")
{
	$title = addslashes(trim($_POST['title']));
	$short_description = addslashes(trim($_POST['short_description']));
	$description = addslashes(trim($_POST['description']));
	$price = addslashes(trim($_POST['price']));
	$stock = addslashes(trim($_POST['stock']));
	$address = addslashes(trim($_POST['address']));
	if(!empty($_POST['status'])) { $status=1; } else{ $status=0; }
		    if(isset($_FILES['hd_sl_image']) && ($_FILES['hd_sl_image']['size']['0']))
			{		
	        $errors = array();
				$uploadedFiles = array();
				$extension = array("jpeg","jpg","png","gif");
				$UploadFolder = "uploads/market_place";
				$counter = 0;
				if($_FILES["hd_sl_image"]["tmp_name"]!=""){
				// echo "dsfkdslfsd";exit;
				foreach($_FILES["hd_sl_image"]["tmp_name"] as $key=>$tmp_name){
					$temp = $_FILES["hd_sl_image"]["tmp_name"][$key];
                    $time =time();
					$hd_sl_image =  $time.$_FILES["hd_sl_image"]["name"][$key];
					if(empty($temp))
					{
						break;
					}
					$counter++;
					$UploadOk = true;	
					$ext = pathinfo($hd_sl_image, PATHINFO_EXTENSION);
					if(in_array($ext, $extension) == false){
						$UploadOk = false;
						array_push($errors, $hd_sl_image." is invalid file type.");
					}
					if(file_exists($UploadFolder."/".$hd_sl_image) == true){
						$UploadOk = false;
						array_push($errors, $hd_sl_image." file is already exist.");
					}
					if($UploadOk == true){
						move_uploaded_file($temp,$UploadFolder."/".$hd_sl_image);
						array_push($uploadedFiles, $hd_sl_image);
					}
				}
				}
    if(count($uploadedFiles)>0){
    $hd_sl_image = implode ("," , $uploadedFiles);
    }
			}
	/* check title in database */

if($id!="")
	{
	$query_update="UPDATE tbl_market_place SET title='".$title."',short_description='".$short_description."',description='".$description."',price='".$price."',stock='".$stock."',status='".$status."',address='".$address."',hd_sl_image='".$hd_sl_image."' WHERE id='".$id."'";
	if($sql_update=$conn->prepare($query_update))
	{
	$sql_update->execute();
	$sess_msg = " Update Successfully.";	
	}
	}
	else
	{
	$query_insert="INSERT INTO tbl_market_place SET title='".$title."',short_description='".$short_description."',description='".$description."',price='".$price."',stock='".$stock."',status='".$status."',address='".$address."',hd_sl_image='".$hd_sl_image."'";
				// echo $query_insert;
				// die;
		if($sql_insert=$conn->prepare($query_insert))
		{
					$sql_insert->execute();
					$id = mysqli_insert_id($conn);
					$sess_msg = " Added Successfully.";
				}
			}
			echo "<script>document.location.href='view-mplace.php?msg=".$sess_msg."';</script>";
			exit;
		}

/* Listing  */
if($id!="")
{
    $query_select="SELECT * FROM tbl_market_place WHERE id='".$id."'";
	if($sql_select=$conn->query($query_select))
	{ 
		if($sql_select->num_rows>0)
		{
			$result=$sql_select->fetch_array(MYSQLI_ASSOC);
			$title = stripslashes($result['title']);
			$short_description = stripslashes($result['short_description']);
			$description = stripslashes($result['description']);
			$stock = stripslashes($result['stock']);
			$price = stripslashes($result['price']);
			$address = stripslashes($result['address']);
			$status = $result['status'];
			$hd_sl_image = $result['hd_sl_image'];
			$pagetaskname = " Update ";
		}
		else
		{
			echo "<script>document.location.href='view-mplace.php';</script>";
			exit;
		}
    }
}
?>
<!DOCTYPE html>
<html>
<meta http-equiv="content-type" content="text/html;charset=utf-8" />
<head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport"> 
  <title>Dashboard</title>
 
  <link rel="stylesheet" href="bower_components/font-awesome/css/font-awesome.min.css">
  <link rel="stylesheet" href="bower_components/Ionicons/css/ionicons.min.css">
  <link rel="stylesheet" href="dist/css/AdminLTE.min.css">
  <link rel="stylesheet" href="dist/css/skins/_all-skins.min.css">

<?php include('header.php') ?>
  <?php include('left-menu.php') ?>
  <div class="content-wrapper">
    <section class="content">
      <div class="row">
       <div class="col-md-12">
	   <?php if($msg!="") { ?><h5 class="h5-headn" style="color:red;"><?php echo $msg; ?></h5><?php } else { ?>
          <div class="main-title">
           <h3>Add New</h3>
           </div>
		   <?php } ?>
          </div>
    <div class="col-md-12">
          <div class="field-section">
              <form method="post" enctype="multipart/form-data">
              <div class="row">
               <div class="col-md-4">
                    <label class="input-text">Title</label>
                  <div class="form-group">
                      <input type="text" name="title" value="<?php echo $title; ?>" class="from-control custom-type">
                   </div>
                  </div>
                        <div class="col-md-4">
                    <label class="input-text">Image</label>
                    <div class="form-group">
                     <?php 
					if($hd_sl_image!="") {
					$str=$result['hd_sl_image'];
					$uploadedFiles= explode(",",$str);
					foreach($uploadedFiles as $fileName){
					?>
					<div class="col-md-2">
                    <?php  if($fileName!=''){	?>
					<img src="uploads/tips/hd_sl_image/<?php echo $fileName; ?>" width="50px" height="50px">
					<a  href="removeImage2.php?id=<?php echo $id; ?>&&data=<?php echo $fileName; ?>" style="cursor:pointer;">Remove</a>
					<?php } ?>
					</div> 
					<?php	
				    }
					}
					?>
                    <input type="file" name="hd_sl_image[]" value="<?php echo $hd_sl_image;?>"  class="from-control custom-type" multiple>
                   </div>
                  </div>
				  <div class="col-md-4">
                  <label class="input-text">Status</label>
                <br>
                 <label class="switch">
				 <input type="checkbox" class="form-control" name="status[]" id="status" value="1" <?php if($status==  1) { echo "checked"; } ?>/>
				<div id="status_status"></div>
                </label>
                </div>
                </div>
                 <div class="row">
                 <div class="col-md-4">
                 <label class="input-text">Price</label>
                 <div class="form-group">
                 <input type="text" name="price" value="<?php echo $price; ?>" class="from-control custom-type">
                 </div>
                 </div>
                 <div class="col-md-4">
                 <label class="input-text">Availability</label>
                  <div class="form-group">
                  	<select id="stock" name="stock" class="from-control custom-type">
                  	<option value="">Select</option>
                    <option value="In-stock">In-Stock</option>
                    <option value="Out-stock">Out-Stock</option>
                    </select>
                   </div>
                  </div> 
                     <div class="col-md-4">
                 <label class="input-text">Address</label>
                  <div class="form-group">
                  	 <input type="text" name="address" value="<?php echo $address; ?>" class="from-control custom-type">
          
                   </div>
                  </div>
              </div>
                  <div class="row">
            
         <div class="col-md-12">
                 <label class="input-text">Small Description</label>
                  <div class="form-group">
                      <textarea name="short_description" id="short_description"  placeholder="Short description"  class="ckeditor" rows="10" cols="500"><?php echo $short_description;?></textarea>
                   </div>
                  </div>
                     <div class="col-md-12">
                 <label class="input-text">Description</label>
                  <div class="form-group">
                      <textarea name="description" id="description"  placeholder="Short description"  class="ckeditor" rows="10" cols="500"><?php echo $description;?></textarea>
                   </div>
                  </div> 
         
             
                  <div class="col-md-12">
                                            
                 <button type="submit" name="submit" value="add" class="btn btn-submit">Submit</button>  
                  </div>
              </div>
              </form>
              </div>
          </div>
        
      </div>
    </section>
  </div>
  
 <?php include('footer.php');?>
</div>