2. PHPRunner General questions
  3. [SOLVED] default add values from previous record
This topic is locked
[SOLVED]

default add values from previous record

 		4/14/2024 1:59:16 PM
PHPRunner General questions
francesco author

when I Add a new record in this situation:

img alt

I want to load previous values ad default, so I added this code in Process record values:

$matricola = $values["matricola"];
$queryIngresso = "SELECT ingresso FROM rettifiche WHERE matricolarett = '$matricola' ORDER BY idrett DESC LIMIT 1";
$resultIngresso = CustomQuery($queryIngresso);

$values["ingresso"]=db_fetch_array($resultIngresso);

I don't have any results so I think is not correct to read matricola $values["matricola"]

Do you have another solution?
francesco author 4/14/2024

solved myself, here is correct code

$matricola = $values["matricolar"];

// Costruisci una singola query per ottenere l'ultimo ingresso, intermedio, uscita, e i valori di lardoni per la matricola specificata
$query = "SELECT ingresso, intermedio, scarico, inlardoni, intlardoni, outlardoni FROM rettifiche WHERE matricolar = '$matricola' ORDER BY idrett DESC LIMIT 1";

// Esegui la query
$result = DB::Query($query);

// Recupera il risultato
$data = $result->fetchAssoc();

// Assegna i valori alle variabili appropriate
$values["ingresso"] = $data["ingresso"];
$values["intermedio"] = $data["intermedio"];
$values["scarico"] = $data["scarico"];
$values["inlardoni"] = $data["inlardoni"];
$values["intlardoni"] = $data["intlardoni"];
$values["outlardoni"] = $data["outlardoni"];