Web Tutorials - PHP, Drupal

Using MySQLi (Object-Oriented Style)


<?php

$host = "localhost";
$username = "your_username";
$password = "your_password";
$database = "your_database";

// Create connection
$conn = new mysqli($host, $username, $password, $database);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>


Using MySQLi (Procedural Style)

<?php
$host = "localhost";
$username = "your_username";
$password = "your_password";
$database = "your_database";

// Create connection
$conn = mysqli_connect($host, $username, $password, $database);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
echo "Connected successfully";
?>


Using PDO (Recommended for Flexibility and Security)

<?php
$host = 'localhost';
$db   = 'your_database';
$user = 'your_username';
$pass = 'your_password';
$charset = 'utf8mb4';

$dsn = "mysql:host=$host;dbname=$db;charset=$charset";

try {
    $pdo = new PDO($dsn, $user, $pass);
    // Set error mode to exception
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "Connected successfully";
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}
?>

Key differences between Drupal 9 and Drupal 10

Drupal 10 builds upon the Drupal 9 but introduces several key changes and improvements. Below are the main differences:

1. Symfony Upgrade

Drupal 9: Based on Symfony 4, which is now end-of-life.
Drupal 10: Upgraded to Symfony 6, providing better performance, security, and support for modern PHP development practices.

2. CKEditor Upgrade

Drupal 9: CKEditor 4 was the default WYSIWYG editor.
Drupal 10: CKEditor 5 is now the default editor, offering a more modern user experience with enhanced collaboration features, better media handling, and more intuitive controls.

3. Theme Changes

Drupal 9: Used the Bartik theme as the default front-end theme and Seven as the default admin theme.
Drupal 10: Introduces a new default front-end theme called Olivero, which is modern, accessible, and mobile-first. The admin theme Claro replaces Seven, offering a cleaner and more accessible experience.

4. Removal of Deprecated Code

Drupal 9: Included deprecated code from earlier versions, which was required for backward compatibility.
Drupal 10: Deprecated code has been removed, making the core codebase more streamlined and improving performance. This also means that modules and themes must be compatible with the latest APIs.

5. jQuery and Front-End Dependencies

Drupal 9: Relied heavily on jQuery and older JavaScript libraries.
Drupal 10: Reduces reliance on jQuery, adopting modern JavaScript standards to improve performance and minimize dependencies.

6. New Starterkit Theme Generator

Drupal 9: No native tool for theme generation.
Drupal 10: Introduces the Starterkit theme generator, allowing developers to create custom themes more easily by providing a starting point that can be modified.

7. JavaScript Modernization

Drupal 9: Legacy JavaScript approaches (e.g., jQuery-based).
Drupal 10: Emphasizes modern JavaScript (ES6+), reducing the footprint of legacy scripts and focusing on modern browser APIs for faster performance and easier maintainability.

8. Database and Performance Improvements

Drupal 10 brings improvements in database handling and overall performance optimization compared to Drupal 9. This includes enhancements in caching, query performance, and rendering speed.

9. Automatic Updates (Experimental in Drupal 9)

Drupal 9: Automatic updates were experimental but not fully developed.
Drupal 10: Continuation of efforts to fully implement automatic updates, making it easier to maintain site security by keeping the core and contributed modules up-to-date without manual intervention.

10. PHP Compatibility

Drupal 9: Supports PHP 7.4 and later.
Drupal 10: Requires PHP 8.1 or later, leveraging the new features of modern PHP versions for better security and performance.

11. Modules and Deprecated Features

Drupal 9: Includes several modules that were marked as deprecated (e.g., Quick Edit, Aggregator).
Drupal 10: Removes deprecated modules and features to maintain a cleaner core, encouraging the use of external libraries or more modern alternatives.

Drupal 10 Interview Question List

General Drupal Knowledge

What are the key differences between Drupal 9 and Drupal 10? Click Here
What are some of the major improvements in Drupal 10’s performance compared to earlier versions? Click Here
How do you approach a Drupal site migration from an earlier version to Drupal 10?
Explain the significance of the Symfony framework in Drupal 10.
What is the purpose of the Configuration Management System (CMI) in Drupal? How do you use it in your projects?

Custom Module Development

How do you create a custom module in Drupal 10?
What’s the best practice for working with Drupal hooks in custom modules? Can you give examples of hooks you commonly use?
Explain how services and dependency injection work in Drupal 10 custom module development. Click Here
How do you create and define custom routes in Drupal 10?
What are plugins in Drupal, and how would you create a custom plugin?
How do you work with the Drupal 10 Entity API to create or alter content entities?

Click Here

Theming & Frontend

What is the role of Twig in Drupal theming, and how has Twig improved over previous templating engines?
How do you override a template file in Drupal 10, and what steps do you follow to debug theming issues?
What is the purpose of libraries in Drupal theming, and how do you use them to include CSS and JavaScript files?
Can you explain what a Twig extension is and how to create one for a custom project?
What’s your approach to implementing responsive design in Drupal 10?

Configuration Management & Deployment

How does the Drupal 10 Configuration Management system differ from earlier versions?
How do you manage configuration synchronization between different environments (local, dev, production)?
What tools do you use for continuous integration and automated deployment in a Drupal project?
Can you explain how Drupal's Update API works, and how do you handle database updates?

Caching & Performance

What caching mechanisms are available in Drupal 10? How do you optimize a Drupal site’s performance?
How would you diagnose and fix slow database queries in a Drupal environment?
Explain Drupal’s render cache system and how you manage cache invalidation.
How do you use Varnish or Redis to enhance performance in a Drupal project?

Security Best Practices

What steps do you take to secure a Drupal 10 site?
How do you handle user roles, permissions, and access control in Drupal?
Can you explain how you would prevent CSRF, XSS, and SQL Injection attacks in Drupal?
How do you keep your Drupal site up to date with security patches?

Webforms & APIs

How do you create and manage custom webforms in Drupal 10?
Explain how you would integrate third-party APIs with Drupal 10 using REST, JSON
, or GraphQL.
How do you use Drupal's Queue API to handle deferred or asynchronous tasks?

Multilingual & Localization

What’s the process for configuring a multilingual Drupal 10 website?
How do you manage translations for content entities, config entities, and strings in Drupal 10?

Composer & Dependency Management

What role does Composer play in Drupal 10 project management?
How do you handle module updates and core updates using Composer in a project?

Testing & Debugging

What testing frameworks are integrated with Drupal 10? How do you perform automated testing?
Can you walk through how you debug issues in Drupal (e.g., using Xdebug, Drupal’s watchdog log, etc.)?
What is PHPUnit, and how do you write unit tests for Drupal 10 custom modules?

Decoupled Drupal

What is Decoupled Drupal? Have you worked on a decoupled or headless Drupal project? If so, what technologies did you use?
How do you use JSON
or GraphQL to expose Drupal data to an external frontend?

Leadership & Architecture

How do you approach large-scale Drupal projects and ensure high code quality?
What’s your process for performing a site audit and identifying bottlenecks or areas for improvement?
Have you led a team in a Drupal development project? How do you manage code reviews, team coordination, and project milestones?

Drupal Ecosystem

What contributed modules do you commonly use and why?
How do you contribute to the Drupal community (e.g., patches, custom modules, etc.)?
How do you manage custom code while still leveraging Drupal's contributed modules ecosystem?

For PHP Interviews Question Click Here

For MySQL Interviews Question Click Here

Drupal 10 Interview Question Bank (With Answers)

Multiple databases can be connected to Drupal using the Database API and configuring settings.php file.

Use the Database API to connect to additional databases

Add the database connection details to settings.php file

Use the db_set_active() function to switch between databases

Use the db_query() function to execute queries on the selected database

#Drupal 8

#Adding additional databases to your configuration

Preferably you would add your configuration to the settings.php file for your site so that all modules can interact with the new database.

In your settings.php:

$databases['default']['default'] = array (
  'database' => 'drupal8_default',
  'username' => 'root',
  'password' => 'root',
  'prefix' => '',
  'host' => 'localhost',
  'port' => '3306',
  'namespace' => 'Drupal\\Core\\Database\\Driver\\mysql',
  'driver' => 'mysql',
);

$databases['second']['default'] = array (
  'database' => 'drupal8_second',
  'username' => 'root',
  'password' => 'root',
  'prefix' => '',
  'host' => 'localhost',
  'port' => '3306',
  'namespace' => 'Drupal\\Core\\Database\\Driver\\mysql',
  'driver' => 'mysql',
);

#Connect to the correct data base:

//To get the default database key "default"
$con = \Drupal\Core\Database\Database::getConnection();

//To get another database (here : 'second')
$con = \Drupal\Core\Database\Database::getConnection('default','second');

//To set the active connection
$conn = \Drupal\Core\Database\Database::setActiveConnection('second');