<?php
 
 /* 
 
 * Project:  AX MVC
 
 * File     : /models/Classificado.php
 
 * Purpose  : model for the error controller.
 
 * Author   : Axel Alexander Martins Benites
 
 */
 
 
require_once 'bootstrap.php'; 
 
require_once 'ConnectionFactory.php'; 
 
require_once 'entities/Notificacao.php'; 
 
 
 
#1 - conectar ao mysql 
 
#2 - criar a tabela Notifica??o
 
  
 
 
// repositorio
 
$retorno    = ConnectionFactory::getInstance()->RepositoryfindBy('Notificacao',   
 
        array('usuario' => $id , 'id' => 2),
 
        array('id'=>'DESC'), null, null );
 
 
print_r ( $retorno ) ;
 
 
 
// query 
 
function getAll($id){
 
        $strSql   = "SELECT n from Notificacao n WHERE n.id = :id ";
 
        $setParam = array("id" => $id);
 
        return ConnectionFactory::getInstance()->criarQuery(
 
        $strSql , $setParam , 2);
 
}
 
 
$retorno  = getAll(1);
 
 
print_r ( $retorno ) ;
 
 |