select - Read For Learn

Custom select query two tables by a meta key

First of all you are trying to combine both of the tables by post_parent. $wpdb->posts.post_parent = $wpdb->ftcalendar_events.post_parent I guess data in the ftcalendar_events has children of posts table, try $wpdb->posts.ID = $wpdb->ftcalendar_events.post_parent Also you can try joining tables: SELECT * FROM $wpdb->posts JOIN $wpdb->ftcalendar_events ON $wpdb->posts.ID = $wpdb->ftcalendar_events.post_parent WHERE $wpdb->posts.post_status=”publish” AND $wpdb->posts.post_type=”post” ORDER BY $wpdb->posts.post_date … Read more

Adding option values as an array using a multi selectable select box

It’s a lot simpler than that: <select name=”swcs_postpage_id[]” id=”swcs_postpage_id” multiple> See those brackets? Boom.

SELECT query with prepare and placeholder for string

You need to define $wpdb as global. Try this code. global $wpdb; $mail = $_POST[’email’]; $table = $wpdb->prefix . ‘members’; $result = $sql->get_results( “SELECT * FROM $table WHERE email = %s”, $mail);

Display posts by combining multiple meta key

As Tim Malone said, WP_Query isn’t going to return multiple copies of the same post in its result set. I think you have a design problem and I would suggest you use parent/child posts rather than post meta to accomplish what you want. The following is one approach to doing this. First, register both post … Read more

How to call custom jQuery plugins into the customizer controls

First, in order to enqueue JS in the customizer controls, you need to use the customize_controls_enqueue_scripts action. This is different than the action used to enqueue scripts into the customizer preview, which is what themes normally do via customize_preview_init or wp_enqueue_scripts. So in your snippet above, replace customize_preview_init with customize_controls_enqueue_scripts. Secondly, in order to extend … Read more

Retrieve select tag custom values from array and display them in current page with wp_query?

@Nick83, While I’m not trying to make the answer overly complicated, in order to do what you are attempting to do correctly I believe you’ll need to call WordPress via Ajax. My recommendation is the following: Create two ajax calls. The first gets the prices (without duplicates). The second takes whichever price the user chose … Read more

Check if a value exists in database table

Replace this: $result = $wpdb->get_row(“SELECT * FROM wp44_predefined_address WHERE ‘UPPER(Address1)’ LIKE ‘UPPER(%s)'”, $myinput); with this: (just choose the appropriate $like based on your requirements) // Properly generate the LIKE query. $like=”%” . $wpdb->esc_like( $myinput ) . ‘%’; // e.g. ‘%input%’ //$like=”%” . $wpdb->esc_like( $myinput ); // e.g. ‘%input’ //$like = $wpdb->esc_like( $myinput ) . ‘%’; … Read more

Multiple selection for wordpress widget

Hi why don’t you used multiple check-box instead of select option field. As well as you have used deprecated functions like “create_function”. I have modified your code which replaced select option with multiple check-box selection. function myCatWidget() { register_widget( ‘my_custom_cat_widget’ ); } add_action( ‘widgets_init’, ‘myCatWidget’ ); class my_custom_cat_widget extends WP_Widget { function __construct() { parent::__construct(‘my_custom_cat_widget’, … Read more

+ More