The files on your server are the WordPress app, themes, and plugins. All page, post, widget, user, and plugin data only exists in the database. When you create a page or post, add a user, leave a comment, etc., WordPress is writing that data to the database and nowhere else. When a visitor loads your … Read more
If that changes the MySQL password that WordPress is using, and it sounds like it does, then yes you will have a problem, but not a big one. You’d need to edit wp-config.php and change define(‘DB_PASSWORD’,’oldpass’); to define(‘DB_PASSWORD’,’newpass’); Beyond that, the question is a CPanel question and would be off topic here. http://codex.wordpress.org/Editing_wp-config.php#Set_Database_Password
if I understand you correctly, you might want something like this: global $wpdb; $number=30; // EDIT this to your needs $sql=”SELECT post_id FROM `wp_ak_popularity` ORDER BY `single_views` DESC LIMIT %d”; $my_top_posts = $wpdb->get_results($wpdb->prepare($sql,$number),ARRAY_N); to get an array of the top posts id’s. You could then use this in your WP_Query: ‘post__in’ => $my_top_posts
While you might not be writing a plugin specifically, this resource will still be pertinent: http://codex.wordpress.org/Writing_a_Plugin#Plugin_Development_Suggestions From the codex Use the existing database tables instead of creating new custom tables if possible. Most use-cases can be accomplished with custom post types and meta data, custom taxonomy and/or one of the other standard tables and using … Read more
This is essentially a SQL question. The only possible WordPress related component would be if you were asking about database structure, which is in the Codex. Or you could just look at the database itself. The post ID is incremented and never duplicated. The highest IDs are the last added. The query is simple. SELECT … Read more
As @s_ha_dum mentioned in the comments, building an API or some sort of XML or JSON feed (or leveraging one that’s already there, or installing a plugin on whatever system that is, etc) is really your only way of getting at that data remotely. Once you get that going, you can use wp_remote_get to query … Read more
WordPress has its own connection class, which can be used trough the $wpdb object. Is there a particular reason to use direct queries to the db, instead the wordpress functions (get_posts, get_post_meta, get_option)? Keep in mind that by doing this, you loose a lot of the wordpress tools, such as cache, filters, etc…
WordPress is an ecosystem of its own, and it’s pretty fat in terms of memory use and existing APIs and structures. Integrating this huge behemoth with a lean back-end that you have already built on your own won’t make much sense unless you specifically want to use WP’s back-end functionality instead of yours. WordPress themes … Read more
I’m pretty sure that first SQL query isn’t correct SQL (insert has different syntax) 😉 It should be: INSERT INTO {$wpdb->prefix}awpcp_adphotos (ad_id, image_name, disabled, isprimary) VALUES (%d, %s, %d,%d) In second example, I’m almost sure that ad_id is not string, and image_name is not a number. Of cours I’m only guessing, because I haven’t seen … Read more
Changing the case of the paths without changing the file names themselves could break your links, depending on the server and its configuration. But to get to the question directly, you may be able to do this with SQL using MySQL’s REPLACE and LOWER, but I would advise against it. MySQL has some regex functionality … Read more