0

Hello,

I was wondering if any one help me ouut guide me or let me know how do i filter records using php like it is done in property listings product listings etc I am stuck up can anypne help me out with that.

Thank You

<form action="" method="POST">
        <div class="option">
            <select>
            <?php 
                $get_prod = find_all_products();
                echo "<option>Brand</option>";
                while($prod_row = mysqli_fetch_assoc($get_prod)) {
                    echo "<option>" . $prod_row["brand"] . "</option>";
                }
            ?>
            </select>
        </div>

        <div class="option">
            <select>
                <option>Model</option>
            <?php 
                $get_prod = find_all_products();    
                while($prod_row = mysqli_fetch_assoc($get_prod)) {
                    echo "<option>" . $prod_row["model"] . "</option>";
                }
            ?>
            </select>
        </div>

        <div class="option">
            <select>
                <option>Refrence</option>
            <?php 
                $get_prod = find_all_products();    
                while($prod_row = mysqli_fetch_assoc($get_prod)) {
                    echo "<option>" . $prod_row["reff"] . "</option>";
                }
            ?>  
            </select>
        </div>

        <div class="option">
            <select>
                <option>Material</option>
            <?php 
                $get_prod = find_all_products();    
                while($prod_row = mysqli_fetch_assoc($get_prod)) {
                    echo "<option>" . $prod_row["mtrl"] . "</option>";
                }
            ?>  
            </select>
        </div>

        <div class="option">
            <select>
                <option>Condition</option>
            <?php 
                $get_prod = find_all_products();    
                while($prod_row = mysqli_fetch_assoc($get_prod)) {
                    echo "<option>" . $prod_row["cond"] . "</option>";
                }
            ?>  
            </select>
        </div>

        <div class="option">
            <select>
                <option>Seller</option>
            <?php 
                $get_prod = find_all_products();    
                while($prod_row = mysqli_fetch_assoc($get_prod)) {
                    echo "<option>" . $prod_row["seller"] . "</option>";
                }
            ?>  
            </select>
        </div>

        <div class="option">
            <select>
                <option>Box</option>
            <?php 
                $get_prod = find_all_products();    
                while($prod_row = mysqli_fetch_assoc($get_prod)) {
                    echo "<option>" . $prod_row["box"] . "</option>";
                }
            ?>  
            </select>
        </div>

        <div class="option">
            <select>
                <option>Discount %</option>
            <?php 
                $get_prod = find_all_products();    
                while($prod_row = mysqli_fetch_assoc($get_prod)) {
                    echo "<option>" . $prod_row["disc"] . "</option>";
                }
            ?>  
            </select>
        </div>

        <div class="option">
            <select>
                <option>Papers</option>
            <?php 
                $get_prod = find_all_products();    
                while($prod_row = mysqli_fetch_assoc($get_prod)) {
                    echo "<option>" . $prod_row["paper"] . "</option>";
                }
            ?>  
            </select>
        </div>

        <div class="option">
            <select>
                <option>Price $</option>
            <?php 
                $get_prod = find_all_products();    
                while($prod_row = mysqli_fetch_assoc($get_prod)) {
                    echo "<option>" . $prod_row["price"] . "</option>";
                }
            ?>  
            </select>
        </div>
3
Contributors
2
Replies
21
Views
2 Years
Discussion Span
Last Post by diafol
0

From the looks of it.. your function find_all_products() makes a database call, then you churn through the results as needed.

This is just terribly inefficient. You do not seem to be changing the SQL in any way for each call, so just do it once and store the values locally in either an object, or an associative array (if that makes you happy). Or, an array of Objects (which seems to be the best solution in your case).

Then, instead of doing the database calls over and over again, you simply iterate through your local array of objects and pull whatever data you need at the time.

Hope that helps!

0

Agree with RT. This makes no sense at all. Looks to me that you have one big table - which is wrong. Your data should be in related tables.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.