PHP PDO连接mysql数据库和sqlserver数据库

    科技2025-06-26  14

    ini_set('max_execution_time',0); try{ $dns="mysql:host=$host;dbname=$dbname"; $username="root"; $password="123456"; $con_mysql=new PDO("$dns","$username","$password"); }catch(PDOException $e){ echo $e->getMessage(); exit; } try { $host = "$host"; $port = '1433'; $dbname = "$dbname"; $username = "root"; $pw = "123456"; $dbh = null; $dns="sqlsrv:Server=$host;Database=$dbname"; $con_sqlser = new PDO("$dns","$username","$pw"); } catch (PDOException $e) { echo "Failed to get DB handle: " . $e->getMessage() . "\n"; exit; } $query_count="select count(*) from ss_student"; $smt_count=$con_mysql->query($query_count); $res_count=$smt_count->fetchAll(PDO::FETCH_ASSOC);
    Processed: 0.010, SQL: 8