Author Topic: JS not passing to php (Read 5641 times)

12Strings · « **on:** November 15, 2014, 11:50:34 PM »

Hi, I'm baffled here; the two following statements from my JS
file displays the correct values but the code to enter them
into a table enters zeroes. I tried document.write(s) and the
correct values were displayed.what am I missing? Thanks in advance.

Code: [Select]

var expression = value1 + op +value2 +'='+ total;
alert(expression);

------------------------------------

Code: [Select]

<?php 
include('calcbegin.html');
$servername = "localhost";
$username = "root";table
$password = "cookie";
$dbname = "homedb";
 show 
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
 // Check connection
 if ($conn->connect_error)
 { die("Connection failed: " . $conn->connect_error); } 

$sql = "INSERT INTO calculator (purpose, value1, op, value2, total)
VALUES ('$purpose', '$value1', '$op', '$value2', '$total')";
if ($conn->query($sql) === TRUE)
 { echo "New record created successfully"; }
 else
 { echo "Error: " . $sql . "<br>" . $conn->error; }
$conn->close();
 ?>

DaveLembke · « **Reply #1 on:** November 16, 2014, 06:30:35 AM »

Looks like your getting 0's because no values are being passed to VALUES ('$purpose', '$value1', '$op', '$value2', '$total') and so because nothing is passed to them they are 0 and so $total = 0.

From looking at your shared code it establishes a connection to your database, and just passes whatever value the variables are without any data being passed into those variables ( which is usually 0, however because not initialized to 0 it could be different than 0 with bogus info ) to the database as seen here:

$sql = "INSERT INTO calculator (purpose, value1, op, value2, total)
VALUES ('$purpose', '$value1', '$op', '$value2', '$total')";

Do you have more code to this to show other than what is shown that shows where the variables are being assigned values? I feel that is where your problem is with this in the variable value assignments.

12Strings · « **Reply #2 on:** November 22, 2014, 02:11:52 PM »

Below is my code in it"s entirety. thanks for any help.

Code: [Select]

<?php
include('calcbegin.html');
?>
<html><head>
 <script type="text/javascript">
 function make_blank()
 { document.form.type.value =""; }
 </script>
</head><body><center>
<!-- use ajax - OnCalc function to send data to your database. ???-->
<FORM name="Keypad" action="" method="post">
<input type="text" name="purpose" size="48" value="what's this for?" onFocus="this.value=''">                                                 
<TABLE border=2 width=50 height=60 cellpadding=1 cellspacing=5> 
<tr> <TD colspan=3 align=middle> 
<input name="ReadOut" type="Text" size=24 value="0" width=100%></TD> 
<TD></TD> 
<TD> 
<input name="btnClear" type="Button" value="  C  " onclick="Clear()"></TD> 
<TD>
<input name="btnClearEntry" type="Button" value="  CE  " onclick="ClearEntry()"></TD> 
</TR><TR> 
<TD> 
<input name="btnSeven" type="Button" value="  7  " onclick="NumPressed(7)"></TD>
 <TD> 
<input name="btnEight" type="Button" value="  8  " onclick="NumPressed(8)"></TD>
 <TD> 
<input name="btnNine" type="Button" value="  9  " onclick="NumPressed(9)"></TD> 
<TD></TD> 
<TD> 
<input name="btnNeg" type="Button" value="  +/-  " onclick="Neg()"></TD> 
<TD> 
<input name="btnPercent" type="Button" value="  %  " onclick="Percent()"></TD>
</TR><TR> 
<TD> 
<input name="btnFour" type="Button" value="  4  " onclick="NumPressed(4)"></TD> 
<TD> 
<input name="btnFive" type="Button" value="  5  " onclick="NumPressed(5)"></TD> 
<TD> 
<input name="btnSix" type="Button" value="  6  " onclick="NumPressed(6)"></TD> 
<TD></TD> 
<TD align=middle>
<input name="btnPlus" type="Button" value="   +   " onclick="Operation('+')"></TD>
 <TD align=middle>
<input name="btnMinus" type="Button" value="   -   " onclick="Operation('-')"></TD> 
</TR><TR> 
<TD> 
<input name="btnOne" type="Button" value="  1  " onclick="NumPressed(1)"></TD> 
<TD> 
<input name="btnTwo" type="Button" value="  2  " onclick="NumPressed(2)"></TD> 
<TD> 
<input name="btnThree" type="Button" value="  3  " onclick="NumPressed(3)"></TD>
 <TD></TD> 
<TD align=middle>
<input name="btnMultiply" type="Button" value="   x   " onclick="Operation('*')"></TD> 
<TD align=middle>
<input name="btnDivide" type="Button" value="   /   " onclick="Operation('/')"></TD> 
</TR><TR> 
<TD> 
<input name="btnZero" type="Button" value="  0  " onclick="NumPressed(0)"></TD> 
<TD> 
<input name="btnDecimal" type="Button" value="   .   " onclick="Decimal()"></TD> 
<TD colspan=3> 
</TD><TD> 
<input name="btnEquals" type="Button" value="   =   " onclick="Operation('=')"></TD> 
</TR></TABLE>
 <INPUT type="image" src="programmer.gif" alt="submit button"><p>
</FORM> 
<font face="Verdana, Arial, Helvetica" size=2> 
<SCRIPT LANGUAGE="JavaScript"> 
var FKeyPad = document.Keypad; 
var Accumulate = 0; 
var FlagNewNum = false; 
var PendingOp = ""; 
function NumPressed (Num) 
{ 
if (FlagNewNum) 
{ FKeyPad.ReadOut.value = Num; 
FlagNewNum = false; 
} 
else 
{ 
if (FKeyPad.ReadOut.value == "0") 
FKeyPad.ReadOut.value = Num;

else 
FKeyPad.ReadOut.value += Num; 
} 
} 
function Operation (Op) 
{ 
var Readout = FKeyPad.ReadOut.value; 
if (FlagNewNum && PendingOp != "="); 
else 
{ 
FlagNewNum = true; 
if ( '+' == PendingOp )
{ 
var temp = Accumulate;
Accumulate += parseFloat(Readout); 
OnCalc(temp,PendingOp,Readout,Accumulate);
}
else if ( '-' == PendingOp ) 
{
var temp = Accumulate;
Accumulate -= parseFloat(Readout); 
OnCalc(temp,PendingOp,Readout,Accumulate);
}
else if ( '/' == PendingOp ) 
{
var temp = Accumulate;
Accumulate /= parseFloat(Readout); 
OnCalc(temp,PendingOp,Readout,Accumulate);
}
else if ( '*' == PendingOp ) 
{
var temp = Accumulate;
Accumulate *= parseFloat(Readout); 
OnCalc(temp,PendingOp,Readout,Accumulate);
}
else 
{
Accumulate = parseFloat(Readout); 
}
FKeyPad.ReadOut.value = Accumulate; 

PendingOp = Op; 
} 
} 
function Decimal () 
{ 
var curReadOut = FKeyPad.ReadOut.value; 
if (FlagNewNum) 
{ 
curReadOut = "0."; 
FlagNewNum = false; 
} 
else 
{ 
if
(curReadOut.indexOf(".") == -1) 
curReadOut += "."; 
} 
FKeyPad.ReadOut.value = curReadOut; 
} 
function ClearEntry () 
{ 
FKeyPad.ReadOut.value = "0"; 
FlagNewNum = true; 
} 
function Clear () 
{ 
Accumulate = 0; 
PendingOp = ""; 
ClearEntry(); 
} 
function Neg () 
{ 
FKeyPad.ReadOut.value = parseFloat(FKeyPad.ReadOut.value) * -1; 
} 
function Percent () 
{ 
FKeyPad.ReadOut.value = (parseFloat(FKeyPad.ReadOut.value) / 100) * parseFloat(Accumulate); 
} 
function OnCalc(value1,op,value2,total)
{
var expression = value1 + op +value2 +'='+ total;
alert(expression);
}
</SCRIPT>

Code: [Select]

<?php
include ('gethomedb.php');
// now connected to database
    if(!empty($_POST["submit"])) 
  { 
       $id = $_POST['id'];
 $value1=$_POST['value1'];
         $op=$_POST['op'];
 $value2=$_POST['value2'];
   $total=$_POST['total'];
  $name = $_POST['total'];
 if(isset($_POST['total']))  
 {       
   $fetch="SELECT purpose, value1, op, value2, total FROM calculator WHERE total = '".$name."'";    
       $result = mysqli_query($con,$fetch);  
        if(!$result)  
         {echo "Error:".(mysqli_error($con));}
// ===========================================================   
$query = "
INSERT INTO calculator (purpose, value1, op, value2, total)
VALUES ('$purpose','$value1','$op','$value2','$total')";
mysqli_query($con, $query);
mysqli_close($con); 
 }
  }
?>

Code: [Select]

<a href="http://localhost/home/calcprint.php">PRINT</a>
</body></html>

Computer Hope Forum

News:

Author Topic: JS not passing to php (Read 5641 times)

12Strings

JS not passing to php

DaveLembke

Re: JS not passing to php

12Strings

Re: JS not passing to php