Exemplos de Evengyl\db App em PHP

Exemplo n.º 1

Arquivo: Breadcrumb.class.php Projeto: evengyl/poo_advanced

 public function db_get_current_sub_categ()
 {
     //on détermine l'option a envoyer pour la requète préparée, ici on envoie l'ID
     $options = array(':id' => $_GET['id_sub_categ']);
     $current_sub_categ = \Evengyl\db\App::DB()->prepare_pdo("SELECT name FROM test_sub_category WHERE id = :id", $options, "Evengyl\\module\\Breadcrumb", true);
     return $current_sub_categ;
 }

Exemplo n.º 2

Arquivo: Home_page.class.php Projeto: evengyl/poo_advanced

 public static function db_get_random_article($array_random_number)
 {
     foreach ($array_random_number as $id_random) {
         $res_sql[] = App::DB()->query_pdo("SELECT * FROM test_articles WHERE id= '" . $id_random . "'", "Evengyl\\module\\Articles");
     }
     return $res_sql;
 }

Exemplo n.º 3

Arquivo: show_logo.php Projeto: evengyl/poo_advanced

<div class="col-xs-12 col-sm-12 col-md-12 col-lg-12 col-without-padding header" style="z-index: 10000;">
    <div class="col-lg-3" style="padding-left:25px;">
        <?php 
use Evengyl\db\App;
$name_website = App::set_logo_website();
?>
<img style='margin-top: 45px; ' class='img-responsive' src='<?php 
echo $base_path . '' . $name_website;
?>
'/>
    </div>
    <div class="col-lg-5">

    </div>
    <div class="col-lg-4" style="margin-top: auto">
        <img style='margin-top: 25px;' class='img-responsive' src='<?php 
echo $base_path;
?>
/images/logo_matedex.png'/>
    </div>
</div>

Exemplo n.º 4

Arquivo: index.php Projeto: evengyl/robot_game

<?php

require "../app/autoloader.php";
\Evengyl\Autoloader::register();
$base_path = "/robot_game/public";
$app = \Evengyl\db\App::get_instance();
// enregistrement du logo
ob_start();
require '../content/show_logo.php';
$header = ob_get_clean();
// enregistrement du breadcumb
ob_start();
require '../content/show_breadcumb.php';
$breadcumb_content = ob_get_clean();
//start menu lateral + la home page avec des article aléatoire + prochainement des textes et articles + explication
ob_start();
if (isset($_GET['page'])) {
    $page = $_GET['page'];
} else {
    $page = 'home';
}
if ($page == 'home') {
    $title_page = 'Home Page';
}
require "../content/show_menu_lateral.php";
$menu_lateral = ob_get_clean();
ob_start();
$content = ob_get_clean();
ob_start();
$random_home_page = ob_get_clean();
require_once "../content/templates/default.php";

Exemplo n.º 5

Arquivo: Construct_categ.class.php Projeto: evengyl/poo_advanced

 public static function db_get_name_current_subcateg($id_sub_categ)
 {
     return App::DB()->query_pdo("SELECT name AS name_sub_categ FROM test_sub_category WHERE id = '" . $id_sub_categ . "'", "");
 }