3v4l.org

run code in 300+ PHP versions simultaneously

@ 2019-04-19T18:33:45Z

<?php

function checkParameters(string $sql) {
    $countNamed = 0;
    $countUnnamed = 0;

    $inQuote = false;
    
    for ($i = 0; $i < strlen($sql); ++ $i) {
        if ($inQuote) {
            if ($sql[$i] == $quote) {
                $inQuote = false;
                continue;
            }
        }
        else {
            if (in_array($sql[$i], ['"', "'"])) {
                $quote = $sql[$i];
                continue;
            }
        }
        
        if ($sql[$i] == ':') {
            $countUnnamed ++;
        }
        elseif ($sql[$i] == '?') {
            $countNamed ++;
        }
    }
    
    if ($countNamed && $countUnnamed) {
        throw new Exception("mixed parms in: $sql" . PHP_EOL);
    }
}


$sql = "SELECT a, b FROM someTable WHERE a = '?' AND b = :id";
// checkParameters($sql);

$sql = "SELECT a, b FROM someTable WHERE a = ? AND b = :id";
// checkParameters($sql);

$sql = "SELECT a, b FROM someTable WHERE a = '?' AND b = :id";
checkParameters($sql);

Output for git.master, git.master_jit, rfc.property-hooks: Fatal error: Uncaught Exception: mixed parms in: SELECT a, b FROM someTable WHERE a = '?' AND b = :id in /in/Rc7B6:32 Stack trace: #0 /in/Rc7B6(44): checkParameters('SELECT a, b FRO...') #1 {main} thrown in /in/Rc7B6 on line 32
Process exited with code 255.

This tab shows result from various feature-branches currently under review by the php developers. Contact me to have additional branches featured.

Active branches

Archived branches

Once feature-branches are merged or declined, they are no longer available. Their functionality (when merged) can be viewed from the main output page

2020-03-21 RFC: Is_Literal - declined
2020-12-04 Enumerations - included in PHP 8.1
2018-06-15 Typed Properties v2 - implemented in PHP 7.4
2016-08-12 Object typehint - included in PHP 7.2
2016-08-14 Arrow functions - withdrawn
2016-05-29 array_change_keys() - withdrawn
2016-04-19 Lexical scope support for anonymous classes - suspended
2016-04-17 Functional Interfaces - declined
2016-03-16 Typed Properties - superseded in favor of Typed Properties 2.0
2015-08-27 Callable Prototypes - declined
2015-05-01 Short Closures - declined / withdrawn in favor of Arrow Functions
2015-02-18 Scalar type hints v5 - included in PHP 7
2015-02-14 Union Types - declined
2013-09-22 Anonymous classes - included in PHP 7

preferences:dark modelive preview

53.68 ms | 401 KiB | 8 Q