How can the FETCH_KEY_PAIR method in PDO be utilized for handling multilingual data in PHP?

When handling multilingual data in PHP using PDO, the FETCH_KEY_PAIR method can be utilized to fetch data from the database in a key-value pair format, where the key represents the language code and the value represents the corresponding translation. This method simplifies the process of retrieving and displaying multilingual data in PHP applications. 

// Connect to the database using PDO
$pdo = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');

// Prepare and execute the SQL query to fetch multilingual data
$stmt = $pdo->prepare("SELECT language_code, translation FROM translations WHERE key = :key");
$stmt->execute(array(':key' => 'example_key'));

// Fetch the data in a key-value pair format
$translations = $stmt->fetchAll(PDO::FETCH_KEY_PAIR);

// Display the translations in the desired language
echo $translations['en']; // English translation
echo $translations['fr']; // French translation

Keywords

PDO FETCH_KEY_PAIR multilingual data PHP handling

Related Questions