Esempi di codice in PHP per LTE\AdminLte2

Esempio n. 1

0

Mostra file

File: index.php Progetto: jambonbill/midi.jambonbill.org

<?php

// MIDI
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("MIDI Sequencer");
echo $admin;
?>
<section class="content-header">
  <h1><i class='fa fa-keyboard-o'></i> MIDI Sequencer
  <small></small>
  </h1>
</section>


<section class="content">


<script type="text/javascript" src='js/keyboard.js'></script>

<?php 
$admin->footer("Midi - Sequencer");
$admin->end();

Esempio n. 2

0

Mostra file

File: login.php Progetto: jambonbill/expenses.jambonbill.org

<?php

header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("Login");
$admin->config()->menusearch = false;
//disable menu search
$admin->config()->menu = (object) [];
//unset the global menu
echo $admin->html();
//
?>
<section class='content'>
<?php 
$pdo = new PDO\Pdo();
$db = $pdo->db();
$UD = new PDO\UserDjango($db);
//echo "<pre>";print_r($_POST);exit;
// Check django login
if (isset($_POST['email']) && isset($_POST['password'])) {
    //if ($admin->django->login($_POST['email'], $_POST['password'])) {
    if ($UD->login($_POST['email'], $_POST['password'])) {
        echo "Login ok";
        echo "<script>document.location.href='../home/';</script>";
    } else {
        echo new LTE\Callout("danger", "<i class='fa fa-warning'></i> Credentials error", "Your email or password is incorrect. Please try again");
        echo "<a href=index.php class='btn btn-default'><i class='fa fa-sign-in'></i> Log in</a>";
        //echo "<script>document.location.href='../home/';</script>";
    }

Esempio n. 3

0

Mostra file

File: ctrl.php Progetto: jambonbill/ip.jambonbill.org

<?php

//Admin login page
header('Content-Type: application/json');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
switch ($_POST['do']) {
    case "login":
        print_r($_POST);
        break;
    case "logout":
        print_r($_POST);
        $admin->logout();
        break;
    case "testProfile":
        $dat = [];
        $dat['POST'] = $_POST;
        $configfile = __DIR__ . "/../../profiles/" . $_POST['conf'];
        if (is_file($configfile)) {
            $conf = json_decode(file_get_contents($configfile));
            //exit;
            if ($err = json_last_error_msg()) {
                if ($err != 'No error') {
                    $dat['error'] = 'Profile error (json):' . $err;
                    exit(json_encode($dat));
                }
            }
            try {
                $dsn = "mysql:host=" . $conf->pdo->host . ";";
                $db = new \PDO($dsn, $conf->pdo->user, $conf->pdo->pass);

Esempio n. 4

0

Mostra file

File: login.php Progetto: jambonbill/ip.jambonbill.org

<?php

header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("Login");
$admin->config()->menusearch = false;
//disable menu search
$admin->config()->menu = (object) [];
//unset the global menu
$admin->config()->layout->{'sidebar-collapse'} = true;
echo $admin;
?>
<section class='content'>
<?php 
//print_r($_POST);
//print_r($_SESSION);
$pdo = new PDO\Pdo();
$UD = new PDO\UserDjango($pdo->db());
//echo "<pre>";print_r($_POST);exit;
// Check django login
if (isset($_POST['email']) && isset($_POST['password'])) {
    //if ($admin->django->login($_POST['email'], $_POST['password'])) {
    if ($UD->login($_POST['email'], $_POST['password'])) {
        ob_clean();
        header('location: ../login');
        exit;
        //echo "<pre>Login ok - redirecting...</pre>";
        //echo "<script>document.location.href='../home/';</script>";
    } else {

Esempio n. 5

0

Mostra file

File: index.php Progetto: jambonbill/midi.jambonbill.org

<?php

// JasMid
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("Midifiles");
echo $admin;
?>
<section class="content-header">
  <h1><i class='fa fa-list'></i> Midifiles
  <small></small>
  </h1>
</section>

<section class="content">

<div class='row'>
	<div class='col-sm-12'>
	<?php 
include "box_filter.php";
include "box_files.php";
?>
	</div>

</div>

<script type="text/javascript" src="js/main.js"></script>

<?php

Esempio n. 6

0

Mostra file

File: index.php Progetto: jambonbill/expenses.jambonbill.org

<?php

// Expenses visualisation //
// Stats
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("Stats");
echo $admin;
//
$EXP = new Expenses\Expenses();
if (!$EXP->user_id()) {
    header("location:../login/logout.php");
    die("Error:!user_id");
}
?>
<section class="content-header">
  <h1><i class='fa fa-bar-chart'></i> Stats</h1>
</section>

<section class="content">
	
    <div class="row">
        <div class='col-md-12'>
      	<?php 
// Search form //
include "box_filter.php";
// search results //
$box = new LTE\Box();
$box->id("boxResult");

Esempio n. 7

0

Mostra file

File: index.php Progetto: jambonbill/midi.jambonbill.org

<?php

// MIDI SYSEX
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("Sysex");
echo $admin;
?>
<section class="content-header">
  <h1><i class='fa fa-terminal'></i> Sysex
  </h1>
</section>


<section class="content">

<div class='row'>

	<div class='col-sm-6'>
	<?php 
include "box_inputs.php";
?>
	</div>

	<div class='col-sm-6'>
	<?php 
include "box_outputs.php";
?>
	</div>

Esempio n. 8

0

Mostra file

File: index.php Progetto: jambonbill/midi.jambonbill.org

<?php

header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("Volume meter");
echo $admin;
// https://gilian.web.elte.hu/demos/spectrum_analyzer/index.html
?>
<style type="text/css" src='css/spectrum.css'></style>
<section class="content-header">
  <h1><i class='fa fa-microphone'></i> Volume
  <small></small>
  </h1>
</section>

<section class="content">

<p>This sample shows how to implement a clip-indicating volume meter in Web Audio, using a ScriptProcessor.  
It's necessary to use a ScriptProcessor in order to not miss any clipping samples - otherwise you could implement this using a RealtimeAnalyser to only grab samples when necessary.</p>
		
		<canvas id="meter" width="500" height="50"></canvas>

		<p>The usage is quite easy:
		<pre>var meter = createAudioMeter(audioContext,clipLevel,averaging,clipLag);

audioContext: the AudioContext you're using.
clipLevel: the level (0 to 1) that you would consider "clipping".  Defaults to 0.98.
averaging: how "smoothed" you would like the meter to be over time.  
Should be between 0 and less than 1.  Defaults to 0.95.

Esempio n. 9

0

Mostra file

File: index.php Progetto: jambonbill/ip.jambonbill.org

<?php

header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
//$_SERVER['REMOTE_ADDR']='61.15.194.152';//deboug
$REMOTE_ADDR = $_SERVER['REMOTE_ADDR'];
//echo 'ok';
$admin = new LTE\AdminLte2();
//$admin->config()->title=$REMOTE_ADDR;
//menu override//
$IP = new IP\IP();
$admin->config()->menu = $IP->menuleft();
if (!$IP->is_staff()) {
    $admin->config()->layout->{'sidebar-collapse'} = true;
    //print_r($IP->user());
}
echo $admin;
?>

<section class="content-header container">
  <h1><?php 
echo $_SERVER['REMOTE_ADDR'];
?>
</h1>
</section>

<section class="content container">

	<div class="col-md-12">	
	<?php

Esempio n. 10

0

Mostra file

File: index.php Progetto: jambonbill/expenses.jambonbill.org

<?php

// Expenses visualisation //
// new expense
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("New");
echo $admin;
//
$EXP = new Expenses\Expenses();
if (!$EXP->user_id()) {
    header("location:../login/logout.php");
    die("Error:!user_id");
}
?>

<section class="content-header">
  <h1><?php 
echo $EXP->user()['email'];
?>
</h1>
</section>

<section class="content">
	<div class="row">
  	<div class='col-md-6'>
	<?php 
$box = new LTE\Box();
$box->id("boxNew");

Esempio n. 11

0

Mostra file

File: index.php Progetto: jambonbill/expenses.jambonbill.org

<?php

// Expenses visualisation //
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("Import");
echo $admin;
//
$EXP = new Expenses\Expenses();
if (!$EXP->user_id()) {
    header("location:../login/logout.php");
    die("Error:!user_id");
}
?>
<section class="content-header">
  <h1><i class='fa fa-upload'></i> Import/Export</h1>
</section>


<section class="content">
    
    <div class="col-md-6">
	<?php 
include "box_googleDriveCsv.php";
include "box_upload.php";
?>
	</div><!-- /.row -->
    
    <div class="col-md-6">

Esempio n. 12

0

Mostra file

File: index.php Progetto: jambonbill/jambonbill.org

<?php

//jambonbill.org
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$J = new JAMBON\Jambon();
$admin->config()->menu = $J->menuleft();
//menu override//
echo $admin;
//
$J = new JAMBON\Jambon();
//$jambon->useronly();
if (!$J->is_superuser()) {
    print_r($J->user());
    die("Hello ?" . $J->user_id());
}
$user = $J->auth_user($_GET['id']);
if (isset($user['id'])) {
    echo "<input type=hidden id=user_id value='" . $user['id'] . "'>";
} else {
    die("Error : no user #" . $_GET['id']);
}
?>
<section class="content-header">
  <h1><i class='fa fa-user'></i> User</h1>
</section>


<section class="content">

Esempio n. 13

0

Mostra file

File: index.php Progetto: jambonbill/expenses.jambonbill.org

<?php

// Expenses visualisation //
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("Edit");
echo $admin;
//
$EXP = new Expenses\Expenses();
if (!$EXP->user_id()) {
    header("location:../login/logout.php");
    die("Error:!user_id");
}
$id = 0;
if (isset($_GET['id'])) {
    $id = $_GET['id'] * 1;
}
if (isset($_GET['date'])) {
    $x = $EXP->expenseByDay($_GET['date']);
    //array_pop($x)
    if (count($x)) {
        $id = $x[0]['ed_id'];
    }
    //print_r($x[0]);exit;
    //$id=$EXP->idByDate($_GET['date']);
}
if (!$id) {
    echo "<pre>Error</pre>";
    exit("<script>document.location.href='../search/';</script>");

Esempio n. 14

0

Mostra file

File: index.php Progetto: jambonbill/midi.jambonbill.org

<?php

// MIDI
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("MIDI");
echo $admin;
?>
<section class="content-header">
  <h1><i class='fa fa-list'></i> MIDI Monitor
  <small></small>
  </h1>
</section>

<section class="content">

<div class='row'>
	<div class='col-sm-6'>
	<?php 
include "box_inputs.php";
?>
	</div>

	<div class='col-sm-6'>
	<?php 
include "box_filter.php";
?>
	</div>

Esempio n. 15

0

Mostra file

File: index.php Progetto: jambonbill/gif.jambonbill.org

<?php

header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("Home");
echo $admin;
//
?>

<section class="content-header">
  <h1><i class='fa fa-image'></i> gif.js <small>based on gif.js</small></h1>
</section>

<section class="content">

<div class='row'>
	<div class='col-md-6'>
	<?php 
$box = new LTE\Box();
$box->title("Dropzone");
$box->id("boxFrames");
$box->body("Drop your images here");
$box->footer("<a href=#gif class='btn btn-default'>Make a gif</a>");
echo $box;
$box = new LTE\Box();
$box->title("Frames");
$box->id("boxFrames");
$box->icon("fa fa-list");
$box->collapsable(1);

Esempio n. 16

0

Mostra file

File: test.php Progetto: jambonbill/midi.jambonbill.org

<?php

// test.php
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
require __DIR__ . "/../../src/MIDI/midi.class.php";
$admin = new LTE\AdminLte2();
$admin->title("MIDI");
echo $admin;
?>
<section class="container">
<?php 
$midi = new Midi();
$files = glob(__DIR__ . "/../../midifiles/*.mid");
shuffle($files);
$file = $files[0];
$midi->importMid($file);
$track = $midi->getTrack(0);
echo "<h1>" . basename($file) . "</h1>\n";
echo "<pre>";
$tempo = $midi->getTempo();
$bpm = $midi->getBpm();
//returns tempo as beats per minute (0 if tempo not set).
$timebase = $midi->getTimebase();
//returns timebase value.
$trackCount = $midi->getTrackCount();
//returns number of tracks.
$duration = $midi->getDuration();
//in sec
echo "tempo={$tempo}\n";

Esempio n. 17

0

Mostra file

File: index.php Progetto: jambonbill/ip.jambonbill.org

<?php

header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$IP = new IP\IP();
$admin = new LTE\AdminLte2();
//menu override//
$admin->config()->menu = $IP->menuleft();
echo $admin;
//
?>

<section class="content-header">
  <h1><i class='fa fa-sitemap'></i> Route(s)</h1>
</section>

<section class="content">
	<div class="col-sm-6">
	<?php 
include "box_routes.php";
?>
	</div>
	<div class="col-sm-6">
	<?php 
include "box_route.php";
?>
	</div>
</section>

<script src="js/app.js"></script>

Esempio n. 18

0

Mostra file

File: index.php Progetto: jambonbill/midi.jambonbill.org

<?php

header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("Spectrum analyzer");
echo $admin;
// https://gilian.web.elte.hu/demos/spectrum_analyzer/index.html
?>
<section class="content-header">
  <h1><i class='fa fa-microphone'></i> Spectrum analyzer
  <small></small>
  </h1>
</section>

<section class="content">

<?php 
include "box_spectrum.php";
include "box_settings.php";
?>

<script src='js/fft.js'></script>
<script src='js/cybuf.js'></script>
<script src='js/main.js' charset="utf-8"></script>
<script src='js/midi.js' charset="utf-8"></script>
<script type="text/javascript" src="js/dat.gui.min.js"></script>
<style type="text/css" src='css/spectrum.css'></style>

Esempio n. 19

0

Mostra file

File: index.php Progetto: jambonbill/expenses.jambonbill.org

<?php

// Expenses visualisation //
// Search expense
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("Search");
echo $admin;
//
$EXP = new Expenses\Expenses();
if (!$EXP->user_id()) {
    header("location:../login/logout.php");
    die("Error:!user_id");
}
?>
<section class="content-header">
  <h1>Search</h1>
</section>

<section class="content">
	
    <div class="row">
        <div class='col-md-12'>
      	<?php 
// Search form //
include "box_search.php";
// search results //
$box = new LTE\Box();
$box->id("boxResult");

Esempio n. 20

0

Mostra file

File: index.php Progetto: jambonbill/midi.jambonbill.org

<?php

// MIDI
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("MIDI Keyboard");
echo $admin;
?>
<section class="content-header">
  <h1><i class='fa fa-keyboard-o'></i> MIDI Keyboard
  <small>Use you keyboard as a midi keyboard/controller</small>
  </h1>
</section>


<section class="content">

<div class='row'>

	<div class='col-sm-6'>
	<?php 
include "box_outputs.php";
?>
	</div>

	
	<div class='col-sm-6'>
	<?php 
include "box_keyboard.php";

Esempio n. 21

0

Mostra file

File: index.php Progetto: jambonbill/ip.jambonbill.org

<?php

// register a public ip
// call this page during your computer init sequence so i can register its public ip
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$REMOTE_ADDR = $_SERVER['REMOTE_ADDR'];
$admin = new LTE\AdminLte2();
$admin->config()->title = $REMOTE_ADDR;
echo $admin;
//
$IP = new IP\IP();
?>
<section class="content-header">
  <h1><i class='fa fa-chevron-right'></i> Register</h1>
</section>

<section class='content'>

<?php 
$ip = $_SERVER['REMOTE_ADDR'];
$NAME = @$_GET['name'];
if (!$NAME) {
    $NAME = 'Anonymous';
}
if ($IP->registerIp($ip, $NAME)) {
    echo new LTE\Callout("success", "<i class='fa fa-check'></i> Success", "Ip '{$ip}' registered successfuly");
    echo "<a href='http://ip.jambonbill.org' class='btn btn-default'>ip.jambonbill.org</a>";
    //die("Ip '$ip' registered successfuly");
    exit;

Esempio n. 22

0

Mostra file

File: index.php Progetto: jambonbill/expenses.jambonbill.org

<?php

// admin :: Calendar
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("Calendar");
echo $admin;
//
?>

<!-- Content Header (Page header) -->
<section class="content-header">
    <h1><i class='fa fa-calendar'></i> Expenses calendar
    </h1>
    
</section>



<!-- Main content -->
<section class="content">


<!-- Main row -->
<div class="row">

    
    <section class="col-sm-12">
    <!-- THE CALENDAR -->

Esempio n. 23

0

Mostra file

File: index.php Progetto: jambonbill/midi.jambonbill.org

<?php

// JasMid
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("Jasmid");
echo $admin;
?>
<link href="./css/main.css" rel="stylesheet" type="text/css" />
<section class="content-header">
  <h1><i class='fa fa-music'></i> Jasmid
  <small><a href=# id=btnBrowse>Browse</a></small>
  </h1>
</section>

<section class="content">

<div class='row'>
	<div class='col-sm-6'>
	<?php 
//include "box_file.php";
//include "box_files.php";
include "box_tracks.php";
?>
	</div>

	<div class='col-sm-6'>
	<?php 
//include "box_filter.php";

Esempio n. 24

0

Mostra file

File: index.php Progetto: jambonbill/expenses.jambonbill.org

<?php

// Expenses visualisation //
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("Home");
echo $admin;
//
$EXP = new Expenses\Expenses();
if (!$EXP->user_id()) {
    header("location:../login/");
    die("Error:!user_id");
}
$count = $EXP->count();
?>
<section class="content-header">
  <h1>Home 
  	<small><?php 
echo number_format($count);
?>
 records</small>
  </h1>
</section>


<div class="content">
    
    <div class="col-md-6">
	<?php

Esempio n. 25

0

Mostra file

File: index.php Progetto: jambonbill/ip.jambonbill.org

<?php

header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$REMOTE_ADDR = $_SERVER['REMOTE_ADDR'];
$IP = new IP\IP();
$admin = new LTE\AdminLte2();
$admin->config()->title = $REMOTE_ADDR;
//menu override//
$admin->config()->menu = $IP->menuleft();
echo $admin;
//
?>

<section class="content-header">
  <h1>Ports</h1>
</section>

<section class="content">

	<div class="col-md-12">
	
	<?php 
include "box_ports.php";
?>
	</div>

</section>

<script src="js/ports.js"></script>

Esempio n. 26

0

Mostra file

File: logout.php Progetto: jambonbill/ip.jambonbill.org

<?php

header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("Logout");
$admin->config()->menu = (object) [];
$admin->config()->layout->{'sidebar-collapse'} = true;
echo $admin;
// Write your logout code here
try {
    $pdo = new PDO\Pdo();
    $UD = new PDO\UserDjango($pdo->db());
    $UD->logout();
} catch (Exception $e) {
    exit("Logout Failure");
}
// You could also redirect to the login page
?>

<section class='content'>

<div class="login-box">
		<h1>Bye !</h1>
		<pre>redirecting to the login page...</pre>
</div>

<script>
$(function(){
	setTimeout("document.location.href='index.php';",1000);

Esempio n. 27

0

Mostra file

File: news.php Progetto: jambonbill/vorc.jambonbill.org

<?php

// VORC :: NEWS EN
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
echo $admin;
$VORC = new VORC\Vorc();
$id = $_GET['id'];
$sql = "SELECT * FROM vorc.news_en WHERE nid={$id} LIMIT 1;";
$q = $VORC->db()->query($sql) or die("Error");
$r = $q->fetch(PDO::FETCH_ASSOC);
if (!$r) {
    die("Error");
}
?>
<section class="content-header">
  <h1><i class='fa fa-newspaper-o'></i> NEWS - EN 
  <small>#<?php 
echo $r['nid'];
?>
</small>
  </h1>
</section>

<section class="content">
<?php 
$htm = [];
$htm[] = $VORC->process_en($r['newsbody']);
//$htm[]="<i class='text-muted'>".$r['newsbody']."</i>";

Esempio n. 28

0

Mostra file

File: index.php Progetto: jambonbill/expenses.jambonbill.org

<?php

// Expenses visualisation //
// Categories
header('Content-Type: text/html; charset=utf-8');
session_start();
require __DIR__ . "/../../vendor/autoload.php";
$admin = new LTE\AdminLte2();
$admin->title("Categories");
echo $admin;
//
$EXP = new Expenses\Expenses();
if (!$EXP->user_id()) {
    header("location:../login/logout.php");
    die("Error:!user_id");
}
?>
<section class="content-header">
  <h1>Categories</h1>
</section>

<section class="content">
	
    <div class="row">
        <div class='col-md-12'>
      	<pre>
        <?php 
$sql = "SELECT COUNT(*) as count,ed_name FROM expenses_data GROUP BY ed_name ORDER BY count DESC;";
$q = $EXP->db()->query($sql) or die("Error {$sql}");
while ($r = $q->fetch(PDO::FETCH_ASSOC)) {
    print_r($r);

Esempi in PHP per LTE\AdminLte2