Jump to content

aquilina

Members
  • Content Count

    32
  • Joined

  • Last visited

Community Reputation

0 Neutral

About aquilina

  • Rank
    Member

Profile Information

  • Gender
    Not Telling
  1. yes i using HTMl form for the print button.. in my searchform.php got two type of search filter, dropdown option (search based on company name )and date range. (search based on date range).. both of it i using $_POST $companyname = $_POST['companyname'] << this for dropdown while for the date range $from = $_POST['from'] $to = $_POST['to'] is there any specific value need to put in the print button so that it able to pass the value when i using dropdown or date search? for my print button i put <a href="print_tax.php?company=<?php echo $COMPANYNAME;
  2. Im currenlty working on it. in searchform.php i got two type of searching method by using dropdown option (search based on company name) and using date range(search company based on the date range) i able to pass the dropdown option (search based on company) result search to print report page (mpdf).. in my searchform.php my print button <a href="print_tax.php?company=<?php echo $company; ?> while for my print.php $company = $_GET['company']; . I was able to pass the dropdown searched data. But i wonder how i going to pass the value when i using date range search to
  3. For that form, i does not using any another page for processing because i display the result in the same page. once the result search is found, i want the pass the value of the search result to MPDF by clicking the print button and it will bring to mpdf page where the report templete is appear... im not really familiar with mpdf.btw how to get the value from another page form.
  4. I got a page where user able to search data by filtering using datepicker(date range) or using dropdown selection option. There are two button on the page which are search button and print button. I want to pass the data which i have search to another page where i using mpdf. How to pass the searched value to another page(mpdf).. im using method POST for my form. what kind of unique ID or value that i can pass to another page?
  5. i have make both working but can u help me take a look? <?php if(isset ($_POST["from"],$_POST["to"])) { $from = $_POST["from"]; $to = $_POST["to"]; $test = "SELECT * From `sl_iv` Inner Join `ar_iv` On ar_iv.DOCNO = sl_iv.DOCNO Inner Join `payment_terms` On ar_iv.TERMS = payment_terms.id WHERE sl_iv.DOCDATE BETWEEN '".$from."' AND '".$to."'"; $result = mysqli_query($conn_connection,$test)or die("MySQL error: " . mysqli_error($conn_connection) . "<hr>\nQuery: $test"); } if(isset ($_POST['COMPANYNAME'])) { $COMPANYNAME = $_POST['COMPANY
  6. how about user can use date or dropdown option.. i mean date or dropdown.. mean here need to have 2 query?
  7. i have been rearrange the code for whole day still cannt make the date search filter working.. i changed using one submit button where preivously using 2 submit button.. <?php include '../include/navbar.php'; $post_at = ""; $post_at_to_date = ""; $count = 1000; $queryCondition = ""; if(!empty($_POST["search"]["DOCDATE"])) { $post_at = $_POST["search"]["DOCDATE"]; list($fid,$fim,$fiy) = explode("-",$post_at); $post_at_todate = date('Y-m-d'); if(!empty($_POST["search"]["post_at_to_date"])) { $post_at_to_date = $_POST["search"]["post_at_to_date"]; list($tid,$tim,$
  8. put that part aside 1st.. because now the date picker is not working. looks like the date picker only worked when there is data displayed on the table.. since the default page doesnt shows any data it might not working.
  9. Ok now the selection option working and another things happen which the datepicker does not work... But how to make it show all the data in the select table as default? Because as default the table area is empty but i want it shows all the data. and when select <option>ALL</option> it also able to show all the data.. any clue? <form name="frmSearch" method="post" action=""> <p class="search_input" id="hiderow"> <input type="text" placeholder="From Date" id="post_at" name="search[DOCDATE]" value="<?php echo $post_at; ?>" class="input-control" /> &
  10. Now it said mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given at while($data = mysqli_fetch_array($result)) $query = "SELECT * From `sl_iv` Inner Join `ar_iv` On ar_iv.DOCNO = sl_iv.DOCNO Inner Join `payment_terms` On ar_iv.TERMS = payment_terms.id GROUP BY sl_iv.COMPANYNAME"; $result1 = mysqli_query($conn_connection, $query); ?> <link rel='stylesheet' type='text/css' href='css/style.css' /> <link rel='stylesheet' type='text/css' href='css/print.css' media="print" /> <script type='text/javascript' src='js/jquery-1.3.2.mi
  11. Im adding POST method in the form. <form name="frmSearch" method="post" action=""> <p class="search_input" id="hiderow"> <input type="text" placeholder="From Date" id="post_at" name="search[DOCDATE]" value="<?php echo $post_at; ?>" class="input-control" /> <input type="text" placeholder="To Date" id="post_at_to_date" name="search[post_at_to_date]" style="margin-left:10px" value="<?php echo $post_at_to_date; ?>" class="input-control" /> <input type="submit" name="go" value="Search"> </p>
  12. i need a hint on it.. i didnt ask for full. im going to try it
  13. yes that the problem.. i kind a problem when mixing up the two seach filter. i was able to run it seperately but when i want merge and mix the two function is matter
  14. Im currently doing the generate report from fetched data. I got 2 type of search filter , search by date and search using customername (select dropdown list). The one using the date search is worked but when i try using the drop down list to fetch the data, it does'nt appear. <?php include '../include/navbar.php'; $post_at = ""; $post_at_to_date = ""; $count = 1000; $queryCondition = ""; if(!empty($_POST["search"]["DOCDATE"])) { $post_at = $_POST["search"]["DOCDATE"]; list($fid,$fim,$fiy) = explode("-",$post_at); $post_at_todate = date('Y-m-d'); if(!empty($_POST["sea
  15. Im looking for the explaination which can make me easier to understand. im try to understand the previous post, but i cannt
×
×
  • 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.