<?php
require_once 'DB.php';
require_once 'Console/Table.php';
$dbh = DB::connect('mysqli://*****:*****@localhost/pear');
if (PEAR::isError($dbh)) {
die('Database connection failed');
}
$sql = '
SELECT p.name, p.license
FROM packages p
WHERE p.package_type = "pear" AND p.license LIKE "%PHP%"
ORDER BY p.name';
$data = $dbh->getAll($sql, DB_FETCHMODE_ASSOC);
$table = new Console_Table();
$table->setHeaders(array('Package (' . count($data) . ')', 'License'));
$table->addData($data);
echo $table->getTable();
/**
* Return pretty printed table from data, useful for printing to console or wrapped in <pre>
* @return string
*/
public function getValue()
{
require_once 'Console/Table.php';
$tbl = new \Console_Table();
$tbl->setHeaders($this->getColHeadings());
$tbl->addData($this->getAllRows());
return $tbl->getTable();
}
