0
<?php


$con=mysqli_connect("localhost","root","","trial");

if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }


if(isset($_POST['submit']))
{
$day = $_POST['day'];
    {



$result = mysqli_query($con,"SELECT * FROM cust WHERE DATE(day)= '$day'");}

while($row=mysqli_fetch_array($result))  
 {
echo " <br><br><h2> EDIT Record of " . $row['name'] . " for the day " .$row['day'] . "</h2>";  

echo " Name <input type='text' name='name' size='20' value= '   $row[name] ' /> <br>";
echo " Benificiary<input type='text' name='name' size='20' value= '   $row[beni] ' /> <br>";
echo " Hospital No <input type='text' name='name' size='20' value= '   $row[mrd] ' /> <br>";
echo "Customer No <input type='text' name='name' size='20' value= '   $row[cusno] ' /> <br> ";
echo "Date Of Admission<input type='date' name='name' size='20' value= '   $row[doa] ' /><br> ";
echo "Date Of Discharge <input type='date' name='name' size='20' value= '   $row[dod] ' /><br> ";
echo "Date Of Operation<input type='date' name='name' size='20' value= '   $row[doo] ' /><br> ";

}
mysqli_close($con);
?>
2
Contributors
1
Reply
18
Views
3 Years
Discussion Span
Last Post by decade
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.