将Javascript和HTML表单条目添加到数据库

How can I add this javascript/html form to the database? I know only how to connect html/php with SQL...

如何将此javascript / html表单添加到数据库?我只知道如何连接html / php和SQL ...

here is the code that will allow the user to pick up the dates but its connected with javascript .. I need a way to save it into the database ..

这里的代码将允许用户选择日期,但它与javascript连接..我需要一种方法将其保存到数据库中..

HTML

<div id="hourForm">
    <div id="Sunday" class="day"></div>
    <div id="Monday" class="day"></div>
    <div id="Tuesday" class="day"></div>
    <div id="Wednesday" class="day"></div>
    <div id="Thursday" class="day"></div>
    <div id="Friday" class="day"></div>
    <div id="Saturday" class="day"></div>
</div>

javascript

$('.day').each(function() {
    var day = $(this).attr('id');
    $(this).append('<div id="label">' + day + ': </div>');
    $(this).append('<select name="' + day + 'FromH" class="hour from"></select>');
    $(this).append('<select name="' + day + 'FromM" class="min from"></select>');
    $(this).append('<select name="' + day + 'FromAP" class="ampm from"></select>');
    $(this).append(' to <select name="' + day + 'ToH" class="hour to"></select>');
    $(this).append('<select name="' + day + 'ToM" class="min to"></select>');
    $(this).append('<select name="' + day + 'ToAP" class="ampm to"></select>');
    $(this).append(' <input type="checkbox" name="closed" value="closed" class="closed"><span>Closed</span>');

});

$('.hour').each(function() {
    for (var h = 1; h < 13; h++) {
        $(this).append('<option value="' + h + '">' + h + '</option>');
    }

    $(this).filter('.from').val('9');
    $(this).filter('.to').val('5');
});

$('.min').each(function() {
    var min = [':00', ':15', ':30', ':45'];
    for (var m = 0; m < min.length; m++) {
        $(this).append('<option value="' + min[m] + '">' + min[m] + '</option>');
    }

    $(this).val(':00');
});

$('.ampm').each(function() {
    $(this).append('<option value="AM">AM</option>');
    $(this).append('<option value="PM">PM</option>');

    $(this).filter('.from').val('AM');
    $(this).filter('.to').val('PM');
});

$('input').change( function() { 
    if($(this).filter(':checked').val() == "closed") {
        $(this).siblings('select').attr('disabled', true);
    } else {
        $(this).siblings('select').attr('disabled', false);
    }
});

$('#Saturday .closed, #Sunday .closed').val(["closed"]).siblings('select').attr('disabled', true);

please give me a hint or a tutorial if you can't help..

如果你不能帮忙,请给我一个提示或教程..

1 个解决方案

#1

You'll need to learn how to use AJAX, this will allow you to send and receive data from the database, usually you'll have some PHP which will display JSON and your AJAX will request this from the PHP page.

你需要学习如何使用AJAX,这将允许你从数据库发送和接收数据,通常你会有一些PHP显示JSON,你的AJAX将从PHP页面请求。

http://www.formget.com/submit-form-using-ajax-php-and-jquery/

Your AJAX will look something like this:

你的AJAX看起来像这样:

$.ajax({
    method: "GET",
    url: "test.php",
    data: { param1 : "Bob", param2 : "Larry" },
    dataType: "script"
});

This will call your PHP file "test" and pass in parameters param1 and param2

这将调用您的PHP文件“test”并传入参数param1和param2

#1