PHP Classes
elePHPant
Icontem

File: examples/library/www/index.php

Recommend this page to a friend!
  Classes of Victor Bolshov  >  Tiny PHP ORM Framework  >  examples/library/www/index.php  >  Download  
File: examples/library/www/index.php
Role: Example script
Content type: text/plain
Description: Example script
Class: Tiny PHP ORM Framework
Map objects to databases using composed queries
Author: By
Last change: improving the library example
Date: 3 years ago
Size: 940 bytes
 

Contents

Class file image Download
<?php

use \tinyorm\Select;

include
__DIR__ . "/../bootstrap.php";

echo \
library\View::render("header.php", [
   
"title" => "Tinyorm Library Example Home",
   
"description" => \library\View::render("sidebar/index.html"),
]);

$bookCount = (new Select("book"))->count();
$authorCount = (new Select("author"))->count();
$editionCount = (new Select("edition"))->count();
$stats = (new Select(
   
"edition",
   
"AVG(instance_count) AS avg_instance_count,
        SUM(instance_count) AS total_instance_count"
))
    ->
execute()
    ->
fetch();
$instanceCount = $stats["total_instance_count"];
$instanceAvg = $stats["avg_instance_count"];

echo \
library\View::render(
   
"index.php",
    [
       
"bookCount" => $bookCount,
       
"authorCount" => $authorCount,
       
"instanceCount" => $instanceCount,
       
"editionCount" => $editionCount,
       
"instanceAvg" => $instanceAvg,
    ]
);

echo \
library\View::render("footer.php"); ?>