PHP mysql::getTableName方法代码示例

 function run()
 {
     global $_out;
     $mysql = new mysql();
     $row = filter_var(param('row'), FILTER_VALIDATE_INT);
     if (($rs = $mysql->query('select * from `' . $mysql->getTableName($this->table) . '` where ' . '`section`="' . $this->getSection()->getId() . '" and `module`="' . $this->getConf('module', true) . '" and `id_article`=' . ($row ? $row : 0))) && ($r = $mysql->fetch($rs))) {
         if ($v = $r['title']) {
             $_out->setMeta('title', $v);
         }
         if ($v = $r['keywords']) {
             $_out->setMeta('keywords', $v);
         }
         if ($v = $r['description']) {
             $_out->setMeta('description', $v);
         }
         if (($v = $r['h1']) && ($e = $_out->query('/page/section')->item(0))) {
             $e->setAttribute('h1', $v);
         }
     }
 }

 function uninstall()
 {
     $mysql = new mysql();
     if ($md = $this->getConf('module')) {
         $mysql->query('delete from `' . $mysql->getTableName($this->table) . '` where `section`="' . $this->getSection()->getID() . '" AND `module`="' . $md . '"');
     }
     if ($sec = ap::getClientSection($this->getSection()->getId())) {
         $modules = $sec->getModules();
         if ($modules->remove($this->getId())) {
             $modules->getXML()->save();
         }
         return true;
     }
 }

 function uninstall()
 {
     $mysql = new mysql();
     $table = $this->table;
     if ($rs = $mysql->query('select * from `' . $mysql->getTableName($table) . '` where `section`="' . $this->getSection()->getID() . '" AND `module`="' . $this->getId() . '"')) {
         while ($r = mysql_fetch_array($rs)) {
             $this->deleteRow($r['id']);
         }
     }
     if ($sec = ap::getClientSection($this->getSection()->getId())) {
         $modules = $sec->getModules();
         if ($modules->remove($this->getId())) {
             $modules->getXML()->save();
         }
         return true;
     }
 }

    function getNextSortIndex($form)
    {
        $mysql = new mysql();
        $index = 1;
        $rs = $mysql->query('select max(`sort`)+1 as `new_sort_index`
		from `' . $mysql->getTableName($form->getAttribute('dbTable')) . '`
		where `section`="' . $this->getName() . '" AND `module`="' . $this->getId() . '"');
        if ($rs && ($row = mysql_fetch_assoc($rs)) && $row['new_sort_index']) {
            $index = $row['new_sort_index'];
        }
        return $index;
    }

    /**
    * Картинки
    */
    static function getImages($id, $preview = false, $limit = null)
    {
        global $_out;
        if (!is_array($id)) {
            $id = array($id);
        }
        if (!count($id)) {
            return;
        }
        $res = array();
        $mysql = new mysql();
        $counter = array();
        if ($rs = $mysql->query('SELECT img.*,art.section,art.module
FROM `' . $mysql->getTableName('articles_images') . '` AS img
LEFT JOIN `' . $mysql->getTableName('articles') . '` AS art ON art.id=img.id_article
WHERE `id_article` IN (' . implode(',', $id) . ') AND img.`active`=1
ORDER BY `id_article`,`sort`')) {
            while ($r = mysql_fetch_assoc($rs)) {
                if ($limit > 0) {
                    if (!isset($counter[$r['id_article']])) {
                        $counter[$r['id_article']] = 0;
                    }
                    if ($counter[$r['id_article']] >= $limit) {
                        continue;
                    }
                    $counter[$r['id_article']]++;
                }
                $v = array();
                if (is_file($path = 'userfiles/articles/' . $r['section'] . '/' . $r['id'] . '.jpg')) {
                    list($width, $height) = getimagesize($path);
                    $v['img'] = $_out->createElement('img', array('id' => $r['id'], 'src' => $path, 'width' => $width, 'height' => $height));
                    if ($r['title']) {
                        $v['img']->setAttribute('alt', $r['title']);
                    }
                }
                if ($preview && is_file($path = 'userfiles/articles/' . $r['section'] . '/' . $r['id'] . ($preview ? '_preview' : null) . '.jpg')) {
                    list($width, $height) = getimagesize($path);
                    $v['prv'] = $_out->createElement('preview', array('src' => $path, 'width' => $width, 'height' => $height));
                    if ($r['title']) {
                        $v['prv']->setAttribute('alt', $r['title']);
                    }
                }
                if (count($v)) {
                    $res[$r['id_article']][] = $v;
                }
            }
        }
        return $res;
    }

 function fixedFields($form)
 {
     global $_sec;
     $clientSection = ap::getClientSection($_sec->getId());
     $md = $clientSection->getXML()->getElementById($this->getId());
     if ($clientSection->getXML()->evaluate('string(./form[1]/@dbSave)', $md) && ($dbConnect = $clientSection->getXML()->evaluate('string(./form[1]/@dbConnect)', $md)) && ($dbTable = $clientSection->getXML()->evaluate('string(./form[1]/@dbTable)', $md)) && ($ff = $form->appendField(formSelect::create('uri', 'Database field name:', '/@uri')))) {
         $ff->addOption('', '...');
         $mysql = new mysql($dbConnect);
         $q = 'SHOW COLUMNS FROM ' . $mysql->getTableName($dbTable);
         $rs = $mysql->query($q);
         while ($res = mysql_fetch_assoc($rs)) {
             if (!$res['Extra']) {
                 $ff->addOption($res['Field'], $res['Field']);
             }
         }
     }
 }

 function getTableName()
 {
     $params = mysqllist::getParams($this->params);
     $mysql = new mysql($params['con']);
     return $mysql->getTableName($params['table']);
 }

 function getRow($con, $table, $cond)
 {
     if (isset($cache[$con][$table][$cond])) {
         return $cache[$con][$table][$cond];
     }
     if ($table && $cond) {
         $mysql = new mysql($con);
         $query = 'SELECT * FROM `' . $mysql->getTableName($table) . '` WHERE ' . $cond;
         if ($rs = $mysql->query($query)) {
             return $cache[$con][$table][$cond] = mysql_fetch_assoc($rs);
         }
     }
 }

 private function load($id_article)
 {
     $mysql = new mysql();
     $values = $this->getSubmitImages();
     $isUpdate = is_array($values);
     $arId = $isUpdate ? array_keys($values['exist']) : array();
     if (($rs = $mysql->query('select `id`,`title` from `' . $mysql->getTableName($this->getTable()) . '` where `id_article`=' . $id_article . ' and `field_name`="' . addslashes($this->ff->getName()) . '"' . (count($arId) ? ' and `id` not in(' . implode(',', $arId) . ')' : null) . ' order by `sort`')) && mysql_num_rows($rs)) {
         $rowsToDelete = array();
         while ($r = mysql_fetch_assoc($rs)) {
             $fieldName = $this->fieldName($r['id']);
             if ($isUpdate) {
                 $this->values[$fieldName] = jpgScheme::VALUE_DELETE;
                 $rowsToDelete[] = $r['id'];
             }
             foreach ($this->formats as $param) {
                 if (!$isUpdate && !$param->hasAttribute('preview')) {
                     continue;
                 }
                 $e = $this->ff->getRootElement()->appendChild($param->cloneNode(true));
                 $e->setAttribute('name', $fieldName);
                 $e->setAttribute('uri', str_replace('%IMG_ID%', $r['id'], $e->getAttribute('uri')));
                 if ($r['title']) {
                     $e->setAttribute('title', $r['title']);
                 }
             }
         }
         if ($isUpdate && count($rowsToDelete)) {
             $mysql->query('delete from `' . $mysql->getTableName($this->getTable()) . '` where id in(' . implode(',', $rowsToDelete) . ')');
         }
     }
     if ($isUpdate) {
         $v = array();
         foreach ($this->sortOrder as $i => $str) {
             if (preg_match('/id([0-9]+)/', $str, $m)) {
                 $v[$m[1]] = '(' . $m[1] . ',"' . addslashes($values['exist'][$m[1]]['title']) . '",' . ($i + 1) . ')';
             }
         }
         //vdump($values);
         if (count($v)) {
             $mysql->query('insert into `' . $mysql->getTableName($this->getTable()) . '` (`id`,`title`,`sort`) values ' . implode(',', $v) . ' on duplicate key update `title`=values(`title`),`sort`=values(`sort`)');
         }
     }
 }