hello everyone. i have this same custom php function
function Details($doc_id) {
$conn = db_connect("sample_db");
if (!$conn) {
die("Database connection failed: " . mysqli_connect_error());
}
$sql = "SELECT * FROM `view_tbl_kilos` WHERE doc_id = '$doc_id'";
$qry = mysqli_query($conn, $sql);
if (!$qry) {
die("Query execution failed: " . mysqli_error($conn));
}
$row = mysqli_fetch_assoc($qry);
mysqli_close($conn);
if (!$row) {
return null;
}
return array(
'alpha' => $row['alpha'],
'bravo' => $row['bravo'],
'delta' => $row['delta'],
'charlie' => $row['charlie'],
'echo' => $row['echo'],
'foxtrot' => $row['foxtrot']
);
}
i tried to use these lines in row_inserted to get the values of the array but it did not show.
$result = grsDetails($doc_id);
$alpha = $result['alpha'];
$bravo = $result['bravo'];
$charlie = $result['charlie'];
$delta = $result['delta'];
$echo = $result['echo'];
$foxtrot = $result['foxtrot'];
i have tested this and i have got data but in phpmaker it does not show. am i missing something?