关于jQuery中dataTable问题,如何修改sAjaxSource添加参数

关于jQuery中dataTable问题,如何修改sAjaxSource添加参数,第1张

1.

fnfiler

插入表格数据的一个方法

查了下

有以下参数

{string}:

string

to

filter

the

table

on

插入表格的值

{int|null}:

column

to

limit

filtering

to

最大行数

{bool}

[default=false]:

treat

as

regular

expression

or

not

{bool}

[default=true]:

perform

smart

filtering

or

not

{bool}

[default=true]:

show

the

input

global

filter

in

it's

input

box(es)

{bool}

[default=true]:

do

case-insensitive

matching

(true)

or

not

(false)

2.

this.value

是对应的input的值

3.

$("tfoot

th").index($(this).parent())+1

因为序列index是从0取的,而实际行数应该需要加1.

好比

0.1.2

其实是有3个数,但显示最后是2.

需要+1

按你的代码得到的是

7

官网有例子在API,addrow那个例子里

<button id="addRow">Add new row</button>

<table id="example" class="display" cellspacing="0" width="100%">

<thead>

<tr>

<th>Column 1</th>

<th>Column 2</th>

<th>Column 3</th>

<th>Column 4</th>

<th>Column 5</th>

</tr>

</thead>

<tfoot>

<tr>

<th>Column 1</th>

<th>Column 2</th>

<th>Column 3</th>

<th>Column 4</th>

<th>Column 5</th>

</tr>

</tfoot>

</table>

//引入其他js

<script type="text/javascript" language="javascript" class="init">

$(document).ready(function() {

var t = $('#example').DataTable()

var counter = 1

$('#addRow').on( 'click', function () {

t.row.add( [

counter +'.1',

'<input type="button" value="button"/>',

'<a href="xxx">超链接</a>',

counter +'.4',

counter +'.5'

] ).draw()

counter++

} )

// Automatically add a first row of data

$('#addRow').click()

} )

</script>

add里面的分号内容 随便你插入什么格式的东西只要标签对就可以。

JS:

$(document).ready(function() {

    $('#example').DataTable( {

        initComplete: function () {

            var api = this.api()

            api.columns().indexes().flatten().each( function ( i ) {

                var column = api.column( i )

                var select = $('<select><option value=""></option></select>')

                    .appendTo( $(column.footer()).empty() )

                    .on( 'change', function () {

                        var val = $.fn.dataTable.util.escapeRegex(

                            $(this).val()

                        )

                        column

                            .search( val ? '^'+val+'$' : '', true, false )

                            .draw()

                    } )

                column.data().unique().sort().each( function ( d, j ) {

                    select.append( '<option value="'+d+'">'+d+'</option>' )

                } )

            } )

        }

    } )

} )

html:

<table id="example" class="display" cellspacing="0" width="100%">

        <thead>

            <tr>

                <th>Name</th>

                <th>Position</th>

                <th>Office</th>

                <th>Age</th>

                <th>Start date</th>

                <th>Salary</th>

            </tr>

        </thead>

 

        <tfoot>

            <tr>

                <th>Name</th>

                <th>Position</th>

                <th>Office</th>

                <th>Age</th>

                <th>Start date</th>

                <th>Salary</th>

            </tr>

        </tfoot>

 

        <tbody>

            <tr>

                <td>Tiger Nixon</td>

                <td>System Architect</td>

                <td>Edinburgh</td>

                <td>61</td>

                <td>2011/04/25</td>

                <td>$320,800</td>

            </tr>

            <tr>

                <td>Garrett Winters</td>

                <td>Accountant</td>

                <td>Tokyo</td>

                <td>63</td>

                <td>2011/07/25</td>

                <td>$170,750</td>

            </tr>

            <tr>

                <td>Ashton Cox</td>

                <td>Junior Technical Author</td>

                <td>San Francisco</td>

                <td>66</td>

                <td>2009/01/12</td>

                <td>$86,000</td>

            </tr>

            <tr>

                <td>Cedric Kelly</td>

                <td>Senior Javascript Developer</td>

                <td>Edinburgh</td>

                <td>22</td>

                <td>2012/03/29</td>

                <td>$433,060</td>

            </tr>

            <tr>

                <td>Airi Satou</td>

                <td>Accountant</td>

                <td>Tokyo</td>

                <td>33</td>

                <td>2008/11/28</td>

                <td>$162,700</td>

            </tr>

            <tr>

                <td>Brielle Williamson</td>

                <td>Integration Specialist</td>

                <td>New York</td>

                <td>61</td>

                <td>2012/12/02</td>

                <td>$372,000</td>

            </tr>

            <tr>

                <td>Herrod Chandler</td>

                <td>Sales Assistant</td>

                <td>San Francisco</td>

                <td>59</td>

                <td>2012/08/06</td>

                <td>$137,500</td>

            </tr>

            <tr>

                <td>Rhona Davidson</td>

                <td>Integration Specialist</td>

                <td>Tokyo</td>

                <td>55</td>

                <td>2010/10/14</td>

                <td>$327,900</td>

            </tr>

            <tr>

                <td>Colleen Hurst</td>

                <td>Javascript Developer</td>

                <td>San Francisco</td>

                <td>39</td>

                <td>2009/09/15</td>

                <td>$205,500</td>

            </tr>

            <tr>

                <td>Sonya Frost</td>

                <td>Software Engineer</td>

                <td>Edinburgh</td>

                <td>23</td>

                <td>2008/12/13</td>

                <td>$103,600</td>

            </tr>

            <tr>

                <td>Jena Gaines</td>

                <td>Office Manager</td>

                <td>London</td>

                <td>30</td>

                <td>2008/12/19</td>

                <td>$90,560</td>

            </tr>

            <tr>

                <td>Quinn Flynn</td>

                <td>Support Lead</td>

                <td>Edinburgh</td>

                <td>22</td>

                <td>2013/03/03</td>

                <td>$342,000</td>

            </tr>

            <tr>

                <td>Charde Marshall</td>

                <td>Regional Director</td>

                <td>San Francisco</td>

                <td>36</td>

                <td>2008/10/16</td>

                <td>$470,600</td>

            </tr>

            <tr>

                <td>Haley Kennedy</td>

                <td>Senior Marketing Designer</td>

                <td>London</td>

                <td>43</td>

                <td>2012/12/18</td>

                <td>$313,500</td>

            </tr>

            <tr>

                <td>Tatyana Fitzpatrick</td>

                <td>Regional Director</td>

                <td>London</td>

                <td>19</td>

                <td>2010/03/17</td>

                <td>$385,750</td>

            </tr>

            <tr>

                <td>Michael Silva</td>

                <td>Marketing Designer</td>

                <td>London</td>

                <td>66</td>

                <td>2012/11/27</td>

                <td>$198,500</td>

            </tr>

            <tr>

                <td>Paul Byrd</td>

                <td>Chief Financial Officer (CFO)</td>

                <td>New York</td>

                <td>64</td>

                <td>2010/06/09</td>

                <td>$725,000</td>

            </tr>

            <tr>

                <td>Gloria Little</td>

                <td>Systems Administrator</td>

                <td>New York</td>

                <td>59</td>

                <td>2009/04/10</td>

                <td>$237,500</td>

            </tr>

            <tr>

                <td>Bradley Greer</td>

                <td>Software Engineer</td>

                <td>London</td>

                <td>41</td>

                <td>2012/10/13</td>

                <td>$132,000</td>

            </tr>

            <tr>

                <td>Dai Rios</td>

                <td>Personnel Lead</td>

                <td>Edinburgh</td>

                <td>35</td>

                <td>2012/09/26</td>

                <td>$217,500</td>

            </tr>

            <tr>

                <td>Jenette Caldwell</td>

                <td>Development Lead</td>

                <td>New York</td>

                <td>30</td>

                <td>2011/09/03</td>

                <td>$345,000</td>

            </tr>

            <tr>

                <td>Yuri Berry</td>

                <td>Chief Marketing Officer (CMO)</td>

                <td>New York</td>

                <td>40</td>

                <td>2009/06/25</td>

                <td>$675,000</td>

            </tr>

        </tbody>

    </table>

datatables的中文网也可以找到demo


欢迎分享,转载请注明来源:内存溢出

原文地址:https://www.54852.com/bake/11278179.html

(0)
打赏 微信扫一扫微信扫一扫 支付宝扫一扫支付宝扫一扫
上一篇 2023-05-14
下一篇2023-05-14

发表评论

登录后才能评论

评论列表(0条)

    保存