PHP 8.5.0 Beta 3 available for testing

    Pdo\Sqlite::createCollation

    (PHP 8 >= 8.4.0)

    Pdo\Sqlite::createCollation โ€” Registers a user-defined function for use as a collating function in SQL statements

    ่ฏดๆ˜Ž

    public Pdo\Sqlite::createCollation(string $name, callable $callback): bool

    This method is similar to Pdo\Sqlite::createFunction() except that it registers functions that are used to collate strings.

    ๅ‚ๆ•ฐ

    name
    Name of the SQL collating function to be created or redefined.
    callback
    Callback function that defines the behaviour of a collation. It must accept two strings and return -1, 0, or 1 if the first string sorts before, sorts identically, or sorts after the second string respectively. An internal function that behaves like this is strcmp().

    This function need to be defined as:

    collation(string $string1, string $string2): int

    ่ฟ”ๅ›žๅ€ผ

    ๆˆๅŠŸๆ—ถ่ฟ”ๅ›ž true๏ผŒ ๆˆ–่€…ๅœจๅคฑ่ดฅๆ—ถ่ฟ”ๅ›ž falseใ€‚

    ็คบไพ‹

    ็คบไพ‹ #1 Pdo\Sqlite::createCollation() example

    <?php
    $db     = new Pdo\Sqlite('sqlite::memory:');
    $db->exec("CREATE TABLE test (col1 string)");
    $db->exec("INSERT INTO test VALUES ('a1')");
    $db->exec("INSERT INTO test VALUES ('a10')");
    $db->exec("INSERT INTO test VALUES ('a2')");

    $db->sqliteCreateCollation('NATURAL_CMP', 'strnatcmp');
    foreach (    $db->query("SELECT col1 FROM test ORDER BY col1") as $row) {
    echo     $row['col1'] . "\n";
    }
    echo     "\n";
    foreach (    $db->query("SELECT col1 FROM test ORDER BY col1 COLLATE NATURAL_CMP") as $row) {
    echo     $row['col1'] . "\n";
    }
    ?>

    ไปฅไธŠ็คบไพ‹ไผš่พ“ๅ‡บ๏ผš

    a1
a10
a2

a1
a2
a10

    ๅ‚่ง

    ๅ‘็Žฐไบ†้—ฎ้ข˜๏ผŸ

    ไบ†่งฃๅฆ‚ไฝ•ๆ”น่ฟ›ๆญค้กต้ข โ€ข ๆไบคๆ‹‰ๅ–่ฏทๆฑ‚ โ€ข ๆŠฅๅ‘Šไธ€ไธช้”™่ฏฏ
    ๏ผ‹ๆทปๅŠ ๅค‡ๆณจ

    ็”จๆˆท่ดก็Œฎ็š„ๅค‡ๆณจ

    ๆญค้กต้ขๅฐšๆ— ็”จๆˆท่ดก็Œฎ็š„ๅค‡ๆณจใ€‚
    To Top