PHP q_assoc_iterator Examples

Example #1

File: SQL.php Project: neTpyceB/TMCms-core

 /**
  * Show functions in database
  * @param string $db - database name
  * @return array - list of non-temporary tables, by pairs key/value
  */
 public static function getFunctions($db = NULL)
 {
     if (!$db) {
         $db = Configuration::getInstance()->get('db')['name'];
     }
     $res = [];
     foreach (q_assoc_iterator('SHOW FUNCTION STATUS WHERE `Db` = "' . $db . '"') as $v) {
         $res[] = $v['Name'];
     }
     return $res;
 }

Example #2

File: _ajax_tools_application_log.php Project: neTpyceB/TMCms-panel

<?php

defined('INC') or exit;
if (IS_AJAX_REQUEST) {
    ob_start();
}
$application_log = [];
foreach (q_assoc_iterator('
SELECT
	`l`.`ts`,
	`l`.`msg`,
	CONCAT(`u`.`name`, " ", `u`.`surname`) AS `user`
FROM `cms_app_log` AS `l`
LEFT JOIN `cms_users` AS `u` ON `u`.`id` = `l`.`user_id`
WHERE IF("' . ((int) USER_ID == 1) . '", 1, `u`.`id` != "1")
ORDER BY `l`.`ts` DESC
LIMIT 20
') as $v) {
    $application_log[] = date(CFG_CMS_DATETIME_FORMAT, $v['ts']) . ': ' . $v['user'] . ' - ' . $v['msg'];
}
echo '<b>Application log</b><br>';
echo implode('<br>', $application_log);
if (IS_AJAX_REQUEST) {
    echo ob_get_clean();
    die;
}