I have some code that LIMITs data to display only 50 items per page. The column I'm using has many items, so I need to make those spread out across the pages.
below is my code
Loading
below is product.php
- //fetch_data.php
- include('connect.php');
- if(isset($_POST["action"]))
- {
- $query = "SELECT * FROM diamond_tbl WHERE product_status = '0' ";
- if(isset($_POST["minimum_price"], $_POST["maximum_price"]) && !emptyempty($_POST["minimum_price"]) && !emptyempty($_POST["maximum_price"]))
- {
- $query .= "AND price BETWEEN '".$_POST["minimum_price"]."' AND '".$_POST["maximum_price"]."'";
- }
- if(isset($_POST["minimum_price2"], $_POST["maximum_price2"]) && !emptyempty($_POST["minimum_price2"]) && !emptyempty($_POST["maximum_price2"]))
- {
- $items = array();
- foreach (range($_POST["minimum_price2"], $_POST["maximum_price2"]) as $letter) {
- $items[] = $letter;
- }
- $it=implode("','", $items);
- $it="'".$it."'";
- //$query .= "AND color LIKE '".$_POST["minimum_price2"].'%'."' OR color LIKE '".$_POST["maximum_price2"].'%'."'";
- //$query .= "AND color LIKE '".$_POST["minimum_price2"].'%'."' AND color LIKE '".$_POST["maximum_price2"].'%'."'";
- //$query .= "AND (color LIKE '".$_POST["minimum_price2"].'%'."') OR (color LIKE '".$_POST["maximum_price2"].'%'."')";
- //$query .= "AND (color LIKE '".$_POST["minimum_price2"].'%'."' OR color LIKE '".$_POST["maximum_price2"].'%'."')";
- $query .= "AND color in($it)";
- }
- if(isset($_POST["minimum_price3"], $_POST["maximum_price3"]) && !emptyempty($_POST["minimum_price3"]) && !emptyempty($_POST["maximum_price3"]))
- {
- $clarity = array("0" => "SI2", "25" => "SI1", "50" => "VS2", "75" => "VS1", "100" => "VVS2", "125" => "VVS1", "150" => "IF", "175" => "FL");
- //$clarity[$_POST["minimum_price3"]];
- //$clarity[$_POST["maximum_price3"]];
- $key_arr=array();
- $clarity_key= array("0","25","50","75", "100", "125", "150", "175");
- $min_key = array_search($_POST["minimum_price3"], $clarity_key);
- $max_key = array_search($_POST["maximum_price3"], $clarity_key);
- for($i = $min_key; $i<=$max_key; $i++){
- $key_arr[]=$clarity_key[$i];
- }
- //print_r($key_arr);
- $cnt= count($key_arr);
- //echo $clarity["0"];
- for($i = 0; $i<$cnt; $i++){
- $value_arr[]=$clarity["$key_arr[$i]"];
- }
- //print_r($value_arr);
- $it2=implode("','", $value_arr);
- $it2="'".$it2."'";
- $query .= "AND clarity in($it2)";
- }
- if(isset($_POST["shape"]))
- {
- $brand_filter = implode("','", $_POST["shape"]);
- $query .= "AND shape IN('".$brand_filter."') ";
- }
- $query .= " ORDER BY price ASC";
- $statement = $connect->prepare($query);
- $statement->execute();
- $result = $statement->fetchAll();
- $total_row = $statement->rowCount();
- $output = '';
- if($total_row > 0)
- {
- foreach($result as $row)
- {
- $output .= '
-
'.$row["shape"].' '.$row["carat"].' '.$row["color"].' '.$row["clarity"].' '.$row["cut"].' '.$row["report"].' '.$row["origin"].' '.$row["price"].' - ';
- }
- }
- else
- {
- $output = '
No Data Found
'; - }
- echo $output;
- }
- ?>
- /* Title : Ajax Pagination with jQuery & PHP
- Example URL : http://www.sanwebe.com/2013/03/ajax-pagination-with-jquery-php */
- $connect = new PDO("mysql:host=localhost;dbname=diamond", "root", "");
- ?>
Code is not visible.
dip vyasPosted Sep 10, 2019, 10:56 PM
Search for Diamonds