作者:云聪京初瑞子_617 | 来源:互联网 | 2018-04-24 11:20
直接上代码:$sql"selectmrnfromAwheretype2";mysql数据库$result$dbFin->query($sql);while($row$result->fetch_assoc()){$sqlPid"selectnamefromTestDB.dbo.Bwherepid'{$row['mrn']}'";sqlse
mysqlphpmssqlcakephp
直接上代码:
$sql = "select mrn from A where type=2"; //mysql数据库
$result = $dbFin->query($sql);
while ($row = $result->fetch_assoc()) {
$sqlPid = "select name from TestDB.dbo.B where pid= '{$row['mrn']}'"; //sql server 数据库
$rs = mssql_query($sqlPid,$dbClin);
if($rs && mssql_num_rows($rs)) {
$r = mssql_fetch_assoc($rs);
$name = $r['name'];
}
$row["patientName"]=$name; ); 这样的代码在循环中访问数据库,在数据量特别大时会很费时间, 应该如何写效率会提高呢