Jump to content

Progress record with PHP and Oracle


chrishutagalung

Recommended Posts

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>";
    }
    
    
?>
Link to comment
https://forums.phpfreaks.com/topic/287260-progress-record-with-php-and-oracle/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.