Static/PhpInclude/FareOfficeLib/Db/Db.php File Reference

Includes database manipulating functions. More...

Go to the source code of this file.

Enumerations
enum	ESC_NONE
	Escape/prepare variables for string SQL queries. More...
enum	ESC_LAST
enum	ESC_FIRST
enum	ESC_BOTH
Functions
&	escN (&$value)
	Escape/prepare variables for numeric SQL queries.
&	escS (&$value, $tkn= '', $type=ESC_LAST)

---

Detailed Description

Includes database manipulating functions.

Author:

Daniel Lindh <[email protected]>

Definition in file Db.php.

---

Enumeration Type Documentation

enum ESC_BOTH

Definition at line 51 of file Db.php.

enum ESC_FIRST

Definition at line 50 of file Db.php.

enum ESC_LAST

Definition at line 49 of file Db.php.

enum ESC_NONE

Escape/prepare variables for string SQL queries.

Example:

 // Will create UPDATE user SET user_name = "Daniel";
 $userName = 'Daniel';
 $sql = 'UPDATE user SET user_name = ' . escS($userName);

 // Will create SELECT * FROM user WHERE user LIKE 'Daniel%';
 $userName = 'Daniel';
 $sql = 'SELECT * FROM user WHERE user LIKE ' . escS($userName, '%');

Definition at line 48 of file Db.php.

---

Function Documentation

& escN

(

&$

value

)

Escape/prepare variables for numeric SQL queries.

Example:

 // Will create UPDATE user SET login_count = NULL;
 $loginCount = NULL;
 $sql = 'UPDATE user SET login_count = ' . $escN($loginCount;

Definition at line 21 of file Db.php.

References emptyString().

{
  if (emptyString($value))
  {
    return 'NULL';
  }
  else
  {
    return $value;
  }
};

& escS	(	&$	value,
		$	tkn = '',
		$	type = ESC_LAST
	)

Definition at line 52 of file Db.php.

References emptyString().

{
  if (is_array($value) || is_object($value))
  {
    $v = serialize($value);
  }
  else
  {
    $v =& $value;
  }

  if (emptyString($v))
  {
    $ret = 'NULL';
  }
  else
  {
    switch ($type)
    {
      case ESC_LAST:
        $ret = '\'' . mysql_real_escape_string($v) . $tkn.'\'';
        break;

      case ESC_FIRST:
        $ret = '\'' . $tkn . mysql_real_escape_string($v).'\'';
        break;

      case ESC_BOTH:
        $ret = '\'' . $tkn . mysql_real_escape_string($v) . $tkn.'\'';
        break;

      case ESC_NONE:
        $ret = '\'' . mysql_real_escape_string($v).'\'';
        break;

      default:
        ASSERTLOG(TRUE, LOG_SYSTEMERROR, 'ecsS: Invalid type', EL_LEVEL_3, ECAT_SYSTEM_CORE);
        exit;
    }
  }

  return $ret;
}