function prepare_query($sql, $params=null)<\/p>\n
{<\/p>\n
$sql_block = explode(“?”, $sql);<\/p>\n
$sp_size = sizeof($sql_block) – 1;<\/p>\n
$param_size = sizeof($params);<\/p>\n
<\/p>\n
if ( $sp_size == 0 && $params == null)<\/p>\n
return $sql;<\/p>\n
<\/p>\n
if ( ($sp_size < 1) || ($param_size < 1) || ($sp_size != $param_size) )<\/p>\n
return “”;<\/p>\n
<\/p>\n
if ($param_size == 1)<\/p>\n
{<\/p>\n
if ( gettype($params) == ‘string’)<\/p>\n
{<\/p>\n
$result = str_replace(‘?’, “‘”.$params.”‘”, $sql);<\/p>\n
}<\/p>\n
else if ( gettype($params) == ‘integer’)<\/p>\n
{<\/p>\n
$result = str_replace(‘?’, $params, $sql);<\/p>\n
}<\/p>\n
}<\/p>\n
else if ($param_size > 1)<\/p>\n
{<\/p>\n
for ($i = 0; $i < sizeof($params); $i++)<\/p>\n
{<\/p>\n
if ( gettype($params[$i]) == ‘string’)<\/p>\n
$sql_block[$i] .= “‘”.$params[$i].”‘”;<\/p>\n
else if ( gettype($params[$i]) == ‘integer’)<\/p>\n
$sql_block[$i] .= $params[$i];<\/p>\n
}<\/p>\n
<\/p>\n
$result = “”;<\/p>\n
for ($i = 0; $i < $param_size; $i++)<\/p>\n
{<\/p>\n
$result .= $sql_block[$i];<\/p>\n
}<\/p>\n
}<\/p>\n
<\/p>\n
return $result;<\/p>\n
}<\/p>\n","protected":false},"excerpt":{"rendered":"
function prepare_query($sql, $params=nul …<\/p>\n