<?php
ob_start();
function runSQL($rsql) {
$hostname = 'WWW-5DFE2B125A3\SQL2005';// 数据库服务器
$username = 'sa'; // 数据库用户名
$password = 'dosoft'; // 数据库密码
$dbname = 'ld'; // 数据库名
$connect = mssql_connect($hostname,$username,$password);
$db = mssql_select_db($dbname,$connect);
$result = mssql_query($rsql);
mssql_free_result $result;
mssql_close();
}
include("include/JSON.php");
if(isset($_GET['parent_id'])){
$where = "WHERE parent_id = ".$_GET['parent_id']." ";
}else{
$where = "WHERE parent_id = 0 ";
}$sql = "SELECT * FROM region $where";
$result = runSQL($sql);
$data_type = "json";
if(isset($_GET['data_type'])){
$data_type = $_GET['data_type'];
}
if($data_type == "json"){
$json_str = "[";
$json = array();
while ($row = mssql_fetch_array($result)) {
$r = array('region_id' => $row['region_id'],
'region_name' => $row['region_name']);
$json[] = JSON($r);
}
$json_str .= implode(',',$json);
$json_str .= "]";
echo $json_str;
}else if($data_type == "xml"){
header("Content-type: text/xml;");
$xml = "<?xml version='1.0' encoding='UTF-8'?>";
$xml .= "<root>";
while ($row = mssql_fetch_array($result)) {
$xml .= "<record>";
$xml .= "<region_id>".$row['region_id']."</region_id>";
$xml .= "<region_name>".$row['region_name']."</region_name>";
$xml .= "</record>";
}
$xml .="</root>";
echo $xml;
}
?>这是一段JQuery三级联动无刷新的连接数据库查询的代码,可是他是连接MYSQL数据库的,我想要个连接SQLSERVER2005的,照着网上的改了一半不会改了,哪位大大能帮忙改完,谢谢了!急用!
'WWW-5DFE2B125A3\\SQL2005'
这贴跟你是一个问题。
$server="WWW-5DFE2B125A3\SQL2005";
$user = "sa";
$password = "dosoft";
$database="ld"; $con = odbc_connect("Driver={SQL Server};Server=$server;Database=$database;", $user, $password) or die("unable to connect"); if (($res = odbc_exec($con, "select * from region")))
{
// echo "<p>\n";
// odbc_result_all($res);
$results=Array();
while(( $result=odbc_fetch_array($res))!=FALSE)
{
$results[]=$result;
}
print_r($results); // echo "</p>\n";
}
odbc_close($con);
?>一个测试。