how to pass codeigniter DB array to javascript function

Question

i have this database array in codeigniter that i want to pass it to the javascript function. is it possible?

MODEL:

public function show_employment_skills($P1)
{
    $this->db->select('*');
    $this->db->from('employee_skills');
    $this->db->where('emp_id', $P1);
    $this->db->order_by('ID', 'desc');

    $query = $this->db->get();

    if($query->num_rows() > 0)
    {
        foreach ($query->result() as $row)
        {
            $data[] = array(
                    'id' => $row->ID,
                    'emp_id' => $row->emp_id,
                    'skills' => $row->skills


                );
        }
    }
    else
    {
        $data = "";
    }
    return $data;
}

and after getting the $data (that is a DB array, right?)

here's my controller

 public function swoosh_employment_skills()
{
    $P1 = $this->session->userdata('id');

    $set['record_skills'] = $this->emp->show_employment_skills($P1);
    $this->load->view('swoosh_template/employee/employmentskills',$set);

}

the $set['record_skills'] is the array came from the database..

now here's my view:

<?php if ($record_skills != "") } ?>
<table class="table table-bordered">
<tr>
    <th>Skills</th>
<th style='width:50px;'>Alert it!</th>
</tr>
<?php foreach ($record_skills as $row): ?>
<tr>   
    <td class="skills"><?php echo $row['skills'];?></td>
    <td><img src=alert_it.png onclick="show(db array that i should put. but how?);"</td>
</tr>
</table>

here is the javascript

function show(array){
 //in here i should alert all the values of arrays. ..
}

Sudhir Bastakoti · Accepted Answer · 2013-11-01 03:13:35Z

2

you could use json_encode() for that, like:

<img src=alert_it.png onclick="show(<?php echo json_encode($your_array); ?>);" />

and in js

function show(arr){
 console.log(arr); //check the array format and loop
}

answered Nov 1, 2013 at 3:13

Sudhir Bastakoti

100k15 gold badges163 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jesús · Accepted Answer · 2013-11-01 12:02:13Z

2

Try this:

<img src=alert_it.png onclick="show('<?php echo json_encode($your_array); ?>');" />

Then you pass the string to the function in JS, and then in the JS you can decode that string as JSON:

function show(arr){
    var _json = $.parseJSON( arr );
    console.log( _json ); //check the array format and loop
}

answered Nov 1, 2013 at 12:02

Jesús

7808 silver badges16 bronze badges

Collectives™ on Stack Overflow

how to pass codeigniter DB array to javascript function

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related