@ 2014-09-24T16:46:21Z <?php
$sql = array("inUserID" =>7250, "inCustID" =>15319, "btAll" => "True", "btPermPref" => "True", "inDisplay"=>0);
function pram_alter($array, $key)
{
//echo implode(',', each($array));
reset($array);
$pStr=null;
$bound = count($array);
while (list($key, $val) = each($array))
{
//echo "$key => $val";
$pStr=$pStr."$key ='" . $val . "',";
$strproc='myProc';
$sqlStatment="exec " . $strproc . " " . $pStr;
}
$sqlStatment =$sqlStatment. $endSqlStatement;
$endSqlStatement = ";";
echo $bound;
return $sqlStatment;
}
$temp=pram_alter($sql, 'pram_alter');
echo $temp;
?>
Enable javascript to submit You have javascript disabled. You will not be able to edit any code.
Output for 8.0.0 - 8.0.30 , 8.1.0 - 8.1.28 , 8.2.0 - 8.2.18 , 8.3.0 - 8.3.6 Fatal error: Uncaught Error: Call to undefined function each() in /in/TqfI4:10
Stack trace:
#0 /in/TqfI4(23): pram_alter(Array, 'pram_alter')
#1 {main}
thrown in /in/TqfI4 on line 10
Process exited with code 255 . Output for 7.2.5 - 7.2.33 , 7.3.16 - 7.3.31 , 7.4.0 - 7.4.33 Deprecated: The each() function is deprecated. This message will be suppressed on further calls in /in/TqfI4 on line 10
Notice: Undefined variable: endSqlStatement in /in/TqfI4 on line 17
5exec myProc inUserID ='7250',inCustID ='15319',btAll ='True',btPermPref ='True',inDisplay ='0', Output for 7.3.32 - 7.3.33 5exec myProc inUserID ='7250',inCustID ='15319',btAll ='True',btPermPref ='True',inDisplay ='0', Output for 5.0.4 - 5.0.5 , 5.1.0 - 5.1.6 , 5.2.0 - 5.2.17 , 5.3.0 - 5.3.29 , 5.4.0 - 5.4.45 , 5.5.24 - 5.5.35 , 5.6.7 - 5.6.28 , 7.0.0 - 7.0.20 , 7.1.0 - 7.1.20 Notice: Undefined variable: endSqlStatement in /in/TqfI4 on line 17
5exec myProc inUserID ='7250',inCustID ='15319',btAll ='True',btPermPref ='True',inDisplay ='0', Output for 4.3.0 - 4.3.11 , 4.4.0 - 4.4.9 , 5.0.0 - 5.0.3 Notice: Undefined variable: endSqlStatement in /in/TqfI4 on line 17
5exec myProc inUserID ='7250',inCustID ='15319',btAll ='True',btPermPref ='True',inDisplay ='0', preferences:dark mode live preview
255.18 ms | 402 KiB | 312 Q