Файловый менеджер - Редактировать - /home/lmsyaran/public_html/j3/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php
Назад
<?php namespace Nextend\Framework\Database\Joomla; use JDatabaseDriver; use Nextend\Framework\Database\AbstractPlatformConnector; use Nextend\Framework\Database\AbstractPlatformConnectorTable; use stdClass; class JoomlaConnectorTable extends AbstractPlatformConnectorTable { /** @var JDatabaseDriver */ protected static $db; /** * @param AbstractPlatformConnector $connector * @param JDatabaseDriver $db */ public static function init($connector, $db) { self::$connector = $connector; self::$db = $db; } public function findByPk($primaryKey) { $query = self::$db->getQuery(true); $query->select('*'); $query->from(self::$connector->quoteName($this->tableName)); $query->where(self::$connector->quoteName($this->primaryKeyColumn) . ' = ' . (is_numeric($primaryKey) ? $primaryKey : self::$db->quote($primaryKey))); // Reset the query using our newly populated query object. self::$db->setQuery($query); // Load the results as a list of stdClass objects (see later for more options on retrieving data). return self::$db->loadAssoc(); } public function findByAttributes(array $attributes, $fields = false, $order = false) { $query = self::$db->getQuery(true); if ($fields) { $query->select(self::$connector->quoteName($fields)); } else { $query->select(array('*')); } $query->from(self::$connector->quoteName($this->tableName)); foreach ($attributes as $key => $val) { $query->where(self::$connector->quoteName($key) . ' = ' . (is_numeric($val) ? $val : self::$connector->quote($val))); } if ($order) { $query->order($order); } self::$db->setQuery($query); return self::$db->loadAssoc(); } public function findAll($order = false) { $query = self::$db->getQuery(true); $query->select('*'); $query->from(self::$db->quoteName($this->tableName)); if ($order) { $query->order($order); } self::$db->setQuery($query); return self::$db->loadAssocList(); } public function findAllByAttributes(array $attributes, $fields = false, $order = false) { $query = self::$db->getQuery(true); if ($fields) { $query->select(self::$connector->quoteName($fields)); } else { $query->select('*'); } $query->from(self::$db->quoteName($this->tableName)); foreach ($attributes as $key => $val) { $query->where(self::$db->quoteName($key) . ' = ' . (is_numeric($val) ? $val : self::$db->quote($val))); } if ($order) { $query->order($order); } self::$db->setQuery($query); return self::$db->loadAssocList(); } public function insert(array $attributes) { $object = new stdClass(); foreach ($attributes as $key => $value) { $object->$key = $value; } // Insert the object into the user profile table. try { return self::$db->insertObject($this->tableName, $object); } catch (\Exception $e) { return false; } } public function insertId() { return self::$db->insertid(); } public function update(array $attributes, array $conditions) { $query = self::$db->getQuery(true); $fields = array(); foreach ($attributes as $akey => $avalue) { $fields[] = self::$connector->quoteName($akey) . ' = ' . (is_numeric($avalue) ? intval($avalue) : self::$connector->quote($avalue)); } $where = array(); foreach ($conditions as $ckey => $cvalue) { $where[] = self::$connector->quoteName($ckey) . ' = ' . (is_numeric($cvalue) ? intval($cvalue) : self::$connector->quote($cvalue)); } $query->update(self::$connector->quoteName($this->tableName)) ->set($fields) ->where($where); self::$db->setQuery($query); return self::$db->execute(); } public function updateByPk($primaryKey, array $attributes) { $query = self::$db->getQuery(true); $fields = array(); foreach ($attributes as $akey => $avalue) { $fields[] = self::$connector->quoteName($akey) . ' = ' . (is_numeric($avalue) ? intval($avalue) : self::$connector->quote($avalue)); } $conditions = self::$connector->quoteName($this->primaryKeyColumn) . ' = ' . (is_numeric($primaryKey) ? $primaryKey : self::$connector->quote($primaryKey)); $query->update(self::$connector->quoteName($this->tableName)) ->set($fields) ->where($conditions); self::$db->setQuery($query); return self::$db->execute(); } public function deleteByPk($primaryKey) { $query = self::$db->getQuery(true); $conditions = array(self::$connector->quoteName($this->primaryKeyColumn) . ' = ' . (is_numeric($primaryKey) ? $primaryKey : self::$connector->quote($primaryKey))); $query->delete(self::$connector->quoteName($this->tableName)); $query->where($conditions); self::$db->setQuery($query); return self::$db->execute(); } public function deleteByAttributes(array $conditions) { $query = self::$db->getQuery(true); $where = array(); foreach ($conditions as $ckey => $cvalue) { $where[] = self::$connector->quoteName($ckey) . ' = ' . (is_numeric($cvalue) ? intval($cvalue) : self::$connector->quote($cvalue)); } $query->delete(self::$connector->quoteName($this->tableName)); $query->where($where); self::$db->setQuery($query); return self::$db->execute(); } }
| ver. 1.4 |
Github
|
.
| PHP 8.1.33 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка