Jump to content

Tilke1955

Members
 View Profile  See their activity

  • Posts

    10

  • Joined

  • Last visited

 Content Type 

Posts posted by Tilke1955

    Sum in Javascript and Count to 10

    in JavaScript

    Posted

    Hello,

     

    If you mean that i should use this:

     

    $sql = "INSERT INTO database (columname1,columname2)
    VALUES ('$_POST [val1]' , '$_POST [val1]' )";
    It gives the same result: only number 0
    I have tried all the examples in the tutorials and none of them worked.
    When i use this:
    $sql = "INSERT INTO database(columname1,columname2) VALUES ('6', '$_POST[val2]')";
    then the number 6 apeares in column 1 and number 0 in column 2
    This proves that the connection is well and the column type is well.

    Sum in Javascript and Count to 10

    in JavaScript

    Posted

    Hi,

    I am still trying to get the data in the database.

    It does not work. When i use this:

     

    $sql = "INSERT INTO database (columname1,columname2)
    VALUES(id='list1' , id='list2')";
    or this:
    $sql = "INSERT INTO database (columname1,columname2)
    VALUES(id='val1' , id='val2')";
    The database returns only the number 1 and not the value of the pressed radio button.
    The columns definitions are int(11)
    I work with the data posted as at 12-3-2015
    Has any one an idea what i do wrong ?

    Sum in Javascript and Count to 10

    in JavaScript

    Posted · Edited by Tilke1955

    Thanks @ justsomeguy and @ Foxy Mod

     

    With your help and suggestions I have found this solution for the element:

     

    function DisplayPrice(price){
    var val1 = 0;
    for( i = 0; i < document.form1.price.length; i++ ){
    if( document.form1.price.checked == true ){
    val1 = document.form1.price.value;
    var list1=parseInt(val1);
    document.getElementById("list1").innerHTML=list1;
    And it did the job, now i can go on, putting the data in the MySql database with a query.
    Tilke1955

    Sum in Javascript and Count to 10

    in JavaScript

    Posted

    Hi,

     

    I have added in the the DisplayPrice function this:

    {
    var list1=parseInt(val1);
    document.getElementById("list1").innerHTML=list1;
    }
    and in HTML this:
    <input type="text" name="list1" id="list1" value="" size="2" readonly>
    But no result....., what is wrong?

    Sum in Javascript and Count to 10

    in JavaScript

    Posted · Edited by Tilke1955

    I have found an other example that also sum radio buttons.

    The only thing i now need to find, is to put under the totaal : a list from each value.

    Does any one knows a working example for me.

    The code i now have is this:

     

    <html>
    <body>
    <script type="text/javascript">
    function DisplayPrice(price){
    var val1 = 0;
    for( i = 0; i < document.form1.price.length; i++ ){
    if( document.form1.price.checked == true ){
    val1 = document.form1.price.value;
    }
    }
    var val2 = 0;
    for( i = 0; i < document.form2.price2.length; i++ ){
    if( document.form2.price2.checked == true ){
    val2 = document.form2.price2.value;
    }
    }
    var val3 = 0;
    for( i = 0; i < document.form3.price3.length; i++ ){
    if( document.form3.price3.checked == true ){
    val3 = document.form3.price3.value;
    }
    }
    var sum=parseInt(val1) + parseInt(val2) + parseInt(val3);
    document.getElementById('totalSum').value=sum;
    }
    </script>
    </head>
    <body>
    Choose the first number:<br>
    <form name="form1" id="form1" runat="server">
    <br>
    <input id="rdo_1" type="radio" value="1" name="price" onClick="DisplayPrice(this.value);">1
    <br>
    <input id="rdo_2" type="radio" value="2" name="price" onClick="DisplayPrice(this.value);">2
    <br>
    </form>
    Choose the second number:<br>
    <form name="form2" id="form2" runat="server">
    <br>
    <input id="rdo_1" type="radio" value="3" name="price2" onClick="DisplayPrice(this.value);">3
    <br>
    <input id="rdo_2" type="radio" value="4" name="price2" onClick="DisplayPrice(this.value);">4
    <br>
    </form>
    Choose the third number:<br>
    <form name="form3" id="form3" runat="server">
    <br>
    <input id="rdo_1" type="radio" value="5" name="price3" onClick="DisplayPrice(this.value);">5
    <br>
    <input id="rdo_2" type="radio" value="6" name="price3" onClick="DisplayPrice(this.value);">6
    <br>
    </form>
    <br><br>
    Total Result:
    <input type="text" name="totalSum" id="totalSum" value="" size="2" readonly>
    <br><br>
    List of Each number: <p id="list1"><p id="list2"><p id="list3">
    </body>
    </html>

    Sum in Javascript and Count to 10

    in JavaScript

    Posted

    I am stucked again.

    There are so many examples on the forums but they are all with a fixed item to add to an existing Array.

    Never i find an example with an empty Array that i can fill with a result from a button.

     

    I am sure i need some or all of the following items:

    var serie = new Array(10);
    serieArray = [ ];
    function myFunctionGetal ( ) {
    document.getElementById("name").innerHTML = serie;
    system.out.println('q1','q2.....q10'); or array('index0', 'index1', ..., 'index10' )
    Could you please give me a hint in the right direction?
    Thanks
    Tilke1955

    Sum in Javascript and Count to 10

    in JavaScript

    Posted

    Hi, now i am desperate.

     

    The results by clicking on the button is a new button so the users can see what numbers they have used.

    So far so good.

     

    But now is the question: How do i modify the function to write it in a array.

    And how can i link this 10 new buttons with my db columnames.( 101, 102,....110, total)

     

    The result of the array must be something like this ?

    var serieArray = new Array("5","5","5","5","8","8","8","10","10","10","Array_sum") showArray(serieArray);
    This is to see for the users what they filled in and show them a total.
    And when the user agreed i will make a "insert to button" to fill the database from the 'serieArray'.

    Thanks

    Tilke1955

    Sum in Javascript and Count to 10

    in JavaScript

    Posted

    Thanks @justsomeguy :good:

     

    This works fine.

    I had to change all the html lines:

    ex: <button onclick="myFunctionGetal10()">10</button>

    to

    ex: <button onclick="myFunctionGetal(10)">10</button>

     

    and then it works perfectly.

     

    I am going to try to modify the function into: store it as an array, as you suggested.

     

    I will try it first by myself, and when i become desperate, i will come back to the forum. ;)

     

    Tilke1955

    Sum in Javascript and Count to 10

    in JavaScript

    Posted

    Hello,

     

    I am building a site to record results to a MySql database.

    The visitors have to fill in 10 numbers between 1 and 10.

    It can be the same numbers ex: 5,5,5,5,8,8,8,10,10,10 (total=74)

     

    First: I need to block the input when there are exact 10 numbers.

    I have no clue how to do that.

    Two: The 10 numbers and the total must go to a database.

    The output is everytime different and how can i give a unique naam to the output.

     

    I hope that someone nows the answers to my problems.

    My native language is not English and i hope i have it explained good.

     

     

     

     

    What I have made so far :

     

    <!DOCTYPE html>
    <html>
    <title>Series 1</title>
    <body>
    </script>
    <p>Klick on number:</p>
    <button onclick="myFunctionGetal10()">10</button>
    <button onclick="myFunctionGetal9()"> 9</button>
    <button onclick="myFunctionGetal8()"> 8</button>
    <button onclick="myFunctionGetal7()"> 7</button>
    <button onclick="myFunctionGetal6()"> 6</button>
    <button onclick="myFunctionGetal5()"> 5</button>
    <button onclick="myFunctionGetal4()"> 4</button>
    <button onclick="myFunctionGetal3()"> 3</button>
    <button onclick="myFunctionGetal2()"> 2</button>
    <button onclick="myFunctionGetal1()"> 1</button>
    <br>
    <br>
    <p>
    Result:
    <script>
    function myFunctionGetal1() {
    var x = document.createElement("INPUT");
    x.setAttribute("type", "button");
    x.setAttribute("value", "1");
    document.body.appendChild(x);
    }
    function myFunctionGetal2() {
    var x = document.createElement("INPUT");
    x.setAttribute("type", "button");
    x.setAttribute("value", "2");
    document.body.appendChild(x);
    }
    function myFunctionGetal3() {
    var x = document.createElement("INPUT");
    x.setAttribute("type", "button");
    x.setAttribute("value", "3");
    document.body.appendChild(x);
    }
    function myFunctionGetal4() {
    var x = document.createElement("INPUT");
    x.setAttribute("type", "button");
    x.setAttribute("value", "4");
    document.body.appendChild(x);
    }
    function myFunctionGetal5() {
    var x = document.createElement("INPUT");
    x.setAttribute("type", "button");
    x.setAttribute("value", "5");
    document.body.appendChild(x);
    }
    function myFunctionGetal6() {
    var x = document.createElement("INPUT");
    x.setAttribute("type", "button");
    x.setAttribute("value", "6");
    document.body.appendChild(x);
    }
    function myFunctionGetal7() {
    var x = document.createElement("INPUT");
    x.setAttribute("type", "button");
    x.setAttribute("value", "7");
    document.body.appendChild(x);
    }
    function myFunctionGetal8() {
    var x = document.createElement("INPUT");
    x.setAttribute("type", "button");
    x.setAttribute("value", "8");
    document.body.appendChild(x);
    }
    function myFunctionGetal9() {
    var x = document.createElement("INPUT");
    x.setAttribute("type", "button");
    x.setAttribute("value", "9");
    document.body.appendChild(x);
    }
    function myFunctionGetal10() {
    var x = document.createElement("INPUT");
    x.setAttribute("type", "button");
    x.setAttribute("value", "10");
    document.body.appendChild(x);
    }
    </script>
    </body>
    </html>
×
×
  • Create New...