Jump to content

result does not fetch according to the condition set


sashavalentina

Recommended Posts

I'm creating dynamic tabs with dynamic content by using Bootstrap in PHP Mysql. what I want to do here is, display the order_date on the nav-tab and the content of each nav-tab will be displayed by the date of the customer made their orders. The date in each nav-tab can be shown properly according to the condition set, but the content of each nav-tab does not show according to the condition set. It just displays all of the data. Can I know how can I display the content according to the condition set? Let's say I clicked on the '2021-09-09' tab, the order that is only made on this date will be shown as the content of this nav_tab. Any form of help will be appreciated. thanks in advance!

 

 

<?php 
        $tab_query = "SELECT id,cast(order_datetime as date) AS ordered_date , order_status FROM ordered_items GROUP BY ordered_date order by order_datetime DESC LIMIT 7";
        $tab_result = mysqli_query($conn, $tab_query);
        $tab_menu = '';
        $tab_content = '';
        $i = 0;
        while($row = mysqli_fetch_array($tab_result))
        {
         if($i == 0)
         {
          $tab_menu .= '
           <li class="active"><a href="#'.$row["ordered_date"].'" data-toggle="tab">'.$row["ordered_date"].'</a></li>
          ';
          $tab_content .= '
           <div id="'.$row["ordered_date"].'" class="tab-pane fade in active">
          ';
         }
         else
         {
          $tab_menu .= '
           <li><a href="#'.$row["ordered_date"].'" data-toggle="tab">'.$row["ordered_date"].'</a></li>
          ';
          $tab_content .= '
           <div id="'.$row["ordered_date"].'" class="tab-pane fade">
          ';
         }
         $product_query = "SELECT*, cast(order_datetime as date) AS products_ordered_date , order_status FROM ordered_items 
         LEFT JOIN products ON ordered_items.product_id = products.id
         WHERE order_datetime = '".$row["ordered_date"]."'";
         $product_result = mysqli_query($conn, $product_query);
         if(!mysqli_num_rows($product_result)) {    
          $tab_content .=  '<tr>
          <td colspan="5">
              <div class="badge badge-danger">No Order Found</div>
          </td>
        </tr>';         
          }
         while($sub_row = mysqli_fetch_array($product_result))
         {
          $tab_content .= '
          
          <tr>
          <td>
          #'.$sub_row["order_id"].'
          </td>
          <td>
          '.$sub_row["product_title"].'
          </td>
          <td>
          '.$sub_row["quantity"].'
          </td>
          <td>
          '.$sub_row["products_ordered_date"].'
          </td>
          <td>
          '.$sub_row["delivery_date"].'
          </td>
          </tr>
        
   ';
         }
         $tab_content .= '<div style="clear:both"></div></div>';
         $i++;
        }
?>

 <div class="col-12">
  <div class="card">
    <div class="card-header">
      <h4 class="card-title"> All Products</h4>
      <span>
        <a href="download-list/download-products.php" class="btn btn-info float-right mb-3"><i class="fa fa-download" aria-hidden="true"></i> Download Products List</a>
      </span>
      <span>
        <a href="download-list/download-products.php" class="btn btn-info float-right mb-3"><i class="fa fa-download" aria-hidden="true"></i> Download Products List</a>
      </span>
    </div>
      <div class="card-body">
      <ul class="nav nav-tabs">
      <li class="nav-item">
    <ul class="nav nav-tabs">
    <?php echo $tab_menu; ?>
    </ul>
      </li>
      </ul>
      </div>

      <div class="card-body">
                <div class="table-responsive" style="max-height: 70vh">
                  <table class="table">
                    <thead class="text-primary">
                      <th style=" position: sticky;top: 0; background: white" ;>
                        Order no
                      </th>
                      <th style=" position: sticky;top: 0; background: white" ;>
                        Product Name
                      </th>
                      <th style=" position: sticky;top: 0; background: white" ;>
                        Quantity
                      </th>
                      <th style=" position: sticky;top: 0; background: white" ;>
                        Order Date
                      </th>
                      <th style=" position: sticky;top: 0; background: white" ;>
                        Recieve by
                      </th>
                          <tr>
                          <?php echo $tab_content; ?>
                          </tr>
                     
                    </tbody>
                  </table>
                </div>
              </div>

 

Link to comment
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.

×
×
  • 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.