how show value of input select from database without click any button after select date?-CodePudding

<div >
     <div >
        <label >Date_reservation</label>
        <input type="date" name="date_res">
     </div>
</div>
<div >
     <div >
     <div >
        <label >Type_salle</label>
        <select   name="code_salle" >
          <option>STD1</option>
          <option>STD2</option>
          <option>STD3</option>
          <option>STD4</option>
      </select>
   </div>
 </div>
</div>

{{-- In the database, there is a table named rooms. I want to display all room details from the table(room) --}}

CodePudding user response：

You should change the PHP code with following code

<div >
            <div >
                <label >Date_reservation</label>
                <input type="date" name="date_res" id="date_res">
            </div>
        </div>
        <div >
            <div>
            <div >
                <label >Type_salle</label>
                <select name="code_salle" id="code_salle">
                   <option>STD1</option>
                   <option>STD2</option>
                   <option>STD3</option>
                   <option>STD4</option>
               </select>
           </div>
        </div>
        </div>

After that,You can use onchange function to fetch room details from the database(fetch_room_data.php, which is used to fetch the room table details from the database). Here, I will provide a sample code

$('#date_res').on('change', function() 
{                                                                  
$.ajax({
url:"fetch_room_data.php",
method:"POST",
success:function(data)
{ 
  $('#code_salle').html(data);
}
});
});

CodePudding user response：

You will need Javascript and an API Route, because you can't just connect html with your database that's not how it works.

An alternative option would be to use blade(a template engine for laravel).