phpeveryday.com

<?php
// configuration
$dbtype		= "sqlite";
$dbhost 	= "localhost";
$dbname		= "test";
$dbuser		= "root";
$dbpass		= "admin";

// database connection
$conn = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass);

// query
$conn->setAttribute(PDO::ATTR_CASE, PDO::CASE_UPPER);
$sql = "SELECT * FROM books";
$q = $conn->prepare($sql);
$q->execute();

$r = $q->fetch(PDO::FETCH_ASSOC);

print_r($r);

//result:
//Array ( [ID] => 1 
//        [TITLE] => PHP AJAX 
//        [AUTHOR] => Andreas 
//        [DESCRIPTION] => This is good book for learning AJAX 
//        [ON_SALE] => 1 
//        [COVER] => )
?>

Ok, now look at line 13:

$conn->setAttribute(PDO::ATTR_CASE, PDO::CASE_UPPER);

We use connection attributes, PDO::ATTR_CASE. This attribute controls the case of column names that are returned by the PDOStatement::fetch(). It will work if fetch mode is PDO::FETCH_ASSOC or PDO::FETCH_BOTH, because the row returned as an array the contains columns indexed by their name. From code above, will get result:

Array ( [ID] => 1 
        [TITLE] => PHP AJAX 
        [AUTHOR] => Andreas 
        [DESCRIPTION] => This is good book for learning AJAX 
        [ON_SALE] => 1 
        [COVER] => )

Others value for this attribute: PDO::CASE_LOWER and PDO::CASE_NATURAL.