Skip to content

sprintf()-like syntax support  #123

@maartenheideman

Description

@maartenheideman

I'll want to use your great work in combination with the WordPress wpdb class. But WordPress prepare ask for a sprintf()-like syntax in their prepare method. Is there a workaround for that? On the moment I'll use something like this

$sql = $builder->write($query);
$values = $builder->getValues();

foreach ($values as $key => $value) {
    if( is_numeric($value) ){
        $sql = str_replace($key, '%d', $sql);
    } else {
        $sql = str_replace($key, '%s', $sql);
    }
};

$results = $wpdb->get_results( $wpdb->prepare($sql,array_values($values)) );

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions