There is indeed an options table (wp_options / prefix_options). You can the find full details on that table here: http://codex.wordpress.org/Database_Description#Table:_wp_options Options are meant to be globally accessible (not tied to individual posts), and you only need to know the option name/key. You can access that table and its values with the following functions: <?php $your_option … Read more
A Google of wordpress wxr pulled up this link as the first result: https://wordpress.org/support/topic/xml-to-wxr-issue which suggests to If you paste the following line into your export file after the Language defining line in the section near the topyou should be good to go: <wp:wxr_version>1.1</wp:wxr_version> But I would strongly advise against this approach based on the … Read more
This seems to be a problem with “orphaned SELECT statements”. It is described here in more detail. One solution would be to create a temporary table and modify my_acquireuserpasswd to save data to temp_table BEGIN DECLARE passwdtemp VARCHAR(64); DECLARE temp VARCHAR(4000); START TRANSACTION; SELECT id, passwd INTO uid1, passwdtemp FROM users WHERE name = name1; … Read more
Get id from database
MySQL errors after a WordPress clone
Simple email input store in database
It’s an interesting idea you have had and I’ve done something remotely similar but with companies and employees as a sort of CRM I’m building. What I’ve done is go down the plugin route and utilised the WP_List_Table class as it organises things very nicely for me. What I’m doing is creating a set of … Read more
WordPress + Postgresql
You can add the standard taxonomy joins to the query: global $wpdb; $cat_id = 79; // Whatever. $sql = ” select wp_posts.*, coalesce( ( select max(comment_date) from $wpdb->comments wpc where wpc.comment_post_id = wp_posts.id ), wp_posts.post_date ) as mcomment_date from $wpdb->posts wp_posts JOIN $wpdb->term_relationships AS tr ON wp_posts.ID = tr.object_id JOIN $wpdb->term_taxonomy AS tt ON tr.term_taxonomy_id … Read more
Try this : $value = get_post_custom_values( ‘banda_postmeta’, $post->ID ); $value = unserialize(“$value”); print_r($value); echo $value[‘social_networks_url’][‘twitter_url’]; Your social_networks_url are blank, so try echoing these values, it will echo the value. echo $value[‘page_builder_settings’].”<br />”; echo $value[‘date_of_birth’].”<br />”; echo $value[‘location’].”<br />”; Output : array (size=7) ‘social_networks_url’ => array (size=9) ‘twitter_url’ => string ‘wr’ (length=2) ‘facebook_url’ => string ” … Read more