Joomla CMS  4.2.2
Documentation des API du CMS Joomla en version 4.2.2
Référence du fichier tmpl/sql.php

Espaces de nommage

 Joomla\Plugin
 

Variables

 $value = $field->value
 
if($value=='') $db = Factory::getDbo()
 
 $query = $db->getQuery(true)
 
 $sql = $fieldParams->get('query', '')
 
 $bindNames = $query->bindArray($value, ParameterType::STRING)
 
 try
 
 $items = $db->loadObjectList()
 
catch(Exception $e) $texts = array()
 
 foreach ( $items as $item)
 

Documentation des variables

◆ $bindNames

$bindNames = $query->bindArray($value, ParameterType::STRING)

◆ $db

if ( $value=='') $db = Factory::getDbo()

Référencé par Ucm\__construct(), ContentType\__construct(), Language\__construct(), UpdateSite\__construct(), ViewLevel\__construct(), FeaturedTable\__construct(), Usergroup\__construct(), MenuType\__construct(), MessageTable\__construct(), MapTable\__construct(), UserFactory\__construct(), StyleTable\__construct(), ConsentTable\__construct(), TemplateTable\__construct(), Update\__construct(), LinkTable\__construct(), UpdatesiteTable\__construct(), Module\__construct(), ClientTable\__construct(), NoteTable\__construct(), WorkflowTable\__construct(), StageTable\__construct(), GroupTable\__construct(), Menu\__construct(), FieldTable\__construct(), BannerTable\__construct(), Category\__construct(), RequestTable\__construct(), Content\__construct(), AdapterInstance\__construct(), ContentHistory\__construct(), TransitionTable\__construct(), CredentialRepository\__construct(), TagTable\__construct(), CoreContent\__construct(), FilterTable\__construct(), User\__construct(), Extension\__construct(), NewsfeedTable\__construct(), ContactTable\__construct(), RouterFactory\__construct(), Asset\__construct(), ChangeSet\__construct(), TaskTable\__construct(), Router\__construct(), MfaTable\__construct(), MetadataManager\__construct(), BaseDatabaseModel\__construct(), Workflow\__construct(), UpdateCoreCommand\__construct(), Indexer\__construct(), ChangeItem\__construct(), FinderIndexCommand\__construct(), Table\__construct(), Query\__construct(), ComponentAdapter\_buildAdminMenus(), CategoryModel\_buildContentOrderBy(), PlgContentJoomla\_countItemsInCategory(), PlgContentJoomla\_countItemsInChildren(), PlgContentJoomla\_countItemsInStage(), ExtensionAdapter\_endElement(), Update\_endElement(), GroupTable\_getAssetParentId(), PackageAdapter\_getExtensionId(), InstallerModel\_getList(), PluginsModel\_getList(), ModulesModel\_getList(), UpdateModel\_getList(), Categories\_load(), ModuleAdapter\_rollback_menu(), ModuleAdapter\_rollback_module(), ComponentAdapter\_updateMenus(), Installer\abort(), Task\acquireLock(), RegistrationModel\activate(), LinkModel\activate(), UserHelper\activateUser(), PlgSampledataMultilang\addArticle(), PlgSampledataMultilang\addAssociations(), PlgExtensionFinder\addCommonWords(), Helper\addContentType(), ActionlogModel\addLog(), Taxonomy\addMap(), PlgSampledataMultilang\addModuleInModuleMenu(), MessagesModel\addPostInstallationMessage(), TagsHelper\addTagMapping(), PlgExtensionJoomla\addUpdateSite(), JoomlaInstallerScript\addUserAuthProviderColumn(), UserHelper\addUserToGroup(), admin_postinstall_languageaccess340_condition(), MfaTable\afterDelete(), UpdateModel\applyUpdateSite(), MessagesModel\archiveMessage(), Access\assetgroups(), AdministratorService\association(), Menus\association(), DatabaseModel\backupDatabase(), ItemModel\batchCopy(), ModuleModel\batchCopy(), AdminModel\batchCopy(), CategoryModel\batchCopy(), CategoryModel\batchFlipordering(), ItemModel\batchMove(), CategoryModel\batchMove(), LinksModel\batchProcess(), UserModel\batchReset(), UserModel\batchUser(), ContactModel\buildContactExtendedData(), LevelModel\canDelete(), ContentHelper\canDeleteState(), Category\categories(), Usergroup\check(), LinkTable\check(), ViewLevel\check(), StageTable\check(), WorkflowTable\check(), SetConfigurationCommand\checkDb(), DatabaseHelper\checkDbServerParameters(), DiscoverModel\checkExtensions(), CheckinModel\checkin(), TemplateModel\checkNewName(), ConfigurationModel\checkTestingSampledata(), AssociationsModel\clean(), Installer\cleanDiscoveredExtension(), ArticleModel\cleanupPostBatchCopy(), JoomlaInstallerScript\clearStatsCache(), BannerModel\click(), Banner\clientlist(), TagsHelper\convertPathsToNames(), JoomlaInstallerScript\convertTablesToUtf8mb4(), TemplateModel\copyStyles(), NewsfeedsHelper\countItems(), WorkflowsModel\countItems(), ArticlesModel\countItemsByMonth(), HtmlDocument\countMenuChildren(), ContentHelper\countRelations(), NewsfeedsHelper\countTagItems(), DatabaseModel\createDatabase(), DatabaseModel\createDb(), Factory\createDbo(), PlgPrivacyUser\createNotesDomain(), PlgPrivacyUser\createProfileDomain(), ConfigurationModel\createRootUser(), MVCFactory\createTable(), DatabaseModel\createTables(), MailTemplate\createTemplate(), ExecRuleHelper\dateTimeToSql(), MenuTable\delete(), StageTable\delete(), WorkflowTable\delete(), Versioning\delete(), UCMContent\delete(), UpdatesitesModel\delete(), TracksModel\delete(), Usergroup\delete(), ModuleModel\delete(), ActionlogsModel\delete(), AdminModel\delete(), ArticleModel\delete(), MethodsModel\deleteAll(), CoreContent\deleteByContentId(), ContentHistory\deleteOldVersions(), MailTemplate\deleteTemplate(), PlgSampledataMultilang\disableModuleMainMenu(), PlgSystemStats\disablePlugin(), DiscoverModel\discover(), ListUserCommand\doExecute(), DeleteUserCommand\doExecute(), RemoveUserFromGroupCommand\doExecute(), AddUserToGroupCommand\doExecute(), JoomlaInstallerScript\dropUtf8ConversionTable(), ModuleModel\duplicate(), LinkModel\duplicateUrls(), Users\editor(), PluginsHelper\elementOptions(), PrivateKey\emsa_pss_encode(), PublicKey\emsa_pss_verify(), PlgSampledataMultilang\enablePlugin(), PSSRSA\encodeEMSAPSS(), RSA\encodeEMSAPSS(), WorkflowStage\existing(), ContentLanguage\existing(), FileAdapter\extensionExistsInSystem(), ContactModel\featured(), ArticleModel\featured(), DatabaseModel\fetchSchemaCache(), LanguageAdapter\finaliseUninstall(), FileAdapter\finaliseUninstall(), LibraryAdapter\finaliseUninstall(), TemplateAdapter\finaliseUninstall(), PluginAdapter\finaliseUninstall(), PackageAdapter\finaliseUninstall(), ComponentAdapter\finaliseUninstall(), UpdateModel\finaliseUpgrade(), DatabaseModel\fix(), DatabaseModel\fixSchemaVersion(), JoomlaInstallerScript\fixTemplateMode(), PluginsHelper\folderOptions(), ListHelper\genericordering(), Versioning\get(), ModulesModel\getActivePositions(), PlgSampledataMultilang\getAdminId(), StyleModel\getAdminTemplate(), ConfigHelper\getAllComponents(), ExtensionsListCommand\getAllExtensionsFromDB(), TemplateModel\getAllTemplateStyles(), FieldTable\getAssetId(), Access\getAssetRules(), ConsentBoxField\getAssignedArticleUrl(), FieldsHelper\getAssignedCategoriesIds(), FieldsHelper\getAssignedCategoriesTitles(), ConsentBoxField\getAssignedMenuItemUrl(), AssociationsHelper\getAssociationHtmlList(), CategoriesHelper\getAssociations(), AssociationHelper\getAssociations(), Associations\getAssociations(), User\getAuthorisedCategories(), Access\getAuthorisedViewLevels(), Taxonomy\getBranchTitles(), TracksModel\getCategoryName(), BannersModel\getCategoryOrders(), UpdateModel\getCheckForSelfUpdate(), TracksModel\getClientName(), BannersHelper\getClientOptions(), Helper\getCommonWords(), MessagesModel\getComponentOptions(), DebugHelper\getComponents(), PlgContentContact\getContactData(), MultilangstatusHelper\getContacts(), MultilangstatusHelper\getContentlangs(), ExtensionHelper\getCoreExtensionIds(), PrivacyDashboardHelper\getData(), StatisticsModel\getData(), DatabaseHelper\getDbo(), MultilangstatusHelper\getDefaultHomeModule(), UpdateModel\getDisabledUpdateSites(), EditorField\getEditor(), TagsModel\getEmptyStateQuery(), AssociationsHelper\getEnabledExtensions(), InstallerHelper\getExtensionDownloadKey(), MenuModel\getExtensionElementsForMenuItems(), InstallerHelper\getExtensionGroups(), MessagesModel\getExtensionName(), ExtensionHelper\getExtensionRecord(), TemplatesModel\getExtensions(), SysinfoModel\getExtensions(), InstallerHelper\getExtensionTypes(), FieldsHelper\getFieldsPluginId(), FinderIndexCommand\getFilters(), TemplateModel\getForm(), DebuggroupModel\getGroup(), AddUserCommand\getGroupId(), AddUserToGroupCommand\getGroupId(), RemoveUserFromGroupCommand\getGroupId(), UserMessagesField\getGroups(), MenuField\getGroups(), ContentmapField\getGroups(), WorkflowstageField\getGroups(), TemplatestyleField\getGroups(), AddUserToGroupCommand\getGroups(), MenuitemField\getGroups(), MenuItemByTypeField\getGroups(), RemoveUserFromGroupCommand\getGroups(), FieldsModel\getGroups(), Access\getGroupsByUser(), Access\getGroupTitle(), ContentHistory\getHashMatch(), MultilangstatusHelper\getHomes(), SysinfoModel\getInfo(), PlugininfoField\getInput(), FieldLayoutField\getInput(), ModulelayoutField\getInput(), ComponentlayoutField\getInput(), RulesField\getInput(), ChangeSet\getInstance(), ChangeItem\getInstance(), Table\getInstance(), InstallerScript\getInstances(), ConfigModel\getItem(), MessagesModel\getItem(), NewsfeedModel\getItem(), UpdatesiteModel\getItem(), MessageModel\getItem(), ContactModel\getItem(), FieldModel\getItem(), ArticleModel\getItem(), ModuleModel\getItem(), InstallerScript\getItemArray(), MenusModel\getItems(), TemplatesModel\getItems(), LanguagesModel\getItems(), PositionsModel\getItems(), UsersModel\getItems(), CheckinModel\getItems(), ClientsModel\getItems(), TagsHelper\getItemTags(), UpdatesitesModel\getJoomlaUpdateSitesIds(), TosField\getLabel(), MultilangstatusHelper\getLangswitchers(), PlgExtensionFinder\getLanguage(), AssociationsHelper\getLanguagefilterPluginId(), CMSHelper\getLanguageId(), ContentHelper\getLanguageId(), LanguagesModel\getLanguageList(), PlgSampledataMultilang\getLanguageList(), TermsField\getLayoutData(), PrivacyField\getLayoutData(), StatsHelper\getList(), TagsPopularHelper\getList(), TagsSimilarHelper\getList(), ArticlesArchiveHelper\getList(), LoggedHelper\getList(), RequestsModel\getListQuery(), FiltersModel\getListQuery(), ConsentsModel\getListQuery(), SuggestionsModel\getListQuery(), NotesModel\getListQuery(), FeaturedModel\getListQuery(), SelectModel\getListQuery(), ActionlogsModel\getListQuery(), ArchiveModel\getListQuery(), TracksModel\getListQuery(), DiscoverModel\getListQuery(), ClientsModel\getListQuery(), UpdateModel\getListQuery(), BannersModel\getListQuery(), LevelsModel\getListQuery(), SearchesModel\getListQuery(), MessagesModel\getListQuery(), TasksModel\getListQuery(), LanguagesModel\getListQuery(), TemplatesModel\getListQuery(), StylesModel\getListQuery(), GroupsModel\getListQuery(), StagesModel\getListQuery(), TransitionsModel\getListQuery(), SearchModel\getListQuery(), LinksModel\getListQuery(), TagModel\getListQuery(), FieldsModel\getListQuery(), ContactsModel\getListQuery(), NewsfeedsModel\getListQuery(), TagsModel\getListQuery(), MenusModel\getListQuery(), AssociationsModel\getListQuery(), CategoriesModel\getListQuery(), MapsModel\getListQuery(), IndexModel\getListQuery(), DebuguserModel\getListQuery(), PluginsModel\getListQuery(), DebuggroupModel\getListQuery(), WorkflowsModel\getListQuery(), ArticlesModel\getListQuery(), ItemsModel\getListQuery(), ModulesModel\getListQuery(), PlgFinderTags\getListQuery(), UsersModel\getListQuery(), ManageModel\getListQuery(), HistoryModel\getListQuery(), PlgFinderNewsfeeds\getListQuery(), DatabaseModel\getListQuery(), PlgFinderContent\getListQuery(), PlgFinderCategories\getListQuery(), PlgFinderContacts\getListQuery(), UpdatesitesModel\getListQuery(), InstallationApplication\getLocaliseAdmin(), ActionlogConfigModel\getLogContentTypeParams(), ActionlogsModel\getLogDataAsIterator(), ActionlogsModel\getLogDataQuery(), ActionlogsModel\getLogsData(), ActionlogsModel\getLogsForItem(), ContenthistoryHelper\getLookupValue(), ItemsModel\getMenu(), MenusHelper\getMenuItems(), LoginModel\getMenuLanguage(), MenusHelper\getMenuLinks(), MenusHelper\getMenuTypes(), DatabaseHelper\getMinimumServerVersion(), MenusModel\getMissingModuleLanguages(), MenusModel\getModMenuId(), MultilangstatusHelper\getModule(), ModulesHelper\getModules(), MenuModel\getModules(), ItemModel\getModules(), Taxonomy\getNodeByTitle(), UpdateModel\getNonCoreExtensions(), UpdateModel\getNonCorePlugins(), PrivacyStatusHelper\getNumberUrgentRequests(), RequestsModel\getNumberUrgentRequests(), MfaTable\getNumRecords(), WhosonlineHelper\getOnlineCount(), WhosonlineHelper\getOnlineUserNames(), FieldgroupsField\getOptions(), FrontendlanguageField\getOptions(), AliastagField\getOptions(), NewsfeedsField\getOptions(), ComponentsField\getOptions(), SearchfilterField\getOptions(), MenuParentField\getOptions(), ExtensionField\getOptions(), ComponentsCategoryField\getOptions(), LogtypeField\getOptions(), MenuOrderingField\getOptions(), ConfigComponentsField\getOptions(), ContenttypesField\getOptions(), ComponentsWorkflowField\getOptions(), ComponentsFieldgroupField\getOptions(), ComponentsFieldsField\getOptions(), AuthorField\getOptions(), LogcreatorField\getOptions(), ContenttypeField\getOptions(), TransitionField\getOptions(), PluginsField\getOptions(), TagField\getOptions(), CategoryeditField\getOptions(), SqlField\getOptions(), IndexModel\getPluginState(), ModulesHelper\getPositions(), TemplateModel\getPreview(), UCMContent\getPrimaryKey(), PrivacyHelper\getPrivacyConsentPluginId(), PluginorderingField\getQuery(), OrderingField\getQuery(), DatabaseFactory\getQuery(), QueryHelper\getQueryDate(), RedirectHelper\getRedirectPluginId(), GroupModel\getReorderConditions(), WorkflowModel\getReorderConditions(), BannerModel\getReorderConditions(), CategoryModel\getReorderConditions(), PluginModel\getReorderConditions(), FieldModel\getReorderConditions(), ItemModel\getReorderConditions(), ModuleModel\getReorderConditions(), PrivacyStatusHelper\getRequestFormPublished(), DatabaseModel\getSchemaVersion(), LanguageAdapter\getSefString(), Multilanguage\getSiteHomePages(), Updater\getSitesWithUpdates(), StyleModel\getSiteTemplates(), ArchiveModel\getSlugColumn(), Indexer\getState(), StatsAdminHelper\getStats(), MultilangstatusHelper\getStatus(), PlgSystemUpdatenotification\getSuperUsers(), TagsHelper\getTagIds(), TagsHelper\getTagItemsQuery(), TagsHelper\getTagNames(), TaskModel\getTask(), Taxonomy\getTaxonomy(), MailTemplate\getTemplate(), TemplateModel\getTemplate(), TemplateModel\getTemplateList(), TemplatesHelper\getTemplateOptions(), ModulesHelper\getTemplates(), ChromestyleField\getTemplates(), Query\getTokenData(), Token\getTokenSeedForUser(), PlgUserToken\getTokenSeedForUser(), FilterModel\getTotal(), IndexModel\getTotalIndexed(), ArticlesModel\getTransitions(), ContentType\getTypeId(), MenutypesModel\getTypeOptions(), TagsHelper\getTypes(), TemplateModel\getUpdatedList(), UpdateModel\getUpdateInformation(), LanguagesModel\getUpdateSite(), UpdateAdapter\getUpdateSiteName(), Updater\getUpdateSites(), UpdateModel\getUpdateSitesInfo(), InstallerHelper\getUpdateSitesInformation(), UsersModel\getUserDisplayedGroups(), FiltersField\getUserGroups(), AddUserCommand\getUserGroups(), AddUserToGroupCommand\getUserId(), UserHelper\getUserId(), RegistrationModel\getUserIdFromToken(), UsersLatestHelper\getUsers(), Access\getUsersByGroup(), ItemModel\getViewLevels(), UsersHelper\getVisibleByGroups(), ArchiveModel\getYears(), DatabaseModel\handleOldDatabase(), PlgUserToken\hasTokenProfileFields(), MessagesModel\hideMessages(), httpheaders_postinstall_action(), BannersModel\impress(), Indexer\index(), ConsentsModel\invalidate(), ConsentsModel\invalidateAll(), Table\isCheckedOut(), Multilanguage\isEnabled(), UpdateModel\isTemplateActive(), Token\isTokenEnabledForUser(), PlgSystemPrivacyconsent\isUserConsented(), Access\level(), Menu\linkOptions(), UserGroupsHelper\load(), PlgInstallerOverride\load(), ActionlogsHelper\loadActionLogPluginsLanguage(), UserGroupsHelper\loadAll(), ManageModel\loadChangelog(), LanguageHelper\loadPluginLanguage(), MenusHelper\loadXml(), FinderHelper\logSearch(), Finder\mapslist(), Menu\menuItems(), Menu\menus(), PlgSystemDebug\onAfterDisconnect(), PlgSystemPrivacyconsent\onAfterRender(), PlgSystemActionLogs\onAfterRespond(), PlgContentJoomla\onContentAfterSave(), PlgContentPagenavigation\onContentBeforeDisplay(), Joomla\onContentChangeState(), PlgContentJoomla\onContentChangeState(), PlgUserProfile\onContentPrepareData(), PlgSystemActionLogs\onContentPrepareData(), PlgExtensionJoomla\onExtensionAfterUninstall(), Adapter\onFinderGarbageCollection(), ContentHelper\onPrepareForm(), PlgPrivacyActionlogs\onPrivacyExportRequest(), PlgPrivacyConsents\onPrivacyExportRequest(), PlgPrivacyMessage\onPrivacyExportRequest(), PlgUserToken\onUserAfterDelete(), PlgUserProfile\onUserAfterDelete(), PlgSystemActionLogs\onUserAfterDelete(), PlgUserToken\onUserAfterSave(), PlgUserProfile\onUserAfterSave(), PlgSystemActionLogs\onUserAfterSave(), PlgAuthenticationJoomla\onUserAuthenticate(), Basic\onUserAuthenticate(), PlgSystemRemember\onUserBeforeSave(), Joomla\onUserLoginFailure(), Indexer\optimize(), Category\options(), Tag\options(), QueryHelper\orderbySecondary(), Menu\ordering(), ModuleController\orderPosition(), TemplateAdapter\parseQueries(), Installer\parseQueries(), Installer\parseSchemaUpdates(), Installer\parseSQLFiles(), DatabaseModel\populateDatabase(), GroupsModel\populateExtraData(), Modules\positionList(), JoomlaInstallerScript\postflight(), WorkflowController\postSaveHook(), Access\preloadComponents(), Access\preloadPermissions(), NewsfeedModel\prepareTable(), BannerModel\prepareTable(), ContactModel\prepareTable(), PluginModel\preprocessForm(), FormModel\preprocessForm(), ExtensionDiscoverInstallCommand\processDiscover(), Query\processDynamicTaxonomy(), SqlField\processQuery(), RemindModel\processRemindRequest(), ResetModel\processResetConfirm(), ResetModel\processResetRequest(), Query\processStaticTaxonomy(), TemplateModel\publish(), LinksModel\purge(), MessagesModel\purge(), OverridesModel\purge(), DiscoverModel\purge(), UpdateModel\purge(), IndexModel\purge(), MapsModel\purge(), AssociationsModel\purge(), FinderIndexCommand\putFilters(), Usergroup\rebuild(), UpdatesitesModel\rebuild(), ItemModel\rebuild(), StringsModel\refresh(), ServiceProviderInterface\register(), Database\register(), RegistrationModel\register(), Task\releaseLock(), PlgSystemPrivacyconsent\remindExpiringConsents(), Indexer\remove(), PlgExtensionFinder\removeCommonWords(), Taxonomy\removeMaps(), Taxonomy\removeOrphanMaps(), Taxonomy\removeOrphanNodes(), MessagesModel\republishMessage(), SearchesModel\reset(), MessagesModel\resetMessages(), LanguageAdapter\resetUserLanguage(), MenusHelper\resolveAlias(), MenusController\resync(), PrivateKey\rsaes_oaep_decrypt(), PublicKey\rsaes_oaep_encrypt(), FieldModel\save(), ConfigModel\save(), UpdatesiteModel\save(), ApplicationModel\save(), StyleModel\save(), CategoryModel\save(), ModuleModel\save(), AdminModel\save(), ItemModel\save(), LibraryHelper\saveParams(), PlgSystemStats\saveParams(), StringsModel\search(), TagsHelper\searchTags(), Filter\select(), MailModel\send(), ActionlogModel\sendNotificationEmails(), Joomla\Database\setDatabase(), Joomla\CMS\MVC\Model\setDbo(), DatabaseImporter\setDbo(), BaseDatabaseModel\setDbo(), Table\setDbo(), MethodsModel\setFlag(), StyleModel\setHome(), User\setLastVisit(), InstallerScript\setParams(), Installer\setSchemaVersion(), ConfigurationModel\setup(), TemplateAdapter\setupUninstall(), UserHelper\setUserGroups(), Task\skipExecution(), Filter\slider(), Menu\store(), Taxonomy\storeNode(), CoreContent\storeUcmBase(), ArticleModel\storeVote(), MfaTable\switchDefaultRecord(), TagsHelper\tagDeleteInstances(), Tag\tags(), Users\templatestyle(), ExistsRule\test(), UserIdRule\test(), UsernameRule\test(), EmailRule\test(), Indexer\toggleTables(), UpdateAdapter\toggleUpdateSite(), Date\toSql(), UserGroupsHelper\total(), Finder\typeslist(), JoomlaInstallerScript\uninstallEosPlugin(), MessagesModel\unpublishMessage(), StyleModel\unsetHome(), TagsHelper\unTagItem(), JoomlaInstallerScript\updateContentTypes(), TemplatesModel\updated(), JoomlaInstallerScript\updateDatabaseMysql(), Updater\updateLastCheckTimestamp(), JoomlaInstallerScript\updateManifestCaches(), MailTemplate\updateTemplate(), ConfigurationModel\updateUserIds(), User\userlist(), ListHelper\users(), RequestModel\validate(), SetupModel\validateDbConnection(), PSSRSA\verifyEMSAPSS(), et RSA\verifyEMSAPSS().

◆ $items

$items = $db->loadObjectList()

◆ $query

$query = $db->getQuery(true)

◆ $sql

◆ $texts

catch (Exception $e) $texts = array()

◆ $value

$value = $field->value

◆ foreach

foreach($items as $item)

◆ try

try
Valeur initiale :
{
$db->setQuery($query)
if($value=='') $db
Definition: tmpl/sql.php:22
$query
Definition: tmpl/sql.php:24