在php文件中访问jquery

I've recently implemented a jquery script to convert a html table into a excel file. I've written this script inside a php file, but when i try to get the code working the only thing i get is a reference error in firefox:

ReferenceError: $datatype is not defined

I think the php interpreter doesn't ignore $datatype as jquery but try to use it as a php variable. Is there any kind of solution to get jquery code function inside a php file? Thanks for any suggestion

<?php 
        session_start();
        $_SESSION['locazione']= $_GET['locazione'];
        //echo  $_SESSION['locazione'];
        ?>
<html>
    <head>
                <meta http-equiv="content-type" content="text/plain; charset=UTF-8"/>
                <script src="./js/jquery.btechco.excelexport.js"></script>
                <script src="./js/jquery.base64.js"></script>
                <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.0/jquery.min.js" type="text/javascript"></script>
                <link href="./css/style2.css" rel="stylesheet" type="text/css">
                <?php $Locazione = $_GET['locazione']; ?>

                <script type="text/javascript">
                $(document).ready(function () {
                    $("#btnExport").click(function () {
                        $("#tblExport").btechco_excelexport({
                            containerid: "tblExport",
                            datatype: $datatype.Table
                        });
                    });
                });
                </script>
        <!-- [...] -->
    </head>
        <body>      

        <INPUT type="button" value="Aggiungi Elemento" onClick="addRow('dataTable')" />
        <INPUT type="button" value="Elimina Elemento" onClick="deleteRow('dataTable')" />
        <form action="form.php" method="post" name="f" style="position: relative;">  
        <TABLE id="tblExport" border="0"style="width:100%;min-height:50px;top:10px">
        <thead>
        <tr>
            <th width="35"></th>
            <th width="54" align="left">TipoLocale</th>
            <th width="54" align="left">NomeLocale</th>
            <th width="54" align="left">NumeroLocale</th>
            <th width="54" align="left">TipoCarico</th>
            <th width="54">N°</th>
            <th width="54" align="left">Potenza</th>
            <th width="54" align="left">PotenzaTotale</th>
            <th width="54">Note</th>
        </tr>
        </thead>
        <tbody id="dataTable">
        </tbody>
        </TABLE>
        <div id="sendbtn">
        <INPUT type="submit" value="Invia" name="submit" target="_new"  onclick="return confirm('Confermi l\'inserimento?')"/>
            <input type="button" id="btnExport" value=" Export Table data into Excel " />       
        </div>
        </form>             
        </body>
        </html>

this is the jquery.btechco.excelexport.js:

(function ($) {

   var $datatype = {
        Table: 1
        , Json: 2
        , Xml: 3
        , JqGrid: 4
    }

var $defaults = {
    containerid: null
    , datatype: $datatype.Table
    , dataset: null
    , columns: null
};

var $settings = $defaults;

$.fn.btechco_excelexport = function (options) {
    $settings = $.extend({}, $defaults, options);

    switch ($settings.datatype) {
        case 1:
            Export($("#" + $settings.containerid).parent().html());
            break;
        case 2:
            Export(ConvertJsonToTable());
            break;
        case 3:
            Export(ConvertXmlToTable());
            break;
        case 4:
            Export(ConvertJqGridDataToTable());
            break;
    }

    function ConvertJsonToTable() {
        var result = "<table>";

        result += "<thead><tr>";
        $($settings.columns).each(function (key, value) {
            if (this.ishidden != true) {
                result += "<th";
                if (this.width != null) {
                    result += " style='width: " + this.width + "'";
                }
                result += ">";
                result += this.headertext;
                result += "</th>";
            }
        });
        result += "</tr></thead>";

        result += "<tbody>";
        $($settings.dataset).each(function (key, value) {
            result += "<tr>";
            $($settings.columns).each(function (k, v) {
                if (value.hasOwnProperty(this.datafield)) {
                    if (this.ishidden != true) {
                        result += "<td";
                        if (this.width != null) {
                            result += " style='width: " + this.width + "'";
                        }
                        result += ">";
                        result += value[this.datafield];
                        result += "</td>";
                    }
                }
            });
            result += "</tr>";
        });
        result += "</tbody>";

        result += "</table>";
        return result;
    }

    function ConvertXmlToTable() {
        var result = "<table>";

        result += "<thead><tr>";
        $($settings.columns).each(function (key, value) {
            if (this.ishidden != true) {
                result += "<th";
                if (this.width != null) {
                    result += " style='width: " + this.width + "'";
                }
                result += ">";
                result += this.headertext;
                result += "</th>";
            }
        });
        result += "</tr></thead>";

        result += "<tbody>";
        $($settings.dataset).find("row").each(function (key, value) {
            result += "<tr>";
            $($settings.columns).each(function (k, v) {
                if ($(value).attr(this.datafield)) {
                    if (this.ishidden != true) {
                        result += "<td";
                        if (this.width != null) {
                            result += " style='width: " + this.width + "'";
                        }
                        result += ">";
                        result += $(value).attr(this.datafield);
                        result += "</td>";
                    }
                }
            });
            result += "</tr>";
        });
        result += "</tbody>";

        result += "</table>";
        return result;
    }

    function ConvertJqGridDataToTable() {
        var result = "<table>";

        result += "<thead><tr>";
        $($settings.columns).each(function (key, value) {
            if (this.ishidden != true) {
                result += "<th";
                if (this.width != null) {
                    result += " style='width: " + this.width + "'";
                }
                result += ">";
                result += this.headertext;
                result += "</th>";
            }
        });
        result += "</tr></thead>";
        result += "<tbody>";

        $($settings.dataset).find("rows > row").each(function (key, value) {
            result += "<tr>";
            $($settings.columns).each(function (k, v) {
                if ($(value).find(this.datafield)) {
                    if (this.ishidden != true) {
                        result += "<td";
                        if (this.width != null) {
                            result += " style='width: " + this.width + "'";
                        }
                        result += ">";
                        result += $(value).find(this.datafield).text();
                        result += "</td>";
                    }
                }
            });
            result += "</tr>";
        });
        result += "</tbody>";

        result += "</table>";
        return result;
    }

    function Export(htmltable) {
        var excelFile = "<html xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:x='urn:schemas-microsoft-com:office:excel' xmlns='http://www.w3.org/TR/REC-html40'>";
        excelFile += "<head>";
        excelFile += "<!--[if gte mso 9]>";
        excelFile += "<xml>";
        excelFile += "<x:ExcelWorkbook>";
        excelFile += "<x:ExcelWorksheets>";
        excelFile += "<x:ExcelWorksheet>";
        excelFile += "<x:Name>";
        excelFile += "{worksheet}";
        excelFile += "</x:Name>";
        excelFile += "<x:WorksheetOptions>";
        excelFile += "<x:DisplayGridlines/>";
        excelFile += "</x:WorksheetOptions>";
        excelFile += "</x:ExcelWorksheet>";
        excelFile += "</x:ExcelWorksheets>";
        excelFile += "</x:ExcelWorkbook>";
        excelFile += "</xml>";
        excelFile += "<![endif]-->";
        excelFile += "</head>";
        excelFile += "<body>";
        excelFile += htmltable.replace(/"/g, '\'');
        excelFile += "</body>";
        excelFile += "</html>";

        var base64data = "base64," + $.base64.encode(excelFile);
        window.open('data:application/vnd.ms-excel;filename=test;' + base64data);
    }
};
})(jQuery);

(function ($) {

   var $datatype = {
        Table: 1
        , Json: 2
        , Xml: 3
        , JqGrid: 4
    }

var $defaults = {
    containerid: null
    , datatype: $datatype.Table
    , dataset: null
    , columns: null
};

var $settings = $defaults;

$.fn.btechco_excelexport = function (options) {
    $settings = $.extend({}, $defaults, options);

    switch ($settings.datatype) {
        case 1:
            Export($("#" + $settings.containerid).parent().html());
            break;
        case 2:
            Export(ConvertJsonToTable());
            break;
        case 3:
            Export(ConvertXmlToTable());
            break;
        case 4:
            Export(ConvertJqGridDataToTable());
            break;
    }

    function ConvertJsonToTable() {
        var result = "<table>";

        result += "<thead><tr>";
        $($settings.columns).each(function (key, value) {
            if (this.ishidden != true) {
                result += "<th";
                if (this.width != null) {
                    result += " style='width: " + this.width + "'";
                }
                result += ">";
                result += this.headertext;
                result += "</th>";
            }
        });
        result += "</tr></thead>";

        result += "<tbody>";
        $($settings.dataset).each(function (key, value) {
            result += "<tr>";
            $($settings.columns).each(function (k, v) {
                if (value.hasOwnProperty(this.datafield)) {
                    if (this.ishidden != true) {
                        result += "<td";
                        if (this.width != null) {
                            result += " style='width: " + this.width + "'";
                        }
                        result += ">";
                        result += value[this.datafield];
                        result += "</td>";
                    }
                }
            });
            result += "</tr>";
        });
        result += "</tbody>";

        result += "</table>";
        return result;
    }

    function ConvertXmlToTable() {
        var result = "<table>";

        result += "<thead><tr>";
        $($settings.columns).each(function (key, value) {
            if (this.ishidden != true) {
                result += "<th";
                if (this.width != null) {
                    result += " style='width: " + this.width + "'";
                }
                result += ">";
                result += this.headertext;
                result += "</th>";
            }
        });
        result += "</tr></thead>";

        result += "<tbody>";
        $($settings.dataset).find("row").each(function (key, value) {
            result += "<tr>";
            $($settings.columns).each(function (k, v) {
                if ($(value).attr(this.datafield)) {
                    if (this.ishidden != true) {
                        result += "<td";
                        if (this.width != null) {
                            result += " style='width: " + this.width + "'";
                        }
                        result += ">";
                        result += $(value).attr(this.datafield);
                        result += "</td>";
                    }
                }
            });
            result += "</tr>";
        });
        result += "</tbody>";

        result += "</table>";
        return result;
    }

    function ConvertJqGridDataToTable() {
        var result = "<table>";

        result += "<thead><tr>";
        $($settings.columns).each(function (key, value) {
            if (this.ishidden != true) {
                result += "<th";
                if (this.width != null) {
                    result += " style='width: " + this.width + "'";
                }
                result += ">";
                result += this.headertext;
                result += "</th>";
            }
        });
        result += "</tr></thead>";
        result += "<tbody>";

        $($settings.dataset).find("rows > row").each(function (key, value) {
            result += "<tr>";
            $($settings.columns).each(function (k, v) {
                if ($(value).find(this.datafield)) {
                    if (this.ishidden != true) {
                        result += "<td";
                        if (this.width != null) {
                            result += " style='width: " + this.width + "'";
                        }
                        result += ">";
                        result += $(value).find(this.datafield).text();
                        result += "</td>";
                    }
                }
            });
            result += "</tr>";
        });
        result += "</tbody>";

        result += "</table>";
        return result;
    }

    function Export(htmltable) {
        var excelFile = "<html xmlns:o='urn:schemas-microsoft-com:office:office' xmlns:x='urn:schemas-microsoft-com:office:excel' xmlns='http://www.w3.org/TR/REC-html40'>";
        excelFile += "<head>";
        excelFile += "<!--[if gte mso 9]>";
        excelFile += "<xml>";
        excelFile += "<x:ExcelWorkbook>";
        excelFile += "<x:ExcelWorksheets>";
        excelFile += "<x:ExcelWorksheet>";
        excelFile += "<x:Name>";
        excelFile += "{worksheet}";
        excelFile += "</x:Name>";
        excelFile += "<x:WorksheetOptions>";
        excelFile += "<x:DisplayGridlines/>";
        excelFile += "</x:WorksheetOptions>";
        excelFile += "</x:ExcelWorksheet>";
        excelFile += "</x:ExcelWorksheets>";
        excelFile += "</x:ExcelWorkbook>";
        excelFile += "</xml>";
        excelFile += "<![endif]-->";
        excelFile += "</head>";
        excelFile += "<body>";
        excelFile += htmltable.replace(/"/g, '\'');
        excelFile += "</body>";
        excelFile += "</html>";

        var base64data = "base64," + $.base64.encode(excelFile);
        window.open('data:application/vnd.ms-excel;filename=test;' + base64data);
    }
};
})(jQuery);

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

2条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
douzong0711 2014-05-23 08:59
关注
(function ($) { var $datatype = { Table: 1 , Json: 2 , Xml: 3 , JqGrid: 4 }

In your library( jquery.battatech.excelexport.js), add var before the $datatype
解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

报告相同问题？

关注问题

Jquery选择包含在php文件中的div元素？ html javascript jquery php
2018-08-07 18:08

回答 3 已采纳 There is some points in your code thats better to know . Your html structure is wrong! simple h
在WordPress函数文件中添加jQuery php
2017-07-17 13:15

回答 1 已采纳 Basically, what the snippet is doing is changing the already registered and enqueued jquery with t
mouseover在jQuery中触发失效 html5 javascript jquery
2022-06-21 19:10

回答 4 已采纳 <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" />
【前端入门】jQuery
2022-02-27 20:10

新手且笨蛋37的博客当然懒一点的话也可以用cdn，cdn就理解为有些大公司给你加速访问的一些在网上不用下载的jQuery。提供一个cdn库：cdn库引入一个官网的cdn做个示范（注释掉的是引入下载的jQuery文件）：二、语法 jquery的万能公式...
无法使用jquery加载php文件并在文件外部访问变量 jquery php
2015-06-14 11:04

回答 1 已采纳 Why you are using jquery for that purpose. PHP include_once() will do that easily. In Home.php d
jQuery时间排序、前端时间排序 jquery json 前端
2016-12-27 15:14

回答 2 已采纳 ``` var rows = [ { "title": "第一条title", "time": "2008/08/27 05:30:45", "data": "这是数据"
使用JQuery从不同的php文件中获取数据 javascript jquery php
2016-10-04 16:02

回答 1 已采纳 It should be like this. If you want to take your returner data you should use formal parameter of
前端页面校验（使用Jquery-validate.js文件的校验）
2018-12-04 20:21

宇穹的博客在前端页面如果不想自己手写各种校验，那就可以使用jquery-validate.js文件的校验；具体的使用步骤：（基本上就四个大步骤）首先，导入这个jquery-validate.js文件和jquery-min.js文件（后面这个文件不一定非...
关于jQuery中attr方法无效的问题 javascript jquery 前端
2022-11-08 01:52

回答 8 已采纳 $("div").attr 这个值针对标签的属性才能用如果你要用这个那就得是这样了 $("div").attr("style","left:100px;top:100px;") 但是这样做会有一个
如何在php文件中使用jquery？ javascript jquery php
2009-10-19 16:45

回答 2 已采纳 Place this somewhere in the HTML Header area of your PHP file: echo '<script type="text/javasc
php中使用jquery uploadify 无法上传视频文件问题 jquery php
2015-06-03 11:39

回答 5 已采纳我刚发表了一篇此类文章。你是用的集成软件还是自己搭的环境？我是nginx服务器上修改的php.ini除了重启服务器之外还要重启fastcig进程管理器php-fpm
jquery.tools.min.js 最新的1.2.7版本
2022-04-26 10:33

jquery.min.js版本一般用于网站引用使用，减小文件体积，降低网站流量，提升访问速度等。而jquery.js是完整的未压缩的jQuery库，带有注释和空格，方便阅读源码，文件比较大；一般用于阅读学习源码或修改源码，一般...
在前端jquery中，一个判断里flag = false;是什么意思呢 html5 jquery
2022-04-29 14:21

回答 5 已采纳这个就是一个全局的标识变量，设置false，就表示不成立，这里就是标识这个字段没有填写数据，应该就是不可以提交，设置true，就表示这个字段填写了数据，可以提交
2021/10/27 前端开发之JavaScript+jQuery入门第十章jQuery基础
2021-10-27 11:42

Abcdzzr的博客 4、在html页面中如何使用jQuery？ 5、在内编写jquery脚本 6、jQuery的语法结构 7、JQuery对象和DOM对象之间的关系，他们之间如何去转换？ 8、JQuery选择器 7.1基础选择器 7.2层次选择器 7.3过滤选择器 ...
14-前端主流框架JQuery基本操作
2022-03-15 10:18

想踢球考研的java的博客什么是JQuery？ jQuery 是一个 JavaScript 库。jQuery 极大地简化了 JavaScript 编程。 jQuery 是一个集 JavaScript、CSS、DOM、AJAX 于一体的强大框架体系。它是众多 JavaScript 类库中的一种。 jQuery 是继 ...
没有解决我的问题, 去提问

悬赏问题

¥15 maixpy训练模型，模型训练好了以后，开发板通电会报错，不知道是什么问题
¥30 截图中的mathematics程序转换成matlab
¥15 动力学代码报错，维度不匹配
¥15 Power query添加列问题
¥50 Kubernetes&Fission&Eleasticsearch
¥15 有没有帮写代码做实验仿真的
¥15 報錯：Person is not mapped，如何解決？
¥30 vmware exsi重置后登不上
¥15 c++头文件不能识别CDialog
¥15 Excel发现不可读取的内容

在php文件中访问jquery

2条回答 默认 最新

悬赏问题

2条回答默认最新