How to pass an array to a jquery script from a codeigniter view

Question

I am using the jquery datatables plugin and codeigniter. In one of my views I have:

 <table id="myDataTable" class="display" cellspacing="0" width="100%">
    <thead>
        <tr>

            <?php foreach($keys as $key): ?>
            <th><?php echo $key; ?></th>
            <?php endforeach; ?>


        </tr>

      </thead>      
            <tbody>

        </tbody>
    </table>


<script type="text/javascript">
$(document).ready(function () {
    var oTable = $('#big_table').dataTable({
        "bProcessing": true,
        "bServerSide": true,
        "sAjaxSource": 'datatable_controller/datatable',
        "sPaginationType": "full_numbers",
          "columns": [
                    { "data": "id" },
                    { "data": "message_id" },
                    { "data": "subject" },
                    { "data": "date" }
                  ],

in reference to the columns structure, right now I am hard coding in column field names (id, message-id,subject , date ) . I already have these in an array $keys, which I am using above to dynamically generate the table HTML. Is there a way to pass $keys directly into the "columns" option?

Any reason not to use json data?

Kisaragi
– Kisaragi

2014-08-08 20:46:07 +00:00
Commented Aug 8, 2014 at 20:46 — Kisaragi
– Kisaragi, Commented Aug 8, 2014 at 20:46

Chris Barcroft · Accepted Answer · 2014-08-08 20:58:08Z

1

It looks like you could use the PHP loop inside the "columns" option in your javascript, if I'm following the format correctly. Something like this (untested obviously)?

      "columns": [
               <?php foreach($keys as $key): ?>
                 {"data": "<?php echo $key ?>"},
               <?php endforeach; ?>
              ],

answered Aug 8, 2014 at 20:58

Chris Barcroft

5921 gold badge6 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

How to pass an array to a jquery script from a codeigniter view

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related