doubi1713 2015-11-21 12:18
浏览 61
已采纳

JS,PHP,MySQL用于数学运算的代码错误

I wrote a small script. I have a form in my page. It takes data from MySQL Database. After that, When user select some options from select panels, I need JS will do math summation and write total in a div/input field. I wrote the page and got errors. I changed a lot of things after searched similar problems on net and here.

I used parseInt($.. ,10) , document.getElementById("testID").innerHTML , document.getElementById("testID").value , document.getElementById("testID").val() and etc...

So, I'm asking your help to correct my errors. Thanks

Here is the Jsfiddle page link;

jsfiddle page

My Code (this is the latest version that I have) ;

JS:

<script type="text/javascript">
function updatesum() {
    var T = 0;
    var d = document;
    var A = d.getElementById("araclar").val();
    var M = d.getElementById("varis").val();
    var K = d.getElementById("kisiler").val();
    var B = d.getElementById("bavullar").val();
    var C = d.getElementById("cocuklar").val();
    var Ck = d.getElementById("cocukKoltuk").val();
    T = parseInt('A' ,10) * parseInt('M' ,10);
    document.getElementById("toplamm").innerHTML = T;       
      }
</script>

PHP:

<form action="subscribe.php" id="subscribe" method="post" name="subscribe">
                                            <div class="row">
                                                <div class="col-xs-12 col-sm-10">

                                                    <div class="row">

                                                         <div class="col-xs-12 col-sm-6 col-md-3">
                                                            <label>NAME<input class="form-control" name="name" placeholder="NAME" type="text"></label>
                                                        </div>
                                                         <div class="col-xs-12 col-sm-6 col-md-3">
                                                            <label>SURNAME<input class="form-control" name="surname" placeholder="SURNAME" type="text"></label>
                                                        </div>
                                                         <div class="col-xs-12 col-sm-6 col-md-3">
                                                            <label>TELEPHONE<input class="form-control" name="date" placeholder="TELEPHONE" type="tel"></label>
                                                        </div>
                                                         <div class="col-xs-12 col-sm-6 col-md-3">
                                                            <label>EMAIL<input class="form-control" name="email" placeholder="EMAIL" type="email"></label>
                                                        </div>
<hr />
                                                    </div>

                                                    <div class="row">
                                                        <div class="col-xs-12 col-sm-6 col-md-3">
                                                           <label>FROM:<select class="form-control" name="kalkis" id="kalkis" onchange="bolegler(this.value);sifirla();">
    <option value="">Please Select</option>
    <?php
$boleg= mysql_query("SELECT * FROM areas WHERE ust LIKE 0"); 
while($bolges = mysql_fetch_array($boleg)) {
    echo '<option value="'.$bolges['id'].'">'.$bolges['isim'].'</option>';
}
    ?>
</select></label>
                                                        </div>
                                                        <div class="col-xs-12 col-sm-6 col-md-3" id="txtHint">
                                                            <!-- This Code will change after #kalkis change by JS  start-->
                                                           <label>TO:<select name="varis" class="form-control">
                                                        <option value="">Please Select</option>
                                                    </select></label>
                                                    <!-- This Code will change after #kalkis change by JS  end-->
                                                        </div>
                                                         <div id="datetimepicker" class="col-xs-12 col-sm-6 col-md-3 input-append date">
                                                            <label>REZERVATION DATE


      <input type="text" class="col-xs-8 form-control" name="rezervasyon" style="float:left;"></input>
      <span class="add-on col-xs-2" style="float: left; margin: -39px 0; font-size: 23px;"><i class="fa fa-calendar"></i>
      </span>

                                                            </label>
                                                        </div>

                                                        <div class="col-xs-12 col-sm-6 col-md-3">
                                                            <label>CAR:
                                                                <select name="car" id="car" class="form-control" onchange="updatesum();">
                                                                    <option value="0">Please Select</option>
    <?php
$ara= mysql_query("SELECT * FROM cars"); 
while($arac = mysql_fetch_array($ara)) {
    echo '<option value="'.$arac['price'].'" class="'.$arac['id'].'">'.$arac['isim'].'</option>';
}
    ?>

    </select>
                                                            </label>
                                                        </div>

                                                    </div>

                                                    <div class="row">
                                                        <div class="col-xs-12 col-sm-6 col-md-3">
                                                            <label>PERSON QTY
                                                                <select name="persons" id="persons" class="form-control" onchange="updatesum();">
                                                                <option value="0">Please Select</option>
    <?php
$kis= mysql_query("SELECT * FROM person"); 
while($person = mysql_fetch_array($kis)) {
    echo '<option value="'.$person['price'].'" class="'.$person['qty'].'">'.$person['qty'].'</option>';
}
    ?>
    </select>
                                                            </label>
                                                        </div>
                                                        <div class="col-xs-12 col-sm-6 col-md-3">
                                                            <label>bag QTY
                                                               <select name="bags" id="bags" class="form-control" onchange="updatesum();">
                                                                <option value="0">Please Select</option>
    <?php
$bav= mysql_query("SELECT * FROM bag"); 
while($bag = mysql_fetch_array($bav)) {
    echo '<option value="'.$bag['price'].'" class="'.$bag['qty'].'">'.$bag['qty'].'</option>';
}
    ?>
    </select>
                                                            </label>
                                                        </div>
                                                        <div class="col-xs-12 col-sm-6 col-md-3">
                                                            <label>KID QTY
                                                                <select name="cocuklar" id="cocuklar" class="form-control" onchange="updatesum();cocukla();">
                                                                <option value="0">Please Select</option>
    <?php
$coc= mysql_query("SELECT * FROM kidqty"); 
while($kid = mysql_fetch_array($coc)) {
    echo '<option value="'.$kid['price'].'" class="'.$kid['qty'].'">'.$kid['qty'].'</option>';
}
    ?>
    </select>
                                                            </label>
                                                        </div>
                                                        <div class="col-xs-12 col-sm-6 col-md-3" id="koltukalani">
                                                            <label>KID CHAIR 
                                                                <select name='kidchair' id='kidchair' class='form-control' onchange='updatesum();'> 
                                                                    <option value='0'>Please Select</option> 
                                                                    <option value='0'>Do no Want</option> 
                                                                    <option value='<?php echo $genel['kidchair']; ?>'>Need a Kid Chair</option> 
                                                                </select> 
                                                            </label> 
                                                        </div>
                                                    </div>
                                                </div>
                                                <div class="col-xs-12 col-sm-2">
                                                    <button class="form-control submit-button" id="submit" type="submit">SUBMIT</button>
                                                    <br />
                                                    TOTAL AMOUNT:
                                                    <div id="toplamm" class="toplamm">0</div>
                                                </div>
                                            </div>

                                            </form>

And the Other Codes:

function sifirla:

<script type="text/javascript">
function sifirla() {
    document.getElementById("toplamm").innerHTML = "0";
}
      </script>

function cocukla:

      <script type="text/javascript">
function cocukla() {
var cocuk = parseInt(document.getElementById("cocuklar").value);
    if (cocuk < "1") {
    document.getElementById("kidchair").innerHTML = " ";
    }
else {
    document.getElementById("kidchair").innerHTML = "<label>KID CHAIR <select name='kidchair' id='kidchair' class='form-control' onchange='updatesum();'> <option value='0'>Please Select</option> <option value='0'>Do not Want</option> <option value='<?php echo $genel['kidchair']; ?>'>Need a Kid Chair</option> </select> </label>"; }
}

      </script>
  • 写回答

1条回答 默认 最新

  • doumao8803 2015-11-21 12:38
    关注

    In this line T = parseInt('A' ,10) * parseInt('M' ,10); you are using trying to get the ASCII code of char A and char M. Whereas you should be parsing variables A and M to integer.

    You will need to modify your function as below to get the correct numbers-

    T = parseInt(A ,10) * parseInt(M ,10);
    

    Updated as per comment -

    Use value instead of val() for getting the values form html id tags.

    T = parseInt(A ,10) * parseInt(M ,10) + parseInt(K ,10) + parseInt(B ,10) + parseInt(C ,10) + parseInt(Ck ,10);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 素材场景中光线烘焙后灯光失效
  • ¥15 请教一下各位,为什么我这个没有实现模拟点击
  • ¥15 执行 virtuoso 命令后,界面没有,cadence 启动不起来
  • ¥50 comfyui下连接animatediff节点生成视频质量非常差的原因
  • ¥20 有关区间dp的问题求解
  • ¥15 多电路系统共用电源的串扰问题
  • ¥15 slam rangenet++配置
  • ¥15 有没有研究水声通信方面的帮我改俩matlab代码
  • ¥15 ubuntu子系统密码忘记
  • ¥15 保护模式-系统加载-段寄存器