Assuming that you mean that students is a table within your WP database, this should get you started. I’d recommend a read of the following materials, which are pretty useful – WordPress Codex for $wpdb. WordPress Codex for Theme Customization API. Here is the code to add the dorpdown box – /** Required to make … Read more
Is there a $wpdb method available that will allow me to create the query, by looping through my query, and then execute it once I’m out of that loop? If you and your loop can construct the proper SQL, then use $wpdb->query. You can run any query you want with that, so whatever version of … Read more
It’s just serialized, in WordPress, you can run maybe_unserialize and get back the variable/array. $crosssells = $wpdb->get_results( “SELECT * FROM $wpdb->postmeta WHERE _crosssell_ids <> ” ” ); $array = maybe_unserialize($crosssells); However, there are built in functions to retrieve posts based on meta information. You can use get_posts to retrieve the posts and get_post_meta to retrieve … Read more
It is all for adding posts into the cache. The usefulness of this is so that get_post( $post_id ) doesn’t result in another hit to the database. This is likely as many of the template functions inside the loop call get_post(). I don’t fully understand the logic for expression for $split_the_query. The limit makes sense … Read more
You can have problems only if database schema changed from older to new version. To know if the your is the case, you can compare the file wp-admin/includes/schema.php for both the versions, see that online here for 3.8.1 and here for 3.5.1. Note that a db index change should not beak the site, but it … Read more
Don’t use pure SQL if you don’t have to. WordPress provides a useful and relatively solid class for retrieving post data. Use it. $args = array( ‘post_type’ => array(‘post’,’page’), ‘post_status’ => ‘publish’, ‘posts_per_page’ => -1, ‘ignore_sticky_posts’ => true, ); $qry = new WP_Query($args); // Show post titles foreach ($qry->posts as $p) { echo $p->post_title; } … Read more
If you check out the source for the $wpdb->insert( $table, $data, $format) method you will find this comment: Data to insert (in column => value pairs). Both $data columns and $data values should be “raw” (neither should be SQL escaped). so you shouldn’t need to do the SQL escape yourself on the data. As far … Read more
You want the query to look like this: SELECT email FROM wp_my_users WHERE email=”[email protected]” instead of this: SELECT email FROM ‘wp_my_users’ WHERE email=”[email protected]” So try to construct your query with: $sql = “SELECT email FROM {$my_table_name} WHERE email = %s”; $result = $wpdb->get_var( $wpdb->prepare( $sql, $email_address ) ); where you don’t need to escape the … Read more
You shouldn’t be calling get_the_ID() outside of a post loop, and the post ID is handed to you using the filter as a function argument: function insert_new_table( $post_id ){ So use $post_id Added notes Don’t use mysql_connect etc that extension was deprecated and is no longer included by default in newer versions of PHP. This … Read more
You basically have the answer, just add $date2 to the inner sql where clause: AND p.post_date > ‘$date2’ to get last week. To get a particular week, use AND p.post_date < ‘$date1’ AND p.post_date > ‘$date2’ where eg $date1 = date(‘Y-m-d’, strtotime(‘2014-07-04 +1 days’)); $date2 = date(‘Y-m-d’, strtotime(‘2014-07-04 -8 days’)); To return weekly/total votes, you … Read more