Fetching my Data in the table to Input boxes based on their ID

Question

Main Goal: I want to view the whole details of my specific row data in my table into a new form(input text) based on their ID.

Here is my code to fetch my data into table




  
      
        Listing All Services
        

          0) {  
                while ($result = mysqli_fetch_assoc($run)) {
                   echo "
              ";
                if($result['appoint_status'] == 2 ){
                    echo"";
                  } else {
                   echo"";
              } else {
                echo "";
              }
              }
            }
            ?>
             
            
                Service ID
                Order Date
                Client Name
                Contact
                Client Product
                No. of Items
                Due Date
                Service Status
                Action
              
              
                ".$result['appoint_id']."
                ".$result['order_date']."
                ".$result['customer_name']."
                ".$result['customer_contact']."
                ".$result['item_type']."
                ".$result['quantity']."
                ".$result['due_date']." Finished On Going";
                 }
                if($result['appoint_status'] == 2 ){
                echo " 
                
                Remove 
                 
                Finished

So what i want is when i click this button **

** The corresponding row will fetch its data into input boxes.


  
    
      
        Full Details
        
      

   
      
        

    
  Appoint ID:
    
      
    
  

  
  Customer Name:
    
      
    
  

  
  Contact Number:
    
      
    
  

  
  Item/s Type:
    
      
    
  

   
    Quantity:
    
      
    
  


   
    Due Date:
    
      
    
  



    Assinged Worker/s:
     
      
    
  

      
        
        
      
      

    }
  }

This is the visual example of my table.

And when i click the view button

So what i want is to automatically fetch the correspoding row of the view button that i just clicked. Im kinda new to coding so im not really sure what i need to do that. Thanks and sorry for convenience.

Naveen · Accepted Answer

Step 1: Add a appoint_id (i.e. unique id ) to view button using data attribute.

In Your Case data-appoint='".$result['appoint_id']."'

   echo "
        ";

-Step 2: Add a onclick event listener to view button. In Your Case

    $(".edit_cat").click(function(){
        let service_id=$(this).data('appoint');
        console.log(service_id);
    });

so you can able to access service id in function so add ajax or fetch api to request the source and get data from it. And add Data to desired Input

Fetching my Data in the table to Input boxes based on their ID

Answers (1)

Related Questions