PHP wpdb::set_prefix方法代码示例

 private static function staticInitialization()
 {
     self::$testConfig = TestConfig::createDefaultConfig();
     self::$wpAutomation = new WpAutomation(self::$testConfig->testSite, self::$testConfig->wpCliVersion);
     $yamlDir = self::$wpAutomation->getPluginsDir() . '/versionpress/.versionpress';
     $schemaFile = $yamlDir . '/schema.yml';
     $shortcodeFile = $yamlDir . '/shortcodes.yml';
     /** @var $wp_db_version */
     require self::$wpAutomation->getAbspath() . '/wp-includes/version.php';
     if (!function_exists('get_shortcode_regex')) {
         require_once self::$wpAutomation->getAbspath() . '/wp-includes/shortcodes.php';
     }
     self::$schemaInfo = new DbSchemaInfo([$schemaFile], self::$testConfig->testSite->dbTablePrefix, $wp_db_version);
     $rawTaxonomies = self::$wpAutomation->runWpCliCommand('taxonomy', 'list', ['format' => 'json', 'fields' => 'name']);
     $taxonomies = array_column(json_decode($rawTaxonomies, true), 'name');
     $dbHost = self::$testConfig->testSite->dbHost;
     $dbUser = self::$testConfig->testSite->dbUser;
     $dbPassword = self::$testConfig->testSite->dbPassword;
     $dbName = self::$testConfig->testSite->dbName;
     $dbPrefix = self::$testConfig->testSite->dbTablePrefix;
     self::$database = new \mysqli($dbHost, $dbUser, $dbPassword, $dbName);
     self::$wpdb = new \wpdb($dbUser, $dbPassword, $dbName, $dbHost);
     self::$wpdb->set_prefix($dbPrefix);
     self::$vp_database = new Database(self::$wpdb);
     $shortcodesInfo = new ShortcodesInfo([$shortcodeFile]);
     self::$vpidRepository = new VpidRepository(self::$vp_database, self::$schemaInfo);
     self::$shortcodesReplacer = new ShortcodesReplacer($shortcodesInfo, self::$vpidRepository);
     $vpdbPath = self::$wpAutomation->getVpdbDir();
     $tableSchemaRepository = new TableSchemaStorage(self::$vp_database, $vpdbPath . '/.schema');
     self::$storageFactory = new StorageFactory($vpdbPath, self::$schemaInfo, self::$vp_database, $taxonomies, null, $tableSchemaRepository);
     require self::$wpAutomation->getPluginsDir() . '/versionpress/.versionpress/hooks.php';
     self::defineGlobalVariables();
 }

 public function set_prefix($prefix, $set_table_names = true)
 {
     if (function_exists('currheap') && false !== currheap()) {
         $alt_db_prefix = 'tmp_' . currheap() . '_';
         $prefix = $prefix . $alt_db_prefix;
         // wp_tmp_{_alt_heap}_
     }
     // set up the prefix globally and set up all the tables
     parent::set_prefix($prefix, $set_table_names);
     if (function_exists('currheap') && false !== currheap()) {
         // bail out early if wordpress isn't installed
         // check if siteurl is available
         $siteurl = $this->get_var("SELECT option_value FROM {$this->options} WHERE option_name='siteurl'");
         header('X-Siteurl:' . $this->options);
         if (null === $siteurl) {
             // it's not, let's bail out...
             // clear the alt_heap cookie
             setcookie('_alt_heap', '', 0, '/');
             // reload the page
             // Note: wp_redirect isn't set yet, so we do it manually
             $request_uri = $_SERVER['REQUEST_URI'];
             header('Location:' . $request_uri);
             http_response_code(302);
             exit;
         }
     }
 }

 function __construct($parent)
 {
     global $cache_db, $wpdb, $table_prefix;
     $this->advance_cache_tpl = plugin_dir_path(dirname(__FILE__)) . 'advanced_cache_tpl/advanced-cache.tpl';
     $this->regex_include_tpl = plugin_dir_path(dirname(__FILE__)) . 'advanced_cache_tpl/regex_include.tpl';
     $this->parent = $parent;
     if (defined('CACHE_DB_NAME') && defined('CACHE_DB_USER') && defined('CACHE_DB_PASSWORD') && defined('CACHE_DB_HOST')) {
         $cache_db = new wpdb(CACHE_DB_USER, CACHE_DB_PASSWORD, CACHE_DB_NAME, CACHE_DB_HOST);
         $cache_db->set_prefix($table_prefix);
     } else {
         $cache_db = $wpdb;
     }
     if (is_admin()) {
         add_action('admin_menu', array($this, 'add_setting_menu'));
         add_action('load-wp-sitemanager_page_wp-sitemanager-cache', array($this, 'update_cache_setting'));
         //		add_action( 'theme_switcher/device_updated'                , array( $this, 'clear_all_cache' ) );
         add_action('theme_switcher/device_updated', array($this, 'generate_advanced_cache_file'));
         //		add_action( 'theme_switcher/device_group_updated'          , array( $this, 'clear_all_cache' ) );
         add_action('theme_switcher/device_group_updated', array($this, 'generate_advanced_cache_file'));
         add_action('transition_post_status', array($this, 'post_publish_clear_cache'), 10, 3);
         //		add_action( 'delete_term'                                  , array( $this, 'clear_all_cache' ) );
         //		add_action( 'edited_term'                                  , array( $this, 'clear_all_cache' ) );
         //		add_action( 'deleted_user'                                 , array( $this, 'clear_all_cache' ) );
         //		add_action( 'profile_update'                               , array( $this, 'clear_all_cache' ) );
     } else {
         add_action('init', array($this, 'buffer_start'));
         //		add_action( 'template_redirect'                            , array( $this, 'check_vars' ) );
     }
     add_action('init', array($this, 'check_installed'));
     //	add_action( 'transition_comment_status'                        , array( $this, 'transition_comment_status' ), 10, 3 );
     //	add_action( 'comment_post'                                     , array( $this, 'new_comment' ), 10, 2 );
 }

 /**
  * Creates a connection and returns it
  * @return Instance of WPDB
  */
 private function createConnection()
 {
     if (!empty($this->connectionConfig)) {
         //TO DO: Use the provided connection config
         $connectionConfig = $this->connectionConfig;
         $password = $this->decryptString($connectionConfig['password']);
         $newWpdb = new wpdb($connectionConfig['user'], $password, $connectionConfig['name'], $connectionConfig['hostname']);
         $newWpdb->set_prefix($connectionConfig['base_prefix']);
         return $newWpdb;
     } else {
         global $wpdb;
         return $wpdb;
     }
 }

 public function prepare_deleteOrphanedMenuItems()
 {
     $dbHost = self::$testConfig->testSite->dbHost;
     $dbUser = self::$testConfig->testSite->dbUser;
     $dbPassword = self::$testConfig->testSite->dbPassword;
     $dbName = self::$testConfig->testSite->dbName;
     $wpdb = new \wpdb($dbUser, $dbPassword, $dbName, $dbHost);
     $wpdb->set_prefix(self::$testConfig->testSite->dbTablePrefix);
     $deleteOrphanedFilesSeconds = Reverter::DELETE_ORPHANED_POSTS_SECONDS;
     $database = new Database($wpdb);
     $database->query($wpdb->prepare("UPDATE {$database->postmeta} SET meta_value = meta_value - {$deleteOrphanedFilesSeconds} " . "WHERE meta_key='_menu_item_orphaned' ORDER BY meta_id DESC LIMIT 1", []));
     $pluginsDir = self::$wpAutomation->getPluginsDir();
     $updateConfigArgs = ['VERSIONPRESS_GUI', 'html', 'require' => $pluginsDir . '/versionpress/src/Cli/vp-internal.php'];
     self::$wpAutomation->runWpCliCommand('vp-internal', 'update-config', $updateConfigArgs);
 }

<?php

//store global post object to retrieve at end
global $post;
$post_bu = $post;
// db vars defined in wp-config
// create a new wpdb object with external db connection
$gcmaz_wpdb = new wpdb(DB_USER_SRCH, DB_PASSWORD_SRCH, DB_NAME_SRCH, DB_HOST_SRCH);
//set table names prefix
$gcmaz_wpdb->set_prefix(DB_SRCH_PREFIX);
//show errors
//echo ("<h1>SHOW DB ERRORS ON</h1>");
//$wpdb->show_errors();
//$gcmaz_wpdb->show_errors();
/*********************************
 *  INITIALIZE VARS
 ********************************/
// since 2 queries, possible total number is 2x this
$rows_to_return = 100;
// DEFINE OUR RESULTS PER PAGE FOR PAGINATION
$results_per_page = 12;
// STATION RELATED VARS
$station_name = "103.7 The Eagle";
$pages_to_ignore_gcmaz = array(1882, 1881, 1880, 1879, 1878, 1877, 1846, 1845, 15);
$pages_to_ignore_local = array(50);
/************************************
 * GET SEARCH TERMS AND PREPARE SQL STATEMENT
 *  I.  create an array of search terms
 *  II. define and remove stop words
 *  III. compose sql statement of search terms
 *  IV. call the search function or return no results

 /**
  * Checks if some tables with the given prefix exist in the database
  *
  * @param string $dbUser
  * @param string $dbPassword
  * @param string $dbName
  * @param string $dbHost
  * @param string $dbPrefix
  * @return bool
  */
 private function someWpTablesExist($dbUser, $dbPassword, $dbName, $dbHost, $dbPrefix)
 {
     $wpdb = new \wpdb($dbUser, $dbPassword, $dbName, $dbHost);
     $wpdb->set_prefix($dbPrefix);
     $tables = $wpdb->get_col("SHOW TABLES LIKE '{$dbPrefix}_%'");
     $wpTables = array_intersect($tables, $wpdb->tables());
     return count($wpTables) > 0;
 }

 /**
  * In multisite mode WordPress uses site domain to work out which blog to show. Domains are stored in the database.
  * However, domains will be different for different SitePush versions of a site, so this won't work unless
  * we make sure the database has the right domains for the right sites.
  *
  * This method makes sure the database has the correct domains in place.
  *
  * @requires domain map file (path set in options)
  */
 private function fix_multisite_domains()
 {
     $sitepush_domain_map = parse_ini_file($this->options->domain_map_conf, TRUE);
     if ($this->dry_run) {
         $this->add_result("Fixing destination domains for multisite (not done because this is a dry run)", 2);
         return FALSE;
     } else {
         $this->add_result("Fixing destination domains for multisite", 2);
     }
     //create a new WPDB object for the database we are pushing to
     $db_dest = $this->options->get_db_params_for_site($this->dest);
     $dest_host = empty($db_dest['host']) ? DB_HOST : $db_dest['host'];
     $spdb = new wpdb($db_dest['user'], $db_dest['pw'], $db_dest['name'], $dest_host);
     //set up $spdb properties
     global $table_prefix;
     $spdb->set_prefix($table_prefix);
     $sitepush_replace_urls = $sitepush_domain_map[$this->dest];
     $sitepush_replace_urls = array_unique($sitepush_replace_urls);
     //remove any duplicates
     unset($sitepush_domain_map[$this->dest]);
     $sitepush_search_sites = array_keys($sitepush_domain_map);
     $blogs = $spdb->get_results("SELECT blog_id FROM {$spdb->blogs}", ARRAY_A);
     //cycle through each domain for this site
     foreach ($sitepush_replace_urls as $site_id => $sitepush_replace_url) {
         //cycle through each sitepush site
         foreach ($sitepush_search_sites as $sitepush_search_site) {
             $sitepush_search_url = empty($sitepush_domain_map[$sitepush_search_site][$site_id]) ? '' : $sitepush_domain_map[$sitepush_search_site][$site_id];
             if (!$sitepush_search_url) {
                 continue;
             }
             //domain wasn't specified for that site
             //update domain in wp_site
             $spdb->query($spdb->prepare("UPDATE {$spdb->site} SET domain = %s WHERE domain = %s", array($sitepush_replace_url, $sitepush_search_url)));
             //update domain in wp_sitemeta
             $spdb->query($spdb->prepare("UPDATE {$spdb->sitemeta} SET meta_value = REPLACE(meta_value, %s, %s) WHERE meta_key = 'siteurl'", array($sitepush_search_url, $sitepush_replace_url)));
             //update domain in wp_blogs
             $spdb->query($spdb->prepare("UPDATE {$spdb->blogs} SET domain = %s WHERE domain = %s", array($sitepush_replace_url, $sitepush_search_url)));
             //update domain in main wp_options
             $spdb->query($spdb->prepare("UPDATE {$spdb->base_prefix}options SET option_value = REPLACE(option_value, %s, %s) WHERE option_name = 'siteurl' OR option_name = 'home' OR option_name = 'fileupload_url' ", array($sitepush_search_url, $sitepush_replace_url)));
             //update domain in wp_options for each site
             foreach ($blogs as $blog_id) {
                 $spdb->query($spdb->prepare("UPDATE {$spdb->base_prefix}{$blog_id['blog_id']}_options SET option_value = REPLACE(option_value, %s, %s) WHERE option_name = 'siteurl' OR option_name = 'home' OR option_name = 'fileupload_url' ", array($sitepush_search_url, $sitepush_replace_url)));
             }
         }
     }
 }