PDO Autobind Function Viability

[imperium2335]

Hi,

 

I got tired of typing out the same bindParam etc etc so I came up with the function below.

 

As long as you enter your variables into the array in the same order as your placeholders, it works well.

 

Please let me know your thoughts on how to make it better or perhaps there is a method out there that already exists which makes this function pointless!?

 

function autoBind($SQL, $varsArray, $mode = 'FETCH_ASSOC') {

include('dbconnect.php') ;

$result = $dbh->prepare($SQL) ;

$i = 1 ;
foreach($varsArray as $current) {

	if(is_numeric($current))
	{
		$result->bindValue($i, $current, PDO::PARAM_INT) ;
	}
	else // Must be string.
	{
		$result->bindValue($i, $current, PDO::PARAM_STR) ;

	}
	$i++ ;
}
$result->execute() ;

if($mode == 'FETCH_ASSOC')
{
	$output = $result->fetch(PDO::FETCH_ASSOC) ;
}
elseif($mode == 'FETCHCOLUMN')
{
	$output = $result->fetchColumn() ;
}

return $output ;

}

[imperium2335]

Also, does anyone know why bindParam doesn't work? It's why I used bindValue instead.

[imperium2335]

*bump*