Reacties op de tutorial MySQL Error Handling

<?php
$sQuery = "SELECT * FROM <tbl>";
if(!$rResult = MySQL_Query($sQuery))
{
  echo MySQL_Error();
} else
{
  // de rest van je script
}
?>

<?php
$sQuery = "SELECT * FROM <tbl>";
if(!$rResult = MySQL_Query($sQuery))
{
  echo MySQL_Error();
} else
{
  // de rest van je script
}
?>

<?php
function query($query, $fetch="assoc")
{
	global $cfg; // config array
	$die      = $cfg['query']['die']; // die on error?
	$log      = $cfg['query']['log']; // log errors?
	$redirect = $cfg['query']['redirect']; // redirect to error page?

	$ret = array();
	$res = @mysql_query($query);

	if(mysql_error() != "")
	{
		// error handling
		$err = array();
		$err[] = $cfg['mod']."/".$cfg['sub'];
		$err[] = mysql_errno(); // 999-1175
		$err[] = htmlentities(mysql_error()); // possible javascript inserts
		$err[] = htmlentities($query, ENT_QUOTES); // for readability

		// die?
		if($die)
		{
			// dump $err
			// (testomgeving)
		}

		// log?
		if($log)
		{
			// log error, b.v. mail naar webmasters
		}

		// relocate?
		if($redirect)
		{
			// redirect naar nette errorpagina
			// (produktie-omgeving)
		}
	}
	else
	{
		// any results?
		if(mysql_num_rows($res))
		{
			// fetch results
			switch($fetch)
			{
				// fetch row
				case "row":
					while($row = mysql_fetch_row($res)) $ret[] = $row;
					break;
				// fetch assoc - is also default
				case "assoc":
				default:
					while($row = mysql_fetch_assoc($res)) $ret[] = $row;
			}

			// free results
			mysql_free_result($res);
		}
	}

	// return results
	return $ret;
}
?>

<?php
function query($query, $fetch="assoc")
{
	global $cfg; // config array
	$die      = $cfg['query']['die']; // die on error?
	$log      = $cfg['query']['log']; // log errors?
	$redirect = $cfg['query']['redirect']; // redirect to error page?
 
	$ret = array();
	$res = @mysql_query($query);
 
	if(mysql_error() != "")
	{
		// error handling
		$err = array();
		$err[] = $cfg['mod']."/".$cfg['sub'];
		$err[] = mysql_errno(); // 999-1175
		$err[] = htmlentities(mysql_error()); // possible javascript inserts
		$err[] = htmlentities($query, ENT_QUOTES); // for readability
 
		// die?
		if($die)
		{
			// dump $err
			// (testomgeving)
		}
 
		// log?
		if($log)
		{
			// log error, b.v. mail naar webmasters
		}
 
		// relocate?
		if($redirect)
		{
			// redirect naar nette errorpagina
			// (produktie-omgeving)
		}
	}
	else
	{
		// any results?
		if(mysql_num_rows($res))
		{
			// fetch results
			switch($fetch)
			{
				// fetch row
				case "row":
					while($row = mysql_fetch_row($res)) $ret[] = $row;
					break;
				// fetch assoc - is also default
				case "assoc":
				default:
					while($row = mysql_fetch_assoc($res)) $ret[] = $row;
			}
 
			// free results
			mysql_free_result($res);
		}
	}
 
	// return results
	return $ret;
}
?>