Welcome to xCrud Community - Data Management and extended PHP CRUD

[mungle]

Hello,
I need to set a default value in a field that uses “relation” function. “pass_default” function doesn’t works.
Any suggestions?

 

[DaDo]

Hello,
I need to set a default value in a field that uses “relation” function. “pass_var” function doesn’t works.
Any suggestions?

Explain what you need ...

 

[mungle]

Ok... in my php file I have:

$xcrud->relation('user_who_add_the_data', 'user_table', 'user_id', 'user_name', '', '', false);
This will provide me a dropdown list of users name from my users table.
I want to add as default value in the user_who_add_the_data field the current logged in user for which I stored the name in the $logged_user_name variable
I tried to use:
$xcrud->pass_default('user_who_add_the_data', $logged_user_name);
but this doesn't works.

 

[DaDo]

Ok... in my php file I have:

$xcrud->relation('user_who_add_the_data', 'user_table', 'user_id', 'user_name', '', '', false);
This will provide me a dropdown list of users name from my users table.
I want to add as default value in the user_who_add_the_data field the current logged in user for which I stored the name in the $logged_user_name variable
I tried to use:
$xcrud->pass_default('user_who_add_the_data', $logged_user_name);
but this doesn't works.

pass_default if valid to use post on the custom function I will raccomand you to create subselect to extract data you need and pass as variable for example : $xcrud->subselect('logged_user',"SELECT logged as logged from ... where id = $variable"); extract this data maybe return logged from query and pass on relation

 

[mungle]

Hi!
Relation wasn't useful to achieve what I need. I didn't really get your suggestion as subselect only add columns data and not field, right?
Anyway I solved using:

$xcrud->pass_default('user_who_add_the_data', $_SESSION['logged_user_name']);