Results 1 to 2 of 2

Thread: search form to return results between dates

  1. #1
    Join Date
    May 2012
    Posts
    217
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default search form to return results between dates

    Hi

    I have got the results paginated but now need to include a form to search for data between two dates but am stuck

    My code looks like the following but returns the errors

    Code:
    <?php
    
    ini_set('display_startup_errors',1);
    ini_set('display_errors',1);
    error_reporting(-1);
    
    include_once("mysqli_connection.php");
    
    // This first query is just to get the total count of rows
    $sql = "SELECT COUNT(id) FROM purchased_software";
    
    $r = mysqli_query($con,$sql)
      or die("Error: ".mysqli_error($con));
    
    $query = mysqli_query($con, $sql);
    $row = mysqli_fetch_row($query);
    // Here we have the total row count
    $rows = $row[0];
    // This is the number of results we want displayed per page
    $page_rows = 5;
    // This tells us the page number of our last page
    $last = ceil($rows/$page_rows);
    // This makes sure $last cannot be less than 1
    if($last < 1){
    	$last = 1;
    }
    // Establish the $pagenum variable
    $pagenum = 1;
    // Get pagenum from URL vars if it is present, else it is = 1
    if(isset($_GET['pn'])){
    	$pagenum = preg_replace('#[^0-9]#', '', $_GET['pn']);
    }
    // This makes sure the page number isn't below 1, or more than our $last page
    if ($pagenum < 1) { 
        $pagenum = 1; 
    } else if ($pagenum > $last) { 
        $pagenum = $last; 
    }
    // This sets the range of rows to query for the chosen $pagenum
    $limit = 'LIMIT ' .($pagenum - 1) * $page_rows .',' .$page_rows;
    
    $a = ( isset($_POST['from']) ) ? $_POST['from'] : '';
    $b = ( isset($_POST['to']) ) ? $_POST['to'] : '' ;
    
    // This is your query again, it is for grabbing just one page worth of rows by applying $limit
    $sql = "SELECT id, customer_pp_email, sales_month, software_title, quantity, total_sale, ebay_fees, paypal_fees, software_cost, profit, notes, status, sold_by FROM purchased_software 
    WHERE sales_month BETWEEN '$a' AND '$b' ORDER BY id DESC $limit";
    
    //var_dump($_POST);
    
    print_r($_POST);
    
    $query = mysqli_query($con, $sql);
    
    // This shows the user what page they are on, and the total number of pages
    $textline1 = "Sales (<b>$rows</b>)";
    $textline2 = "Page <b>$pagenum</b> of <b>$last</b>";
    // Establish the $paginationCtrls variable
    $paginationCtrls = '';
    // If there is more than 1 page worth of results
    if($last != 1){
    	/* First we check if we are on page one. If we are then we don't need a link to 
    	   the previous page or the first page so we do nothing. If we aren't then we
    	   generate links to the first page, and to the previous page. */
    	if ($pagenum > 1) {
            $previous = $pagenum - 1;
    		$paginationCtrls .= '<a href="'.$_SERVER['PHP_SELF'].'?pn='.$previous.'">Previous</a> &nbsp; &nbsp; ';
    		// Render clickable number links that should appear on the left of the target page number
    		for($i = $pagenum-4; $i < $pagenum; $i++){
    			if($i > 0){
    		        $paginationCtrls .= '<a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'">'.$i.'</a> &nbsp; ';
    			}
    	    }
        }
    	// Render the target page number, but without it being a link
    	$paginationCtrls .= ''.$pagenum.' &nbsp; ';
    	// Render clickable number links that should appear on the right of the target page number
    	for($i = $pagenum+1; $i <= $last; $i++){
    		$paginationCtrls .= '<a href="'.$_SERVER['PHP_SELF'].'?pn='.$i.'">'.$i.'</a> &nbsp; ';
    		if($i >= $pagenum+4){
    			break;
    		}
    	}
    	// This does the same as above, only checking if we are on the last page, and then generating the "Next"
        if ($pagenum != $last) {
            $next = $pagenum + 1;
            $paginationCtrls .= ' &nbsp; &nbsp; <a href="'.$_SERVER['PHP_SELF'].'?pn='.$next.'">Next</a> ';
        }
    }
    $list = '';
    while($row = mysqli_fetch_array($query, MYSQLI_ASSOC)){
    	$id = $row["id"];
    	$customer_pp_email = $row["customer_pp_email"];
    	$sales_month = strftime("%b %d, %Y", strtotime($sales_month));
    	$software_title = $row["software_title"];
    	$quantity = $row["quantity"];
    	$total_sale = $row["total_sale"];
    	$ebay_fees = $row["ebay_fees"];
    	$paypal_fees = $row["paypal_fees"];
    	$software_cost = $row["software_cost"];
    	$profit = $row["profit"];
    	$notes = $row["notes"];
    	$status = $row["status"];
    	$sold_by = $row["sold_by"];
    	$list .= '<p>' . $customer_pp_email . $sales_month . $software_title . $quantity . $total_sale . $ebay_fees . $paypal_fees . $software_cost . $profit . $notes . $status . $sold_by.'</p>';
    }
    // Close your database connection
    mysqli_close($con);
    
    
    ?>
    
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
    <html>
        <head> 
            <title>Search Data Between Two Dates</title>
            <link rel="stylesheet" type="text/css" media="screen" href="css/styles.css" />
            <link rel="stylesheet" type="text/css" href="css/tcal.css" />
            <script type="text/javascript" src="js/tcal.js"></script>
        </head>  
    
        <body>
            <div id="logo">
                <img src="images/logo/it-done-right.jpg" alt="" title="">
            </div>
            
            <br><br>
    
            <?php include("nav-menu.php"); ?>
    
            <br><br>
            
            <form action="search-data.php" method="post">
                From : <input type="text" name="from" class="tcal" />
                To: <input type="text" name="to" class="tcal" />
                <input name="" type="submit" value="Search">
            </form>
            
            <div>
      <h2><?php echo $textline1; ?> Paged</h2>
      <p><?php echo $textline2; ?></p>
      <p><?php echo $list; ?></p>
      <div id="pagination_controls"><?php echo $paginationCtrls; ?></div>
    </div>
    
    </body>
    </html>
    The print post returns Array ( )

    Can anyone help or point me in the right direction please

  2. #2
    Join Date
    May 2012
    Posts
    217
    Thanks
    0
    Thanked 1 Time in 1 Post

    Default

    I need to close this one as got a new idea

Similar Threads

  1. paginate search results
    By ianhaney in forum PHP
    Replies: 45
    Last Post: 02-09-2016, 10:16 PM
  2. Replies: 0
    Last Post: 12-28-2009, 09:14 AM
  3. Replies: 0
    Last Post: 04-06-2008, 07:57 PM
  4. Building a simple mysql search and return in dreamweaver cs3
    By revray in forum MySQL and other databases
    Replies: 0
    Last Post: 02-08-2008, 01:46 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •