4 * Pick the right DB class and return an instance
7 * @param string $extension Optional: user defined choice
8 * @return class $ydb DB class instance
10 function yourls_set_DB_driver( ) {
12 // Auto-pick the driver. Priority: user defined, then PDO, then mysqli, then mysql
13 if ( defined( 'YOURLS_DB_DRIVER' ) ) {
14 $driver = strtolower( YOURLS_DB_DRIVER ); // accept 'MySQL', 'mySQL', etc
15 } elseif ( extension_loaded( 'pdo_mysql' ) ) {
17 } elseif ( extension_loaded( 'mysqli' ) ) {
19 } elseif ( extension_loaded( 'mysql' ) ) {
26 if ( in_array( $driver, array( 'mysql', 'mysqli', 'pdo' ) ) ) {
27 require_once( YOURLS_INC . '/ezSQL/ez_sql_core.php' );
28 require_once( YOURLS_INC . '/ezSQL/ez_sql_core_yourls.php' );
29 require_once( YOURLS_INC . '/ezSQL/ez_sql_' . $driver . '.php' );
30 require_once( YOURLS_INC . '/ezSQL/ez_sql_' . $driver . '_yourls.php' );
32 $class = 'ezSQL_' . $driver . '_yourls';
36 if ( !class_exists( $class, false ) ) {
37 $ydb = new stdClass();
39 yourls__( 'YOURLS requires the mysql, mysqli or pdo_mysql PHP extension. No extension found. Check your server config, or contact your host.' ),
40 yourls__( 'Fatal error' ),
45 yourls_do_action( 'set_DB_driver', $driver );
47 $ydb = new $class( YOURLS_DB_USER, YOURLS_DB_PASS, YOURLS_DB_NAME, YOURLS_DB_HOST );
48 $ydb->DB_driver = $driver;
50 yourls_debug_log( "DB driver: $driver" );
58 function yourls_db_connect() {
61 if ( !defined( 'YOURLS_DB_USER' )
62 or !defined( 'YOURLS_DB_PASS' )
63 or !defined( 'YOURLS_DB_NAME' )
64 or !defined( 'YOURLS_DB_HOST' )
65 ) yourls_die ( yourls__( 'Incorrect DB config, or could not connect to DB' ), yourls__( 'Fatal error' ), 503 );
67 // Are we standalone or in the WordPress environment?
68 if ( class_exists( 'wpdb', false ) ) {
69 /* TODO: should we deprecate this? Follow WP dev in that area */
70 $ydb = new wpdb( YOURLS_DB_USER, YOURLS_DB_PASS, YOURLS_DB_NAME, YOURLS_DB_HOST );
72 yourls_set_DB_driver();
79 * Return true if DB server is responding
81 * This function is supposed to be called right after yourls_get_all_options() has fired. It is not designed (yet) to
82 * check for a responding server after several successful operation to check if the server has gone MIA
86 function yourls_is_db_alive() {
90 switch( $ydb->DB_driver ) {
92 $alive = isset( $ydb->dbh );
96 $alive = ( isset( $ydb->dbh ) && false !== $ydb->dbh );
100 $alive = ( null == mysqli_connect_error() );
103 // Custom DB driver & class : delegate check
105 $alive = yourls_apply_filter( 'is_db_alive_custom', false );
112 * Die with a DB error message
114 * @TODO in version 1.8 : use a new localized string, specific to the problem (ie: "DB is dead")
118 function yourls_db_dead() {
119 // Use any /user/db_error.php file
120 if( file_exists( YOURLS_USERDIR . '/db_error.php' ) ) {
121 include_once( YOURLS_USERDIR . '/db_error.php' );
125 yourls_die( yourls__( 'Incorrect DB config, or could not connect to DB' ), yourls__( 'Fatal error' ), 503 );