当前位置: 首页>>代码示例>>PHP>>正文


PHP mssql_bind函数代码示例

本文整理汇总了PHP中mssql_bind函数的典型用法代码示例。如果您正苦于以下问题:PHP mssql_bind函数的具体用法?PHP mssql_bind怎么用?PHP mssql_bind使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。


在下文中一共展示了mssql_bind函数的14个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: ReaPaises

function ReaPaises($nIdPais)
{
    $sp = mssql_init('REAPAISES');
    //SP
    //Parámetros SP
    mssql_bind($sp, '@nIdPais', $nIdPais, SQLINT4);
    $resultado = mssql_execute($sp);
    //Ejecución SP
    $i = 0;
    while ($row = mssql_fetch_array($resultado)) {
        $html[$i]['id_pais'] = $row[0];
        $html[$i]['nombre'] = $row[1];
        $i++;
    }
    return $html;
    mssql_free_result($resultado);
    //Liberación del recurso
    mssql_free_statement($sp);
    //Liberación del recurso
}
开发者ID:aabritog,项目名称:APP0295,代码行数:20,代码来源:servidor.php

示例2: Parameter

 function Parameter(&$stmt, &$var, $name, $isOutput = false, $maxLen = 4000, $type = false)
 {
     if (!$this->_has_mssql_init) {
         ADOConnection::outp("Parameter: mssql_bind only available since PHP 4.1.0");
         return $sql;
     }
     $isNull = is_null($var);
     // php 4.0.4 and above...
     if ($type === false) {
         switch (gettype($var)) {
             default:
             case 'string':
                 $type = SQLCHAR;
                 break;
             case 'double':
                 $type = SQLFLT8;
                 break;
             case 'integer':
                 $type = SQLINT4;
                 break;
             case 'boolean':
                 $type = SQLINT1;
                 break;
                 # SQLBIT not supported in 4.1.0
         }
     }
     if ($this->debug) {
         $prefix = $isOutput ? 'Out' : 'In';
         $ztype = empty($type) ? 'false' : $type;
         ADOConnection::outp("{$prefix}Parameter(\$stmt, \$php_var='{$var}', \$name='{$name}', \$maxLen={$maxLen}, \$type={$ztype});");
     }
     /*
     	See http://phplens.com/lens/lensforum/msgs.php?id=7231
     	
     	RETVAL is HARD CODED into php_mssql extension:
     	The return value (a long integer value) is treated like a special OUTPUT parameter, 
     	called "RETVAL" (without the @). See the example at mssql_execute to 
     	see how it works. - type: one of this new supported PHP constants. 
     		SQLTEXT, SQLVARCHAR,SQLCHAR, SQLINT1,SQLINT2, SQLINT4, SQLBIT,SQLFLT8 
     */
     if ($name !== 'RETVAL') {
         $name = '@' . $name;
     }
     return mssql_bind($stmt[1], $name, $var, $type, $isOutput, $isNull, $maxLen);
 }
开发者ID:johnfelipe,项目名称:orfeo,代码行数:45,代码来源:adodb-mssql.inc.php

示例3: mssql_init

    }
    echo "retval = {$retval}\n";
    if ($retval != 3) {
        echo "Expected retval 3\n";
        $err = TRUE;
    }
}
// Test 4, SQLVARCHAR output
//
$proc = mssql_init("sp_php_test4", $conn);
$test1 = "";
$retval = 0;
// Bind the parameters
mssql_bind($proc, "@test1", &$test1, SQLVARCHAR, TRUE, FALSE, 13);
// Bind the return value
mssql_bind($proc, "RETVAL", &$retval, SQLINT4);
$result = mssql_execute($proc);
if (!$result) {
    echo "Last message from SQL : " . mssql_get_last_message() . "\n";
    $err = TRUE;
    mssql_free_statement($proc);
} else {
    mssql_free_statement($proc);
    echo "test1 = >{$test1}<\n";
    if ($test1 != 'xyz45678') {
        echo "Expected test1 >xyz45678<\n";
        $err = TRUE;
    }
    echo "retval = {$retval}\n";
    if ($retval != 4) {
        echo "Expected retval 4\n";
开发者ID:ljia310,项目名称:freetds,代码行数:31,代码来源:rpc2.php

示例4: Parameter

 function Parameter(&$stmt, &$var, $name, $isOutput = false, $maxLen = 4000, $type = false)
 {
     if (!$this->_has_mssql_init) {
         ADOConnection::outp("Parameter: mssql_bind only available since PHP 4.1.0");
         return $sql;
     }
     $isNull = is_null($var);
     // php 4.0.4 and above...
     if ($type === false) {
         switch (gettype($var)) {
             default:
             case 'string':
                 $type = SQLCHAR;
                 break;
             case 'double':
                 $type = SQLFLT8;
                 break;
             case 'integer':
                 $type = SQLINT4;
                 break;
             case 'boolean':
                 $type = SQLINT1;
                 break;
                 # SQLBIT not supported in 4.1.0
         }
     }
     if ($this->debug) {
         ADOConnection::outp("Parameter(\$stmt, \$php_var='{$var}', \$name='{$name}'); (type={$type})");
     }
     return mssql_bind($stmt[1], '@' . $name, $var, $type, $isOutput, $isNull, $maxLen);
 }
开发者ID:sraj4,项目名称:EthicsPublicHtmlProd,代码行数:31,代码来源:adodb-mssql.inc.php

示例5: setTimestamp

 /**
  * @see CallableStatement::setTimestamp()
  */
 function setTimestamp($paramIndex, $value, $out = false)
 {
     if ($out) {
         $this->boundOutVars[$paramIndex] =& $value;
     }
     // reference means that changes to value, will be reflected
     if ($value === null) {
         $this->setNull($paramIndex);
     } else {
         if (is_numeric($value)) {
             $value = date('Y-m-d H:i:s', $value);
         }
         mssql_bind($this->stmt, $paramIndex, $value, SQLVARCHAR, $out);
     }
 }
开发者ID:taryono,项目名称:school,代码行数:18,代码来源:MSSQLCallableStatement.php

示例6: BindByReference

 function BindByReference($ParameterName, &$Variable, $Type = null, $Length = null)
 {
     if ($Type === null) {
         $Type = "VARCHAR";
     }
     if (is_string($Type)) {
         $Type = strtoupper($Type);
         if (!array_key_exists($Type, DBAL_MSSQL_StoredProcedure::$Types)) {
             throw new Exception("Unknown SQL Server type in list.");
         }
         $Type = DBAL_MSSQL_StoredProcedure::$Types[$Type];
     }
     if ($Length) {
         mssql_bind($this->Handle, $ParameterName, $Variable, $Type, false, $Variable == null, $Length);
     } else {
         mssql_bind($this->Handle, $ParameterName, $Variable, $Type, false, $Variable == null);
     }
 }
开发者ID:michalkoczwara,项目名称:WebGoatPHP,代码行数:18,代码来源:mssql.php

示例7: mssql_bind

$community = $_POST['community'];
$school = $_POST['school'];
/*
echo "<p>LocID:</p>";
echo $LocID;
echo "<p>SiteKey: </p>";
echo $SiteKey;
echo "<p>Copy Type Key</p>";
echo $CopyTypeKey;
echo "<p>Short:</p>";
echo  $short;
echo "<p>Location: </p>";
echo  $location;
echo "<p>about: </p>";
echo $about;
echo "<p>community: </p>";
echo  $community;
echo "<p>school; </p>";
echo $school;
*/
mssql_bind($Copyproc, '@LocID', $LocID, SQLINT4, false, false, 10);
mssql_bind($Copyproc, '@SiteKey', $SiteKey, SQLINT4, false, false, 1);
mssql_bind($Copyproc, '@CopyTypeKey', $CopyTypeKey, SQLINT1, false, false, 1);
mssql_bind($Copyproc, '@short', $short, SQLTEXT, false, false, 255);
mssql_bind($Copyproc, '@location', $location, SQLTEXT, false, false, 255);
mssql_bind($Copyproc, '@about', $about, SQLTEXT, false, false, 255);
mssql_bind($Copyproc, '@community', $community, SQLTEXT, false, false, 255);
mssql_bind($Copyproc, '@school', $school, SQLTEXT, false, false, 255);
mssql_execute($Copyproc);
mssql_close();
header("Location: http://toolkit.empire-dev.com/copy.php");
开发者ID:brandonwk,项目名称:webadmin,代码行数:31,代码来源:websitecopy.php

示例8: Execute

	public function Execute(){
		if ($this->commandtype == self::C_CMDTEXT)
		{
			//Returns a TRecordset object
			return $this->activeconnection->Execute($this->commandtext);
		}
		elseif ($this->commandtype == self::C_CMDSTOREDPROC)
		{
			try
			{				
				//Call Stored Procedure
				$this->stmt = @mssql_init($this->commandtext, $this->activeconnection->connection_id);
			
				//If can't call Stored Procedure
				if (!$this->stmt) throw new TException(TCustomMessage::GetMessage(5009, $this->commandtext), 5009);

				//Add the SQL Parameters to the Stored Procedure if it exists
				for ($x = 0; $x < $this->parameters->count; $x ++)
				{
					//Add SQL Parameter
					$k = @mssql_bind($this->stmt, $this->parameters->parameter($x)->name, &$this->parameters->parameter($x)->value, $this->parameters->parameter($x)->type,
					$this->parameters->parameter($x)->is_output, $this->parameters->parameter($x)->is_null, $this->parameters->parameter($x)->maxlen);

					//If can't add SQL Parameter
					if (!$k) throw new TException(TCustomMessage::GetMessage(5010, $this->commandtext), 5010);
				}
			
				//Execute Stored Procedure
				$this->result_id = @mssql_execute($this->stmt);	
	
				//If can't execute Stored Procedure
				if (!$this->result_id) throw new TException(TCustomMessage::GetMessage(5011, $this->commandtext), 5011);		

				//Returns a TRecordset object
				return new TRecordset($this->result_id, $this->activeconnection);
			}
			catch (TException $e)
			{
				//Set the exception
				$this->activeconnection->err = $e;
						
				//TCommand::Execute() failed, returns false 
				return false;			
			}
		}
	}
开发者ID:abelcondear,项目名称:repo,代码行数:46,代码来源:MSSQL_ADO.inc.php

示例9: mssql_init

<?php

//Connect to Poolparty
include_once '../includes/connection.php';
// Create a new statement
$stmt = mssql_init('Classstartproc');
// Some data strings
$ClassStartSchedulesID = $_POST['ClassStartSchedulesID'];
$LocID = $_POST['LocID'];
$ScheduleID = $_POST['ScheduleID'];
// Bind values
mssql_bind($stmt, '@ClassStartSchedulesID', $ClassStartSchedulesID, SQLINT1, false, false, 20);
mssql_bind($stmt, '@LocID', $LocID, SQLINT1, false, false, 20);
mssql_bind($stmt, '@ScheduleID', $ScheduleID, SQLTEXT, false, false, 50);
// Execute the statement
$result = mssql_execute($stmt);
echo $result;
// // And we can free it like so:
// mssql_free_statement($stmt);
//
// echo $stmt;
header("Location: http://54.209.36.245/programs.php");
exit;
开发者ID:brandonwk,项目名称:webadmin,代码行数:23,代码来源:Class-start.php

示例10: mssql_init

<?php

//Connect to Poolparty
include_once '../includes/connection.php';
// Create a new statement
$stmt = mssql_init('updatecatalog');
// Some data strings
$SchoolInfoKey = $_POST['SchoolInfoKey'];
$LocID = $_POST['LocID'];
$CatalogURL = $_POST['CatalogURL'];
// Bind values
mssql_bind($stmt, '@SchoolInfoKey', $SchoolInfoKey, SQLINT4, false, false, 20);
mssql_bind($stmt, '@LocID', $LocID, SQLINT4, false, false, 20);
mssql_bind($stmt, '@CatalogURL', $CatalogURL, SQLTEXT, false, false, 500);
// Execute the statement
$result = mssql_execute($stmt);
echo $result;
// // And we can free it like so:
// mssql_free_statement($stmt);
//
// echo $stmt;
header("Location: http://54.209.36.245/programs.php");
exit;
开发者ID:brandonwk,项目名称:webadmin,代码行数:23,代码来源:catalog-update.php

示例11: _bindParam

 /**
  * Binds a parameter to the specified variable name.
  *
  * @param mixed $parameter Name the parameter, either integer or string.
  * @param mixed $variable  Reference to PHP variable containing the value.
  * @param mixed $type      OPTIONAL Datatype of SQL parameter.
  * @param mixed $length    OPTIONAL Length of SQL parameter.
  * @param mixed $options   OPTIONAL Other options.
  * @return bool
  * @throws Zend_Db_Statement_Exception
  */
 protected function _bindParam($parameter, &$variable, $type = null, $length = null, $options = null)
 {
     $is_output = $is_null = null;
     if (isset($options['is_null'])) {
         $is_null = $options['is_null'];
     }
     if (isset($options['is_output'])) {
         $is_output = $options['is_output'];
     }
     if ($length === NULL) {
         $length = -1;
     }
     if ($is_output === NULL) {
         $is_output = false;
     }
     if ($is_null === NULL) {
         $is_null = false;
     }
     try {
         if ($type === null) {
             if (is_bool($variable)) {
                 $type = SQLINT1;
             } elseif ($variable === null) {
                 $type = SQLCHAR;
             } elseif (is_integer($variable)) {
                 $type = SQLINT4;
             } elseif (mb_strlen($variable) > 255) {
                 $type = SQLTEXT;
             } else {
                 $type = SQLVARCHAR;
             }
         }
         return mssql_bind($this->_stmt, $parameter, $variable, $type, $is_output, $is_null, $length);
     } catch (Exception $e) {
         throw new Zend_Db_Statement_Exception($e->getMessage(), $e->getCode(), $e);
     }
 }
开发者ID:diglin,项目名称:diglin_mssql,代码行数:48,代码来源:Mssql.php

示例12: func_mssql_query

function func_mssql_query($query, $sess, &$bin, &$biVal, &$biLen, &$biRes, &$biType)
{
    if (count($bin) >= 1) {
        $res = mssql_init($query);
        for ($i = 0; $i < count($bin); $i++) {
            $TypeParam = TRUE;
            $biRes[$i] = $biVal[$i];
            if ($biLen[$i] == -1) {
                $TypeParam = FALSE;
            }
            if ($biType[$i] == 1) {
                $msType = SQLVARCHAR;
            }
            if ($biType[$i] == 2) {
                $msType = SQLINT4;
            }
            if ($biType[$i] == 3) {
                $msType = SQLFLT8;
            }
            if ($biType[$i] == 4) {
                $msType = SQLVARCHAR;
            }
            mssql_bind($res, $bin[$i], $biRes[$i], $msType, $TypeParam);
        }
        $resExec = mssql_execute($res);
        while (mssql_next_result($resExec)) {
        }
    } else {
        $resExec = mssql_query($query);
        if (!$resExec) {
            ErreurExecutionMSSQL();
        }
    }
    return $resExec;
}
开发者ID:EliosIT,项目名称:PS_AchatFilet,代码行数:35,代码来源:connect.php

示例13: exeStoredProc

 /**
  * method to deal with the execution of MS SQL stored proceedured
  * @param $string $procName The name of the proceedure to execute
  * @param array $paramArray An array containing entries for each paramneeded but the stored proceedure see the exampel in the code below
  */
 function exeStoredProc($procName, $paramArray = false, $skip_results = false)
 {
     // example param array
     // $paramArray = array ('LocationName' => array ('VALUE' => 'the clients host name', 'TYPE' => 'SQLVARCHAR', 'ISOUTPUT' => 'false', 'IS_NULL' =>'false', 'MAXLEN' => '255' ) );
     // each element in the paramArray must idetify a paramiter required by the stored proceedure and can tain an array of settings from that paramiter
     // see http://php.net/manual/en/function.mssql-bind.php for information on the values for these paramiters
     // initiate the stored proceedure
     $stmt = mssql_init($procName, $this->linkid);
     // bind paramiters
     if ($paramArray) {
         foreach ($paramArray as $paramName => $values) {
             mssql_bind($stmt, $paramName, $values['VALUE'], $values['TYPE'], $values['ISOUTPUT'], $values['IS_NULL'], $values['MAXLEN']);
         }
     }
     // execute the stored proceedure
     $results = mssql_execute($stmt);
     // if we do not get anu results return false
     if (!$results) {
         return false;
         // if we get results then put them in to an array and return it
     } else {
         // define the array to return
         $resultArray = array();
         // loop throught he result set and place each result to the resultArray
         do {
             while ($row = mssql_fetch_row($stmt)) {
                 $resultArray[] = $row;
             }
         } while (mssql_next_result($stmt));
         // clean up the statment ready for the next useexec SELLING_GetLocation @LocationName='it-leigh.skilouise.com'
         mssql_free_statement($stmt);
         //returnt he result array
         return $resultArray;
     }
 }
开发者ID:exaflo,项目名称:appli,代码行数:40,代码来源:class.mssql.php

示例14: mssql_bind

$City = $_POST['City'];
$State = $_POST['State'];
$StateID = $_POST['StateID'];
$IsTitle4 = $_POST['IsTitle4'];
$PageH1 = $_POST['PageH1'];
$IsTablet = $_POST['IsTablet'];
$isAndroidTablet = $_POST['isAndroidTablet'];
// Bind values
mssql_bind($info, '@LocID', $LocID, SQLINT4, false, false, 60);
mssql_bind($info, '@DmaID', $DmaID, SQLINT4, false, false, 60);
mssql_bind($info, '@RegionID', $RegionID, SQLINT4, false, false, 60);
mssql_bind($info, '@ZipID', $ZipID, SQLINT4, false, false, 60);
mssql_bind($info, '@Lat', $Lat, SQLINT4, false, false, 100);
mssql_bind($info, '@Lon', $Lon, SQLINT4, false, false, 100);
mssql_bind($info, '@School', $School, SQLVARCHAR, false, false, 255);
mssql_bind($info, '@Brand', $Brand, SQLVARCHAR, false, false, 255);
mssql_bind($info, '@Email', $Email, SQLVARCHAR, false, false, 255);
mssql_bind($info, '@Address', $Address, SQLVARCHAR, false, false, 255);
mssql_bind($info, '@Phone', $Phone, SQLVARCHAR, false, false, 12);
mssql_bind($info, '@URL', $URL, SQLVARCHAR, false, false, 255);
mssql_bind($info, '@City', $City, SQLVARCHAR, false, false, 255);
mssql_bind($info, '@State', $State, SQLVARCHAR, false, false, 50);
mssql_bind($info, '@StateID', $StateID, SQLINT2, false, false, 2);
mssql_bind($info, '@IsTitle4', $IsTitle4, SQLINT1, false, false, 1);
mssql_bind($info, '@PageH1', $PageH1, SQLVARCHAR, false, false, 255);
mssql_bind($info, '@IsTablet ', $IsTablet, SQLINT1, false, false, 1);
mssql_bind($info, '@isAndroidTablet', $isAndroidTablet, SQLINT1, false, false, 1);
// Execute the statement
mssql_execute($info);
mssql_close();
header("Location: http://toolkit.empire-dev.com/schools.php");
开发者ID:brandonwk,项目名称:webadmin,代码行数:31,代码来源:update-school.php


注:本文中的mssql_bind函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。