A MySQL DB within a MySQL DB
I have a client who does not want to switch hosting providers. This provider only allows one database per client. I am setting up a sandbox for the client and do not wish to share the database across the sandbox and the production website. Can I place a database within a database for the sandbox website? If so, I would like some recommendations on how to do this and how I would have WordPress access the nested database.
Solutions
When you run the wordpress installation script, on step 5 of the famous 5 minute install https://codex.wordpress.org/Installing_WordPress#Step_5:_Run_the_Install_Script ... use the same Database Credentials as the existing site, but use a different prefix for the tables.
The default prefix is "wp_" make it something like "my_" and that's it.
(You'll see it says, "If you want to run multiple WordPress installations in a
single database
, change this.)
Similar questions
How to echo shortcodes within shortcodes within shortcodes
I'm all tied up in knots trying to echo shortcodes within shortcodes and I really need your help please! Here's the code: The function adds a button to my site which opens a modal popup when clicked. I'm tying to display content within that popup that is restricted based on membership. That part uses the groups_member shortcode. Then, I'm trying to...
accessing an element within a php object within an array of objects
I am hooking into a wordpress plugin and it is returning an object - $data. I think the structure of it is below. I did a error_log( print_r( $data, true ) ); to get that structure because I can only access the server logs because it's wordpress This is the important part. How can I access the user_email variable inside the class. tried searching t...
Nesting a Wordpress function within a shortcode within a function
I need to use a plugin shortcode within a template file, but have one of the variables be set by the value of a custom field in the post. Here's what I have so far. This just breaks the entire page. My effort (not working): The shortcode: The custom field function: Thanks.
PHP within a variable that contains HTML within another variable
I'd like to add a variable that holds a function ( be it WordPress or a custom function ) within HTML that's within another variable. The problem is that when I concatenate it pops outside of the div container in the front end, where I need it to be inside the container. For example shown here, I'd like "$stay_put" or PHP in general to be generated...
Advanced Custom Fields within WordPress - Unable to use a repeater within a group
I have done this 20+ times previously but I cannot figure out why my call to the repeater field is breaking my site. The page is unable to load due to a php error, it works if I remove the while loop that is calling the repeater field. I would like to know what I am doing wrong in this snippet: ~ The repeater field is called application_sectors, mi...
MySQL Select within WP Page template
I have one WP page which contains a form that posts data to a table in the Wordpress database called "members", data such as first name, surname, email, role and bio. Table posts fine and data is stored fine. I then have a second page where I want to list the data from the table, I have got as far as the following: The above code is displaying an a...
Also ask