wpdb - Read For Learn

SQL query not working in alphabetical post title/content search

Dude, no need of the SQL mess! WP allows you to search through the post content or titles alphabetically using the search parameter. So, use this solution instead… global $wpdb; $q = $_REQUEST[‘q’]; $posts = get_posts(array(‘s’ => $q, ‘post_type’ => ‘question’, ‘posts_per_page’ => -1)); echo ‘<ul>’; foreach($posts as $post){ echo ‘<li><a href=”‘.get_permalink($post->ID).'”>’.$post->post_title.'</a></li>’; } echo ‘</ul>’; … Read more

How to display only first value of database column in WordPress

$usernames = $wpdb->get_results( “SELECT user_name FROM wpxa_project_members WHERE project_id = 698 LIMIT 1”

$wpdb->insert – inserting multiple rows

I guess the problem is a pretty simple one. You didn’t show the whole code, but I guess the problem is that you’re saving the insertion for some unknown reason as string into a var named $stat. Everytime you fill the var with a new query you’re overwriting your var. You should use $stat .= … Read more

$wpdb->get_results() returns good result only in first foreach iteration

wpdb prepare syntax

Just look at the generated string: INSERT INTO ‘wp_table’ (id, datea, one, two) VALUES (1, ‘2013-12-24’, 3, ‘NULL’) ON DUPLICATE KEY UPDATE one = VALUES(one), two = VALUES(two); The problem is the quotes around the table name. (Your hand-written query has no quotes around the table name, and works.) prepare is intended for dynamic user … Read more

Merging PHP download script into `functions.php`

You won’t be calling stuff directly from the functions.php file by URL reference. The functions.php is loaded in with the WordPress theme and it makes functions available to you from within the theme template files. Most of your code can be ported directly into the functions.php but you will have to wrap some sort of … Read more

Can I use $wpdb for my custom tables in the WordPress database?

Yes you can. Straight from the codex The $wpdb object is not limited to the default tables created by WordPress; it can be used to read data from any table in the WordPress database (such as custom plugin tables). For example to SELECT some information from a custom table called “mytable”, you can do the … Read more

ob_end_flush error when using wpdb in plugin

You did not provide that information, so I have to guess a little bit: You are using PHP 5.4 and zlib.output_compression is on on your server? Then you just stumbled upon bug #18525. Possible solutions: Disable zlib.output_compression. Apply the patch provided there and report back on that ticket if it works. Disable notices. What you … Read more

Cannot access the thumbnails of attachment images… Cannot find the reason

You can use several functions to get the URL of a image of any of the intermediate sizes created by WordPress (thumbnail, medium, large, full, or any other custom size). You can use get_the_post_thumbnail()/the_post_thumbnail(): use this function if you want to get a <img> element of the featured image of a post (aka “post thumbnail”). … Read more

Can’t pass table to $wpdb->prepare

The prepare() method escapes %s. The second piece of code you listed breaks because quotation marks are added to the table name, hence it doesn’t match what’s in the DB. The first piece of code works because it’s a straight string replacement hence matching the name of the table in the database. What is the … Read more

+ More