PHP primaryKeyLink 예제들

예제 #1

파일: rasy.php 프로젝트: beowoolf/DogIdentity

?>
 
        <?php 
$mysql = dbConnect();
$stmt = $mysql->prepare("SELECT RASA.ID, RASA.NAZWA, RASA.FCI_ID, FCI.NAZWA " . "FROM RASA " . "JOIN FCI ON FCI.ID = RASA.FCI_ID");
$stmt->bind_result($id, $nazwa, $fci_id, $fciNazwa);
if (!$stmt) {
    die;
}
$stmt->execute();
echo 'Rasy:<br>';
echo '<a href="nowa_rasa.php">Dodaj nową rasę</a>';
echo '<table class="data">';
echo '<tr class="tableheader">';
echo '<th>ID</th>';
echo '<th>Nazwa</th>';
echo '<th>FCI</th>';
echo '</tr>';
while ($stmt->fetch()) {
    echo "<tr>";
    echo "<td>" . primaryKeyLink('rasa', $id) . "</td>";
    echo "<td>" . $nazwa . "</td>";
    echo '<td>' . $fci_id . ': ' . $fciNazwa . '</td>';
    echo "</tr>\n";
}
echo "</table>\n";
$stmt->close();
?>
    </body>
</html>

예제 #2

파일: functions.php 프로젝트: beowoolf/DogIdentity

function showTablePies($where)
{
    $mysql = dbConnect();
    $stmt = $mysql->prepare("SELECT PIES.ID, PIES.IMIE, PIES.SUKA, PIES.OZNACZENIE, PIES.OJCIEC, PIES.MATKA, PIES.M_ID, PIES.R_ID, " . "MIOT.URODZONY, RASA.NAZWA " . "FROM PIES " . "JOIN MIOT ON MIOT.ID = PIES.M_ID " . "JOIN RASA ON RASA.ID = PIES.R_ID " . $where);
    $stmt->bind_result($id, $imie, $suka, $oznaczenie, $ojciec, $matka, $m_id, $r_id, $urodzony, $rasa);
    if (!$stmt) {
        die;
    }
    $stmt->execute();
    echo 'Psy:<br>';
    echo '<a href="nowy_pies.php">Dodaj nowego psa</a>';
    echo '<table class="data">';
    echo '<tr class="tableheader">';
    echo '<th>ID</th>';
    echo '<th>Imię</th>';
    echo '<th>Płeć</th>';
    echo '<th>Oznaczenie</th>';
    echo '<th>Ojciec</th>';
    echo '<th>Matka</th>';
    echo '<th>ID miotu / data urodzenia</th>';
    echo '<th>ID rasy</th>';
    echo '</tr>';
    while ($stmt->fetch()) {
        echo "<tr>";
        echo "<td>" . primaryKeyLink('pies', $id) . "</td>";
        echo "<td>" . $imie . "</td>";
        echo "<td>" . getSex($suka) . "</td>";
        echo "<td>" . $oznaczenie . "</td>";
        echo "<td>" . $ojciec . "</td>";
        echo "<td>" . $matka . "</td>";
        echo '<td>' . foreignKeyLink('miot', $m_id, $urodzony) . '</td>';
        echo '<td>' . foreignKeyLink('rasa', $r_id, $rasa) . '</td>';
        echo "</tr>\n";
    }
    echo "</table>\n";
    $stmt->close();
}

예제 #3

파일: oddzialy.php 프로젝트: beowoolf/DogIdentity

if (!$stmt) {
    die;
}
$stmt->execute();
echo 'Oddziały:<br>';
echo '<a href="nowy_oddzial.php">Dodaj nowy oddział</a>';
echo '<table class="data">';
echo '<tr class="tableheader">';
echo '<th>ID</th>';
echo '<th>Nazwa</th>';
echo '<th>Numer</th>';
echo '<th>Wzór tatuażu</th>';
echo '<th>Adres</th>';
echo '<th>Telefon</th>';
echo '</tr>';
while ($stmt->fetch()) {
    echo "<tr>";
    echo "<td>" . primaryKeyLink('oddzial', $id) . "</td>";
    echo "<td>" . $nazwa . "</td>";
    echo "<td>" . $numer . "</td>";
    echo "<td>" . $tatuaz . "</td>";
    echo "<td>" . $adres . "</td>";
    echo "<td>" . $telefon . "</td>";
    echo "</tr>\n";
}
echo "</table>\n";
$stmt->close();
include "footer.php";
?>
 

예제 #4

파일: hodowcy.php 프로젝트: beowoolf/DogIdentity

$stmt = $mysql->prepare("SELECT HODOWCA.ID, HODOWCA.IMIE, HODOWCA.NAZWISKO, HODOWCA.TELEFON, HODOWCA.ADRES " . "FROM HODOWCA ");
$stmt->bind_result($id, $imie, $nazwisko, $telefon, $adres);
if (!$stmt) {
    die;
}
$stmt->execute();
echo 'Hodowcy:<br>';
echo '<a href="nowy_hodowca.php">Dodaj nowego hodowcę</a>';
echo '<table class="data">';
echo '<tr class="tableheader">';
echo '<th>ID</th>';
echo '<th>Imię</th>';
echo '<th>Nazwisko</th>';
echo '<th>Telefon</th>';
echo '<th>Adres</th>';
echo '</tr>';
while ($stmt->fetch()) {
    echo "<tr>";
    echo "<td>" . primaryKeyLink('hodowca', $id) . "</td>";
    echo "<td>" . $imie . "</td>";
    echo "<td>" . $nazwisko . "</td>";
    echo "<td>" . $telefon . "</td>";
    echo "<td>" . $adres . "</td>";
    echo "</tr>\n";
}
echo "</table>\n";
$stmt->close();
include "footer.php";
?>
 

예제 #5

파일: uzytkownicy.php 프로젝트: beowoolf/DogIdentity

<?php 
include "header.php";
?>
 
        <?php 
$mysql = dbConnect();
$stmt = $mysql->prepare("SELECT UZYTKOWNICY.ID, UZYTKOWNICY.LOGIN " . "FROM UZYTKOWNICY " . "ORDER BY UZYTKOWNICY.LOGIN");
$stmt->bind_result($id, $login);
if (!$stmt) {
    die;
}
$stmt->execute();
echo 'Użytkownicy:<br>';
echo '<a href="nowy_uzytkownik.php">Dodaj użytkownika</a>';
echo '<table class="data">';
echo '<tr class="tableheader">';
echo '<th>ID</th>';
echo '<th>Login</th>';
echo '</tr>';
while ($stmt->fetch()) {
    echo "<tr>";
    echo "<td>" . primaryKeyLink('uzytkownik', $id) . "</td>";
    echo "<td>" . $login . "</td>";
    echo "</tr>\n";
}
echo "</table>\n";
$stmt->close();
?>
    </body>
</html>