Skip to main content ↑ ↓
Recent Posts
11
Questions / Re: Connecting PHPRad to MySQL Server
Last post by jfaburto -
I been having the same problem,  all entries on the field are correct.  I had to disable the SSL for the user to get it to work.  This might be fine for development, but like to know how to enable the SSL from the radphp side, so I don't expose any passwords.
thanks
13
General Discussion / Filtro non visualizza i campi
Last post by daninet -
Salve a tutti.
Ho impostato un filtro in una pagina..  se controllo la query i valori di sono si carica il combo ma non si vedono i valori.

Hello everyone.
I set a filter on a page.. if you check the query the values ​​of are loads the combo but you don't see the values.
14
Questions / Re: trigger
Last post by daninet -
after insert - tabella prenotazioni

$table_data = array(
    "status" => "OCC",
    "postazione_id" => $rec_id
);
$db->where("id", $rec_id);
$bool = $db->update("postazioni", $table_data);

se inserisco questo codice ho error 500
15
Questions / Re: trigger
Last post by daninet -
Il trigger fa questo su after insert della tabella prenotazioni
UPDATE postazioni
SET postazioni.status='OCC'
WHERE postazioni.id = new.postazione_id "

questo è su page events ma non so come impostarlo

$table_data = array(
    "fieldname" => "value",
    "fieldname2" => "value2"
);
$db->where("table_id", $rec_id);
$bool = $db->update("tablename", $table_data);
16
General Discussion / Query page_id
Last post by giulio -
Good morning,
I'm inserting a custom sql query to create a drop-down menu in the form of an add page, but even though the query is correct, when I start the page it doesn't work, it seems like it doesn't recognize the $page_id variable.

The query without $page_id filter (works correctly and returns me all records):

"SELECT DISTINCT dr.id_distinta, dr.id_fase AS value, caf.codice AS label FROM line_list dr JOIN cfg_anagrafica_fasi caf ON dr.id_fase = caf.id"

The query with $page_id filter doesn't work:

"SELECT DISTINCT dr.id_distinta, dr.id_fase AS value, caf.codice AS label FROM line_list dr JOIN cfg_anagrafica_fasi caf ON dr.id_fase = caf.id WHERE dr.id_distinta = $page_id"

I can't understand the error

Thanks for the help