db_mysql.inc.php

Go to the documentation of this file.

<?php

 
if(PHP_VERSION >= "5")
    if(!extension_loaded('mysql'))
        if(!@dl('php_mysql.dll')) {
            wb_message_box(null, "MySQL extension could not be loaded.", "Error", WBC_STOP);
            trigger_error("MySQL extension could not be loaded.\n", E_USER_ERROR);
        }
 
// -------------------------------------------------------------------- CONSTANTS
define("DB_MYSQL_WRAP", "db_v2b");
define("FETCH_BOTH", MYSQL_BOTH);
define("FETCH_NUM", MYSQL_NUM);
define("FETCH_ASSOC", MYSQL_ASSOC);
// ----------------------------------------------------------- DATABASE VERSION CHECK

function raw_get_db_version()
{
    return mysql_get_server_info();
}
 
if (DB_WRAPVERSION != DB_MYSQL_WRAP) {
  die(" db_common.inc.php has different version number than db_mysql.inc.php ");
}
// ----------------------------------------------------------- DATABASE FUNCTIONS
function raw_db_open_database($database, $server = "", $username = "", $password = "")
{
  global $curr_db;
 
  $conn = mysql_connect($server, $username, $password);
  if (!$conn) {
    trigger_error(__FUNCTION__ . ": " . mysql_error());
    return false;
  } else {
    $curr_db = $database;
    if (!mysql_select_db($database)) {
      trigger_error(__FUNCTION__ . ": " . mysql_error());
      return false;
    }
  }
  return $conn;
}

function raw_db_create_database($database, $server = "", $username = "", $password = "")
{
  global $curr_db;
 
  $conn = mysql_connect($server, $username, $password);
  if (!$conn) {
    trigger_error(__FUNCTION__ . ": " . mysql_error());
    return false;
  } else {
    if (!mysql_query("CREATE DATABASE IF NOT EXISTS " . $database))
      die(mysql_error());
    $curr_db = $database;
    if (!mysql_select_db($database)) {
      trigger_error(__FUNCTION__ . ": " . mysql_error());
      return false;
    }
  }
  return $conn;
}

function raw_db_list_database_tables()
{
  global $curr_db;
 
  $hresult = mysql_query("SHOW TABLES FROM $curr_db");
  if (!$hresult) {
    // no Tables in $database
    return false;
  } else {
    while ($row = mysql_fetch_array($hresult, MYSQL_NUM)) {
      $tables[] = $row[0];
    } // while
    return $tables;
  }
}

function raw_db_close_database()
{
  return mysql_close();
}
// -------------------------------------------------------------- TABLE FUNCTIONS
function raw_db_table_exists($tablename)
{
  global $g_current_db;
 
  $sql = "SELECT 1 FROM $tablename LIMIT 0";
  $res = mysql_query($sql);
  if ($res) {
    return true;
  } ;
  return false;
}

function raw_db_rename_table($tablename, $newname)
{
  global $g_lasttable;
 
  if (!$tablename)
    $tablename = $g_lasttable;
 
  $g_lasttable = $newname;
  $res = mysql_query("RENAME TABLE $tablename TO $newname");
  return $res;
}

function raw_db_list_table_fields_def($tablename, $type = false)
{
  $result = mysql_query("SHOW COLUMNS FROM $tablename");
  if ($result === false) return false;
  $coltype = array();
  $colnames = array();
  if (mysql_num_rows($result) > 0) {
    while ($row = mysql_fetch_assoc($result)) {
      $colnames[] = $row['Field'];
      $coltype[] = $row['Type'];
    } // while
  }
  if (mysql_free_result($result) == false) return false;
  return ($type ? $coltype : $colnames);
}
// -------------------------------------------------------------- FIELD FUNCTIONS
function raw_db_create_field($tablename, $field, $type)
{
  global $g_lasttable;
 
  if (!$tablename)
    $tablename = $g_lasttable;
  $g_lasttable = $tablename;
 
  $res = mysql_query("ALTER TABLE $tablename ADD $field $type");
  return $res;
}

function raw_db_delete_field($tablename, $field)
{
  global $g_lasttable;
 
  if (!$tablename)
    $tablename = $g_lasttable;
  $g_lasttable = $tablename;
 
  $res = mysql_query("ALTER TABLE $tablename DROP $field");
  return $res;
}

function raw_db_rename_field($tablename, $field, $newname, $type)
{
  global $g_lasttable;
 
  if (!$tablename)
    $tablename = $g_lasttable;
  $g_lasttable = $tablename;
 
  $res = mysql_query("ALTER TABLE $tablename CHANGE $field $newname $type");
  return $res;
}

function raw_db_edit_field($tablename, $field, $type)
{
  global $g_lasttable;
 
  if (!$tablename)
    $tablename = $g_lasttable;
  $g_lasttable = $tablename;
 
  $res = mysql_query("ALTER TABLE $tablename MODIFY $field $type");
  return $res;
}
// ---------------------------------------------------------------- SQL FUNCTIONS
function raw_db_query($query)
{
  $res = mysql_query($query);
  return $res;
}

function raw_db_fetch_array($result, $type = FETCH_BOTH)
{
  return mysql_fetch_array($result, $type);
}

function raw_db_free_result($result)
{
  mysql_free_result($result);
}

function raw_db_escape_string($str)
{
  return mysql_real_escape_string($str);
}
// ------------------------------------------------------------------ END OF FILE
 
?>