Is There A Way To Access A Separate Local Database From Wordpress?Can I install/update WordPress plugins without providing FTP access?Calling $wpdb in a function in non-WordPress fileError: Object of class stdClass could not be converted to string — implode() — phpAccessing wpdb (wordpress database) from laravel controllercan't select database wordpress errorSetting an external database for WordPress from wp_config file$wpdb->prepare() returns NULL or empty on seemingly correct SQL statementError establishing a database connection during wordpress installationwordpress database connection on local serverWordpress different database Error establishing a database connection
What happens to unproductive professors?
Can a landlord force all residents to use the landlord's in-house debit card accounts?
Non-Chromatic Orchestral Instruments?
US citizen traveling with Peruvian passport
How do I explain that I don't want to maintain old projects?
Can the word "desk" be used as a verb?
Writing an ace/aro character?
Why did Old English lose both thorn and eth?
No Torah = Revert to Nothingness?
Why is the Cauchy Distribution is so useful?
How to convert diagonal matrix to rectangular matrix
When did "&" stop being taught alongside the alphabet?
Intern not wearing safety equipment; how could I have handled this differently?
Is this Cambridge Dictionary example of "felicitate" valid?
Estimates on number of topologies on a finite set
Is there a strong legal guarantee that the U.S. can give to another country that it won't attack them?
Can Jimmy hang on his rope?
Generalized Behrend version for Grothendieck-Lefschetz trace formula
What's it called when the bad guy gets eaten?
My previous employer committed a severe violation of the law and is also being sued by me. How do I explain the situation to future employers?
What would +1/+2/+3 items be called in game?
Did right-wing politician Franz Josef Strauss ever explain why he gave a 3 billion loan to East Germany in 1983?
How should I ask for a "pint" in countries that use metric?
Why does the Antonov AN-225 not have any winglets?
Is There A Way To Access A Separate Local Database From Wordpress?
Can I install/update WordPress plugins without providing FTP access?Calling $wpdb in a function in non-WordPress fileError: Object of class stdClass could not be converted to string — implode() — phpAccessing wpdb (wordpress database) from laravel controllercan't select database wordpress errorSetting an external database for WordPress from wp_config file$wpdb->prepare() returns NULL or empty on seemingly correct SQL statementError establishing a database connection during wordpress installationwordpress database connection on local serverWordpress different database Error establishing a database connection
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I have a wordpress plugin that requires connecting to a separate database that is local to the wordpress database.
Is there a way to use wpdb to connect to a different local database?
Does wordpress have a function that returns the database username and password so I dont have to hardcode the user name and password into my plugin?
I tried the following
$years = $this->wpdb->get_results(
$this->wpdb->prepare("SELECT *
FROM `YearsDatabase.years` , ""),
ARRAY_A
);
return $years;
php wordpress
asked Mar 25 at 23:20
Sebastian FloresSebastian Flores
86 bronze badges
add a comment |
I have a wordpress plugin that requires connecting to a separate database that is local to the wordpress database.
Is there a way to use wpdb to connect to a different local database?
Does wordpress have a function that returns the database username and password so I dont have to hardcode the user name and password into my plugin?
I tried the following
$years = $this->wpdb->get_results(
$this->wpdb->prepare("SELECT *
FROM `YearsDatabase.years` , ""),
ARRAY_A
);
return $years;
php wordpress
asked Mar 25 at 23:20
Sebastian FloresSebastian Flores
86 bronze badges
add a comment |
I have a wordpress plugin that requires connecting to a separate database that is local to the wordpress database.
Is there a way to use wpdb to connect to a different local database?
Does wordpress have a function that returns the database username and password so I dont have to hardcode the user name and password into my plugin?
I tried the following
$years = $this->wpdb->get_results(
$this->wpdb->prepare("SELECT *
FROM `YearsDatabase.years` , ""),
ARRAY_A
);
return $years;
php wordpress
asked Mar 25 at 23:20
Sebastian FloresSebastian Flores
86 bronze badges
I have a wordpress plugin that requires connecting to a separate database that is local to the wordpress database.
Is there a way to use wpdb to connect to a different local database?
Does wordpress have a function that returns the database username and password so I dont have to hardcode the user name and password into my plugin?
I tried the following
$years = $this->wpdb->get_results(
$this->wpdb->prepare("SELECT *
FROM `YearsDatabase.years` , ""),
ARRAY_A
);
return $years;
php wordpress
php wordpress
asked Mar 25 at 23:20
Sebastian FloresSebastian Flores
86 bronze badges
asked Mar 25 at 23:20
Sebastian FloresSebastian Flores
86 bronze badges
asked Mar 25 at 23:20
Sebastian FloresSebastian Flores
86 bronze badges
asked Mar 25 at 23:20
Sebastian FloresSebastian Flores
86 bronze badges
asked Mar 25 at 23:20
Sebastian FloresSebastian Flores
86 bronze badges
86 bronze badges
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Yes no maybe, well yes. The plugin itself would set up its own database connection with its own user so you would have concurrent connections when that plugin runs.
However, I would be wondering why a plugin needs a seperate database when it could just prefix the tables it creates with a unique identifier to avoid clashes and simply just use the existing database connection.
Besides that you I think you actually have an error in your sql query try
`YearsDatabase`.`years`
answered Mar 25 at 23:34
ChrisChris
7835 silver badges16 bronze badges
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55347774%2fis-there-a-way-to-access-a-separate-local-database-from-wordpress%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Yes no maybe, well yes. The plugin itself would set up its own database connection with its own user so you would have concurrent connections when that plugin runs.
However, I would be wondering why a plugin needs a seperate database when it could just prefix the tables it creates with a unique identifier to avoid clashes and simply just use the existing database connection.
Besides that you I think you actually have an error in your sql query try
`YearsDatabase`.`years`
answered Mar 25 at 23:34
ChrisChris
7835 silver badges16 bronze badges
add a comment |
Yes no maybe, well yes. The plugin itself would set up its own database connection with its own user so you would have concurrent connections when that plugin runs.
However, I would be wondering why a plugin needs a seperate database when it could just prefix the tables it creates with a unique identifier to avoid clashes and simply just use the existing database connection.
Besides that you I think you actually have an error in your sql query try
`YearsDatabase`.`years`
answered Mar 25 at 23:34
ChrisChris
7835 silver badges16 bronze badges
add a comment |
Yes no maybe, well yes. The plugin itself would set up its own database connection with its own user so you would have concurrent connections when that plugin runs.
However, I would be wondering why a plugin needs a seperate database when it could just prefix the tables it creates with a unique identifier to avoid clashes and simply just use the existing database connection.
Besides that you I think you actually have an error in your sql query try
`YearsDatabase`.`years`
answered Mar 25 at 23:34
ChrisChris
7835 silver badges16 bronze badges
Yes no maybe, well yes. The plugin itself would set up its own database connection with its own user so you would have concurrent connections when that plugin runs.
However, I would be wondering why a plugin needs a seperate database when it could just prefix the tables it creates with a unique identifier to avoid clashes and simply just use the existing database connection.
Besides that you I think you actually have an error in your sql query try
`YearsDatabase`.`years`
answered Mar 25 at 23:34
ChrisChris
7835 silver badges16 bronze badges
answered Mar 25 at 23:34
ChrisChris
7835 silver badges16 bronze badges
answered Mar 25 at 23:34
ChrisChris
7835 silver badges16 bronze badges
answered Mar 25 at 23:34
ChrisChris
7835 silver badges16 bronze badges
7835 silver badges16 bronze badges
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55347774%2fis-there-a-way-to-access-a-separate-local-database-from-wordpress%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
