Progress record with PHP and Oracle

[chrishutagalung]

Hi Folks, 

 

I am new here and I am building a dummy business application for my school project. So I am still learning from you guys and please guide me with what i have right now. 

So, I want to populate a dropdown list with rows that exists in my Oracle DB and that would be my COMPONENT_ID column.

When i pull that component ID column and select one of them, I need to show the corresponding data that show progress from that particular item.

 

So when i choose one of the ID, I need to show the rest of the column that is in the same row with that particular item.

 

What i have right now is this. I am assuming this will only pull the component ID but it doesnt work either. So please help me...

<?php
    $paint_parse = oci_parse($conn, 'SELECT HEAD_MARK FROM FABRICATION');
    oci_execute($paint_parse, OCI_DEFAULT);
    
    // Count the number of occurence inside the table
    $result = array();
    $numrows = oci_fetch_all($paint_parse, $result, null, null, OCI_FETCHSTATEMENT_BY_ROW);
    
    while ($row = oci_fetch_array($paint_parse, OCI_ASSOC)!= false){
        $value = $row['HEAD_MARK'];
        echo "<option value = $value>$value</option>";
    }
    
    
?>