You may not need extra custom tables. Create a custom post type for songs. Then store all the required data (link, name, date, size, etc.) as post meta data. The songs would be stored in the wp_posts table and the metadata in wp_postmeta.
If you’re using Google Docs, then this plugin Google Spreadsheet Viewer might be helpful.
You would have different choices. I encourage you to use RSS. There are a lot of resources on that, you could benefit from the power of RSS which is pretty well implemented in wordpress. Or just like I said in comment look into th new JSON APIs. So basically look for codes that take the … Read more
This is just bad security method. Because the only way you can connect to the mysql database is via that pc you use. Where is if you username/pwd, you can move the site to another server, etc. So Windows Authentication is a bad idea, too easy to overcome, and honestly just not that secure. Where … Read more
Take a copy of your data file and store it safely just in case you mess up – it’s easily done. Make sure it is labelled as hacked so you can’t accidentally use it anywhere. Look in your SQL for a section starting with: INSERT INTO `wp_posts` VALUES and eventually ending with a semicolon. This … Read more
You cant have 2 sites that uses the same data from the same database, because of how WordPress works (permalinks etc), i am guessing you want to do this to show 2 different themes, 1 for the desktop version and 1 for the mobile version, try doing that with 1 WordPress installation and change the … Read more
This is bug #31071: media / post_mime_type related queries are very slow on larger sites. It should have been fixed for version 4.8 now. You can try it on a test site that is a mirror of your production site. There are some very interesting ideas in that bug discussion. See if you can use … Read more
Use WP’s update_post_meta() function instead of straight SQL. If the postmeta exists, it gets updated. If it doesn’t exist, it gets added. update_post_meta(‘1117’, ‘_yoast_wpseo_metadesc’, ‘Test 5’);
You can use wordpress query args options. I hope this will help you. // WP_Query arguments $args = array ( ‘nopaging’ => false, ‘posts_per_page’ => ‘5’, ); // The Query $query = new WP_Query( $args );
For one thing, you don’t have to include wp-config or wp-db when you use wp-load. And as t31os says, single-quotes around variables will keep them from being interpreted by PHP. <?php include_once(‘wp-load.php’); ?> <!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”> <html xmlns=”http://www.w3.org/1999/xhtml”> <head> <meta http-equiv=”Content-Type” content=”text/html; charset=UTF-8″ /> <title>Untitled Document</title> <style type=”text/css”> /* styles … Read more