将数据提交到单个变量中

发布于 2024-12-23 18:28:28 字数 1064 浏览 1 评论 0原文

我将表单中的一些值传递到函数中，以便为数据库插入做好准备。该功能理论上工作正常。然而，它错过了一个独特的价值，这给我带来了麻烦。我正在尝试根据提交到数据库的数据生成唯一 ID。我想像这样生成ID：

var mystringId = prodID+'{'+selectId+'}'+selectedOptionValue;

应输出例如：20{100}3{200}6。在我的示例中，它会生成以下内容：

20{100}3

20{200}6，

因为 each();

$("#submitme").live('click', function() {
//var mystringId = prodID;
    $('select').each(function() {
        var addedOn = new Date();
        var selectName= $(this).attr("name");        
        var selectId= $(this).attr("id");
        var selectedOption = $(this).find('option:selected');
        var selectedOptionValue = selectedOption.val();
        var selectedOptionText = selectedOption.text();

        var mystringId = prodID+'{'+selectId+'}'+selectedOptionValue;

        db.transaction(function(tx) {
        tx.executeSql('INSERT INTO xxxxx mystringId');

        });

    });
    $.mobile.changePage( "#cart", { transition: "slideup"} );
    });

原文

I am passing some values out of a form into a function so it is ready for database insertion.
The function theoretically works fine. However, it misses a unique value that puts me in trouble afterward.
I'm trying to generate a unique ID based on the data that is submitted to the database.
I want to generate the ID like this:

var mystringId = prodID+'{'+selectId+'}'+selectedOptionValue;

Should output for example: 20{100}3{200}6.
In my sample it generates above the following:

20{100}3

20{200}6

because of the each();

$("#submitme").live('click', function() {
//var mystringId = prodID;
    $('select').each(function() {
        var addedOn = new Date();
        var selectName= $(this).attr("name");        
        var selectId= $(this).attr("id");
        var selectedOption = $(this).find('option:selected');
        var selectedOptionValue = selectedOption.val();
        var selectedOptionText = selectedOption.text();

        var mystringId = prodID+'{'+selectId+'}'+selectedOptionValue;

        db.transaction(function(tx) {
        tx.executeSql('INSERT INTO xxxxx mystringId');

        });

    });
    $.mobile.changePage( "#cart", { transition: "slideup"} );
    });

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

伊面 2024-12-30 18:28:28

根据我从您的问题中收集到的信息，您可以简单地在当前代码之前执行每个循环，以您希望在代码中使用的格式生成 mystringId 。

代码

$("#submitme").live('click', function() {
    var mystringId = prodID;

    $('select').each(function() {
        var selectId= $(this).attr("id");
        var selectedOption = $(this).find('option:selected');
        var selectedOptionValue = selectedOption.val();

        mystringId += '{' + selectId + '}' + selectedOptionValue;
    });

    $('select').each(function() {
        var addedOn = new Date();
        var selectName= $(this).attr("name");
        var selectId= $(this).attr("id");
        var selectedOption = $(this).find('option:selected');
        var selectedOptionValue = selectedOption.val();
        var selectedOptionText = selectedOption.text();

        db.transaction(function(tx) {
            tx.executeSql('INSERT INTO xxxxx mystringId');
        });
    });

    $.mobile.changePage( "#cart", { transition: "slideup"} );
});

结果

结果将为 mystringId，以 prodID 的值开始 mystringId = 20

循环的第一次迭代将附加 { 100}3 导致 mystringId = 20{100}3

循环的第二次迭代将附加 {200}6 导致 mystringId = 20{100}3{100}6

From what I can gather from your question, you can simply do a each loop before your current code to generate the mystringId in the format your looking for to use inside your code.

Code

$("#submitme").live('click', function() {
    var mystringId = prodID;

    $('select').each(function() {
        var selectId= $(this).attr("id");
        var selectedOption = $(this).find('option:selected');
        var selectedOptionValue = selectedOption.val();

        mystringId += '{' + selectId + '}' + selectedOptionValue;
    });

    $('select').each(function() {
        var addedOn = new Date();
        var selectName= $(this).attr("name");
        var selectId= $(this).attr("id");
        var selectedOption = $(this).find('option:selected');
        var selectedOptionValue = selectedOption.val();
        var selectedOptionText = selectedOption.text();

        db.transaction(function(tx) {
            tx.executeSql('INSERT INTO xxxxx mystringId');
        });
    });

    $.mobile.changePage( "#cart", { transition: "slideup"} );
});

Results

The results would be mystringId starting off with the value of prodID mystringId = 20

The first iteration of the loop would append {100}3 resulting in mystringId = 20{100}3

The second iteration of the loop would append {200}6 resulting in mystringId = 20{100}3{100}6

回复收藏 0 原文

~没有更多了~