function getAllTables()
{
$pdo = DbUtil::connect();
$sql = "select table_name from information_schema.tables where table_schema='numeracy'";
//$sql ="DESCRIBE numeracy.m01_user";
$values = $pdo->query($sql);
$count = 1;
$result = "";
$tableArray = array();
if (is_array($values) || is_object($values)) {
foreach ($values as $row) {
$tableName = $row['table_name'];
print "<p class='btn-info'>" . $count++ . " >" . dashesToCamelCase($tableName, true) . "BO.php</p><br/>";
print "<div class='alert alert-danger clearfix'> <?php";
print '<br/>namespace com\\numeracy\\BO; <br/>';
//print(' require __DIR__ . "\BaseBO.php"; <br/>use com\numeracy\BO\BaseBO; <br/> ' );
//print("class ".dashesToCamelCase($tableName,true)."BO extends BaseBO {<br/>");
print "class " . dashesToCamelCase($tableName, true) . "BO {<br/>";
$tableArray[] = $row['table_name'];
getAllColumns($tableName);
print "}<br/>";
print "?><br/></div>";
print "<br/>";
}
}
DbUtil::disconnect();
return $tableArray;
}
/**
*
* @return multitype:unknown
*/
function getAllTables()
{
$pdo = DbUtil::connect();
$sql = "select table_name from information_schema.tables where table_schema='numeracy'";
//$sql ="DESCRIBE numeracy.m01_user";
$values = $pdo->query($sql);
$count = 1;
$result = "";
$tableArray = array();
if (is_array($values) || is_object($values)) {
foreach ($values as $row) {
$tableName = $row['table_name'];
print "<p class='btn-info'>" . $count++ . " >" . dashesToCamelCase($tableName, true) . "Dao.php</p><br/>";
print "<div class='alert alert-danger clearfix'> <?php";
print '<br/>';
print '<br/>
namespace com\\numeracy\\Dao; <br/>
include_once "../bo/' . dashesToCamelCase($tableName, true) . 'BO.php"; <br/>';
print 'use com\\numeracy\\BO\\' . dashesToCamelCase($tableName, true) . 'BO; <br/> ';
print 'use PDO;';
print '<br/>';
print "class " . dashesToCamelCase($tableName, true) . "Dao {<br/>";
print ' private $db; <br/> <br/>';
print 'function __construct($DB_con) <br/>
{ <br/>
$this->db = $DB_con; <br/>
} <br/>';
$tableArray[] = $row['table_name'];
getAllColumns($tableName);
print "}<br/>";
print "?><br/></div>";
print "<br/>";
}
}
DbUtil::disconnect();
return $tableArray;
}
/**
* getAllColumnsFrom
*
* adds "FROM $pntable[$tablename] " to the value returned from
* getAllColumns
*
* also adds an optional WHERE class to be automatically added
*/
function getAllColumnsFrom($tablename, $whereclause = '')
{
// get the table information
$pntable =& pnDBGetTables();
// use the other method and append a FROM clause
$query = getAllColumns($tablename) . "FROM {$pntable[$tablename]} ";
if ($whereclause) {
$query .= "WHERE {$whereclause}";
}
return $query;
}
/**
* getAllColumnsFrom
*
* adds "FROM $pntable[$tablename] " to the value returned from
* getAllColumns
*
* also adds an optional WHERE class to be automatically added
*/
function getAllColumnsFrom($tablename, $whereclause = '')
{
// globals we need
global $pntable;
// use the other method and append a FROM clause
$query = getAllColumns($tablename) . "FROM {$pntable[$tablename]} ";
if ($whereclause) {
$query .= "WHERE {$whereclause}";
}
return $query;
}
