Connect to a database and display results in a table?

November 8, 2019 mdi45drupal developers

I have a simple MYSQL table.

SELECT * FROM countries;

+----------------------------------------------------+
| id | country                                |
+----------------------------------------------------+
| 1| United Kingdom                       |
| 2| United States                         |
| 3| Afghanistan                            |
| 4| Albania                                  |
+----------------------------------------------------+

I’ve searched hight & low.

What is the best way to query a MYSQL table (countries) and display the results in a Drupal page?

Drupal version:

Drupal 8.x

Source: https://www.drupal.org/taxonomy/term/4/feed

Drupal Blender Feed

Zen sub-theme: change navbar's style December 6, 2019
Please advise how I can modify the style of the navigation bar in the header, e.g. style of the logo image, such as width and height. I used Zen’s StarterKit to create a sub-theme. Drupal version: Drupal 8.x Source: https://www.drupal.org/taxonomy/term/3/feed
stinky feet
Convert Drupal 7 Theme to Drupal 8? December 6, 2019
Hi, I purchased a Drupal theme, not knowing it was made for Drupal 7 and not Drupal 8. What is the easiest way to convert this theme over to Drupal 8? I’ve read this documentation: https://www.drupal.org/docs/8/theming/upgrading-7x-themes-to-8x But it does not help me as the core/modules/system/css/system.module.css[…]
yankindeez
How to change the top picture of blueprint theme for Drupal 6? December 6, 2019
I am so new to this… I just need to change the top image of the website (link below) to another image. The website is using Drupal 6 and the blueprint theme. I am able to get to the theme building page, is that the[…]
sarahtjm
Get node entity in region template December 6, 2019
Hello, I am designing a theme that has a header image on some pages. The ‘page’ content type has an image field, which is pulled into views and thrown in a block at the top of the page. However, some pages don’t have this image,[…]
tophboogie
How to access defined variable in customised block: Drupal 8 Theming December 6, 2019
Hi, In .html.twig file, I can access base_path variable. If I use that variable in customised block, however, it does not work. Do I have to anything to make it available in the block level? Thanks Drupal version: Drupal 8.x Source: https://www.drupal.org/taxonomy/term/3/feed
maadis ie
I do not show the contents of my basic page or article December 6, 2019
Hello, my english is not good but i have a problem in my visualization in my basic page, article or any content type that created. I am use a theming custom, but each time I make a content type and save it does not see[…]
darojasde
Create user account programmatically December 6, 2019
Hi, I have a db mysql with new accounts from LDAP every week. I wanted to create a PHP script with a cron who is creating user accounts from this db, how can i do that ? I’m trying to find the code in the[…]
cofaure
View Block – Exposed Filter : Move "Items per page" selector to the top of the content December 6, 2019
Hi everyone, This is my problem of the day. I would like to display the Items per page at the top of the content block. I’m working on a View Block, this is an Exposed Filter with “Better Exposed Filter”. For now, I’m doing this[…]
heyow
Error when creating a custom file plugin December 6, 2019
Hi I am developing a module that creates a new asset formatter, widgit and type. The asset item is an extension of fileItem. I have added the following $element[‘default_asset_type’] = [ ‘#type’ => ‘select’, ‘#title’ => t(‘Default asset type’), ‘#options’ => [ ‘tone of voice’,[…]
Amirmoj
See some slide of a carousel according to the rights December 6, 2019
Hello, I developed a caroussel with some slide (my code looks like this : https://codepen.io/SitePoint/pen/KwBWJd). I would like to know if it was possible to display some slide according to the rights (example: admin can see 3 slide, a visitor 1 or 2)? Sorry if[…]
Nemtecl
How to update managed_file value with ajax? December 6, 2019
Hi all, how do I refresh the value of the managed_file field using ajax, when i choose drop-down field option. this is my code: function blockthemeeu_form($form, &$form_state) { $options_block = get_options_block(); $selected = isset($form_state['values']['title']) ? $form_state['values']['title'] : key($options_block); $form['title'] = array( '#type' => 'select', '#title'[…]
corncakes
School Administration Module December 6, 2019
How to use School Administration module for creating attendance, Classes and Lessons ,Class Lists in my project Drupal version: Drupal 7.x Source: https://www.drupal.org/taxonomy/term/4/feed
831
Modifying Commerce Product Fields with Rules December 6, 2019
Hello everyone! I am working on a rule to create an organic group node based on a commerce product after it is purchased. So far I’ve been successful in creating the entity and filling in fields from the product fields. I am having trouble updating[…]
paperboystudios
Field TimeTable module December 6, 2019
I have downloaded field timetable module. Created content type with one field of type timetable. Added 2 content to it. while creating view with Field Timetable format nothing is coming in view. Drupal version: Drupal 7.x Source: https://www.drupal.org/taxonomy/term/4/feed
831
Export node title and body content December 6, 2019
My requirement is that user should be able to export the node title and body (description) field in ‘Microsoft Word document’ from node details page (Not from views or block). is there any module/code which works in Drupal 8? Thanks, Drupal version: Drupal 8.x […]
hiramanpatil
A question about drupal_add_js December 6, 2019
Hello I’m checking the function drupal_add_js because I want to load some external resources. But I’d like to know if I load the js resources with drupal_add_js Drupal will move the resources to the bundle of js compress files? thanks Oskar Drupal version: Drupal 7.x[…]
oskar calvo
Template suggestion used from module folder December 6, 2019
Hello, i have the following hook_theme() function mymodule_theme() { return [ 'event' => [ 'render element' => 'elements', ] ]; } I also have the following hook_theme_suggestions_HOOK() function mymodule_theme_suggestions_event(array $variables) { $event = $variables['elements']['#event']; $sanitizedViewMode = $variables['elements']['#view_mode']; $suggestions = []; $suggestions[] = 'event__' . $sanitizedViewMode;[…]
dsteindl
Adding captions as an overlay on images and videos using slick and paragraph modules December 6, 2019
I’m running Drupal 8.3.2. I created a slideshow using Slick and Paragraphs modules. Now I want to add captions as an overlay on my image and video slides. I have tried using Slick Media module, but the instructions provided in the project page are not[…]
thephpguy
Warning: Creating default object from empty value in DrupalCoreEntityContentEntityForm->__construct() December 6, 2019
I’m currently working on a site that has a number of custom entities. Two of these entities (Primary and Secondary) are referenced using entity reference where the cardinality of the entity reference for Secondary is set to unlimited. So when creating a Primary entity, the[…]
welly
How to delete boost cache with arguments. December 6, 2019
Hello, I have a page with this url: demenagement/guides and also I have a view in a block with pagination, the point is that Boost create this files: guides_.html guides_page=1.html guides_page=2.html guieds_page=3.html I also have Expire module, and in custom pages I try this: [node:url]|wildcard[…]
oskar calvo

The Drupal Blender

Reposts from the greatest Drupal minds of our time

Connect to a database and display results in a table?

Related

Share this:

Related