Location: PHPKode > projects > Pligg > pligg/plugins/function.db_result_call.php
<?php
/*
 * Template Lite plugin
 * -------------------------------------------------------------
 * Type:	 function
 * Name:	 db_result_call
 * Purpose:  Interface with ADOdb Lite to return all result elements to assigned variable.
 *
 * db_object = Database object
 * db_function = Database result function to execute
 * db_result_object = Database result object
 * db_assign = variable name to assign result data
 * db_errornumber_assign = variable name to assign the database error number
 * db_error_assign = the variable name to assign the database error message
 * db_EOF_assign = the variable name to assign the database end of file flag
 * -------------------------------------------------------------
 */
function tpl_function_db_result_call($params, &$template_object)
{
	if (empty($params['db_object']))
	{
		$template_object->trigger_error("db_result_call: missing db_object parameter");
		return;
	}

	if (!is_object($params['db_object']))
	{
		$template_object->trigger_error("db_result_call: db_object isn't an object");
		return;
	}

	$db = $params['db_object'];

	if (empty($params['db_result_object']))
	{
		$template_object->trigger_error("db_result_call: missing db_result_object parameter");
		return;
	}

	if (!is_object($params['db_result_object']))
	{
		$template_object->trigger_error("db_result_call: db_result_object isn't an object");
		return;
	}

	$result_object = $params['db_result_object'];

	if (empty($params['db_assign']))
	{
		$template_object->trigger_error("db_result_call: missing db_assign parameter");
		return;
	}

	if (empty($params['db_function']))
	{
		$template_object->trigger_error("db_result_call: missing db_function parameter");
		return;
	}

	$db_function = $params['db_function'];

	$result = $result_object->$db_function();

	$template_object->assign($params['db_assign'], $result);

	if (!empty($params['db_errornumber_assign']))
	{
		$template_object->assign($params['db_errornumber_assign'], $db->ErrorNo());
	}

	if (!empty($params['db_error_assign']))
	{
		$template_object->assign($params['db_error_assign'], $db->ErrorMsg());
	}

	if (!empty($params['db_EOF_assign']))
	{
		$template_object->assign($params['db_EOF_assign'], $result_object->EOF);
	}
}
?>
Return current item: Pligg