php 扩展将mysql 整数型转换成字符串类型

最新推荐文章于 2021-02-08 22:23:05 发布

weixin_34342578

最新推荐文章于 2021-02-08 22:23:05 发布

阅读量269

点赞数

文章标签： php 数据库 python

原文链接：https://my.oschina.net/mickelfeng/blog/1592248

版权

2019独角兽企业重金招聘Python工程师标准>>>

真不敢相信

<?php

$mysqli = new mysqli("localhost", "root", "", "test");

if ($mysqli->connect_errno) {
    printf("Connect failed: %s\n", $mysqli->connect_error);
    exit();
}

if ($result = $mysqli->query("SELECT * FROM admin limit 1", MYSQLI_USE_RESULT)) {

    
    while ($row = $result->fetch_object()){
        print_r( gettype($row->id)  );
        print_r( gettype($row->device_type)  );
     }
    $result->close();
}
$mysqli->close();

结果返回：

//string string

postgresql

/*
$user="root";
$pass="";
*/
$user="postgres";
$pass="postgres";
try {
    //$dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass);
    $dbh = new PDO('pgsql:host=localhost;dbname=test', $user, $pass);
    //foreach($dbh->query('SELECT * from admin limit 1') as $row) {
    foreach($dbh->query('SELECT * from company limit 1') as $row) {    
        
        echo gettype($row['age']);
        print_r($row);
    }
    $dbh = null;
} catch (PDOException $e) {
    print "Error!: " . $e->getMessage() . "<br/>";
    die();
}

integerArray
(
[id] => 20001
[0] => 20001
[name] => Paul
[1] => Paul
[age] => 32
[2] => 32
[address] => California0
[3] => California0
[salary] => 20000
[4] => 20000
)