语法错误 - 意外的标识符 -(代码的最后一行)

Question

我在 chrome 中收到此代码最后一行的意外标识符错误，有人知道为什么吗？ 谢谢（更新到页面的完整代码）它应该显示输入到数据库中的作业的数据列表。

    <?php
error_reporting(0);
include('../includes/header.php');
include('connection.php');
?>

<script src="../jqm/demos/js/jquery.js"></script>
<script type="text/javascript">
var db;
    $(document).ready(function () {
    loadJobRecords();    
    }
$(document).on("click", "#jobRecord", function () {
     getJobById($(this).data("key"));
    });
    });
function loadJobRecords() {
    db.transaction(function (txs) {
        txs.executeSql('SELECT * FROM jobs', [], function (txs, results) {
            var len = results.rows.length, i;
                 for (i = 0; i < len; i++) {
                     var JobRecord = results.rows.item(i);
                     var individualJob = '';
                     individualJob = '<li><a href="#detailinfo" id="jobRecord" data-key="' + jobRecord.ID + '" >';
                     individualJob += '<h3>' + jobRecord.Title + '</h3>';
                     individualJob += '<p>Testing</p>';
                     individualJob += '</a></li>';
                     $('#listofjobs ul').append(individualJob);
                     $('#listofjobs ul:visible').listview('refresh');
                 }
             });
         });
 }
    function getJobById(id) {
         db.transaction(function (txs) {
             txs.executeSql('SELECT * FROM jobs WHERE id="' + ID + '"', [], function (txs, results) '){
                var len = results.rows.length, i;
                 for (i = 0; i < len; i++) {
                     var jobRecord = results.rows.item(i);
                     var individualjob = '';
                     individualjob += '<h3>' + jobRecord.Title + '</h3>';
                     individualjob += '<p>' + jobRecord.Description + '</p>';
                     individualjob += '<p>' + jobRecord.Username + '</p>';
                     $('#jobSummary').html(individualJob); 
                 } 
             });
         });
     }    
</script>
    <div class="content container">
    <div daa-role="page" id="jobsdatabase">
        <section>
    <div data-role="content" id="listofjobs">               
        <ul data-role="listview" data-filter="true" data-inset="true">
         </ul>
        </section>
    </div>
    </div>
    </div>
<?php include('../includes/footer.php'); ?>

Answer 1

也许 jquery 选择器找不到匹配项？

尝试在 chrome 中转到控制台并运行：

$('#listofjobs ul:visible').length

该值是否大于 0？

Answer 2

更改为此

var db;
$(document).ready(function () {
    loadJobRecords();    

    $(document).on("click", "#jobRecord", function () {
        getJobById($(this).data("key"));
    });
});
function loadJobRecords() { ...

您在此行的末尾有一个引号 ' 和括号，就在结果之后 - 删除它们

txs.executeSql('SELECT * FROM jobs WHERE id="' + ID + '"', [], function (txs, results) '){

更改为

txs.executeSql('SELECT * FROM jobs WHERE id="' + ID + '"', [], function (txs, results){