如何将Javascript变量插入数据库 [英] How to insert Javascript variables into a database

问题描述

我想将变量插入到我的数据库中，有些是php，它工作正常，但问题是javascript变量，它不起作用。我很新，任何帮助都会很好。

i would like to insert variables into my database, some are php wich works fine, but the problem is the javascript variables, it does not work. im quite new to this any help would be nice.

这是我的第一个问题，对不起，如果我的代码块错误。

this is my first question, im sorry if i get the code blocks wrong.

echo '<br>
<form><input type="button" id="startbutton" value="start time control" onClick="starttime()" style="width:225px; margin-top:0px; "><br>
<script type="text/javascript">
var tekst = "";
var startdatum;
var starttijd;
var stopdatum;
var stoptijd;
var startdatumtijd;

function starttime()
{
    var d = new Date();
    var curr_date = d.getDate();
    var curr_month = d.getMonth() + 1;
    var curr_year = d.getFullYear();

    starttijd = d.getHours() + ":" + d.getMinutes();
    startdatum=(curr_year + "-" + curr_month + "-" + curr_date);
    startdatumtijd = (startdatum + " " + starttijd);

    startbutton.value = "stop timecontrol";
    startbutton.onclick = timecontrol;
}

function timecontrol()
{
    var d = new Date();
    var curr_date = d.getDate();
    var curr_month = d.getMonth() + 1;
    var curr_year = d.getFullYear();
    tekst = document.getElementById("inputtekst").value;

    stoptijd = d.getHours() + ":" + d.getMinutes();
    stopdatum=(curr_year + "-" + curr_month + "-" + curr_date); 
    var stopdatumtijd = (stopdatum + " " + stoptijd);


    tx.executeSql("INSERT INTO `vtiger_timecontrol` (`title`,`relconcept`, `relatedto`, `date_start`,`time_start`,`date_end`,`time_end`)VALUES ('.$ticketno.' , \'Support_\' , '.$ticketnummer.' , startdatum , starttijd , einddatum , eindtijd );");
    tx.executeSql("INSERT INTO `vtiger_crmentity` (`description`,`setype`,`createdtime`,`modifiedtime`,`viewedtime`)VALUES(tekst,\'Timecontrol\',stopdatumtijd,stopdatumtijd,stopdatumtijd);");

}</script></form>';

当我按下按钮时会发生什么，它会将时间保存在变量中，第二次我按下按钮会将时间保存在另一个变量中，现在我希望这些时间变量保存在我的数据库中。

What should happen is when i press a button, it saves the time in a variable, the second time i press the button it will save the time in another variable, now i want these time variables to be saved in my database.

谢谢。

推荐答案

ajax工作：

if (radio2.checked == true)
{
    var checked = 0;        
    xmlhttp = new XMLHttpRequest();

    xmlhttp.open("post","tc.php?ticketid='.$ticketnummer.'&ticketnummer='.$ticketno.'&hidden1=" + startdatum+"&hidden2=" + starttijd+"&hidden3=" + stopdatum+"&hidden4=" + stoptijd+"&hidden5=" + tekst+"&hidden6=" + stopdatumtijd + "&hidden7=" + checked, false);
    xmlhttp.send();
}
else if (radio3.checked == true)
{
    var checked = 1;
    xmlhttp = new XMLHttpRequest();

    xmlhttp.open("post","tc.php?hidden8='.$current_user.'&ticketid='.$ticketnummer.'&ticketnummer='.$ticketno.'&hidden1=" + startdatum+"&hidden2=" + starttijd+"&hidden3=" + stopdatum+"&hidden4=" + stoptijd+"&hidden5=" + tekst+"&hidden6=" + stopdatumtijd + "&hidden7=" + checked , false);
    xmlhttp.send();
}

感谢您的建议。

这篇关于如何将Javascript变量插入数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！