本文整理汇总了PHP中JDatabaseDriver类的典型用法代码示例。如果您正苦于以下问题:PHP JDatabaseDriver类的具体用法?PHP JDatabaseDriver怎么用?PHP JDatabaseDriver使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了JDatabaseDriver类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getOptions
/**
* Method to get the list of database options.
*
* This method produces a drop down list of available databases supported
* by JDatabaseDriver classes that are also supported by the application.
*
* @return array The field option objects.
*
* @since 11.3
* @see JDatabaseDriver::getConnectors()
*/
protected function getOptions()
{
// This gets the connectors available in the platform and supported by the server.
$available = JDatabaseDriver::getConnectors();
/**
* This gets the list of database types supported by the application.
* This should be entered in the form definition as a comma separated list.
* If no supported databases are listed, it is assumed all available databases
* are supported.
*/
$supported = $this->element['supported'];
if (!empty($supported)) {
$supported = explode(',', $supported);
foreach ($supported as $support) {
if (in_array($support, $available)) {
$options[$support] = JText::_(ucfirst($support));
}
}
} else {
foreach ($available as $support) {
$options[$support] = JText::_(ucfirst($support));
}
}
// This will come into play if an application is installed that requires
// a database that is not available on the server.
if (empty($options)) {
$options[''] = JText::_('JNONE');
}
return $options;
}
示例2: isValid
/**
* Validate project owner.
*
* <code>
* $projectId = 1;
* $userId = 2;
*
* $owner = new Crowdfunding\Validator\Project\Owner(\JFactory::getDbo(), $projectId, $userId);
* if(!$owner->isValid()) {
* ......
* }
* </code>
*
* @return bool
*/
public function isValid()
{
$query = $this->db->getQuery(true);
$query->select('COUNT(*)')->from($this->db->quoteName('#__crowdf_projects', 'a'))->where('a.id = ' . (int) $this->projectId)->where('a.user_id = ' . (int) $this->userId);
$this->db->setQuery($query, 0, 1);
return (bool) $this->db->loadResult();
}
示例3: getColumns
/**
* Get table columns.
*
* @param string $table Table name.
*
* @return array Table columns with type.
*/
public function getColumns($table)
{
if (empty(self::$columnCache[$table])) {
self::$columnCache[$table] = $this->db->getTableColumns($table);
}
return self::$columnCache[$table];
}
示例4: remove
/**
* Remove an extra image from database and file system.
*
* <code>
* $imageId = 1;
* $imagesFolder = "/.../folder";
*
* $image = new CrowdFundingImageRemoverExtra(JFactory::getDbo(), $image, $imagesFolder);
* $image->remove();
* </code>
*/
public function remove()
{
// Get the image
$query = $this->db->getQuery(true);
$query->select("a.image, a.thumb")->from($this->db->quoteName("#__crowdf_images", "a"))->where("a.id = " . (int) $this->imageId);
$this->db->setQuery($query);
$row = $this->db->loadObject();
if (!empty($row)) {
// Remove the image from the filesystem
$file = JPath::clean($this->imagesFolder . DIRECTORY_SEPARATOR . $row->image);
if (JFile::exists($file)) {
JFile::delete($file);
}
// Remove the thumbnail from the filesystem
$file = JPath::clean($this->imagesFolder . DIRECTORY_SEPARATOR . $row->thumb);
if (JFile::exists($file)) {
JFile::delete($file);
}
// Delete the record
$query = $this->db->getQuery(true);
$query->delete($this->db->quoteName("#__crowdf_images"))->where($this->db->quoteName("id") . " = " . (int) $this->imageId);
$this->db->setQuery($query);
$this->db->execute();
}
}
示例5: load
/**
* This method loads data about e-mail template from a database.
*
* <code>
* $emailId = 1;
*
* $email = new Emailtemplates\Email();
* $email->setDb(JFactory::getDbo());
* $email->load($emailId);
* </code>
*
* @param int $id
*/
public function load($id)
{
$query = $this->db->getQuery(true);
$query->select('a.id, a.title, a.subject, a.body, a.sender_name, a.sender_email, a.catid')->from($this->db->quoteName('#__emailtemplates_emails', 'a'))->where('a.id = ' . (int) $id);
$this->db->setQuery($query);
$result = (array) $this->db->loadAssoc();
$this->bind($result);
}
示例6: isValid
/**
* Validate project owner.
*
* <code>
* $projectId = 1;
* $userId = 2;
*
* $owner = new Crowdfunding\Validator\Project\Owner(\JFactory::getDbo(), $projectId, $userId);
* if(!$owner->isValid()) {
* ......
* }
* </code>
*
* @return bool
*/
public function isValid()
{
$query = $this->db->getQuery(true);
$query->select("COUNT(*)")->from($this->db->quoteName("#__crowdf_projects", "a"))->where("a.id = " . (int) $this->projectId)->where("a.user_id = " . (int) $this->userId);
$this->db->setQuery($query, 0, 1);
$result = $this->db->loadResult();
return (bool) $result;
}
示例7: load
protected function load()
{
$query = $this->db->getQuery(true);
$query->select('a.id, a.name')->from($this->db->quoteName('#__itpsc_countries', 'a'))->order('a.name ASC');
// Get the options.
$this->db->setQuery($query);
$this->data = $this->db->loadAssocList('id', 'name');
}
示例8: load
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new Prism\Integration\Profiles\Gravatar(\JFactory::getDbo());
* $profiles->load($ids);
* </code>
*
* @param array $ids
*/
public function load(array $ids)
{
if (!empty($ids)) {
$query = $this->db->getQuery(true);
$query->select("a.id AS user_id, a.email, MD5(a.email) as hash")->from($this->db->quoteName("#__users", "a"))->where("a.id IN ( " . implode(",", $ids) . ")");
$this->db->setQuery($query);
$this->profiles = (array) $this->db->loadObjectList("user_id");
}
}
示例9: load
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new Prism\Integration\Profiles\Gravatar(\JFactory::getDbo());
* $profiles->load($ids);
* </code>
*
* @param array $ids
*/
public function load(array $ids)
{
if (count($ids) > 0) {
$query = $this->db->getQuery(true);
$query->select('a.id AS user_id, a.email, MD5(a.email) as hash')->from($this->db->quoteName('#__users', 'a'))->where('a.id IN ( ' . implode(',', $ids) . ')');
$this->db->setQuery($query);
$this->profiles = (array) $this->db->loadObjectList('user_id');
}
}
示例10: exists
/**
* Is an id exists?
*
* @param int|string $id The id to find.
*
* @return boolean True if exists.
*/
public function exists($id)
{
$query = $this->db->getQuery(true);
$query->select($this->pkName)->from($this->table)->where($query->format('%n = %q', $this->pkName, $id));
if ($this->db->setQuery($query)->loadResult()) {
return true;
}
return false;
}
示例11: load
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new Prism\Integration\Profiles\JomSocial(\JFactory::getDbo());
* $profiles->load($ids);
* </code>
*
* @param array $ids
*/
public function load(array $ids)
{
if (count($ids) > 0) {
$query = $this->db->getQuery(true);
$query->select('a.userid AS user_id, a.avatar, a.thumb')->from($this->db->quoteName('#__community_users', 'a'))->where('a.userid IN ( ' . implode(',', $ids) . ')');
$this->db->setQuery($query);
$this->profiles = (array) $this->db->loadObjectList('user_id');
}
}
示例12: load
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new Prism\Integration\Profiles\JomSocial(\JFactory::getDbo());
* $profiles->load($ids);
* </code>
*
* @param array $ids
*/
public function load(array $ids)
{
if (!empty($ids)) {
$query = $this->db->getQuery(true);
$query->select("a.userid AS user_id, a.avatar, a.thumb")->from($this->db->quoteName("#__community_users", "a"))->where("a.userid IN ( " . implode(",", $ids) . ")");
$this->db->setQuery($query);
$this->profiles = (array) $this->db->loadObjectList("user_id");
}
}
示例13: onUserAfterDelete
/**
* Remove all address for the user name
*
* Method is called after user data is deleted from the database
*
* @param array $user Holds the user data
* @param boolean $success True if user was successfully stored in the database
* @param string $msg Message
*
* @return boolean
*
* @since 1.6
*/
public function onUserAfterDelete($user, $success, $msg)
{
if (!$success) {
return false;
}
$query = $this->db->getQuery(true)->delete($this->db->quoteName('#__dogecointipping_address'))->where($this->db->quoteName('user_id') . ' = ' . (int) $user['id']);
$this->db->setQuery($query)->execute();
return true;
}
示例14: load
/**
* Load country data from database.
*
* <code>
* $countryId = 1;
*
* $country = new CrowdFundingCountry(JFactory::getDbo());
* $country->load($countryId);
* </code>
*
* @param int $id
*/
public function load($id)
{
$query = $this->db->getQuery(true);
$query->select("a.id, a.name, a.code, a.code4, a.latitude, a.longitude, a.currency, a.code")->from($this->db->quoteName("#__crowdf_countries", "a"))->where("a.id = " . (int) $id);
$this->db->setQuery($query);
$result = $this->db->loadAssoc();
if (!empty($result)) {
$this->bind($result);
}
}
示例15: load
/**
* Load data about profiles from database.
*
* <code>
* $ids = array(1, 2, 3, 4);
*
* $profiles = new Prism\Integration\Profiles\Kunena(\JFactory::getDbo());
* $profiles->load($ids);
* </code>
*
* @param array $userIds
*/
public function load(array $userIds)
{
if (count($userIds) > 0) {
// Create a new query object.
$query = $this->db->getQuery(true);
$query->select('a.userid AS user_id, a.avatar')->from($this->db->quoteName('#__kunena_users', 'a'))->where('a.userid IN ( ' . implode(',', $userIds) . ')');
$this->db->setQuery($query);
$this->profiles = (array) $this->db->loadObjectList('user_id');
}
}