public function get_data_for_main_page()
{
$db = new Db();
$components = $db->getAll("SELECT `title`,`name` FROM ##extensions WHERE `type`='component' AND `enabled`=1");
$modules = $db->getAll('SELECT `name`,`id` FROM ##modules WHERE `published`=1');
echo Json::encode([$components, $modules]);
}
/**
* Returns array of objects from collection
*
* @return array
*/
public function findAll()
{
$result = array();
if (!$this->hasStatement('select')) {
$this->select('*');
}
$sql = $this->compile();
$tbl = $this->getStatement('table');
$cache_key = OrmCache::genKey($sql, $this->values_accum);
if (($result_cached = OrmCache::getCachedQuery($cache_key)) !== false && $this->use_cache) {
return $result_cached;
}
$rows = Db::getAll($sql, $this->values_accum);
$new_collection = Orm::collection($this->entity_name);
$pk = isset($this->entity_info['primary_key']) ? $this->entity_info['primary_key'] : 'id';
foreach ($rows as $row) {
$pk_value = isset($row[$pk]) ? $row[$pk] : null;
$result[$pk_value] = $new_collection->create($row);
}
if ($this->use_cache) {
OrmCache::cacheQuery($cache_key, $tbl['sql'], $result);
}
return $result;
}
<?php
require_once 'classes/DB.php';
try {
$db = new Db();
$result = $db->getAll();
$departments = array('Робототехника' => array(), 'Нано-хирургия' => array(), 'Инженерия' => array());
for ($i = 0; $i < count($result); $i++) {
array_push($departments[$result[$i]['department']], ['name' => $result[$i]['name'], 'sername' => $result[$i]['sername']]);
}
$html = '<table class="table-bordered" id="robotics">
<caption>Робототехника</caption>
<tr><th>#</th><th>Имя</th><th>Фамилия</th></tr>';
for ($i = 0; $i < count($departments['Робототехника']); $i++) {
$html .= '<tr>
<td class="id_robotics">' . ($i + 1) . '</td>
<td class="name">' . $departments['Робототехника'][$i]['name'] . '</td>
<td class="sername">' . $departments['Робототехника'][$i]['sername'] . '</td>
</tr>';
}
$html .= '</table>';
$html .= '<table class="table-bordered" id="nanosurgery">
<caption>Нано-хирургия</caption>
<tr><th>#</th><th>Имя</th><th>Фамилия</th></tr>';
for ($i = 0; $i < count($departments['Нано-хирургия']); $i++) {
$html .= '<tr>
<td class="id_robotics">' . ($i + 1) . '</td>
<td class="name">' . $departments['Нано-хирургия'][$i]['name'] . '</td>
<td class="sername">' . $departments['Нано-хирургия'][$i]['sername'] . '</td>
</tr>';
}
/**
* Returns column metadata for given table
*
* @static
* @param $table
* @param bool $refresh
* @return mixed
*/
public static function &getColumns($table, $refresh = false)
{
self::connect();
if (!isset(self::$columns_meta[$table]) && !$refresh) {
$rows = Db::getAll('show columns from ' . $table);
foreach ($rows as $row) {
self::$columns_meta[$table][$row['Field']] = $row;
}
}
return self::$columns_meta[$table];
}
/**
* Remove many-to-many relations with objects that not in $related_objects array
*
* @param $associated_class_name
* @param array $related_objects
* @param null $join_table
* @param null $base_table_key
* @param null $associated_table_key
*/
public function clearUnrelated($associated_class_name, array $related_objects, $join_table = null, $base_table_key = null, $associated_table_key = null)
{
$ids = array();
$associated_entity_info = Orm::entityInfo($associated_class_name);
foreach ($related_objects as $object) {
$ids[] = $object->getId();
}
$base_table_key = $base_table_key ? $base_table_key : $this->_table . '_id';
$join_table = $join_table ? $join_table : self::createJoinTable($this->_table, $associated_entity_info['table']);
$associated_table_key = $associated_table_key ? $associated_table_key : $associated_entity_info['table'] . '_id';
OrmCache::clearCacheForTable($join_table);
$rows = Db::getAll('select ' . $associated_table_key . ' from ' . $join_table . ' where ' . $base_table_key . ' = ?', array($this->getId()));
foreach ($rows as $row) {
if (!in_array($row[$associated_table_key], $ids)) {
Db::delete($join_table, $associated_table_key . ' = ? and ' . $base_table_key . ' = ?', array($row[$associated_table_key], $this->getId()));
}
}
}
public function getAll()
{
return $this->_db->getAll('SELECT * FROM customer', 15);
}
public function getAll()
{
$db = new Db();
return $db->getAll('SELECT * FROM customer', 15);
}
