public function delete() { if (!empty($_POST['del'])) { // Nuke departments.. mysql_query("DELETE FROM `" . DB_PREFIX . "departments`\n WHERE `id` IN(" . implode(',', $_POST['del']) . ")\n\t") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__)); $rows = mysql_affected_rows(); // Nuke user department association.. mysql_query("DELETE FROM `" . DB_PREFIX . "userdepts`\n WHERE `deptID` IN(" . implode(',', $_POST['del']) . ")\n ") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__)); if (mswRowCount('departments') == 0) { @mysql_query("TRUNCATE TABLE `" . DB_PREFIX . "departments`"); } if (mswRowCount('userdepts') == 0) { @mysql_query("TRUNCATE TABLE `" . DB_PREFIX . "userdepts`"); } // Rebuild order sequence.. $seq = 0; $q = mysql_query("SELECT `id` FROM `" . DB_PREFIX . "departments` ORDER BY `orderBy`"); while ($RB = mysql_fetch_object($q)) { $n = ++$seq; mysql_query("UPDATE `" . DB_PREFIX . "departments` SET\n\t `orderBy` = '{$n}'\n WHERE `id` = '{$RB->id}'\n ") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__)); } return $rows; } return '0'; }
/** * 连接数据库方法 * @access public * @throws ThinkExecption */ public function connect($config = '', $linkNum = 0, $force = false) { if (!isset($this->linkID[$linkNum])) { if (empty($config)) { $config = $this->config; } // 处理不带端口号的socket连接情况 $host = $config['hostname'] . ($config['hostport'] ? ":{$config['hostport']}" : ''); // 是否长连接 $pconnect = !empty($config['params']['persist']) ? $config['params']['persist'] : $this->pconnect; if ($pconnect) { $this->linkID[$linkNum] = mysql_pconnect($host, $config['username'], $config['password'], CLIENT_MULTI_RESULTS); } else { $this->linkID[$linkNum] = mysql_connect($host, $config['username'], $config['password'], true, CLIENT_MULTI_RESULTS); } if (!$this->linkID[$linkNum] || !empty($config['database']) && !mysql_select_db($config['database'], $this->linkID[$linkNum]) || C('SPARE_DB_DEBUG')) { $errStr = mysql_error(); $errno = mysql_errno(); if ($errno == 13047 || C('SPARE_DB_DEBUG')) { if (C('SMS_ALERT_ON')) { Sms::send('mysql超额被禁用,请在SAE日志中心查看详情', $errStr, Sms::MYSQL_ERROR); } //[sae]启动备用数据库 if (C('SPARE_DB_HOST')) { $this->linkID[$linkNum] = mysql_connect(C('SPARE_DB_HOST') . (C('SPARE_DB_PORT') ? ':' . C('SPARE_DB_PORT') : ''), C('SPARE_DB_USER'), C('SPARE_DB_PWD'), true, CLIENT_MULTI_RESULTS); if (!$this->linkID[$linkNum]) { throw_exception('备用数据库连接失败'); } mysql_select_db(C('SPARE_DB_NAME'), $this->linkID[$linkNum]); //标记使用备用数据库状态 $this->is_spare = true; } else { throw_exception($errStr); } } else { //[sae] 短信预警 if (C('SMS_ALERT_ON')) { Sms::send('数据库连接时出错,请在SAE日志中心查看详情', $errStr, Sms::MYSQL_ERROR); } throw_exception($errStr); } } $dbVersion = mysql_get_server_info($this->linkID[$linkNum]); if ($dbVersion >= '4.1') { //使用UTF8存取数据库 需要mysql 4.1.0以上支持 mysql_query("SET NAMES '" . C('DB_CHARSET') . "'", $this->linkID[$linkNum]); } //设置 sql_model if ($dbVersion > '5.0.1') { mysql_query("SET sql_mode=''", $this->linkID[$linkNum]); } // 标记连接成功 $this->connected = true; // 注销数据库连接配置信息 if (1 != C('DB_DEPLOY_TYPE')) { unset($this->config); } } return $this->linkID[$linkNum]; }
function select($sql) { //Para MYSQL switch ($_SESSION["gestor"]) { case 'MYSQL': $result = mysql_query($sql,$this->conn); if(!$result) { $this->message = mysql_error() . "\n"; $this->message .= mysql_errno(); //die($message); } else { //$data=$this->obtener_datos($result); return $result; } break; case 'POSTGRE': $result = pg_query($this->conn,$sql); if(!$result) { $message = 'Invalid query: ' . pg_last_error() . "\n"; $message .= 'Whole query: ' . $sql; die($message); } else { //$data=$this->obtener_datos($result); return $result; } break; } }
function query($sql, $unbuffered = false) { if (defined('PUN_SHOW_QUERIES')) { $q_start = get_microtime(); } if ($unbuffered) { $this->query_result = @mysql_unbuffered_query($sql, $this->link_id); } else { $this->query_result = @mysql_query($sql, $this->link_id); } if ($this->query_result) { if (defined('PUN_SHOW_QUERIES')) { $this->saved_queries[] = array($sql, sprintf('%.5f', get_microtime() - $q_start)); } ++$this->num_queries; return $this->query_result; } else { if (defined('PUN_SHOW_QUERIES')) { $this->saved_queries[] = array($sql, 0); } $this->error_no = @mysql_errno($this->link_id); $this->error_msg = @mysql_error($this->link_id); return false; } }
public function query($sql) { $resource = mysql_query($sql, $this->link); if ($resource) { if (is_resource($resource)) { $i = 0; $data = array(); while ($result = mysql_fetch_assoc($resource)) { $data[$i] = $result; $i++; } mysql_free_result($resource); $query = new stdClass(); $query->row = isset($data[0]) ? $data[0] : array(); $query->rows = $data; $query->num_rows = $i; unset($data); return $query; } else { return true; } } else { trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br />' . $sql); exit; } }
public function __construct() { // attempt to connect if (!($this->db = !$_SERVER['tracker']['db_persist'] ? mysql_connect($_SERVER['tracker']['db_host'], $_SERVER['tracker']['db_user'], $_SERVER['tracker']['db_pass']) : mysql_pconnect($_SERVER['tracker']['db_host'], $_SERVER['tracker']['db_user'], $_SERVER['tracker']['db_pass'])) or !mysql_select_db($_SERVER['tracker']['db_name'], $this->db)) { tracker_error(mysql_errno($this->db) . ' - ' . mysql_error($this->db)); } }
/** * Performs an SQL query. * * @param string $query * @param mixed $limit * @param boolean $warnOnFailure * @param boolean $tablesAlreadyCreated * @access public */ function query($query, $limit = false, $warnOnFailure = true, $tablesAlreadyCreated = false) { if ($this->isManip($query)) { if (!$tablesAlreadyCreated) { $query = $this->_replaceTableNames($query); } if (isset($this->result) && is_resource($this->result)) { @mysql_free_result($this->result); } if ($this->config['debug_level'] > 1) { $this->debugQuery($query); } $this->result = @mysql_query($query, $this->connection); if (!$this->result) { $throwError = $warnOnFailure ? true : false; if (!$tablesAlreadyCreated && mysql_errno($this->connection) == 1146) { $this->_createNewTables(); $this->query($query, $limit, $warnOnFailure, true); $throwError = false; } if ($throwError) { phpOpenTracker::handleError(@mysql_error($this->connection), E_USER_ERROR); } } } else { $query = $this->_rewriteSelectQuery($query); if ($limit != false) { $query .= ' LIMIT ' . $limit; } parent::query($query); } }
public static function insertToDB($paramosPriemone, $nuo, $iki, $paraiskuKiekis) { $paramosPriemone = repairSqlInjection($paramosPriemone); $nuo = repairSqlInjection($nuo); $iki = repairSqlInjection($iki); $paraiskuKiekis = repairSqlInjection($paraiskuKiekis); if (!ParamosKiekiaiValidation::validateParamosPriemone($paramosPriemone)) { ParamosKiekiai::$error = "Neteisingas priemones formatas formatas!"; return false; } if (!ParamosKiekiaiValidation::validateNuo($nuo)) { ParamosKiekiai::$error = "Neteisingas datos Nuo formatas!"; return false; } if (!ParamosKiekiaiValidation::validateIki($iki)) { ParamosKiekiai::$error = "Neteisingas datos Iki formatas!"; return false; } if (!ParamosKiekiaiValidation::validateParaiskuKiekis($paraiskuKiekis)) { ParamosKiekiai::$error = "Neteisingas paraisku kiekio formatas!"; return false; } $result = mysql_query("INSERT INTO `PPOS`.`ParamosKiekiai` (`idParamosKiekiai`, `ParamosPriemone`, `Nuo`, `Iki`, `ParaiskuKiekis`) \n VALUES (null, '" . $paramosPriemone . "', '" . $nuo . "','" . $iki . "', '" . $paraiskuKiekis . "')"); if (!$result) { if (mysql_errno() != 1062) { ErrorMessages::setError(7, "insertToDB('" . $paramosPriemone . "', '" . $nuo . "','" . $iki . "', '" . $paraiskuKiekis . "')", "ParamosKiekiai.php", "ParamosKiekiai", mysql_error()); } ParamosKiekiai::$error = mysql_error(); return false; } else { return true; } }
function query($query) { global $notify; $query_lower = strtolower($query); if (strpos($query_lower, 'union') > 0) { die('UNION statements are now allowed in database queries.'); return; } // query runtime start $start = microtime(true); // Tries to query if ($result = mysql_query($query, $this->connection)) { // Successfully $this->count_successfully++; $this->last_query = $query; // debug output global $debug; $debug->add('db::query', $query . ' (' . number_format(microtime(true) - $start, 4) . ' sec)'); $this->query_time_sum += microtime(true) - $start; return $result; } else { // something goes wrong, raise an error $this->count_failed++; die(' <h1>Error: ' . 'mysql:query ' . mysql_errno($this->connection) . '</h1> <p>' . mysql_error($this->connection) . '<br />' . $query . '</p>'); // debug output global $debug; $debug->add('db::query (failed)', $query . ' (' . number_format(microtime(true) - $start, 4) . ' sec)'); $this->query_time_sum += microtime(true) - $start; } }
/** * return a mysqli object for database access */ function getDatabaseConnection() { $dbconfig = new configReader("db.config"); $mysqli = new mysqli($dbconfig->config->host, $dbconfig->config->username, $dbconfig->config->password, $dbconfig->config->dbname); echo mysql_errno(); return $mysqli; }
/** * 连接数据库 * @return resource */ function connect() { $link = mysql_connect(DB_HOST, DB_USER, DB_PWD) or die("数据库连接失败Error:" . mysql_errno() . ":" . mysql_error()); mysql_set_charset(DB_CHARSET); mysql_select_db(DB_DBNAME) or die("指定数据库打开失败"); return $link; }
function tabledump($result) { if ($result == 0) { echo "<b>Error " . mysql_errno() . ": " . mysql_error() . "</b>"; } else { if (@mysql_num_rows($result) == 0) { echo "<b>Query completed. Empty result.</b><br>"; } else { $nf = mysql_num_fields($result); $nr = mysql_num_rows($result); echo "<table border='1'> <thead>"; echo "<tr>"; for ($i = 0; $i < $nf; $i++) { echo "<th>" . mysql_field_name($result, $i) . "</th>"; } echo "</tr>"; echo "</thead><tbody>"; for ($i = 0; $i < $nr; $i++) { echo "<tr>"; $row = mysql_fetch_array($result); for ($j = 0; $j < $nf; $j++) { echo "<td>" . $row[$j] . "</td>"; } echo "</tr>"; } echo "</tbody></table>"; } } return $row; }
/** * Connect to database * @return resource */ function connect() { $link = mysql_connect(HOST, USER, PWD) or die("Error:" . mysql_errno() . ":" . mysql_error()); mysql_set_charset(DB_CHARSET); mysql_select_db(DATABASE) or die("Connect MySQL failed!"); return $link; }
function writeToDestination($data) { $sqlInsertStatement = "INSERT INTO TILLEGG (TI_ID, TI_SAID, TI_JPID, TI_DOKID, TI_DOKVER, TI_VARIANT, TI_RNR, TI_ITYPE, TI_TGKODE, TI_TGGRUPPE, TI_REGDATO, \nTI_REGAV, TI_PVGAV, TI_TEKST) VALUES ("; $sqlInsertStatement .= "'" . $data->TI_ID . "',"; $sqlInsertStatement .= "'" . $data->TI_SAID . "',"; $sqlInsertStatement .= "'" . $data->TI_JPID . "',"; $sqlInsertStatement .= "'" . $data->TI_DOKID . "',"; $sqlInsertStatement .= "'" . $data->TI_DOKVER . "',"; $sqlInsertStatement .= "'" . $data->TI_VARIANT . "',"; $sqlInsertStatement .= "'" . $data->TI_RNR . "',"; $sqlInsertStatement .= "'" . $data->TI_ITYPE . "',"; $sqlInsertStatement .= "'" . $data->TI_TGKODE . "',"; $sqlInsertStatement .= "'" . $data->TI_TGGRUPPE . "',"; $sqlInsertStatement .= "'" . $data->TI_REGDATO . "',"; $sqlInsertStatement .= "'" . $data->TI_REGAV . "',"; $sqlInsertStatement .= "'" . $data->TI_PVGAV . "',"; $sqlInsertStatement .= "'" . $data->TI_TEKST . "'"; $sqlInsertStatement .= ");"; $this->uttrekksBase->printErrorIfDuplicateFail = false; if ($this->uttrekksBase->executeStatement($sqlInsertStatement) == false) { // 1062 == duplicate key. Scary to hardcode, but can't find mysql constants somewhere if (mysql_errno() == Constants::MY_SQL_DUPLICATE) { // This table is know to contain duplicates. We just log and continue $this->logger->log($this->XMLfilename, "Duplicate values on PK detected. This is probably not an error in ESA but more a problem with the extraction code not being able to convert løpenummer to journalpostnummer TI_ID(" . $data->TI_ID . "), TI_TEKST(" . $data->TI_TEKST . ")", Constants::LOG_ERROR); } } $this->uttrekksBase->printErrorIfDuplicateFail = true; }
/** * 数据库处理函数 * @param $query mysql处理语句 * @param $kind 处理类型 * @return 如果$kind等于count,则返回符合语句的条数 * @return 如果$kind等于search,则返回符合语句的二维数组,第一维代表第几个符合,第二维为数据库信息,键为数据库表名 * @return 如果$kind等于其他,如果操作成功则返回大于零的数,否则返回零 */ function _mysql($query, $kind) { /* 此处有配置 */ $conn = @mysql_connect($host, $user, $password) or die('数据库链接失败:' . mysql_errno()); @mysql_select_db($name) or die('数据库错误:' . mysql_errno()); @mysql_query('SET NAMES UTF8') or die('字符集错误:' . mysql_errno()); $result = mysql_query($query, $conn); if ($kind == 'count') { $many = mysql_num_rows($result); mysql_close(); return $many; } elseif ($kind == 'search') { $arRow = array(); $i = 0; while (!!($row = mysql_fetch_array($result))) { $arRow[$i] = $row; $i++; } mysql_close(); return $arRow; } else { mysql_close(); return $result; } }
function show_mysql_error($query) { $search = array("<", ">"); $replace = array("<", ">"); echo "<p><b>A Fatal MySQL error occured</b>.\n<br />\n\t\t\t<b>Query:</b> <pre>" . replace($query, $search, $replace) . "</pre><br />\n\n\t\t\t<b>Error:</b> (" . mysql_errno() . ") " . mysql_error() . "</p>"; return true; }
function insert_hasher() { include 'configdb.php'; include 'opendb.php'; $hash_name = $_POST['hash_name']; $insert = "INSERT INTO hashers set " . ($insert .= "hash_name = '" . $hash_name . "'"); $insert .= ",first_name = '" . $_POST['first_name'] . "'"; $insert .= ",last_name = '" . $_POST['last_name'] . "'"; $insert .= ",password = '******'password'] . "'"; $insert .= ",email_address = '" . $_POST['email_address'] . "'"; $insert .= ",address = '" . $_POST['address'] . "'"; $insert .= ",active = '" . $_POST['active'] . "'"; $insert .= ",home_phone = '" . $_POST['home_phone'] . "'"; $insert .= ",work_phone = '" . $_POST['work_phone'] . "'"; $insert .= ",comments = '" . $_POST['comments'] . "'"; $insert .= ",hide_address = '" . $_POST['hide_address'] . "'"; $insert .= ",mother_hash = '" . $_POST['mother_hash'] . "'"; $insert .= ",T_shirt_size = '" . $_POST['T_shirt_size'] . "'"; $insert .= ",country = '" . $_POST['country'] . "'"; $insert .= ",food_choice = '" . $_POST['food_choice'] . "' "; $result = mysql_query($insert); if ($result) { echo "<center><h2>Hasher {$hash_name} was added successfully</h2></center><p>"; } else { echo "<center><h2>Sorry, there was an error adding hasher - {$hash_name}!<br>"; echo "Please make sure the hasher doesn't already exist in the database.</h2></center>"; echo "The insert statement was .... {$insert}<p>"; $MYSQL_ERRNO = mysql_errno(); $MYSQL_ERROR = mysql_error(); echo "The error was {$MYSQL_ERRNO} ... {$MYSQL_ERROR}<br>"; } mysql_close(); }
function check_db($dbhost, $dbuser, $dbpw, $dbname, $tablepre) { if (!function_exists('mysql_connect') && !function_exists('mysqli_connect')) { show_msg('undefine_func', 'mysql_connect', 0); } $mysqlmode = function_exists('mysql_connect') ? 'mysql' : 'mysqli'; $link = $mysqlmode == 'mysql' ? @mysql_connect($dbhost, $dbuser, $dbpw) : new mysqli($dbhost, $dbuser, $dbpw); if (!$link) { $errno = $mysqlmode == 'mysql' ? mysql_errno() : mysqli_errno(); $error = $mysqlmode == 'mysql' ? mysql_error() : mysqli_error(); if ($errno == 1045) { show_msg('database_errno_1045', $error, 0); } elseif ($errno == 2003) { show_msg('database_errno_2003', $error, 0); } else { show_msg('database_connect_error', $error, 0); } } else { if ($query = $mysqlmode == 'mysql' ? @mysql_query("SHOW TABLES FROM {$dbname}") : $link->query("SHOW TABLES FROM {$dbname}")) { if (!$query) { return false; } while ($row = $mysqlmode == 'mysql' ? mysql_fetch_row($query) : $query->fetch_row()) { if (preg_match("/^{$tablepre}/", $row[0])) { return false; } } } } return true; }
function query($sql, $unbuffered = false) { if (defined('FORUM_SHOW_QUERIES')) { $q_start = get_microtime(); } if ($unbuffered) { $this->query_result = @mysql_unbuffered_query($sql, $this->link_id); } else { $this->query_result = @mysql_query($sql, $this->link_id); } if ($this->query_result) { if (defined('FORUM_SHOW_QUERIES')) { $this->saved_queries[] = array($sql, sprintf('%.5f', get_microtime() - $q_start)); } ++$this->num_queries; return $this->query_result; } else { if (defined('FORUM_SHOW_QUERIES')) { $this->saved_queries[] = array($sql, 0); } $this->error_no = @mysql_errno($this->link_id); $this->error_msg = @mysql_error($this->link_id); // Rollback transaction if ($this->in_transaction) { mysql_query('ROLLBACK', $this->link_id); } --$this->in_transaction; return false; } }
function &execute() { $query = $this->read(); $res = mysql_query($query); if ($res || mysql_errno() == 1062) { return $res; } $mysql_error = mysql_error(); $mysql_errno = mysql_errno(); // If debug_backtrace() is available, we can find exactly where the query was called from if (function_exists("debug_backtrace")) { $bt = debug_backtrace(); $i = 1; if ($bt[$i]["function"] == "SQL_Query_exec_cached" || $bt[$i]["function"] == "get_row_count_cached" || $bt[$i]["function"] == "get_row_count") { $i++; } $line = $bt[$i]["line"]; $file = str_replace(getcwd() . DIRECTORY_SEPARATOR, "", $bt[$i]["file"]); $msg = "Database Error in {$file} on line {$line}: {$mysql_error}. Query was: {$query}."; } else { $file = str_replace(getcwd() . DIRECTORY_SEPARATOR, "", $_SERVER["SCRIPT_FILENAME"]); $msg = "Database Error in {$file}: {$mysql_error}. Query was: {$query}"; } mysql_query("INSERT INTO `sqlerr` (`txt`, `time`) \n VALUES (" . sqlesc($msg) . ", '" . get_date_time() . "')"); if (function_exists('show_error_msg')) { show_error_msg("Database Error", "Database Error. Please report this to an administrator.", 1); } }
function check_db($dbhost, $dbuser, $dbpw, $dbname, $tablepre) { if (!function_exists('mysql_connect')) { show_msg('undefine_func', 'mysql_connect', 0); } if (!@mysql_connect($dbhost, $dbuser, $dbpw)) { $errno = mysql_errno(); $error = mysql_error(); if ($errno == 1045) { show_msg('database_errno_1045', $error, 0); } elseif ($errno == 2003) { show_msg('database_errno_2003', $error, 0); } else { show_msg('database_connect_error', $error, 0); } } else { if ($query = @mysql_query("SHOW TABLES FROM {$dbname}")) { while ($row = mysql_fetch_row($query)) { if (preg_match("/^{$tablepre}/", $row[0])) { return false; } } } } return true; }
/** * Returns MySQL error number for last error. * * @return integer MySQL error number */ public function getErrorNumber() { if (!($errorNumber = @mysql_errno($this->linkID))) { $errorNumber = @mysql_errno(); } return $errorNumber; }
function sqlQuery($sql) { global $db_conn; // execute query $db_result = mysql_query($sql, $db_conn); // if db_result is null then trigger error if ($db_result === null) { trigger_error(mysql_errno() . ": " . mysql_error() . "\n"); exit; } // prepare result array $resultSet = array(); // if resulted array isn't true and that is in case of select statement then open loop // (insert / delete / update statement will return true on success) if ($db_result !== true) { // loop through fetched rows and prepare result set while ($row = mysql_fetch_array($db_result, MYSQL_NUM)) { // first column of the fetched row $row[0] is used for array key // it could be more elements in one table cell $resultSet[$row[0]][] = $row; } } // return result set return $resultSet; }
/** * * @param $server * @param $username * @param $password * @param $db_name * @param $persistency * @return unknown_type */ public function __construct($server, $username, $password, $db_name = null, $persistency = true) { if ($persistency) { $this->link = @mysql_pconnect($server, $username, $password); } else { $this->link = @mysql_connect($server, $username, $password, true); } if (!$this->link) { if (mysql_errno()) { throw new MySqlException(mysql_error(), mysql_errno()); } else { throw new MySqlException("Can't connect to MySQL server on '{$server}'", 2003); } } if ($db_name !== null) { if (!$this->selectDatabase($db_name)) { if (mysql_errno()) { $error = mysql_error(); $errno = mysql_errno(); } else { $error = "Error selecting database '{$db_name}' on host '{$server}'"; $errno = 1049; } @mysql_close($this->link); throw new MySqlException($error, $errno); } } }
public function query($sql) { if ($this->link) { $resource = mysql_query($sql, $this->link); if ($resource) { if (is_resource($resource)) { $i = 0; $data = array(); while ($result = mysql_fetch_assoc($resource)) { $data[$i] = $result; $i++; } mysql_free_result($resource); $query = new \stdClass(); $query->row = isset($data[0]) ? $data[0] : array(); $query->rows = $data; $query->num_rows = $i; unset($data); return $query; } else { return true; } } else { $trace = debug_backtrace(); trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br /> Error in: <b>' . $trace[1]['file'] . '</b> line <b>' . $trace[1]['line'] . '</b><br />' . $sql); } } }
function QUERY_SYSLOGS($sql) { $database = "syslogs"; $bd = @mysql_connect(":/var/run/syslogdb.sock", "root", null); if (!$bd) { echo "Connect failed\n"; return false; } $ok = @mysql_select_db($database, $bd); if (!$ok) { $errnum = @mysql_errno($bd); $des = @mysql_error($bd); echo "mysql_select_db [FAILED] N.{$errnum} DESC:{$des} mysql/QUERY_SQL\n"; return false; } $results = mysql_query($sql, $bd); if (!$results) { $errnum = @mysql_errno($bd); $des = @mysql_error($bd); echo "mysql_select_db [FAILED] N.{$errnum} DESC:{$des} mysql/QUERY_SQL\n"; return false; @mysql_close($bd); } @mysql_close($bd); return $results; }
function writeToDestination($data) { $sqlInsertStatement = "INSERT INTO SAKPART (SP_SAID, SP_U1, SP_KORTNAVN, SP_NAVN, SP_ADRESSE, SP_POSTNR, SP_POSTSTED, SP_UTLAND, SP_EPOSTADR, SP_KONTAKT, SP_ROLLE, SP_FAKS, SP_TLF) VALUES ("; $sqlInsertStatement .= "'" . $data->SP_SAID . "',"; $sqlInsertStatement .= "'" . $data->SP_U1 . "',"; $sqlInsertStatement .= "'" . $data->SP_KORTNAVN . "',"; $sqlInsertStatement .= "'" . mysql_real_escape_string($data->SP_NAVN) . "',"; $sqlInsertStatement .= "'" . mysql_real_escape_string($data->SP_ADRESSE) . "',"; $sqlInsertStatement .= "'" . $data->SP_POSTNR . "',"; $sqlInsertStatement .= "'" . $data->SP_POSTSTED . "',"; $sqlInsertStatement .= "'" . $data->SP_UTLAND . "',"; $sqlInsertStatement .= "'" . $data->SP_EPOSTADR . "',"; $sqlInsertStatement .= "'" . $data->SP_KONTAKT . "',"; $sqlInsertStatement .= "'" . $data->SP_ROLLE . "',"; $sqlInsertStatement .= "'" . $data->SP_FAKS . "',"; $sqlInsertStatement .= "'" . $data->SP_TLF . "'"; $sqlInsertStatement .= ");"; $this->uttrekksBase->printErrorIfDuplicateFail = false; if ($this->uttrekksBase->executeStatement($sqlInsertStatement) == false) { // 1062 == duplicate key. Scary to hardcode, but can't find mysql constants somewhere if (mysql_errno() == Constants::MY_SQL_DUPLICATE) { // This table is know to contain duplicates. We just log and continue $this->logger->log($this->XMLfilename, "Duplicate value detected. Value is SP_SAID (" . $data->SP_SAID . "), SP_NAVN (" . $data->SP_NAVN . ")", Constants::LOG_WARNING); } } $this->uttrekksBase->printErrorIfDuplicateFail = true; // $this->uttrekksBase->executeStatement($sqlInsertStatement); }
function DB_connection($host, $user, $pass, $name) { $dns = 'mysql:dbname=' . $name . ';host=' . $host; $lbd = new PDO($dns, $user, $pass) or die("Sorry, Unable to connect to the Database server <br />" . "<br>Error number : " . mysql_errno() . "<br>Error Message : " . mysql_error()); echo "string"; return $lbd; }
function Query($sqlString) { if (!($resourseId = @mysql_query($sqlString, $this->dbId))) { die("<b>MySQL</b>: Unable to execute<br /><b>SQL</b>: " . $sqlString . "<br /><b>Error (" . mysql_errno() . ")</b>: " . @mysql_error()); } return $resourseId; }
function dbSqlExecute($fMemberId, $sqlFileToExecute) { // Provided by Mark Floyd (aka Cobnet) $success = false; $sqlErrorText = ''; $sqlErrorCode = 0; $sqlStmt = ''; // Load and explode the sql file if (file_exists($sqlFileToExecute)) { writeAudit($fMemberId, 'EXECUTE', 'Executing db file: ' . $sqlFileToExecute); $f = fopen($sqlFileToExecute, "r"); $sqlFile = fread($f, filesize($sqlFileToExecute)); $sqlArray = explode(';', $sqlFile); //Process the sql file by statements foreach ($sqlArray as $stmt) { if (strlen($stmt) > 3) { $result = mysql_query($stmt); if (!$result) { $sqlErrorCode = mysql_errno(); $sqlErrorText = mysql_error(); $sqlStmt = $stmt; break; } } } if ($sqlErrorCode == 0) { $success = true; } else { $success = false; } } else { $success = false; } return $success; }