Example #1
0
                        <th class="text-center">Nazwa</th></th>
                        <th class="text-center">Numer Pesel</th></th>
                        <th class="text-center">Ilość numerów</th>
                        <th class="text-center">Opcje</th>
                     </thead>
                     <tbody class="text-center">
                        <?php 
        $result = mysql_query("SELECT * FROM customers WHERE (" . $sql . ") AND (length(nr_pes_nip) = 11);") or die(mysql_error());
        if ($result) {
            $i = 1;
            while ($row = mysql_fetch_assoc($result)) {
                echo "<tr>";
                echo "<td>{$i}</td>";
                echo "<td><a href=\"profil.php?id=" . $row['id'] . "\">" . $row['nazwa'] . "</a></td>";
                echo "<td>" . $row['nr_pes_nip'] . "</a></td>";
                echo "<td><span class=\"badge\">" . how_many_number($row['id']) . "</span></td>";
                echo "<td><a href=\"profil.php?id=" . $row['id'] . "\" target=\"_blank\" class=\"btn btn-info btn-sm\">Opcje</a></td>";
                echo "</tr>";
                $i++;
            }
        }
        ?>
                     </tbody>
                  </table>
               <?php 
    }
    ?>
      </div>
   </div>

</div>
Example #2
0
     $i = 1;
     while ($row = mysql_fetch_assoc($result)) {
         if (!isset($customer)) {
             $customer = $row['customers_id'];
         }
         if ($customer == $row['customers_id'] and $i != 1) {
             echo "<tr>";
             echo "<td class=\"text-center\"><a id=\"" . $i . "\">" . $i . "</a></td>";
             echo "<td class=\"text-center\"> </td>";
             echo "<td class=\"text-center\"><span class=\"fa fa-mobile\"></span> " . $row['nr_tel'] . "</td>";
             echo "<td class=\"text-center\">" . $row['data_zawarcia'] . "</td>";
             echo "<tr>";
         } else {
             $customer = $row['customers_id'];
             echo "<tr>";
             echo "<td colspan=\"4\"><h4><a href=\"profil.php?id=" . $row['customers_id'] . "\"><b>" . who_is_name($row['customers_id']) . "</b></a> " . who_is_number($row['customers_id']) . " <span class=\"badge\">" . how_many_number($row['customers_id']) . "</span></h4></td>";
             echo "</tr>";
             echo "<tr>";
             echo "<td class=\"text-center\"><a id=\"" . $i . "\">" . $i . "</a></td>";
             echo "<td class=\"text-center\"> </td>";
             echo "<td class=\"text-center\"><span class=\"fa fa-mobile\"></span> " . $row['nr_tel'] . "</td>";
             echo "<td class=\"text-center\">" . $row['data_zawarcia'] . "</td>";
             echo "<tr>";
         }
         $i++;
     }
     ?>
               </tbody>
            </table>
         <?php 
 } else {
Example #3
0
                ?>
               <table class="table table-striped table-hover">
                  <thead>
                     <tr>
                        <th>Imie nazwisko/Nazwa</th>
                        <th class="text-center">Nr Pesel/NIP</th>
                        <th class="text-center">Ilość numerów</th>
                     </tr>
                  </thead>
                  <tbody>
               <?php 
                while ($row = mysql_fetch_assoc($name_customer)) {
                    echo "<tr>";
                    echo "<td><a href=\"profil.php?id=" . $row['id'] . "\">" . $row['nazwa'] . "</a></td>";
                    echo "<td class=\"text-center\">" . $row['nr_pes_nip'] . "</td>";
                    echo "<td class=\"text-center\"><span class=\"badge\">" . how_many_number($row['id']) . "</td>";
                    echo "<tr>";
                }
                ?>
               </tbody>
               </table>
               <?php 
            }
            break;
    }
    ?>
   </div>
</div>
<?php 
} else {
    ?>