Questions about $wpdb->prepare()

  • Jacob N. Breetvelt

    (@opajaap)


    2 months ago

    1:
    Is there a placeholder for a columname so we can have something like:
    $wpdb->prepare("SELECT * FROM $wpdb->tablename WHERE columname = %s ORDER BY %??", $value, $sortby)
    If not, please make it an enhancement request

    2:
    Is there a placeholder for an enumeration of integer values so we can have something like:
    $wpdb->prepare("SELECT * FROM $wpdb->tablename WHERE id IN (%??)", implode(',', $intvaluearray))
    If not, please make it an enhancement request

Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    2 months ago

    Available placeholder formats are clearly listed in the related doc page.

    You’re free to make your own requests. A request from me would carry no more weight than your own. You’re in a better position to articulate why additional formats are important.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.