|
|
我上周末，二天只吃了2次饭，睡觉共有8小时吧，最后把thinkphp换服务器问题给解决了。原因是我的apache版本太高了，2.0以下不支持mssql之原因。同时在网上找代码时，也学习了一下try catch的使用。<html>
<head>
<meta http-equiv='content-type' content='text/html;charset=utf-8'>
<title>/高性能的计算器的结果/</title>
</head>
<body>
<?php
phpinfo();
try {
$hostname = "192.192.192.2"; //host
$dbname = "fymis"; //db name
$username = "asuser"; // username like 'sa'
$pw = "9211110410693107109"; // password for the user
$dbh = new PDO ("mssql:host=$hostname;dbname=$dbname","$username","$pw");
} catch (PDOException $e) {
echo "Failed to get DB handle: " . $e->getMessage() . "\n";
exit;
}
$stmt = $dbh->prepare("SELECT * FROM table");
$stmt->execute();
while ($row = $stmt->fetch()) {
print_r($row);
}
unset($dbh); unset($stmt);
$server='192.192.192.2';$username='asuser';$password='9211110410693107109';$database='fymis';
//方法二
$link="Driver={SQL Server};Server=192.192.192.2;Database=fymis";
$conn=odbc_connect("Driver={SQL Server};Server=192.192.192.2;Database=fymis","asuser","9211110410693107109",SQL_CUR_USE_ODBC);
//$conn=odbc_connect($link,$username,$password,SQL_CUR_USE_ODBC);
echo $conn?NULL:"Couldn't connect to SQL Server on ".$server;
$sql1="SELECT * FROM SYSOBJECTS WHERE XTYPE = 'U' order by name";
$sql="SELECT * FROM Employeeinfo where EmployeeNo='001'";
$result=odbc_exec($conn,$sql);
$i=1;
echo '<pre>';
while($r=odbc_fetch_array($result)){
print_r($r);echo "<br>";
$i++;
}
echo '</pre>';
odbc_free_result($result);
odbc_close($conn);
?>
</body> |
|
|
QQ群⑧：
窥视卡
雷达卡
发表于 2017-4-5 12:05:07
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
千斤顶
显身卡