为什么警告框不显示?

问题描述:

这是我的代码。如果存储在文本文件中的重置日期等于当前日期并且来自表(mysql)的数据不为零,它应该显示警告框。然后它应该将值重置为零并删除其他记录。我试着呼应的if语句,它的一禁止知道为什么警告框不会弹出.. 为什么警告框不显示?

<?php 
function reset1(){ 
$sql=mysql_query("UPDATE tbl_txbookStock SET suppliedQuantity=0, boughtQuantity=0"); 
$sql=mysql_query("DELETE FROM tbl_order"); 
$sql=mysql_query("DELETE FROM tbl_order_book"); 
//overwrite date 
$myFile = "config/config.txt"; 
$fh = fopen($myFile, 'w') or die("can't open file"); 
$resetDate = fread($fh, filesize($myFile)); 
fwrite($fh,date("m/d/Y",strtotime("+1 years"))); 
fclose($fh); 

    } 

function getCurrentDate(){ 
return date('m/d/Y'); 
} 
function resetDateIsToday($resetDate){ 
    $itIs=false; 
    if($resetDate==getCurrentDate()) 
     $itIs=true; 

    return $itIs; 
} 
function isReset(){ 
    $isReset=false; 
    if(countZeroQuantities()==countBooks()){    
     $isReset=true; 
    } 

    return $isReset; 
} 
function countBooks(){ 
$sql=mysql_query("select count(bookID) as count from tbl_textbook"); 
$row=mysql_fetch_array($sql); 
return $row['count'];   
} 
function countZeroQuantities(){ 
$sql=mysql_query("select count(bookID) as count FROM `tbl_txbookStock` where  suppliedQuantity>0 OR boughtQuantity>0"); 
$row=mysql_fetch_array($sql); 
return $row['count']; 

} 
?> 
<!doctype html> 
<html lang="en"> 
<head> 
<meta charset="utf-8"/> 
<title>TEXTBOOK ORDERING SYSTEM</title> 
<link rel="stylesheet" href="templatemo_style.css"> 
<?php if (!isset($_SESSION['loggedin'])){ {?> 
<?php if(resetDateIsToday(getResetDate())&&!isReset()){?> 

<script type="text/javascript"> 
<!-- 
function confirmReset(){ 
var answer = confirm ("Reset is scheduled today.Do you really want to reset?") 
if (answer===1){ 
<?php reset1();?>  
window.location="index.php"; 
}else{ 
    alert('Records not reset...'); 
    window.location="index.php"; 
}} 
// --> 
</script> 
<? }}}?> 
</head> 
<body> 
</body> 
</html> 
+0

我希望你知道,''页面之前总是执行甚至发送到客户端。您无法通过JavaScript控制该PHP语句,因为首先在服务器上评估PHP,并将结果发送给客户端,然后再执行JavaScript。放入JavaScript'if'语句的效果与将PHP代码块放在最后的效果相同。而' 2012-02-24 01:06:16

我没有看到你在哪里执行confirmReset,也许只是写

window.onload =function(e){ 
confirmReset(); 
} 

在脚本末尾

+0

哦,对,我会先尝试删除功能。 – user1077271 2012-02-24 01:28:47

confirm()返回true/false,并且“true === 1”不正确。

只写你的证实控制这个样子,

var answer = confirm ("Reset is scheduled today.Do you really want to reset?") 
if (answer){ 
... 
}