global $wpdb; /* grab meta value, it is assumed you know the post id ($id) in question */ $dot_number = get_post_meta( $id, ‘dot_number’, true ); /* grab all rows with matching value in ‘dot_number’ column */ $matches_query = $wpdb->get_results( “SELECT * FROM ” . $wpdb->prefix . “csadata ” . “WHERE dot_number = ” . $dot_number, … Read more
You should wirte a Function or Plugin inside WordPress to achive that. First, you could insert the tables into your WordPress Database. After that, make sure you make good use of the WordPress postsstructure. Set up a Loop through your existing Posts that you want to import. At each Post create a WordPress Post using … Read more
How to prevent further updates of custom meta when using actions to set one meta based on another
The server-side code looks to be OK (at a glance) but you are not calling the correct server-side code from your JavaScript. Have a look at this: http://wp.smashingmagazine.com/2011/10/18/how-to-use-ajax-in-wordpress/. You need to have an Ajax call to admin-ajax.php?action=<your action>
Try WP_Query to get the posts, since get_posts() also makes use of it: $args = array( ‘category_name’ => ‘product-videos’, ‘posts_per_page’ => 5000, // or -1 if you want all ‘offset’ => 1 ); $the_query = new WP_Query( $args ); if ( $the_query->have_posts() ) : while ( $the_query->have_posts() ): $the_query->the_post(); ?> <option value=”<?php the_ID(); ?>” <?php … Read more
if ( !$value ) evaluates to TRUE when the value is 0. Alternative: if ( ! isset ( $_POST[‘_ordre’] ) ) return delete_post_meta( $post_id, ‘_ordre’ ); update_post_meta( $post_id, ‘_ordre’, $_POST[‘_ordre’] ); You don’t need add_post_meta(), the call to update_post_meta() will do that automatically.
Attach time/date stamp on add_post_meta
Custom WP_Query for WordPress Search Results with meta_query
I use a similar method to the following in a plugin of mine: function wpse107488_urls_to_links( $string ) { /* make sure there is an http:// on all URLs */ $string = preg_replace( “/([^\w\/])(www\.[a-z0-9\-]+\.[a-z0-9\-]+)/i”, “$1http://$2”, $string ); /* create links */ $string = preg_replace( “/([\w]+:\/\/[\w-?&;%#~=\.\/\@]+[\w\/])/i”, “<a target=\”_blank\” title=\”” . __( ‘Visit Site’, ‘your-textdomain’ ) . “\” … Read more
Editing does not change post_name