File: fwphp/01mater/fw_popel/lnktbl.php

Recommend this page to a friend!
  Classes of Slavko Srakocic  >  B12 PHP FW  >  fwphp/01mater/fw_popel/lnktbl.php  >  Download  
File: fwphp/01mater/fw_popel/lnktbl.php
Role: Example script
Content type: text/plain
Description: Example script
Class: B12 PHP FW
Manage database records with a PDO CRUD interface
Author: By
Last change:
Date: 2 months ago
Size: 1,059 bytes
 

Contents

Class file image Download
<?php
// J:\awww\www\fwphp\01mater\fw_popel\lnktbl.php
/**
* Page lists all borrowed books (products in invoice items rows)
*
*/
              //include('common.inc.php');
//
showHdr('Lended Books (products in invoice items rows)');
// Get all lended books list
$brs = Model::getBorrowers();
$totalBooks = Model::getBorrowerCount();



// display table
?>
Total borrowed books: <?=$totalBooks?>
<table width="100%" border="1" cellpadding="3">
<tr style="font-weight: bold">
<td>Title</td><td>Author</td><td>Borrowed by</td><td>Borrowed on</td><td>Return</td>
</tr>
<?php
// Iterate over every row and display it
while($br = $brs->fetch())
{
 
$b = $br->getDetailByID();
 
$a = $b->getAuthor();
 
?>
<tr>
  <td><?=htmlspecialchars($b->title)?></td>
  <td><?=htmlspecialchars("$a->firstName $a->lastName")?></td>
  <td><?=htmlspecialchars($br->name)?></td>
  <td><?=date('Y.m.d', $br->dt)?></td>
  <td>
  <a href="lnktbl_delrec.php?borrower=<?=$br->id?>">Return</a>
  </td>
  </tr>
<?php
}
?>
</table>
<?php
// Display footer
                   //showFtr();

For more information send a message to info at phpclasses dot org.