Forum Moderators: open
<script language="jscript">
function getWrkHrsNew (tempDateLog2)
{
//some code here
//connection to database here
$recllWrkHrsNew_query=mysql_query(($SQLString),$datenewWrkHrsRec);
$recllWrkHrsNew2=mysql_num_rows($recllWrkHrsNew_query);if (<?$recllWrkHrsNew2?>!=0)
{
<? while($recllWrkHrsNew=mysql_fetch_array($recllWrkHrsNew_query))
{?>
if ("<? echo $recllWrkHrsNew["Transaction_Date"];?>" == tempDateLog2)
{
alert ("found something");
TotalRemainingTemp = TotalRemainingTemp + 7.5
foundValue = "found"
}
else
{
alert ("Can't find same date!");
}
<? }?>
}
</script>HERE is somecode in vbscript
<script language="vbscript">
Sub OkOutput()
tempDateLog = NewDataForm.LogYear.value &"-"& NewDataForm.LogMonth.value &"-"& NewDataForm.LogDay.value
NewDataForm.DateLog.value = tempDateLog
tempDateLog2 = tempDateLog
getWrkHrsNew(tempDateLog2)
End Sub
</script>
I am trying my best to work around with it but I'm stuck. hoping for help out there. thank you in advance
An ASP forum may be what you need.
All PHP processing must be done before j/s ever sees it.
PHP code embedded in j/s is just meaningless strings.
This will work
<script>
function getPHPvar() {
var MyVarFromPHP = "<? echo SomePHPvar?>"
}
</script>
but not because PHP and j/s are interacting. It will work because PHP has written part of your j/s before the page was rendered.
<script language="javascript">
function getWrkHrsNew (tempDateLog2)
{
//some code here
//connection to database here
$recllWrkHrsNew_query=mysql_query(($SQLString),$da
tenewWrkHrsRec);
$recllWrkHrsNew2=mysql_num_rows($recllWrkHrsNew_qu
ery);if (<?$recllWrkHrsNew2?>!=0)
{
<? while($recllWrkHrsNew=mysql_fetch_array($recllWrkH
rsNew_query))
{?>
if ("<? echo $recllWrkHrsNew["Transaction_Date"];?>" == tempDateLog2)
{
alert ("found something");
TotalRemainingTemp = TotalRemainingTemp + 7.5
foundValue = "found"
}
else
{
alert ("Can't find same date!");
}
<? }?>
}
</script>
and here's the some part of the code which is working
<script language="vbscript">
Sub OkOutput()
tempDateLog = NewDataForm.LogYear.value &"-"& NewDataForm.LogMonth.value &"-"& NewDataForm.LogDay.value
NewDataForm.DateLog.value = tempDateLog
tempDateLog2 = tempDateLog
getWrkHrsNew(tempDateLog2)
End Sub
</script>
<body>
<form name=NewDataForm ...>
//select box here LogYear,LogMonth,LogDay
</form>
</body>
This is a (largely client-side) Javascript forum. We don't deal in PHP. Your problem may well be in the Javascript, but to solve it we'll need to see the code that reaches the browser.
Run your code on the server, then post the resulting client-side code (all server-side code having been resolved) on the forum so we can have a look at it.
<? if ($WrkHrsNew2!= 0 )
{?>
alert ("ga san");
<? while( $WrkHrsNew=mysql_fetch_array($WrkHrsNew_query))
{
?>
alert ("san ga");
alert (<? echo $DateLogtemp?>);
alert (<? echo $WrkHrsNew['Date']?>);
<? if ( $WrkHrsNew['Date'] == $DateLogtemp )
{?>
alert ("Found!");
<? }
else
{?>
alert ("NONE");
<? }
}
}?>
Sub OkOutput()
tempDateLog = NewDataForm.LogYear.value &"-"& NewDataForm.LogMonth.value &"-"& NewDataForm.LogDay.value
NewDataForm.DateLog.value = tempDateLog
tempDateLog2 = tempDateLog
NewDataForm.DateLogtemp.value = tempDateLog2
getWrkHrsNew(tempDateLog2)
End Sub
<script language="js">
function getWrkHrsNew (tempDateLog2)
{
temp = tempDateLog2;
//some code here
//connection to database here
$WrkHrsNew_query=mysql_query($SQLString,$newWrkHrsRec);
$WrkHrsNew2=mysql_num_rows($WrkHrsNew_query);?><? if ($WrkHrsNew2!= 0 )
{?>
alert ("ga san");
<? while( $WrkHrsNew=mysql_fetch_array($WrkHrsNew_query))
{?>
alert ("<? echo $WrkHrsNew['Date']?>");
alert (temp);if ("<? echo $WrkHrsNew['Date']?>" == temp)
{ alert ("Found!");
foundValue = "found";
}
else
{ alert ("NONE");
}
<? }
}?>
}
</script><script language="vbscript">
//some other vb code
Sub OkOutput()
tempDateLog = NewDataForm.LogYear.value &"-"& NewDataForm.LogMonth.value &"-"& NewDataForm.LogDay.value
NewDataForm.DateLog.value = tempDateLog
tempDateLog2 = tempDateLog
getWrkHrsNew(tempDateLog2)
End Sub
</script>
but i've got a problem in comparing dates. in my database i have dates 2004-11-02, and 2004-11-22. in my select box if i have chosen the date november 23 2004 it is displayed in my textbox as 2004-11-23 and this date will be compared if there is a date in my database equal to my chosen date then it displays "Found". however, if i have chosen novermber 2 2004 it is displayed in my textbox as 2004-11-2 so when it is compared in my database it is displayed as "NONE". any idea what will i do now? thank you in advance. i will be looking forward for your reply.
