Example #1
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 #2
0
                     <?php 
     if (!isset($_POST['InputNrTel'])) {
         $_POST['InputNrTel'] = "";
     }
     $dlugosc = strlen($_POST['InputNrTel']);
     if ($dlugosc == 9) {
         $result = mysql_query("SELECT id, customers_id, nr_tel, data_zawarcia FROM tabela_um_an WHERE nr_tel = '" . $_POST['InputNrTel'] . "' AND  typ_uslugi = 'KUD' AND salon = '" . $_SESSION['salon'] . "';") or die(mysql_error());
     } else {
         $result = mysql_query("SELECT id, customers_id, nr_tel, data_zawarcia FROM tabela_um_an WHERE data_zawarcia >= '" . $_POST['InputDateFrom'] . "' AND data_zawarcia <= '" . $_POST['InputDateTo'] . "' AND  typ_uslugi = 'KUD' AND salon = '" . $_SESSION['salon'] . "';") 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['customers_id'] . "\">" . who_is_name($row['customers_id']) . "</a></td>";
             echo "<td class=\"text-center\">" . who_is_number($row['customers_id']) . "</td>";
             echo "<td>" . $row['nr_tel'] . "</td>";
             echo "<td>" . $row['data_zawarcia'] . "</td>";
             echo "<td><a href=\"profil.php?id=" . $row['customers_id'] . "\" class=\"btn btn-info btn-xs\"><span class=\"glyphicon glyphicon-wrench\"></span> Opcje</a></td>";
             echo "</tr>";
             $i++;
         }
     }
     ?>
                  </tbody>
               </table>
            <?php 
 }
 ?>
   </div>