To do that, create custom post type to store info. You do not need to create any custom table as your every record will be saved as a unique post in your custom post type. For detailed assistance, please have a look at the documentation here: https://codex.wordpress.org/Function_Reference/register_post_type Let us know if there is any confusion. … Read more
Instead of adding new columns to the WordPress database, you might want to use the wp_usermeta table. It is used to store any kind of data about your users (just like the wp_postmeta for your posts and pages). To add fields on the registration form you can use the user_new_form action which is triggered by … Read more
You can try to trace in the PostgreSQL log file what pg_dump –table table –schema-only really does. Then you can use the same method to write your own sql function.
You should not modify the wordpress DB via SQL unless it is a total emergency. WordPress DB structure getting more complex with time and there are always possible intractions with plugins that you might bypass with direct SQL. What you should do is to write a small plugin that inserts the tags by calling using … Read more
I thought it might be helpful to mention that, as of 9.0, postgres does have the syntax to grant privileges on all tables (as well as other objects) in a schema: GRANT SELECT ON ALL TABLES IN SCHEMA public TO user; GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA public TO user; Here’s the link.
In SQL Server Management Studio right-click your database and select Tasks / Generate Scripts. Follow the wizard and you’ll get a script that recreates the data structure in the correct order according to foreign keys. On the wizard step titled “Set Scripting Options” choose “Advanced” and modify the “Types of data to script” option to … Read more
Add brackets to the input names: <label><input type=”checkbox” name=”taxonomy-name[]” value=”term”>term</label> It will be automatically converted to an array: if( isset( $_GET[‘taxonomy-name’] ) ){ foreach( $_GET[‘taxonomy-name’] as $term ){ echo $term; } }
You can create a new wpdb object and connect to an external MySQL database, though there will be a performance cost to making a remote connection, don’t expect it to be fast. But, you mentioned it’s an MS SQL database, not MySQL. There won’t be a WordPress based mechanism to do this, you’ll have to … Read more
Your best bet is a ‘search and replace’ plugin that will fix things in the database. I like the “Better Search and Replace” plugin. It has a ‘test’ mode so you can make sure that all is well. You would enter the first term in your question as the ‘search’, and the 2nd term as … Read more
The two most obvious things you can do to reduce the load time of this query are the IN statement and the offset in your LIMIT statement. The larger the number of items you’re checking for in the IN statement, the less efficient the query. See: https://stackoverflow.com/questions/4514697/mysql-in-operator-performance-on-large-number-of-values The reason the offset is causing performance issues … Read more