/*执行存储过程
*$pName 过程名 过程里有三个参数 @p_opid int , @p_username varchar(10) , @p_tel varchar(20) *$parName 参数名 -array
*$sqlType 过程数据类型array
*/$pName = pr_user;
$parName = array(
'@p_opid' => '1',
'@p_username' => 'zhangsi',
'@p_tel' =>'200'
);
$sqlType = array(SQLINT4,SQLVARCHAR);
$db-> execProc($pName,$parName,$sqlTyle);
function execProc($pName,$parName,$sqlTyle)
{
$stmt = mssql_init($pName,$this->link);
if(isset($parName))
{
$i = 0;
foreach($parName as $par=>$value)
{
mssql_bind($stmt,$par,$value,$sqlTyle[$i]);
++$i;
}
$res = mssql_execute($stmt);
$this->close(); while($row=mssql_fetch_assoc($res))
{
$r[] = $row;
}
unset($i);
mssql_free_result($res);
mssql_free_statement($stmt);
return $r;
}
}错误-------------------------------
Warning: mssql_bind() [function.mssql-bind]: unsupported type in E:\Apache\htdocs\newProject\test\db.php on line 47Warning: mssql_execute() [function.mssql-execute]: message: 过程或函数 'pr_user' 需要参数 '@p_opid',但未提供该参数。 (severity 16) in E:\Apache\htdocs\newProject\test\db.php on line 50Warning: mssql_execute() [function.mssql-execute]: stored procedure execution failed in E:\Apache\htdocs\newProject\test\db.php on line 50Warning: mssql_fetch_assoc(): supplied argument is not a valid MS SQL-result resource in E:\Apache\htdocs\newProject\test\db.php on line 54
*$pName 过程名 过程里有三个参数 @p_opid int , @p_username varchar(10) , @p_tel varchar(20) *$parName 参数名 -array
*$sqlType 过程数据类型array
*/$pName = pr_user;
$parName = array(
'@p_opid' => '1',
'@p_username' => 'zhangsi',
'@p_tel' =>'200'
);
$sqlType = array(SQLINT4,SQLVARCHAR);
$db-> execProc($pName,$parName,$sqlTyle);
function execProc($pName,$parName,$sqlTyle)
{
$stmt = mssql_init($pName,$this->link);
if(isset($parName))
{
$i = 0;
foreach($parName as $par=>$value)
{
mssql_bind($stmt,$par,$value,$sqlTyle[$i]);
++$i;
}
$res = mssql_execute($stmt);
$this->close(); while($row=mssql_fetch_assoc($res))
{
$r[] = $row;
}
unset($i);
mssql_free_result($res);
mssql_free_statement($stmt);
return $r;
}
}错误-------------------------------
Warning: mssql_bind() [function.mssql-bind]: unsupported type in E:\Apache\htdocs\newProject\test\db.php on line 47Warning: mssql_execute() [function.mssql-execute]: message: 过程或函数 'pr_user' 需要参数 '@p_opid',但未提供该参数。 (severity 16) in E:\Apache\htdocs\newProject\test\db.php on line 50Warning: mssql_execute() [function.mssql-execute]: stored procedure execution failed in E:\Apache\htdocs\newProject\test\db.php on line 50Warning: mssql_fetch_assoc(): supplied argument is not a valid MS SQL-result resource in E:\Apache\htdocs\newProject\test\db.php on line 54
$conn = mysql_connect("localhost", "root", "123456",1,CLIENT_MULTI_RESULTS)or die ("数据连接错误!!!"); 有这样定义吗
$this -> link = @mssql_connect($config['hostname'],$config['dbname'],$config['dbpwd']) or die('数据库连接失败,检查配置');
$select = mssql_select_db($config['dbname'],$this-> link);
}