doupuchao4256 2013-05-06 03:57
浏览 154
已采纳

如何在html标签中调用javascript和php函数?

I have a php page that contains a button that is suppose to export MySql data to excel. Before exporting the user on the page selects "To" and "From" dates. I have placed a check() javascript function that verifies when the user has selected both the dates.

The problem statement is that on the button click the download begins without checking the dates. Please help. Here's the code.

<?  
include("adminlogin.php");

include("classes/tc_calendar.php");

$myCalendar = new tc_calendar("stdt", true, false);
$myCalendar->setIcon("images/iconCalendar.gif");
$myCalendar->setPath("./");
$myCalendar->setYearInterval(2000, 2015);
$myCalendar->dateAllow('2000-01-01', '2015-12-31');
$myCalendar->setDateFormat('j F Y');
//$myCalendar->setHeight(350);    
//$myCalendar->autoSubmit(true, "form1");

$myCalendar2 = new tc_calendar("enddt", true, false);
$myCalendar2->setIcon("images/iconCalendar.gif");
$myCalendar2->setPath("./");
$myCalendar2->setYearInterval(2000, 2015);
$myCalendar2->dateAllow('2000-01-01', '2015-12-31');
$myCalendar2->setDateFormat('j F Y');
//$myCalendar2->setHeight(350);   
//$myCalendar2->autoSubmit(true, "form1");

$stdt1=$_POST['stdt'];
$enddt1=$_POST['enddt'];
echo "dates are";
echo $stdt1;
echo $enddt1;

// function to download report
function export_excel_csv()
{
    $init_sql = "select distinct(proj_id) from timeshiftentry_master where dt>='$stdt1' and dt<='$enddt1'";
    $init_res=mysql_query($init_sql);

    //header info for browser
    $filename = "WP_List_" . date('Ymd') . ".xls";
    header("Content-Type: application/vnd.ms-excel; name='excel'");
    header("Content-Disposition: attachment; filename=\"$filename\"");
    header("Pragma: no-cache");
    header("Expires: 0");

    /*******Start of Formatting for Excel*******/
    //define separator (defines columns in excel & tabs in word)    
    $sep = "\t"; //tabbed character
    ob_end_clean();

    //start of printing column names as names of MySQL fields
    /*for ($i = 0; $i < mysql_num_fields($result); $i++) 
    {
        if($i == 0)
        {
            echo "S. No." . "\t";
        }
        echo mysql_field_name($result,$i) . "\t";
    }
    echo "Employee Name" . "\t";
    echo "Hours Booked" . "\t";
    print("
");*/

    $SerialNum = 0;
    while($init_row=mysql_fetch_array($init_res))
    {
        $sql = "SELECT * FROM project_master where proj_id='$init_row[0]'";
        //execute query
        $result = mysql_query($sql) or die (mysql_error());
        //end of printing column names
        //start while loop to get data
        while($row = mysql_fetch_array($result))
        {
            // get the emplyoee details 
            $projid=$row[0];
            $projnm=$row[1];
            $sql_emp="Select distinct(emp_no),emp_name from timeshiftentry_master where proj_id='$projnm' and  dt>='$stdt1' and dt<='$enddt1'";
            $res_emp=mysql_query($sql_emp);
            while($row_emp=mysql_fetch_array($res_emp))
            {
                $sql_hrs="select sum(wrkhrs) from timeshiftentry_master where proj_name='$projnm'  and emp_no='$row_emp[0]' and dt>='$stdt1' and dt<='$enddt1'";
                $res_hrs=mysql_query($sql_hrs);
                $row_hrs=mysql_fetch_array($res_hrs);
                if($row_hrs[0] >= 0)
                {
                    $SerialNum++;
                    // insert to excel
                    $schema_insert = "";
                    for($j=0; $j<mysql_num_fields($result);$j++)
                    {
                        if($j==0)
                        {
                            $schema_insert .= "$SerialNum".$sep;
                        }
                        if(!isset($row[$j]))
                            $schema_insert .= "NULL".$sep;
                        elseif ($row[$j] != "")
                            $schema_insert .= "$row[$j]".$sep;
                        else
                            $schema_insert .= "".$sep;
                    }
                    $schema_insert .= "$row_emp[1]".$sep;   
                    $schema_insert .= "$row_hrs[0]".$sep;
                    $schema_insert = str_replace($sep."$", "", $schema_insert);
                    $schema_insert = preg_replace("/
|
|
|/", " ", $schema_insert);
                    $schema_insert .= "\t";

                    print(trim($schema_insert));
                    print "
";
                    // inserted one row
                }
            }
        }
    }
    exit();
}

/*if(!isset($_POST))
{
    export_excel_csv();
}*/

if($_SERVER['REQUEST_METHOD']=="POST")
{
    $chk1= $_POST['download'];

    if($chk1=='Download')
    {
        export_excel_csv();
    }
}
else
{

}

?> 

<script language="javascript">
<!--

function check()
{
    if(show)
    {
        if(document.f1.stdt.value=="0000-00-00")
        {
            alert("Please Enter Start Date")
            show=false;
            return false;
        }
        if(document.f1.enddt.value=="0000-00-00")
        {
            alert("Please Enter the End Date")
            show=false; 
            return false;
        }
        if(document.f1.stdt.value>document.f3.enddt.value)
        {
            alert("Dates not allowed.")
            show=false;
            return false;
        }
    }
    return true;
} 

//-->
</script>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Bombardier TSM System</title>

<style type="text/css">
<!--
.style1 {font-size: small}
.style2 {color: #FFFFFF}
.style3 {font-size: x-small}
-->
</style>

</head>

<body>

<form name="f1" method="POST" action="" onClick="return check()"> 

<script language="javascript" src="calendar.js"></script>

<br>

<table align="center" cellspacing="5">

<tr>
<th colspan="2"><font color="#993300" size="4">Download Hours Booking Report</font></th>
</tr>

<tr>
<td>&nbsp;</td>
</tr>

<tr>
<td align="right"><font color="#993300">From : </font></td>
<td><?$myCalendar->writeScript();?></td>
</tr>

<tr>
<td align="right"><font color="#993300">To : </font></td>
<td><?$myCalendar2->writeScript();?></td>
</tr>

<tr>
<td>&nbsp;</td>
</tr>

<tr>
<td colspan="2" align="center"><input type="submit" name="download" value="Download"  id="download" onclick="download=true"/></td
</tr>

</table>

<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>

<?include("footer.php");?>

</form>
</body>
</html>

展开全部

  • 写回答

2条回答 默认 最新

  • dsbruqxgt820011351 2013-05-06 04:04
    关注

    There are two problems

    1) You have unnecessary html comment tag.

    2) You are checking 'if' condition against undeclared variable show

    here

    if(show)
    

    hence your javascript is failing. It is like undefined variable show.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)
编辑
预览

报告相同问题?

悬赏问题

  • ¥15 python 3.8.0版本,安装官方库ibm_db遇到问题,提示找不到ibm_db模块。如何解决?
  • ¥15 TMUXHS4412如何防止静电,
  • ¥30 Metashape软件中如何将建模后的图像中的植被与庄稼点云删除
  • ¥20 机械振动学课后习题求解答
  • ¥15 IEC61850 客户端和服务端的通讯机制
  • ¥15 MAX98357a(关键词-播放音频)
  • ¥15 Linux误删文件,请求帮助
  • ¥15 IBMP550小型机使用串口登录操作系统
  • ¥15 关于#python#的问题:现已知七自由度机器人的DH参数,利用DH参数求解机器人的逆运动学解目前使用的PSO算法
  • ¥15 发那科机器人与设备通讯配置