Jump to content

Recommended Posts

I want to download the records of the output of search criteria to excel.

As the fields for search criteria are more than 20. I am submitting the form with POST method rather than GET.

 

On click of  "Download2excel", the hidden variable name1 is set to Yes. so i will check the condition in my code. Once the download is successful, I want to reset the variable.

 

 

Here is a sample structure of my code.

 

        <html>
        <head>
            <?php
            if(trim($_POST['name1']) == 'yes') {
                header("Content-type: application/vnd-ms-excel");
                header("Content-Disposition: attachment; filename=$filename.xls");
            }else {
                ?>
        </head>
        <body onload="tempFn()">
    
            <script language="javascript" type="text/javascript">
                function tempFn(){  
                    global_search.name1.value = "";
                }
                function gs_download2xl_c() {
                    document.getElementById('name1').value="yes";
                    document.global_search.submit();
                }
            </script>
            <form name="global_search" id="global_search" action="test_1.php" method="POST">
                <input type="text" id="name1" name="name1" />
                <a  class="underline"  style="cursor: pointer" onclick="gs_download2xl_c();">
                    Download2excel
                </a>
            </form>
                <?php } ?>
        </body>
    </html>

As i am not executing the form after posting the form, i am not able to access the variable name1 is in it. I want to reset the variable name1.

 

I want to trigger the download, after submitting the form. As the records that are downloaded to excel should obey input search criteria.

 

 

Please suggest me a better procedure.

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.