/**
* wrapper para el ejecutor de queries en base de datos
* @param string $sqlcmd comando sql a ejectuar
* @param bool $cache usar cache?
* @param string $table tabla a usar (usada por limpiador de cache luego)
*/
function execSql($sqlcmd, $cache = null, $table = null)
{
$this->data = $this->query($sqlcmd);
if (!almdata::isError($sqlcmd) && $this->data && (preg_match('/^SELECT/', $sqlcmd) || preg_match('/^SHOW/', $sqlcmd))) {
$this->num = almdata::rows($this->data);
}
}
<?php
//FIXME: Solo usa la primera llave, qué pasa con tablas que usan más de una llave?
if (!$sqlcmd) {
$key = $this->keys[0];
if (isset($this->dd[$this->name])) {
$sqlcmd = "SELECT {$key}, {$this->name} FROM {$this->name} _WHERE_ ORDER BY {$this->name}.{$this->name}";
} else {
$sqlcmd = "SELECT {$key}, {$key} AS {$this->name} FROM {$this->name} _WHERE_ ORDER BY {$this->name}";
}
}
/* $sqlcmd no contiene comando sql sino nombre de la tabla !?! */
global $global_dd;
if (!preg_match("/^SELECT/", $sqlcmd)) {
$table = $sqlcmd;
$id = $global_dd[$table]['keys'][0];
$descriptor = $global_dd[$table]['descriptor'];
$sqlcmd = "SELECT {$id}, {$descriptor} FROM {$sqlcmd} _WHERE_ ORDER BY {$descriptor}";
}
if ($filter) {
$sqlcmd = preg_replace('/_WHERE_/ ', "WHERE {$filter}", $sqlcmd);
} else {
$sqlcmd = preg_replace('/_WHERE_/ ', '', $sqlcmd);
}
$result = $this->query($sqlcmd);
$num = almdata::rows($result);
$menu = array();
for ($i = 0; $i < $num; $i++) {
$r = almdata::fetchRow($result, false);
$menu[$r[0]] = $r[1];
}
