 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Mobile Dev World | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
<?php // -*- C++ -*- /* * $Id: db-odbc.phl,v 1.7 1998/10/01 18:41:56 ssb Exp $ */ $db_error_code = 0; $db_error_msg = false; $db_error_source = false; /** * @function db_connect * @purpose Connect to a database * @desc * Connects to a database and returns and identifier for the connection. * @arg database * Data source name or database host to connect to. * @arg user * Name of user to connect as. * @arg password * The user's password. */ function db_connect($dsn, $user, $password) { $ret = @odbc_connect($dsn, $user, $password); if (!$ret) { db_check_errors($php_errormsg); return false; } return $ret; } /* * Function: db_query * Arguments: $conn (int) - connection identifier * $query (string) - SQL statement to execute * Description: executes an SQL statement * Returns: (int) 0 - query failed * 1 - query succeeded */ function db_query($conn, $query) { $ret = @odbc_exec($conn, $query); if (!$ret) { db_check_errors($php_errormsg); return false; } return $ret; } /* * Function: db_fetch_row * Arguments: $result (int) - result identifier * Description: Returns an array containing data from a fetched row. * Returns: false - error * (array) - returned row */ function db_fetch_row($result) { $row = array(); $cols = @odbc_fetch_into($result, &$row); if (!$cols) { db_check_errors($php_errormsg); return false; } return $row; } /* * Function: db_free_result * Arguments: $result (int) - result identifier * Description: Frees all memory associated with a result identifier. * Returns: (int) 0 - failure * 1 - success */ function db_free_result($result) { $ret = @odbc_free_result($result); db_check_errors($php_errormsg); return $ret; } /* * Function: db_disconnect * Arguments: $connection (int) - connection identifier * Description: closes a database connection * Returns: (int) 0 - failure * 1 - success */ function db_disconnect($connection) { $ret = @odbc_close($connection); db_check_errors($php_errormsg); return $ret; } /* * Function: db_autocommit * Arguments: $connection (int) - connection identifier * Description: turn autocommit on or off * Returns: (int) 0 - failure * 1 - success */ function db_autocommit($connection, $enabled) { $ret = @odbc_autocommit($connection, $enabled); db_check_errors($php_errormsg); return $ret; } function db_commit($connection) { $ret = @odbc_commit($connection); db_check_errors($php_errormsg); return $ret; } function db_rollback($connection) { $ret = @odbc_rollback($connection); db_check_errors($php_errormsg); return $ret; } function db_quote_string($string) { $ret = ereg_replace( "'", "''", $string); return $ret; } function db_prepare($connection, $query) { $ret = @odbc_prepare($connection, $query); db_check_errors($php_errormsg); return $ret; } function db_execute($statement, $data) { $ret = @odbc_execute($statement, $data); db_check_errors($php_errormsg); return $ret; } function db_error_code() { global $db_error_code; return $db_error_code; } function db_error_msg() { global $db_error_msg; return $db_error_msg; } function db_error_source() { global $db_error_source; return $db_error_source; } function db_check_errors($errormsg) { global $db_error_code, $db_error_msg, $db_error_source; if (ereg( 'SQL error: (\[.*\]\[.*\]\[.*\])(.*), SQL state (.....)', $errormsg, &$data)) { list($foo, $db_error_source, $db_error_msg, $db_error_code) = $data; } else { $db_error_msg = $db_error_source = false; $db_error_code = 0; } } function db_post_error($code, $message) { global $db_error_code, $db_error_msg, $db_error_source; $db_error_code = $code; $db_error_msg = $message; $db_error_source = "[PHP][ODBC][db-odbc]"; } function db_api_version() { return 10; // 1.0 } ?> | |||||
| Related Code Examples | |||||
