CODEWITHSUNDEEP
javascriptphpjquerycodeigniter
sethu
sethu

Reputation: 49

How to pass select option values from php code to Jquery?

When clicking add row button, new row will add to the specific table. So I need to add a select option with php option values.

How to pass this php values to jQuery?

Jquery function I need to show select option inside the rowData.push('');

  $('.dt-add').each(function () {
        var whichtable = $(this).parents('form').attr('data-id');
        $(this).on('click', function(evt){
            //Create some data and insert it
            var rowData = [];
            var table = $('#teammembertable' + whichtable).DataTable();
//          rowData.push('');

            rowData.push('<select class="form-control addstafftype" id="addstafftype" name="addstafftype"><option value="">Select</option><option value="Leader">Leader</option><option value="Technician">Technician</option></select');
            rowData.push('<button type="button" data-id='+ whichtable +' class="btn-xs dt-delete dt-deletes"><i style="font-size:10px" class="fa">&#xf00d;</i></button>');
            table.row.add(rowData).draw( false );
        });
    });

PHP CODE

$dataadd_team_memb = array(
        'team_id' => $id,
        'Staff_id' => $this->input->post('getaddstaffname'),
        'Staff_type' => $this->input->post('getaddstafftype'),
        'status' => "active"
    );


    $insert_id = 0;
    if ($this->db->insert("team_members", $data)) {
        $insert_id = $this->db->insert_id();
    }

Upvotes: 3

Views: 326

Answers (1)

Piyush Shukla
Piyush Shukla

Reputation: 254

$('.dt-add').each(function () {
    var whichtable = $(this).parents('form').attr('data-id');
    $(this).on('click', function(evt){
        var rowData = [];
        var table = $('#teammembertable' + whichtable).DataTable();
        rowData.push('<select class="form-control addstafftype" id="addstafftype" name="addstafftype">'+
            '<option value="">Select</option>'+
            '<?php foreach($selectallstaff as $staffname){ ?>'+
                '<option value="<?php $staffname["Staff_id"]; ?>"><?php $staffname["Staff_name"]; ?></option>'+
            '<?php } ?>'+
            '</select');
        rowData.push('<button type="button" data-id='+ whichtable +' class="btn-xs dt-delete dt-deletes"><i style="font-size:10px" class="fa">&#xf00d;</i></button>');
        table.row.add(rowData).draw( false );
    });
});

Upvotes: 2

Related Questions