<?php session_start();
require_once('../DBManager.php');
require_once('../LoginManager.php');
include 'header.php';
include 'workdeskmenu.php';
//Code for Registration 
if(isset($_POST['signup'])) 
{ 
$sql ="UPDATE bedindex SET price='$_POST[price]'  WHERE  bedid='$_GET[bedid]'";
if($qsql = mysqli_query($con,$sql))
		{
    echo "<script>alert('Update successfully');</script><script>window.history.go(-2)</script>;</script>";
  } else {
    echo "Sorry, there was an error uploading your file.";
  } 
   
  
}

?>

<div class="content-wrapper">
    <!-- Content Header (Page header) -->
    <section class="content-header">
  <script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>

<form name="signup" enctype="multipart/form-data" method="post" >
<h3 align='center'>Bed Index</h3>
<table id='example2' class='table table-bordered table-hover'>
    

<?php
  	$sql ="SELECT * FROM bedindex WHERE bedid='$_GET[bedid]'";
		$qsql = mysqli_query($con,$sql);
		while($rs = mysqli_fetch_array($qsql))
		{
    echo " <tr><td width='50%'> Price </td>
<td width='50%'>
  <input name='price' value='$rs[price]' type='number'>
 </td></tr>";
}
?>

</table>
	<button type="submit" name="signup"> <span style="color:WHITE">Update</SPAN></button>
				 
				 
				 </form>