Jump to content

redirect pages with data

maideen

By maideen
in PHP Coding Help

 Share

Recommended Posts

maideen Member

maideen

Posted
Posted
Hi 
 
I have two button in my page One is 'search' and another is 'print'
But i could not re direct and passing date to another page. code is working fine for search. But print
I am blur of this. Pls help me how i can redirect the page by using button click. Pls help me
 
Below my code
 
index.php
 
<?php
include_once '../inc/connection.inc.php';
?>
 
<?php
try {
       $stmt = $dbh->prepare('SELECT * FROM MVendorMaster order by MVName');
       $stmt->execute();
    } 
catch (PDOException $e) 
    {
       $output = 'Error fetching main vendor from database!';
       include '../errormsg.php';
       exit();
    }
 
foreach ($stmt as $row) 
    {
       $mvcode[] = array('MVCode' => $row['MVCode'], 'MVName' => $row['MVName']);
    }
include 'searchform.html.php';
?>
 
<?php
if (isset($_POST['search']) && $_POST['search']  != "" )
    {
        $mvcode = $_POST["mvendor"];
        $datefrom=$_POST["datefrom"];
        $dateto=$_POST["dateto"];
        
        $stmt = $dbh->query("SELECT * FROM php_vw_InvoiceHead WHERE MVCode='$mvcode' and SODate>='$datefrom' and SODate<='$dateto' ORDER BY MVCode,SODate");
        $stmt->setFetchMode(PDO::FETCH_ASSOC); 
        include 'view.html.php';
        
    }   
 
if (isset($_POST['print']) && $_POST['print']  != "" )
    {
        $mvcode = $_POST["mvendor"];
        $datefrom=$_POST["datefrom"];
        $dateto=$_POST["dateto"];
        
        $stmt = $dbh->query("SELECT * FROM php_vw_InvoiceHead WHERE MVCode='$mvcode' and SODate>='$datefrom' and SODate<='$dateto' ORDER BY MVCode,SODate");
        $stmt->setFetchMode(PDO::FETCH_ASSOC); 
        include 'print.html.php';
        
    }       
    
?>
 
searchform.html.php
 
<?php
include '../templete/header.php';
?>
 
<div>
    <h6>Sales Report by Main Vendor</h6>
</div>
 
<form action="" method="POST">
<table class="tdtable" id="tdtable">
                  <tr>
                  <td>Main Vendor Name </td>
                  <td>
                      <select name="mvendor" id="mvcode"><option value="">Mian Vendor</option>
                    <?php foreach ($mvcode as $mvcodes): ?>
                        <option value="<?php htmlout($mvcodes['MVCode']); ?>">
                            <?php htmlout($mvcodes['MVName']); ?></option>
                    <?php endforeach; ?>
                    </select>
                        
                  </td>
                  
              </tr>           
      <tr>
        <td>Date[From]:</td>
        <td><input type="text" id="datepicker1" name="datefrom" /></td>
      </tr>
      <tr>
        <td>Date[To]:</td>
        <td><input type="text" id="datepicker2" name="dateto" /></td>
      </tr>    
</table>
    <div>
        <input type="submit" value="Search" name="search">
        <input type="submit" value="Print" name="print">
    </div>
</form>
 
view.html.php
 
<?php  
$groupby = '';
$displaySubTotal = FALSE;
$subTotal = 0;
$grandTotal = 0;
 
$sub_balqty=0;  // maideen
$grn_balqty=0;  // maideen
 
$sub_rtnqty=0;  // maideen
$grn_rtnqty=0;  // maideen
 
$sub_qty=0;  // maideen
$grn_qty=0;  // maideen
 
?>
 
 
    <table width="100%" align="center" cellpadding="4" cellspacing="1" class=tbl_table">
        <tr>
   <td class="tbl_header">MV CODE</td>
    <td class="tbl_header">MV NAME</td>
    <td class="tbl_header">SO Date</td>
    <td class="tbl_header">SO No</td>
    <td class="tbl_header">RATE</td>
    <td class="tbl_header">SUPP.QTY</td>
    <td class="tbl_header">RTN.QTY</td>
    <td class="tbl_header">BAL.Qty</td>
    <td class="tbl_header">SOLD AMT</td>
    <td class="tbl_header">Actions</td>
            
        </tr>
        <?php if(isset($stmt))
        {
        while($row = $stmt->fetch()): 
              
              if($groupby!=$row['MVCode']): 
                if($displaySubTotal): ?>
                   
                   <tr><td colspan="10"><hr /></td></tr>
                   
                   <tr>
                       
                        <td colspan="4">
                        <td class="tbl_subtotal_left" ><b>Sub Total </b></td>
                        <td class="tbl_subtotal_right"><b><?php echo number_format($sub_qty); ?></b></td>
                        <td class="tbl_subtotal_right"><b><?php echo number_format($sub_rtnqty); ?></b></td>
                        <td class="tbl_subtotal_right"><b><?php echo number_format($sub_balqty); ?></b></td>
                        <td class="tbl_subtotal_right"><b><?php echo number_format($subTotal,2); ?></b></td>
                    </tr>
                    
                    <tr><td colspan="10"><hr /></td></tr>
                    
               <?php 
                     $grandTotal += $subTotal; 
                     $subTotal = 0; 
                     
                     $grn_balqty += $sub_balqty;
                     $sub_balqty=0;
                     
                     $grn_rtnqty += $sub_rtnqty;
                     $sub_rtnqty=0;
                     
                     $grn_qty += $sub_qty;
                     $sub_qty=0;
                else: 
                      $displaySubTotal = TRUE;
                endif; 
                      //$groupby = $row['SODate']; 
                      $groupby = $row['MVCode']; 
                endif; 
                ?>
            <tr>
                <td class="tbl_content"><?php echo $row['MVCode'];?></td>
                <td class="tbl_content"><?php echo $row['MVName'];?></td>
                <td class="tbl_content"><?php echo date("d-m-Y", strtotime($row['SODate']));?></td>
                <td class="tbl_content"><?php echo $row['SONo'];?></td>
                <td class="tbl_content_right"><?php echo number_format($row['Rate'],2) ;?></td>
                <td class="tbl_content_right"><?php echo number_format($row['Qty']) ;?></td>
                <td class="tbl_content_right"><?php echo number_format($row['RTNQty']) ;?></td>
                <td class="tbl_content_right"><?php echo number_format($row['BalQty']) ;?></td>
                <td class="tbl_content_right"><?php echo number_format($row['BalAmt'],2) ;?></td>
             </td>
             
            <?php 
                 $subTotal += $row['BalAmt']; 
                 $sub_balqty += $row['BalQty'];
                 $sub_rtnqty += $row['RTNQty'];
                 $sub_qty += $row['Qty'];
                 
                 endwhile; 
                 $grandTotal += $subTotal; 
                 $grn_balqty += $sub_balqty;
                 $grn_rtnqty += $sub_rtnqty;
                 $grn_qty += $sub_qty;
                 
                 
             ?>
        <tr><td colspan="10"><hr /></td></tr>
        <tr>
            <td colspan="4">
                <td class="tbl_subtotal_left" ><b>Sub Total </b></td>
                <td class="tbl_subtotal_right"><b><?php echo number_format($sub_qty); ?></b></td>
                <td class="tbl_subtotal_right"><b><?php echo number_format($sub_rtnqty); ?></b></td>
                <td class="tbl_subtotal_right"><b><?php echo number_format($sub_balqty); ?></b></td>
                <td class="tbl_subtotal_right"><b><?php echo number_format($subTotal,2); ?></b></td>
        </tr>
        <!--
        <tr><td colspan="10"><hr /></td></tr>
        <tr>
            <td colspan="4">
            <td class="tbl_subtotal_left"><b>Grand Total</b></td>
            <td class="tbl_subtotal_right"><b><?php echo number_format($grn_qty); ?></b></td>
            <td class="tbl_subtotal_right"><b><?php echo number_format($grn_rtnqty); ?></b></td>
            <td class="tbl_subtotal_right"><b><?php echo number_format($grn_balqty); ?></b></td>
            <td class="tbl_subtotal_right"><b><?php echo number_format($grandTotal,2); ?></b></td>
        </tr>
        <tr><td colspan="10"><hr /></td></tr>
        -->
        <?php }?>
    </table>
   <?php unset($dbh); unset($stmt); ?>
 
<?php
include '../templete/footer.php';
?>
 
print.html.php
 
<?php
echo "print page";
?>
 
<script language="javascript" type="text/javascript">
     function printFunction(){
     
     window.print();
     }
</script>
 
<script language="javascript" type="text/javascript">
 
        function PrintGridData() {
            var prtGrid = document.getElementById('<%=txtDocNo%>');
            prtGrid.border = 0;
            var prtwin = window.open('', 'PrintGridViewData', 'left=100,top=100,width=1000,height=1000,tollbar=0,scrollbars=1,status=0,resizable=1');
            prtwin.document.write(prtGrid.outerHTML);
            prtwin.document.close();
            prtwin.focus();
            prtwin.print();
            prtwin.close();
 </script>
 
<?php  
$groupby = '';
$displaySubTotal = FALSE;
$subTotal = 0;
$grandTotal = 0;
 
$sub_balqty=0;  // maideen
$grn_balqty=0;  // maideen
 
$sub_rtnqty=0;  // maideen
$grn_rtnqty=0;  // maideen
 
$sub_qty=0;  // maideen
$grn_qty=0;  // maideen
 
?>
 
 
    <table width="100%" align="center" cellpadding="4" cellspacing="1" class=tbl_table">
        <tr>
   <td class="tbl_header">MV CODE</td>
    <td class="tbl_header">MV NAME</td>
    <td class="tbl_header">SO Date</td>
    <td class="tbl_header">SO No</td>
    <td class="tbl_header">RATE</td>
    <td class="tbl_header">SUPP.QTY</td>
    <td class="tbl_header">RTN.QTY</td>
    <td class="tbl_header">BAL.Qty</td>
    <td class="tbl_header">SOLD AMT</td>
    <td class="tbl_header">Actions</td>
            
        </tr>
        <?php if(isset($stmt))
        {
        while($row = $stmt->fetch()): 
              
              if($groupby!=$row['MVCode']): 
                if($displaySubTotal): ?>
                   
                   <tr><td colspan="10"><hr /></td></tr>
                   
                   <tr>
                       
                        <td colspan="4">
                        <td class="tbl_subtotal_left" ><b>Sub Total </b></td>
                        <td class="tbl_subtotal_right"><b><?php echo number_format($sub_qty); ?></b></td>
                        <td class="tbl_subtotal_right"><b><?php echo number_format($sub_rtnqty); ?></b></td>
                        <td class="tbl_subtotal_right"><b><?php echo number_format($sub_balqty); ?></b></td>
                        <td class="tbl_subtotal_right"><b><?php echo number_format($subTotal,2); ?></b></td>
                    </tr>
                    
                    <tr><td colspan="10"><hr /></td></tr>
                    
               <?php 
                     $grandTotal += $subTotal; 
                     $subTotal = 0; 
                     
                     $grn_balqty += $sub_balqty;
                     $sub_balqty=0;
                     
                     $grn_rtnqty += $sub_rtnqty;
                     $sub_rtnqty=0;
                     
                     $grn_qty += $sub_qty;
                     $sub_qty=0;
                else: 
                      $displaySubTotal = TRUE;
                endif; 
                      //$groupby = $row['SODate']; 
                      $groupby = $row['MVCode']; 
                endif; 
                ?>
            <tr>
                <td class="tbl_content"><?php echo $row['MVCode'];?></td>
                <td class="tbl_content"><?php echo $row['MVName'];?></td>
                <td class="tbl_content"><?php echo date("d-m-Y", strtotime($row['SODate']));?></td>
                <td class="tbl_content"><?php echo $row['SONo'];?></td>
                <td class="tbl_content_right"><?php echo number_format($row['Rate'],2) ;?></td>
                <td class="tbl_content_right"><?php echo number_format($row['Qty']) ;?></td>
                <td class="tbl_content_right"><?php echo number_format($row['RTNQty']) ;?></td>
                <td class="tbl_content_right"><?php echo number_format($row['BalQty']) ;?></td>
                <td class="tbl_content_right"><?php echo number_format($row['BalAmt'],2) ;?></td>
             </td>
             
            <?php 
                 $subTotal += $row['BalAmt']; 
                 $sub_balqty += $row['BalQty'];
                 $sub_rtnqty += $row['RTNQty'];
                 $sub_qty += $row['Qty'];
                 
                 endwhile; 
                 $grandTotal += $subTotal; 
                 $grn_balqty += $sub_balqty;
                 $grn_rtnqty += $sub_rtnqty;
                 $grn_qty += $sub_qty;
                 
                 
             ?>
        <tr><td colspan="10"><hr /></td></tr>
        <tr>
            <td colspan="4">
                <td class="tbl_subtotal_left" ><b>Sub Total </b></td>
                <td class="tbl_subtotal_right"><b><?php echo number_format($sub_qty); ?></b></td>
                <td class="tbl_subtotal_right"><b><?php echo number_format($sub_rtnqty); ?></b></td>
                <td class="tbl_subtotal_right"><b><?php echo number_format($sub_balqty); ?></b></td>
                <td class="tbl_subtotal_right"><b><?php echo number_format($subTotal,2); ?></b></td>
        </tr>
        <!--
        <tr><td colspan="10"><hr /></td></tr>
        <tr>
            <td colspan="4">
            <td class="tbl_subtotal_left"><b>Grand Total</b></td>
            <td class="tbl_subtotal_right"><b><?php echo number_format($grn_qty); ?></b></td>
            <td class="tbl_subtotal_right"><b><?php echo number_format($grn_rtnqty); ?></b></td>
            <td class="tbl_subtotal_right"><b><?php echo number_format($grn_balqty); ?></b></td>
            <td class="tbl_subtotal_right"><b><?php echo number_format($grandTotal,2); ?></b></td>
        </tr>
        <tr><td colspan="10"><hr /></td></tr>
        -->
        <?php }?>
    </table>
   <?php unset($dbh); unset($stmt); ?>
 
<?php
include '../templete/footer.php';
?>
 

Thank you very much

 

Regards

 

Maideen

 

Link to comment
https://forums.phpfreaks.com/topic/278416-redirect-pages-with-data/
Share on other sites
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.

×
 Share
Go to topic listing
×
×
  • 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.