And, although off topic, further to my above comment about IN lists...

    /**
     * Create a PDO-aware construct suitable for IN clauses.
     *
     * Each PDO param created is composed of a colon, the $prefix and
     * the $key of each each item in the $set.
     *
     * @param array  $set    Tuples for creating the list
     * @param string $prefix Prepend each PDO param with this
     * @return array
     */
    public function makeInList($set, $prefix = 'val')
    {
        $inList = array();
        $params = array();

        foreach ($set as $key => $item) {
            if (is_numeric($key)) {
                $key = str_pad($key, 6, '0', STR_PAD_LEFT);
            }

            $paramName = ':' . $prefix . $key;
            $inList[] = $paramName;
            $params[$paramName] = $item;
        }

        return array($inList, $params);
    }

Usage:

list($inList, $params) = $helper->makeInList(array(5, 42, 103, 3, 11), 'ids');
$sql = "SELECT * FROM table WHERE id IN (" . ($inList ? implode(',', $inList) : "''") . ")";
...
// prepare($sql)
// bind($params)
// exec();

Uh oh!

Allow AND/OR in WHERE clause of safe_upsert #724

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions