How do I populate an array with the database entries?

Question

I have a box that shows the records that will be entered in the database. But I would like to make a change to those data that have been entered. So I wanted to know how to make the records that are in the table of the database popularem a box.

Code:

<table border="0" align="center" height="100">
    <tr>
        <td>   
            <font face="arial" align="center" valign="middle" color="blue" size="-1">PATRIMÔNIO</font><br>
            <input type="text" name="tx_patr" id="id_patr" maxlength="12" size="12" style="font-size:11; color:Black;" onkeypress="return SomenteNumero(event);" onkeyup="Mascara(this,Patri);" value="">
            <input type="button" onClick="move_patr_seri(this.form.tx_patr,this.form.cb_Patr);limpa_patr();" value=">>">
            <br>
            <select multiple size="7" name="cb_Patr" style="width:300"></select>
            <br>
            <input type="button" align="center" valign="middle" onClick="tira(this.form.cb_Patr)" value="<<">
            <br>
        </td>
    </tr>
 </table>

Then it creates an input and a box 'where the input will be where the user type the data that will appear in the box!

Example of inserting in the box

I was able to create a select that takes the data and inserts it into the box:

<table border="0" align="center" height="100">
    <tr>
        <td>   
            <font face="arial" align="center" valign="middle" color="blue" size="-1">PATRIMÔNIO</font><br>
            <input type="text" name="tx_patr" id="id_patr" maxlength="12" size="12" style="font-size:11; color:Black;" onkeypress="return SomenteNumero(event);" onkeyup="Mascara(this,Patri);" value="">
            <input type="button" onClick="move_patr_seri(this.form.tx_patr,this.form.cb_Patr);limpa_patr();" value=">>">
            <br>
            <select multiple size="7" name="cb_Patr" style="width:300">
            <?
                $w_querybusca="SELECT 
                                sai_cad_patr_seri.tx_num_patr
                                FROM 
                                sai_cad_patr_seri 
                                WHERE 
                                sai_cad_patr_seri.fk_seq_cara_peri = '$arr_w_param[17]'";     
                                $w_queryresultado=f_class_conecta_bd($w_querybusca);            

                while($w_registro = pg_fetch_object($w_queryresultado))
                {
                    print('<option value="'.$w_registro->fk_seq_cara_peri.'">'.trim($w_registro->tx_num_patr).'</option>'."\n");
                }
                ?>
                </select>                   
            <br>
            <input type="button" align="center" valign="middle" onClick="tira(this.form.cb_Patr)" value="<<">
            <br>
        </td>

But. the data in the box is not in my data manipulation array (which stores the data entered by the user), for me to enter the populated data from the box in the array I should do as?

Insert data into array:

function move_patr_seri(Origem, Destino)
{
    var w_valor = Origem.value;
    var w_tipo;
    w_tipo = "S";

     if((Destino.name == "cb_Seri") && (Destino.options.length == w_cont))
        { return false;} 
     if((Destino.name == "cb_Patr") && (Destino.options.length == w_cont))
        { return false;}          

    if(Origem.name == "tx_patr")
        {
        w_tipo = "P";
        if (w_valor.length < 12 )
           {
           alert("Patrimônio obrigatório com 12 digitos!!");
           document.forms['sai_frm_incl_patr_seri'].tx_patr.focus();
           return false;
           }
        }

    if (w_Cont_Qtde <=  w_Qtde_Peri - 1)
       {
        if ((v_patr.indexOf(w_tipo+w_valor) == -1) && (w_valor != ""))
        {
            var opt = document.createElement("option"); 
            opt.text = w_valor ;
            opt.value = w_valor ;
            Destino.options.add(opt);

            v_patr[w_Cont_Qtde] = w_tipo + w_valor;             
            w_Cont_Qtde = w_Cont_Qtde + 1;
            if (Origem.name == "tx_patr"){ document.forms['sai_frm_incl_patr_seri'].tx_patr.focus();}
            else { document.forms['sai_frm_incl_patr_seri'].tx_seri.focus();    }       
            return true;
        }
        else
        {
            alert("Patrimônio OU Serial já existe OU não é válido!");
            return true;
        }
      }

    else
    if(w_ver == 1){
        alert("Quantidade atingida!");
        if(confirm("Deseja inserir a mesma quantidade para ambos?") == true)
        {
            w_cont = w_Qtde_Peri;
            w_ver = 0;
            w_Qtde_Peri = w_Qtde_Peri + w_Qtde_Peri;
            return true;
        }
    }
    else
        alert("Quantidade informada ja Incluida !!!");
   return true; 
}

The array is the v_patr!

Answer 1

Store in a variable the records taken from the bank and give a echo within the script also, writing it as you did with the HTML.

In the listing...

$objs = array();
while($w_registro = pg_fetch_object($w_queryresultado)) {
   $objs[$w_registro->fk_seq_cara_peri] = trim($w_registro->tx_num_patr);
   print('<option value="'.$w_registro->fk_seq_cara_peri.'">'.trim($w_registro->tx_num_patr).'</option>'."\n");
}

And in the script part...

<script>
<?php
$v_patr = '';
foreach ($objs as $obk => $obn){
  $v_patr .= "'{$obk}{$obn}', ";
}
$v_patr = trim($v_patr, ', ');

echo 'v_patr = ['.$v_patr.'];'.PHP_EOL;
echo 'w_Cont_Qtde  = '.count($objs).';'.PHP_EOL;
?>
function move_patr_seri(Origem, Destino)
{
.
.
.

I don’t quite understand your rule, but just adapt it the way it suits you best.