PHP PDO的setAttribute函数
数据库的连接:
1 $dsn = 'mysql:host=127.0.0.1;port=3306;dbname=cardslg'; 2 $username = 'root'; 3 $password = ''; 4 $options = array( 5 PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8', 6 ); 7 $pdo = new PDO($dsn,$username,$password,$options); 8 9 $stmt = $pdo->prepare("SELECT * FROM card_users");
1.PDO::ATTR_CASE :强制列名为指定的大小写。
1)PDO::CASE_UPPER :强制列名大写。
1 $pdo->setAttribute(PDO::ATTR_CASE,PDO::CASE_UPPER); 2 $stmt = $pdo->prepare("SELECT * FROM card_users"); 3 $stmt->setFetchMode(PDO::FETCH_OBJ); 4 $stmt->execute(); 5 $queries = $stmt->fetch(); 6 7 file_put_contents("log.txt",print_r($queries,true));