You might be able to solve this if you have a text editor with good encoding support. That way, you could switch between the Latin 1 and the UTF-8 encoding until you have the right combination. I use SubEthaEdit which can convert but also reinterpret a file when you change the encoding. The ç should … Read more
Here is an example code that will get the data and then display it: global $wpdb; // this adds the prefix which is set by the user upon instillation of wordpress $table_name = $wpdb->prefix . “your_table_name”; // this will get the data from your table $retrieve_data = $wpdb->get_results( “SELECT * FROM $table_name” ); ?> <ul> … Read more
After executing these: [root@shop ~]# mysqlcheck -p -c wordpress hihgv_options wordpress.hihgv_options OK [root@shop ~]# mysqlcheck -p -o wordpress hihgv_options wordpress.hihgv_options note : Table does not support optimize, doing recreate + analyze instead status : OK [root@shop ~]# mysqlcheck -p -a wordpress hihgv_options wordpress.hihgv_options OK Size is down to 1.6MB, not sure if it was optimize … 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
Put a file named db-error.php into the wp-content directory. Here you can ask the global $wpdb object for more detailed errors: global $wpdb; $wpdb->print_error(); This will print out the last error message if the database handler.
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