Forum PHP.pl

[SQL] pobierz, plaintext 
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE
   TABLE_SCHEMA = 'my_database' 
   AND TABLE_NAME = 'my_table'
   AND COLUMN_NAME LIKE 'name_%';
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php var_dump($_SERVER); ?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php var_dump($_SERVER); ?>
[PHP] pobierz, plaintext 

[HTML] pobierz, plaintext 
RewriteEngine On
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^miasto/([^/]+)$ miasto/site.php?mlink=$1 [L]
 
RewriteBase /
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule (.+)$ site.php?link=$1 [L]
[HTML] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT oczekujacy.id                AS id,
       oczekujacy.pacjent           AS pacjent,
       oczekujacy.telefon           AS telefon,
       oczekujacy.lekarz            AS lekarz,
       oczekujacy.kategoria         AS kategoria,
       oczekujacy.pilne             AS pilne,
       oczekujacy.dojazd            AS dojazd,
       oczekujacy.dostepny          AS dostepny,
       oczekujacy.informacje        AS informacje,
       oczekujacy.wpisany           AS wpisany,
       oczekujacy.archiwum          AS archiwum,
       MAX(oczekujacytelefon.polaczenie) AS polaczenie
FROM oczekujacy
         LEFT JOIN oczekujacytelefon ON oczekujacy.id = oczekujacytelefon.kto
 
WHERE archiwum = 0
GROUP BY oczekujacy.id
ORDER BY kategoria ASC, pilne DESC
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
$var = str_replace(chr(0), '', $var  '');
[PHP] pobierz, plaintext 

[HTML] pobierz, plaintext 
<div data-comment-id="1" data-element="comment" class="comment">
  <a class="comment_button" href="#" data-action="up">
    <div class="1">plus +</div>
  </a>
  <div class="suma">
    <input class="sumai" type="number" value="1">
  </div>
 
  <a class="comment_button" href="#" data-action="down">
    <div class="0">minus -</div>
  </a>
</div>
<div data-comment-id="2" data-element="comment" class="comment">
  <a class="comment_button" href="#" data-action="up">
    <div class="1">plus +</div>
  </a>
  <div class="suma">
    <input class="sumai" type="number" value="1">
  </div>
 
  <a class="comment_button" href="#" data-action="down">
    <div class="0">minus -</div>
  </a>
</div>
<div data-comment-id="3" data-element="comment" class="comment">
  <a class="comment_button" href="#" data-action="up">
    <div class="1">plus +</div>
  </a>
  <div class="suma">
    <input class="sumai" type="number" value="1">
  </div>
 
  <a class="comment_button" href="#" data-action="down">
    <div class="0">minus -</div>
  </a>
</div>
[HTML] pobierz, plaintext 

[HTML] pobierz, plaintext 
.comment {
  background: #ccc;
  padding: 10px;
  margin-bottom: 20px;
}
 
.commented [data-action] {
  font-weight: bold;
  color: green;
}
 
.commented__down [data-action="up"] {
  display: none;
}
 
.commented__up [data-action="down"] {
  display: none;
}
[HTML] pobierz, plaintext