- reset: documentation ( source)
- each: documentation ( source)
<?php
$sql = array("inUserID" =>7250, "inCustID" =>15319, "btAll" => "'True'", "btPermPref" => "'True'", "inDisplay"=>0);
function pram_alter($array)
{
//echo implode(',', each($array));
reset($array);
$pStr=null;
$sqlStatment=null;
$bound = count($array);
$endSqlStatement = ";";
$count=0;
while (list($key, $val) = each($array))
{
if ($count < ($bound-1)){
$pStr=$pStr."@$key = $val, ";
}
else
{
$pStr=$pStr."@$key =$val;\" ";
}
$strproc='myProc';
$sqlStatment="\"exec " . $strproc . " " . $pStr;
$count ++;
}
return $sqlStatment;
}
$temp=pram_alter($sql);
echo $temp;
?>