how i can use where function in the select options

saee2838

 Editor::inst( $db, 'users_visits', array('event_id', 'event_level') )
    ->where( 'event_id', $eventid )
    ->debug( true )
    ->field( 
        Field::inst( 'users_visits.event_id' )
            ->options( Options::inst()
                ->table( 'sport_calendar_match_events' )
                ->where('id',$event_id)               <<<<<<<<<<<<<<<<<<<<<<<-------------------------- do not work       
                ->value( 'id' )
                ->label( array('name') )
            )
            ->validator( 'Validate::dbValues' ),
        Field::inst( 'users_visits.level_name' )->validator( 'Validate::notEmpty' ),

        Field::inst( 'users_visits.competition_type' ),
        Field::inst( 'sport_calendar_match_events.name' )
            ->set( false )
    )

allan

That should be all you need to do. I would point out on line 8 you have $event_id while on line 2 you have $eventid. Is that intentional?

Allan

saee2838

i change it
but it dosent work
when i add ->where( 'id' , $eventid )
it dosent work

saee2838

i test ->where( 'id' , 1)
but not working

saee2838

i try with compoundKey example in source
but it dose not work

saee2838

when i use this code

$userid=5;
// The key thing to note for compound key support is the use of an array as the
// third parameter for the Editor constructor, which is used to tell Editor what
// the primary key column(s) are called (default is just `id`).
Editor::inst( $db, 'users_visits', array('user_id', 'visit_date') )
    ->debug( true )
    ->where('user_id', $userid)
    ->field( 
        Field::inst( 'users_visits.user_id' )
            ->options( Options::inst()
                ->table( 'users' )
                ->value( 'id' )
                ->label( array('first_name', 'last_name') )
                ->where( function ($db) {
                    $db->where( 'id', 5 );     <<<<<<<<<<<<<-----------------here
                })
            )
            ->validator( 'Validate::dbValues' ),

its work
but when i use $userid in second where it dosent work

$userid=5;
// The key thing to note for compound key support is the use of an array as the
// third parameter for the Editor constructor, which is used to tell Editor what
// the primary key column(s) are called (default is just `id`).
Editor::inst( $db, 'users_visits', array('user_id', 'visit_date') )
    ->debug( true )
    ->where('user_id', $userid)
    ->field( 
        Field::inst( 'users_visits.user_id' )
            ->options( Options::inst()
                ->table( 'users' )
                ->value( 'id' )
                ->label( array('first_name', 'last_name') )
                ->where( function ($db) {
                    $db->where( 'id', $userid );    <<<<<<<<---------here
                })
            )
            ->validator( 'Validate::dbValues' ),

allan

That is correct and expected as that's how PHP closures work. You need to use the use statement:

->where( function ($db) use ($userid) {

See the PHP documentation on anonymous functions for more details.

Allan