3v4l.org

run code in 300+ PHP versions simultaneously
<?php $db = new SQLite3(':memory:'); $db->exec("CREATE TABLE Dogs (Id INTEGER PRIMARY KEY, Breed TEXT, Name TEXT, Age INTEGER)"); $sth = $db->prepare("INSERT INTO Dogs (Breed, Name, Age) VALUES (:breed,:name,:age)"); $sth->bindValue(':breed', 'canis', SQLITE3_TEXT); $sth->bindValue(':name', 'jack', SQLITE3_TEXT); $sth->bindValue(':age', 7, SQLITE3_INTEGER); $sth->execute(); $sth->clear(); //this is supposed to clear bindings! $sth->reset(); $sth->bindValue(':breed', 'russel', SQLITE3_TEXT); $sth->bindValue(':age', 3, SQLITE3_INTEGER); $sth->execute(); $res = $db->query('SELECT * FROM Dogs'); while (($row = $res->fetchArray(SQLITE3_ASSOC))) { var_dump($row); }
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 42) Position 1 = 52
Branch analysis from position: 52
2 jumps found. (Code = 44) Position 1 = 57, Position 2 = 49
Branch analysis from position: 57
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 49
2 jumps found. (Code = 44) Position 1 = 57, Position 2 = 49
Branch analysis from position: 57
Branch analysis from position: 49
filename:       /in/nLZAP
function name:  (null)
number of ops:  58
compiled vars:  !0 = $db, !1 = $sth, !2 = $res, !3 = $row
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    3     0  E >   NEW                                              $4      'SQLite3'
          1        SEND_VAL_EX                                              '%3Amemory%3A'
          2        DO_FCALL                                      0          
          3        ASSIGN                                                   !0, $4
    5     4        INIT_METHOD_CALL                                         !0, 'exec'
          5        SEND_VAL_EX                                              'CREATE+TABLE+Dogs+%28Id+INTEGER+PRIMARY+KEY%2C+Breed+TEXT%2C+Name+TEXT%2C+Age+INTEGER%29'
          6        DO_FCALL                                      0          
    7     7        INIT_METHOD_CALL                                         !0, 'prepare'
          8        SEND_VAL_EX                                              'INSERT+INTO+Dogs+%28Breed%2C+Name%2C+Age%29++VALUES+%28%3Abreed%2C%3Aname%2C%3Aage%29'
          9        DO_FCALL                                      0  $8      
         10        ASSIGN                                                   !1, $8
    9    11        INIT_METHOD_CALL                                         !1, 'bindValue'
         12        SEND_VAL_EX                                              '%3Abreed'
         13        SEND_VAL_EX                                              'canis'
         14        SEND_VAL_EX                                              3
         15        DO_FCALL                                      0          
   10    16        INIT_METHOD_CALL                                         !1, 'bindValue'
         17        SEND_VAL_EX                                              '%3Aname'
         18        SEND_VAL_EX                                              'jack'
         19        SEND_VAL_EX                                              3
         20        DO_FCALL                                      0          
   11    21        INIT_METHOD_CALL                                         !1, 'bindValue'
         22        SEND_VAL_EX                                              '%3Aage'
         23        SEND_VAL_EX                                              7
         24        SEND_VAL_EX                                              1
         25        DO_FCALL                                      0          
   12    26        INIT_METHOD_CALL                                         !1, 'execute'
         27        DO_FCALL                                      0          
   14    28        INIT_METHOD_CALL                                         !1, 'clear'
         29        DO_FCALL                                      0          
   15    30        INIT_METHOD_CALL                                         !1, 'reset'
         31        DO_FCALL                                      0          
   17    32        INIT_METHOD_CALL                                         !1, 'bindValue'
         33        SEND_VAL_EX                                              '%3Abreed'
         34        SEND_VAL_EX                                              'russel'
         35        SEND_VAL_EX                                              3
         36        DO_FCALL                                      0          
   18    37        INIT_METHOD_CALL                                         !1, 'bindValue'
         38        SEND_VAL_EX                                              '%3Aage'
         39        SEND_VAL_EX                                              3
         40        SEND_VAL_EX                                              1
         41        DO_FCALL                                      0          
   19    42        INIT_METHOD_CALL                                         !1, 'execute'
         43        DO_FCALL                                      0          
   21    44        INIT_METHOD_CALL                                         !0, 'query'
         45        SEND_VAL_EX                                              'SELECT+%2A+FROM+Dogs'
         46        DO_FCALL                                      0  $19     
         47        ASSIGN                                                   !2, $19
   22    48      > JMP                                                      ->52
   23    49    >   INIT_FCALL                                               'var_dump'
         50        SEND_VAR                                                 !3
         51        DO_ICALL                                                 
   22    52    >   INIT_METHOD_CALL                                         !2, 'fetchArray'
         53        SEND_VAL_EX                                              1
         54        DO_FCALL                                      0  $22     
         55        ASSIGN                                           ~23     !3, $22
         56      > JMPNZ                                                    ~23, ->49
   24    57    > > RETURN                                                   1

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
176.67 ms | 1392 KiB | 15 Q