One Hat Cyber Team

Your IP : 172.69.130.198

Server IP : 188.114.97.4

Server : Linux thuru 6.5.11-4-pve #1 SMP PREEMPT_DYNAMIC PMX 6.5.11-4 (2023-11-20T10:19Z) x86_64

Server Software : Apache/2.4.51 (Unix) OpenSSL/1.0.2k-fips

PHP Version : 7.3.33

View File Name : test_tree.php

<?php include('../../connections.php'); ?>  
<?php


                                           if (isset($_GET['pageno'])) {
                                              $pageno = $_GET['pageno'];
                                          } else {
                                              $pageno = 1;
                                          }
                                          
                                           $no_of_records_per_page = 10;

                                          $offset = ($pageno-1) * $no_of_records_per_page; 

                                          //find the total number of results stored in the database  

                                      $query = "SELECT * FROM `users` inner join `newuser_plants` WHERE users.user_id=newuser_plants.user_id AND       newuser_plants.status='activate'";  
                        
                            $result = mysqli_query($connect,$query);

                           echo  $total_rows = mysqli_num_rows($result);

                            $total_pages = ceil($total_rows / $no_of_records_per_page);



                  $query = "SELECT * FROM `users` inner join `newuser_plants` WHERE users.user_id=newuser_plants.user_id AND newuser_plants.status='activate' ORDER BY newuser_plants.created_time DESC LIMIT   " . $offset . "," . $no_of_records_per_page;


                    // $query="SELECT * FROM `users` inner join `newuser_plants` WHERE users.user_id=newuser_plants.user_id AND newuser_plants.status='activate' ORDER BY newuser_plants.created_time DESC LIMIT  " . $page_first_result . ',' . $results_per_page;  




                                                    $result = mysqli_query($connect,$query) or die(mysqli_error($connect));
                                                    
                                                    $i;
                                                    while($row=mysqli_fetch_assoc($result)){
                                                      
                                                             echo    $row['plant_name'];
                                                      
                                                        
                                                    }
                                                
                                                ?>