微微族

/**
*?create?the?connection
*/
function connect()
{
$this->link = mssql_connect($this->host,$this->user,$this->keys);
if(!$this->link)
{
die(‘connecting?failed…check?the?module?and?setting…‘);
}
$select = mssql_select_db($this->base,$this->link);
if(!$select)
{
die(‘data?base?is?not?exist…,please?checke?it?…‘);
}
}

/**
*?execute?the?procedur?width?the?parameter
*?@param?<type>?$pName?procedur?name
*?@param?<type>?$parName?parameters?it’s?like?this?$par=array(‘@a’=>’a')
*?@param?<type>?$sqlTyle?the?procedur’s?parameter?type,?it’s?llike?this?$sqlType=array(SQLVARCHAR,SQLVARCHAR);?and?there?is?not?the?char?single?quote?mark(‘).
*?@return?<type>?object?array
*/
function executeProcedur($pName,$parName,$sqlTyle)
{
$this->connect();

$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;
}
}

/**
*?execute?procedur?without?the?parameter
*?@param?<type>?$pName?Procedur?Name
*?@return?<type>?object?array
*/
function executeProcedurNoPar($pName)
{
$this->connect();

$stmt = mssql_init($pName,$this->link);
$res = mssql_execute($stmt);

$this->close();

while($row=mssql_fetch_assoc($res))
{
$r[] = $row;
}
mssql_free_result($res);
mssql_free_statement($stmt);
return $r;
}
/**
*?Get?one?row?return?Array
*?@param?<type>?$sql
*?@return?<type>?Array
*/
function getRowArray($sql)
{
$res = $this->query($sql);
$r = mssql_fetch_row($res);
mssql_free_result($res);
return $r;
}
/**
*?Get?one?row?return?object
*?@param?<type>?$sql?Sql
*?@return?<type>?Object
*/
function getRowObject($sql)
{
$res = $this->query($sql);
$r = mssql_fetch_assoc($res);
return $r;

}

/**
*?Execute?one?sql
*?@param?<type>?$sql?Sql
*?@return?<type>?result
*/
function query($sql)
{
$this->connect();
$res = mssql_query($sql,$this->link);
$this->close();
return $res;
}

/**
*?Get?every?row?from?result?by?Object,?Return?a?Array?with?every?element?is?Object
*?@param?<type>?$sql
*?@return?<type>?Object?Array?result
*/
function getResult($sql)
{
$res = $this->query($sql);
while($row=mssql_fetch_assoc($res))
{
$r[] = $row;
}
unset($row);
mssql_free_result($res);
return $r;
}

/**
*?execute?a?sql
*?@param?<type>?$sql?Sql
*/
function executeSql($sql)
{
return $this->query($sql);
}

/**
*??execute?a?sql?statement
*?@param?<type>?$sql
*?@return?<type>?int?$affected?rows
*/
function querySql($sql)
{
$this->connect();
mssql_query($sql,$this->link);
$affected = mssql_rows_affected($this->link);
$this->close();
return $affected;
}

/**
*?close?connection
*/
function close()
{
mssql_close();
}
}
?>