There seems little point in creating a new post entry for each of your products if your table of products already has all of the information you wish to display. Your best bet is to create a single page for example “Product” and then setup your own rewrite rule, using add_rewrite_rule, so that you can … Read more
It happens because when you save a post, WordPress calls sanitize_title function to sanitize your title. This function applies sanitize_title filter. One of core hooks for sanitize_title filter is sanitize_title_with_dashes function, which checks title on utf8 format by calling seems_utf8 function and if the title has utf8 format, the function call utf8_uri_encode function. utf8_uri_encode function … Read more
First add define(‘WP_SITEURL’, ‘http://example.com’); define(‘WP_HOME’, ‘http://example.com’); To your wp-config.php file (obviously change example.com to your domain) then login and once you see the admin panel navigate to http://yoursite/wp-admin/options.php there you can change home and siteurl to your new domain and save. You will also need to change the links for images and other media in … Read more
Unfortunately it’s not really and easy process. It’s not about just having a table. The tables in WordPress will have different names, fields, and relationships than the cms you’re pulling your table from. That’s just for the content. Then to mirror appearance will definitely be starting over all the same. It would likely be a … Read more
The WordPress database is already indexed. See this codex article for a detailed list of indexes per table: http://codex.wordpress.org/Database_Description And even if it weren’t, you’d need to know what queries are being run in order to effectively add indexes. Meaning, there would be no quick fix–you’d have to learn how indexing works, figure out what … Read more
If you mean post type instead of slug I’d say… UPDATE wp_posts SET post_status=”archived” WHERE post_status <> ‘static’ AND post_type=”cpt_operator”; But be careful when editing the db directly!
If you are concerned about efficiency, you might want to use the Transients API to store the query. Storing something that you want to randomize might seem counter-intuitive, but if you store the entire query, you can always randomize and manipulate the resulting array to get the results you want. Here’s how to get all … Read more
You can’t use WPDB to connect to databases that aren’t MySQL/MariaDB based. There are no WordPress APIs or WP based solutions that will do this. Instead you will need to use a general PHP solution inside your plugin, and should look at general PHP resources and communities, not WP ones. I can also guarantee, that … Read more
Load the existing option first and save the new data as an element in an array: // get the option $data = get_option( ‘row_name’ ); // add new data to the option $data[] = $options; // save it back to the db update_option( ‘row_name’, $data ); Your option will then be an array of arrays … Read more
You don’t get an error because WordPress does not check for the length, and MySQL silently truncates it (giving a warning, not an error), unless you enable the STRICT_ALL_TABLES option (which will change the warning into an error). Even more confusing, when you enable multisite the options are saved in the sitemeta table with a … Read more