summaryrefslogtreecommitdiff
path: root/includes/database.mysql.inc
Commit message (Collapse)AuthorAge
* - Removing some whitespace.Dries Buytaert2007-07-23
|
* - Patch #159748 by pwolanin: db_fetch_array() returned different values ↵Dries Buytaert2007-07-22
| | | | depending on the database engine used. Make the return value consistent across all supported database backends.
* - Patch #149176 by chx, David et al: getting rid of the sequences table, ↵Dries Buytaert2007-06-05
| | | | using db_last_insert_id() instead of db_next_id().
* - Patch #55516 by David Strauss et al: removed some database locking.Dries Buytaert2007-05-25
|
* - Killer patch #144765 by bjaspan, frando et al: schema API 1 hits core. ↵Dries Buytaert2007-05-25
| | | | Oh, behave.
* - Patch #99011 by merlinofchaos: remove sites/default/settings.php and ship ↵Dries Buytaert2007-05-08
| | | | with sites/default/default.settings.php.
* - Patch #137479 by dww: added db_column_exits(). (Yay, the servers are ↵Dries Buytaert2007-04-21
| | | | snappy on Saturday evening.)
* - Patch #134493 by douggreen: getting the Drupal coding standards right in ↵Dries Buytaert2007-04-13
| | | | core. Woot. Woot.
* #109513: Create temporary mysql tables in memory.Steven Wittens2007-03-19
|
* #102387: index.php does not redirect to install.php if PHP does not support ↵Steven Wittens2007-01-22
| | | | 'mysql'.
* - Patch #105461 by jvandyk: fixed code comments.Dries Buytaert2006-12-27
|
* - Patch #85979 by RobRoy, keith.smith, fgm and webchick: improve ↵Dries Buytaert2006-12-27
| | | | documentation of db_next_id().
* - Patch #98988 by Robert Douglass et al: db_result should return FALSE if no ↵Dries Buytaert2006-12-04
| | | | result was found. Consistent with PHP's mysql_result.
* - Patch #98059 by chx: trying to get the never-ending regex mess right.Dries Buytaert2006-11-21
|
* #76819 by smsimms and sammys. Move part of the sql rewriting down into the ↵Neil Drumm2006-10-23
| | | | database abstraction layer and add extra rewriting needed only for Postgres.
* - Patch #88705 by profix898 and sammys: made version checking work with ↵Dries Buytaert2006-10-22
| | | | PostgreSQL. (Critical bug)
* - Patch #85123 by gerd: set proper HTTP headers.Dries Buytaert2006-09-26
|
* #81332 by wundo and davemicc. Allow empty MySQL passwords to work.Neil Drumm2006-09-16
|
* - Removing stray whitspaces.Dries Buytaert2006-09-07
|
* #75002: Install-time and run-time requirements checking + status report pageSteven Wittens2006-09-01
|
* #75264: Redirect uninstalled default Drupal site to install.phpSteven Wittens2006-07-31
|
* #74997 by dww, add db_table_exists()Neil Drumm2006-07-26
|
* - Patch #68926 by chx, jeremy, steven, eaton, webchick, amazon, neil, nedjo ↵Dries Buytaert2006-07-13
| | | | et al: an initial install system for Drupal core.
* SQL abstraction layer improvement.Gerhard Killesreiter2006-05-24
|
* #54981: calls to db_lock_table in bootstrap.inc do not use db_prefixSteven Wittens2006-04-27
|
* - Patch #41870 by fgm: improved debugging support.Dries Buytaert2006-02-20
|
* - #40515: MySQL UTF-8 conversion fixesSteven Wittens2006-02-02
|
* - Patch #21719 by rkerr: made db passwords with special characters work.Dries Buytaert2006-01-24
|
* - #40515: Ensure UTF-8 character set on the database side (and include ↵Steven Wittens2006-01-21
| | | | upgrade path for incorrectly set up databases)
* - Patch #38889 by rkerr: db_error and db_affected_rows did not work properly ↵Dries Buytaert2005-12-07
| | | | in presence of multiple database connections.
* - Patch #35924 by Neil: improved the update system.Dries Buytaert2005-12-06
|
* - Patch #39357 by m3vrck: fixed typo in mysqli backend.Dries Buytaert2005-11-30
|
* - Various fixes. Updated CHANGELOG.txtDries Buytaert2005-11-29
|
* - Patch #10407 by Cvbge: fixed cache problems with PostgreSQL.Dries Buytaert2005-11-27
|
* #36352: Don't prefix temporary table names after all.Steven Wittens2005-11-21
| | | | #36658: Make search query pgsql compatible.
* - #36255: Fix db_query_temporary() in pgsqlSteven Wittens2005-11-04
| | | | - Prefix temporary table names (helps on restricted hosts)
* - Add maintenance-page error screens when the php module for the dbtype is ↵Steven Wittens2005-10-20
| | | | not loaded (just showed a blank screen before)
* - #28159: Advanced search features (hello from DrupalCon)Steven Wittens2005-10-18
| | | | | Presentation about it: http://www.acko.net/files/drupal-search-slim.pdf
* - Modified patch #13180/#29414: use mysql_real_escape_string() to escapeDries Buytaert2005-10-13
| | | | | strings rather than addslashes(). mysql_real_escape_string() uses the connections charset settings to properly escape.
* - Patch #22911 by Cvgbe: fixed table locking in PostgreSQL. You'll have toDries Buytaert2005-08-29
| | | | use db_lock_table() and db_unlock_tables() for your code to be compatible.
* - Patch #29385 by chx: no ?> add end of files.Dries Buytaert2005-08-25
|
* - Patch #25522 by Cvbge: _db_query() does not return FALSE in case of errors ↵Dries Buytaert2005-08-11
| | | | as stated in documentation.
* - #27846: Clean up dev_query code in db_query()Steven Wittens2005-07-30
|
* - #27231: Friendly DB error screens.Steven Wittens2005-07-27
|
* - Patch #18213 by chx: boostrap system. Modified to work with HEAD, tidiedDries Buytaert2005-06-22
| | | | | | | up the documentation a little. chx: can you double-check whether the global $conf variable is secure? (That is, make sure it can't be send using the URL or something.)
* - Patch #23465 by Gerhard: tiny performance improvement to db_query_range().Dries Buytaert2005-05-23
|
* - Patch #19442 by chx: cache_set sometimes failed.Dries Buytaert2005-05-12
| | | | | TODO: this patch lets us clean up more code in code! Let's have a look at this ...
* - Patch #20235 by chx: fixed problem with db_set_active().Dries Buytaert2005-04-14
|
* - Patch #13581 by Steven: Db_query() allows a variable amount of parameters ↵Dries Buytaert2004-11-29
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | so you can pass the query arguments in. There is however an alternative syntax: instead of passing the query arguments as function arguments, you can also pass a single array with the query arguments in it. For example the following two statements are equivalent: db_query($query, $a, $b, $c); db_query($query, array($a, $b, $c)); This usage is particularly interesting when the query is constructed dynamically, and the amount of arguments to pass varies. In that case we use the second method to avoid using call_user_func_array(). This behaviour is not documented explicitly, but it is used in several places. However, db_query_range() and pager_query() do not support this syntax properly, which means there are several pieces of code which still revert to the ugly call_user_func_array() call. This patch updates db_query_range() and pager_query() so they support the array-passing method. I also added documentation about this method to each of the db functions. I also cleaned up the code for db_query (it was weird and hard to understand) and moved db_query() and db_queryd() from database.xxxxx.inc to database.inc: it was the same between both mysql and pgsql, as it doesn't do anything database specific. It just prefixes the tables and inserts the arguments. The actual db query is performed in _db_query(), which is still in database.xxxxx.inc. Finally, I updated several places with the new syntax, and the code is a lot cleaner. For example: - array_unshift($params, "SELECT u.* FROM {users} u WHERE $query u.status < 3"); - $params[] = 0; - $params[] = 1; - $result = call_user_func_array('db_query_range', $params); + $result = db_query_range("SELECT u.* FROM {users} u WHERE $query u.status < 3", $params, 0, 1); and - return call_user_func_array('db_query_range', array_merge(array($query), $args, array((int)$pager_from_array[$element], (int)$limit))); + return db_query_range($query, $args, (int)$pager_from_array[$element], (int)$limit); I've tested it on mysql. I didn't alter the actual db behaviour, so pgsql should be okay too. This patch is important because many people avoid the call_user_func_array() method and put data directly into the db query. This is very, very bad because the database prefix will be applied to it, and strip out braces. It's also generally bad form as you have to call check_query() yourself. With the new, documented syntax, there is no more excuse to put data directly in the query.
* - Patch 13180 by chx: renamed check_query() to db_escape_string() and ↵Dries Buytaert2004-11-21
| | | | | | implemtented it properly per database backend. Read the manual for pg_escape_string: "Use of this function is recommended instead of addslashes()." Or read sqlite_escape_string: "addslashes() should NOT be used to quote your strings for SQLite queries; it will lead to strange results when retrieving your data."
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-16 21:44:14 +0000